数据库:oracle 19.3
系统:CentOS 7.9
环境:rac
问题描述:在节点2执行adrci指令,出现No ADR base is set,如下所示:
[oracle@hisdb2 ~]$ adrci
ADRCI: Release 19.0.0.0.0 - Production on Thu Apr 28 13:59:01 2022
Copyright © 1982, 2019, Oracle and/or its affiliates. All rights reserved.
No ADR base is set
adrci> show home
No ADR homes are set
经查询资料,以下为解决过程:
[oracle@hisdb2 db]$ ll
O
R
A
C
L
E
H
O
M
E
/
l
o
g
/
d
i
a
g
/
l
s
:
c
a
n
n
o
t
a
c
c
e
s
s
/
u
01
/
a
p
p
/
o
r
a
c
l
e
/
p
r
o
d
u
c
t
/
19.3.0
/
d
b
/
l
o
g
/
d
i
a
g
/
:
N
o
s
u
c
h
f
i
l
e
o
r
d
i
r
e
c
t
o
r
y
[
o
r
a
c
l
e
@
h
i
s
d
b
2
d
b
]
ORACLE_HOME/log/diag/ ls: cannot access /u01/app/oracle/product/19.3.0/db/log/diag/: No such file or directory [oracle@hisdb2 db]
ORACLEHOME/log/diag/ls:cannotaccess/u01/app/oracle/product/19.3.0/db/log/diag/:Nosuchfileordirectory[oracle@hisdb2db] mkdir -p
O
R
A
C
L
E
H
O
M
E
/
l
o
g
/
d
i
a
g
/
[
o
r
a
c
l
e
@
h
i
s
d
b
2
d
b
]
ORACLE_HOME/log/diag/ [oracle@hisdb2 db]
ORACLEHOME/log/diag/[oracle@hisdb2db] printf “%s” $ORACLE_BASE >
O
R
A
C
L
E
H
O
M
E
/
l
o
g
/
d
i
a
g
/
a
d
r
c
i
d
i
r
.
m
i
f
[
o
r
a
c
l
e
@
h
i
s
d
b
2
]
ORACLE_HOME/log/diag/adrci_dir.mif [oracle@hisdb2 ~]
ORACLEHOME/log/diag/adrcidir.mif[oracle@hisdb2 ] adrci
ADRCI: Release 19.0.0.0.0 - Production on Thu Apr 28 14:03:34 2022
Copyright © 1982, 2019, Oracle and/or its affiliates. All rights reserved.
ADR base = “/u01/app/oracle”
adrci> show home
ADR Homes:
diag/rdbms/orcl/orcl2
adrci> set home diag/rdbms/orcl/orcl2
adrci> show alert -tail -f
2022-04-28 13:45:05.914000 +08:00
Set master node info
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Reconfiguration complete (total time 0.3 secs)
2022-04-28 13:45:25.092000 +08:00
Increasing number of high priority LMS from 0 to 2
2022-04-28 13:45:34.272000 +08:00
ALTER SYSTEM SET _ipddb_enable=TRUE SCOPE=MEMORY SID=‘orcl2’;
2022-04-28 13:45:42.272000 +08:00
Warning: VKTM detected a forward time drift.
Please see the VKTM trace file for more details:
/u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_vktm_9520.trc
2022-04-28 13:56:01.401000 +08:00
ALTER SYSTEM SET db_files=1000 SCOPE=SPFILE;