Oracle rac dataguard sqlplus啟動不了資料庫
1.問題描述
使用srvctl命令查看集群節點的資料庫狀態都是正常的running狀態，
[oracle@stbrac2 dbs]$ srvctl status database -d stbrac
Instance stbrac1 is running on node stbrac1
Instance stbrac2 is running on node stbrac2
使用crsctl 命令查詢集群的各個服務也是顯示正常的，
[oracle@stbrac2 dbs]$ crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE stbrac1 STABLE
ONLINE ONLINE stbrac2 STABLE
ora.DATA.dg
ONLINE ONLINE stbrac1 STABLE
ONLINE ONLINE stbrac2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE stbrac1 STABLE
ONLINE ONLINE stbrac2 STABLE
ora.OCR.dg
ONLINE ONLINE stbrac1 STABLE
ONLINE ONLINE stbrac2 STABLE
ora.chad
ONLINE ONLINE stbrac1 STABLE
ONLINE ONLINE stbrac2 STABLE
ora.net1.network
ONLINE ONLINE stbrac1 STABLE
ONLINE ONLINE stbrac2 STABLE
ora.ons
ONLINE ONLINE stbrac1 STABLE
ONLINE ONLINE stbrac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE stbrac1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE stbrac1 169.254.142.38 10.0.
0.81,STABLE
ora.asm
1 ONLINE ONLINE stbrac1 Started,STABLE
2 ONLINE ONLINE stbrac2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE stbrac1 STABLE
ora.mgmtdb
1 ONLINE ONLINE stbrac1 Open,STABLE
ora.qosmserver
1 ONLINE ONLINE stbrac1 STABLE
ora.scan1.vip
1 ONLINE ONLINE stbrac1 STABLE
ora.stbrac.db
1 ONLINE INTERMEDIATE stbrac1 Mounted (Closed),HOM
E=/u01/app/oracle/pr
oduct/12.2.0/dbhome_
1,STABLE
2 ONLINE INTERMEDIATE stbrac2 Mounted (Closed),HOM
E=/u01/app/oracle/pr
oduct/12.2.0/dbhome_
1,STABLE
ora.stbrac1.vip
1 ONLINE ONLINE stbrac1 STABLE
ora.stbrac2.vip
1 ONLINE ONLINE stbrac2 STABLE
--------------------------------------------------------------------------------
使用sqlplus命令進入到客戶端控制臺，確顯示Connected to an idle instance.
[oracle@stbrac2 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sun Sep 26 07:18:09 2021
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/12.2.0/dbhome_1/dbs/initrac2.ora'
SQL> show parameter dg_broker
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
SQL>
2.解決辦法
執行startup nomount命令后報錯找不到‘/u01/app/oracle/product/12.2.0/dbhome_1/dbs/initrac2.ora’引數檔案，由于這臺機器是dataguard的rac備機，服務名應該是stbrac2，但是這里提示是initrac2.ora檔案不存在，因此我懷疑是ORACLE_SID設定錯了，
export ORACLE_SID=stbrac2
修改完ORACLE_SID環境變數后重新進入sqlplus發現正常了，
[oracle@stbrac2 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sun Sep 26 10:12:44 2021
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> show parameter dg_broker
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1 string +DATA/STBRAC/DGCONFIG/dr1stbra
c.dat
dg_broker_config_file2 string +DATA/STBRAC/DGCONFIG/dr2stbra
c.dat
dg_broker_start boolean TRUE
SQL>
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/304044.html
標籤：區塊鏈
上一篇：一文了解華為Gauss資料庫：開發歷程、OLTP&OLAP特點、行式&列式存盤，及與Oracle和AWS對比...
下一篇：簡易投票系統資料庫設計