2021-09-02
ORACLE 12CR2 RAC 数据库启动失败，报错ORA-00443，但是sqlplus却可以启动，求解？
软硬件环境
操作系统：SUSE 12 SP5
数据库版本：12.2.0.1
内存：两台6G
SWAP：6G
问题描述
RAC搭建完成之后数据库状态正常，将数据库关闭后进行机器的重启，重启完成后运行数据库启动命令发现节点rac1没有起来，但是通过sqlplus命令却可以将数据库启动，启动后通过srvctl status去查看也是not running的状态。
本人的一些操作命令如下：
rac1:~ # srvctl start database -d rac
PRCR-1079 : Failed to start resource ora.rac.db
CRS-5017: The resource action "ora.rac.db start" encountered the following error:
ORA-00443: background process "CKPT" did not start
. For details refer to "(:CLSN00107:)" in "/home/oracle/app/grid/diag/crs/rac1/crs/trace/crsd_oraagent_oracle.trc".
CRS-2674: Start of 'ora.rac.db' on 'rac1' failed
CRS-2632: There are no more servers to try to place resource 'ora.rac.db' on that would satisfy its placement policy
rac1:~ # srvctl status database -d rac
Instance rac1 is not running on node rac1
Instance rac2 is running on node rac2
rac1:~ # su - oracle
oracle@rac1:~> sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Fri Sep 3 00:45:20 2021
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1493172224 bytes
Fixed Size 8620896 bytes
Variable Size 553649312 bytes
Database Buffers 922746880 bytes
Redo Buffers 8155136 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
oracle@rac1:~> srvctl status database -d rac
Instance rac1 is not running on node rac1
Instance rac2 is running on node rac2
日志详情：
/home/oracle/app/grid/diag/crs/rac1/crs/trace/crsd_oraagent_oracle.trc日志
2021-09-02 23:40:46.792 : AGFW:2163021568: {0:35:2} Added new restype: ora.proxy_advm.type
2021-09-02 23:40:46.792 : AGFW:2163021568: {0:35:2} Agent sending last reply for: RESTYPE_ADD[ora.proxy_advm.type] ID 8196:14883
2021-09-02 23:40:46.792 : AGFW:2163021568: {0:35:2} Agent received the message: RESTYPE_ADD[ora.scan_listener.type] ID 8196:14884
2021-09-02 23:40:46.792 : AGFW:2163021568: {0:35:2} Added new restype: ora.scan_listener.type
2021-09-02 23:40:46.793 : AGFW:2163021568: {0:35:2} Agent sending last reply for: RESTYPE_ADD[ora.scan_listener.type] ID 8196:14884
2021-09-02 23:40:46.793 : AGFW:2163021568: {0:35:2} Agent received the message: RESTYPE_ADD[ora.service.type] ID 8196:14886
2021-09-02 23:40:46.793 : AGFW:2163021568: {0:35:2} Added new restype: ora.service.type
2021-09-02 23:40:46.794 : AGFW:2163021568: {0:35:2} Agent sending last reply for: RESTYPE_ADD[ora.service.type] ID 8196:14886
2021-09-02 23:40:46.794 : AGFW:2163021568: {0:35:2} Agent received the message: RESTYPE_ADD[ora.supercluster.type] ID 8196:14887
2021-09-02 23:40:46.798 : AGFW:2163021568: {0:35:2} Added new restype: ora.supercluster.type
2021-09-02 23:40:46.798 : AGFW:2163021568: {0:35:2} Agent sending last reply for: RESTYPE_ADD[ora.supercluster.type] ID 8196:14887
2021-09-02 23:40:46.799 : AGFW:2163021568: {0:35:2} Agent received the message: RESTYPE_ADD[ora.vm.type] ID 8196:14888
2021-09-02 23:40:46.800 : AGFW:2163021568: {0:35:2} Added new restype: ora.vm.type
2021-09-02 23:40:46.800 : AGFW:2163021568: {0:35:2} Agent sending last reply for: RESTYPE_ADD[ora.vm.type] ID 8196:14888
2021-09-02 23:40:46.800 : AGFW:2163021568: {0:35:2} Agent received the message: RESOURCE_ADD[ora.rac.db 1 1] ID 4356:14889
2021-09-02 23:40:46.802 : CLSDADR:2163021568: (:CLSD0023:)dynamic component [R2606027] mapped to [CLSDYNAM]
2021-09-02 23:40:46.802 : AGFW:2163021568: {0:35:2} ID = [ora.rac.db 1 1] Intermediate Timeout = [0]
2021-09-02 23:40:46.802 : AGFW:2163021568: {0:35:2} Added new resource: ora.rac.db 1 1 to the agfw
2021-09-02 23:40:46.803 : AGFW:2163021568: {0:35:2} Agent sending last reply for: RESOURCE_ADD[ora.rac.db 1 1] ID 4356:14889
2021-09-02 23:40:46.803 : AGFW:2163021568: {1:63699:1704} Agent received the message: RESOURCE_START[ora.rac.db 1 1] ID 4098:14890
2021-09-02 23:40:46.804 : AGFW:2163021568: {1:63699:1704} Preparing START command for: ora.rac.db 1 1
2021-09-02 23:40:46.804 : AGFW:2163021568: {1:63699:1704} ora.rac.db 1 1 state changed from: UNKNOWN to: STARTING
2021-09-02 23:40:46.805 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [start] (:CLSN00107:) clsn_agent::start {
2021-09-02 23:40:46.805 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [start] Agent::getResAgent resname:ora.rac.db version:12.2.0.1.0
2021-09-02 23:40:46.806 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [start] Agent::Agent pAgent:0x7fc35c032978 &m_resName:0x7fc35c0329f8 resname:ora.rac.db
2021-09-02 23:40:46.806 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [start] adding state dumper of res:ora.rac.db
2021-09-02 23:40:46.806 : USRTHRD:2165122816: {1:63699:1704} Thread:InstStartThread: thread constructor exit this:5c032350 m_pThnd:0 m_thndMX:5c032370, m_stopMX:5c0323e0 m_tintMX:5c0323c0 m_postMX:5c0323a0
2021-09-02 23:40:46.806 : USRTHRD:2165122816: {1:63699:1704} Thread:DedicatedThread thread constructor exit this:5c0326e8 m_pThnd:0 m_thndMX:5c032708, m_stopMX:5c032778 m_tintMX:5c032758 m_postMX:5c032738
2021-09-02 23:40:46.806 : USRTHRD:2165122816: {1:63699:1704} LsnrRegThd constructor entry threadName:DedicatedThread agent:5c032978 crsHome:/home/oracle/app/12.2.0/grid
2021-09-02 23:40:46.806 : USRTHRD:2165122816: {1:63699:1704} DbAgent::DedicatedThread contructor
2021-09-02 23:40:46.807 : USRTHRD:2165122816: {1:63699:1704} Creating new Subscriber
2021-09-02 23:40:46.807 : USRTHRD:2165122816: {1:63699:1704} Worker::schedule thread 'ReconnectingSubscribers' not already created. Creating
2021-09-02 23:40:46.807 : USRTHRD:2165122816: {1:63699:1704} Thread:ReconnectingSubscribers thread constructor exit this:5c03b4e0 m_pThnd:0 m_thndMX:5c03b500, m_stopMX:5c03b570 m_tintMX:5c03b550 m_postMX:5c03b530
2021-09-02 23:40:46.807 : USRTHRD:2165122816: {1:63699:1704} Worker::schedule adding worker 'ReconnSub-sub-singleton' to thread 'ReconnectingSubscribers'
2021-09-02 23:40:46.807 : USRTHRD:2165122816: {1:63699:1704} WorkerThread::addWorker starting self
2021-09-02 23:40:46.807 : USRTHRD:2165122816: {1:63699:1704} Thread::start { acquire thndMX:5c03b500
2021-09-02 23:40:46.807 : USRTHRD:2165122816: {1:63699:1704} Thread::start spawn pThnd:0x7fc35c033890 thndType:1
2021-09-02 23:40:46.807 : USRTHRD:2165122816: {1:63699:1704} Thread::start thread spawned tid:2171426560
2021-09-02 23:40:46.807 : USRTHRD:2165122816: {1:63699:1704} Thread::start spawned release thndMX:5c03b500 }
2021-09-02 23:40:46.808 : USRTHRD:2165122816: {1:63699:1704} WorkerThread::addWorker waiting for thread to start
2021-09-02 23:40:46.809 : USRTHRD:2165122816: {1:63699:1704} WorkerThread::addWorker waiting for thread to start
2021-09-02 23:40:46.810 : USRTHRD:2165122816: {1:63699:1704} WorkerThread::addWorker waiting for thread to start
/CLSN00107
2021-09-02 23:40:54.422 : USRTHRD:2154616576: {1:63699:1704} InstAgent::startInstance 050 errcode 443
2021-09-02 23:40:54.422 : USRTHRD:2154616576: {1:63699:1704} InstAgent::startInstance 250 untrapped error
2021-09-02 23:40:54.422 : USRTHRD:2154616576: {1:63699:1704} InstAgent::startInstance 350 errcode 443
2021-09-02 23:40:54.422 : USRTHRD:2154616576: {1:63699:1704} InstAgent::startInstance 360 clean
2021-09-02 23:40:54.423 : USRTHRD:2154616576: {1:63699:1704} InstAgent::startInstance 370 excp what:ORA-00443: background process "CKPT" did not start
2021-09-02 23:40:54.423 : USRTHRD:2154616576: {1:63699:1704} InstConnection::~InstConnection destructor this pConnxn:0x7fc34c0324f0
2021-09-02 23:40:54.423 : USRTHRD:2154616576: {1:63699:1704} InstAgent::startInstance 400 schedule check
2021-09-02 23:40:54.423 : USRTHRD:2154616576: {1:63699:1704} CHECK action in progress on ora.rac.db 1 1,queuing 1 more
2021-09-02 23:40:54.423 : USRTHRD:2154616576: {1:63699:1704} Check action requested by agent entry point for ora.rac.db
2021-09-02 23:40:54.423 : USRTHRD:2154616576: {1:63699:1704} InstAgent::startInstance 999 }
2021-09-02 23:40:54.423 : USRTHRD:2154616576: {1:63699:1704} InstStartThread::run call startInstance exception:1 error:0
2021-09-02 23:40:54.423 : USRTHRD:2154616576: {1:63699:1704} Thread:InstStartThread: isRunning is reset to false here
2021-09-02 23:40:54.423 : USRTHRD:2154616576: {1:63699:1704} Thread:InstStartThread: isFinished set to true
2021-09-02 23:40:54.423 : AGFW:2163021568: {1:63699:1704} Agent received the message: RESOURCE_PROBE[ora.rac.db 1 1] ID 4097:44
2021-09-02 23:40:54.424 : AGFW:2163021568: {1:63699:1704} Preparing CHECK command for: ora.rac.db 1 1
2021-09-02 23:40:55.018 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [start] InstAgent::start 340 End Loop thread:0x7fc35c032350 start isAlive:0 isRunning:0
2021-09-02 23:40:55.018 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [start] InstAgent::start 380 Exception occurred in the thread
2021-09-02 23:40:55.019 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [start] clsnUtils::error Exception type=2 string=
CRS-5017: The resource action "ora.rac.db start" encountered the following error:
ORA-00443: background process "CKPT" did not start
. For details refer to "(:CLSN00107:)" in "/home/oracle/app/grid/diag/crs/rac1/crs/trace/crsd_oraagent_oracle.trc".
2021-09-02 23:40:55.020 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [start] InstAgent::start: m_prevState:4 exit }
2021-09-02 23:40:55.020 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [start] (:CLSN00107:) clsn_agent::start }
2021-09-02 23:40:55.020 : AGFW:2165122816: {1:63699:1704} Command: start for resource: ora.rac.db 1 1 completed with status: SUCCESS
2021-09-02 23:40:55.021 : AGFW:2163021568: {1:63699:1704} Agent sending reply for: RESOURCE_START[ora.rac.db 1 1] ID 4098:14890
2021-09-02 23:40:55.021 :CLSFRAME:2373935168: TM [MultiThread] is changing desired thread # to 3. Current # is 2
2021-09-02 23:40:55.022 :CLSFRAME:2373935168: TM [MultiThread] is changing desired thread # to 4. Current # is 3
2021-09-02 23:40:55.023 : AGFW:2163021568: {1:63699:1704} Agent sending reply for: RESOURCE_START[ora.rac.db 1 1] ID 4098:14890
2021-09-02 23:40:55.025 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [check] (:CLSN00109:) Agent::commonCheck check failed action:0101 retval:5
2021-09-02 23:40:55.025 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [check] Agent::doStateDump Default Agent Dump
2021-09-02 23:40:55.025 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [check] Agent::doStateDump last call info:
2021-09-02 23:40:55.025 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [check] Time:09/02/2021 23:40:54.422 Tint:{1:63699:1704} action:none resname:ora.rac.db lastCall:InstAgent::startInstance 250 untrapped error
2021-09-02 23:40:55.025 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [check] Time:09/02/2021 23:40:54.422 Tint:{1:63699:1704} action:none resname:ora.rac.db lastCall:InstAgent::startInstance 350 errcode 443
2021-09-02 23:40:55.025 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [check] Time:09/02/2021 23:40:54.422 Tint:{1:63699:1704} action:none resname:ora.rac.db lastCall:InstAgent::startInstance 360 clean
2021-09-02 23:40:55.025 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [check] Time:09/02/2021 23:40:54.422 Tint:{1:63699:1704} action:none resname:ora.rac.db lastCall:InstAgent::startInstance 370 excp what:ORA-00443: background process "CKPT" did not start
2021-09-02 23:40:55.025 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [check] Time:09/02/2021 23:40:54.423 Tint:{1:63699:1704} action:none resname:ora.rac.db lastCall:InstConnection::~InstConnection destructor this pConnxn:0x7fc34c0324f0
2021-09-02 23:40:55.025 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [check] Time:09/02/2021 23:40:54.423 Tint:{1:63699:1704} action:none resname:ora.rac.db lastCall:InstAgent::startInstance 400 schedule check
2021-09-02 23:40:55.025 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [check] Time:09/02/2021 23:40:54.423 Tint:{1:63699:1704} action:none resname:ora.rac.db lastCall:InstAgent::startInstance 999 }
2021-09-02 23:40:55.025 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [check] Time:09/02/2021 23:40:54.423 Tint:{1:63699:1704} action:none resname:ora.rac.db lastCall:InstStartThread::run call startInstance exception:1 error:0
2021-09-02 23:40:55.025 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [check] Time:09/02/2021 23:40:55.18 Tint:{1:63699:1704} action:101 resname:ora.rac.db lastCall:InstAgent::start 340 End Loop thread:0x7fc35c032350 start isAlive:0 isRunning:0
2021-09-02 23:40:55.025 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [check] Time:09/02/2021 23:40:55.18 Tint:{1:63699:1704} action:101 resname:ora.rac.db lastCall:InstAgent::start 380 Exception occurred in the thread
2021-09-02 23:40:55.025 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [check] Time:09/02/2021 23:40:55.19 Tint:{1:63699:1704} action:101 resname:ora.rac.db lastCall:InstAgent::start: m_prevState:4 exit }
2021-09-02 23:40:55.025 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [check] Time:09/02/2021 23:40:55.24 Tint:{1:63699:1704} action:104 resname:ora.rac.db lastCall:Agent::commonCheck entry {
2021-09-02 23:40:55.025 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [check] Time:09/02/2021 23:40:55.24 Tint:{1:63699:1704} action:104 resname:ora.rac.db lastCall:Agent::commonCheck notifyObservers
2021-09-02 23:40:55.025 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [check] Time:09/02/2021 23:40:55.24 Tint:{1:63699:1704} action:104 resname:ora.rac.db lastCall:Agent::commonCheck call check
2021-09-02 23:40:55.025 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [check] Time:09/02/2021 23:40:55.24 Tint:{1:63699:1704} action:104 resname:ora.rac.db lastCall:InstAgent::check entry { m_connectionLock:0x7fc35c032550
2021-09-02 23:40:55.025 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [check] Time:09/02/2021 23:40:55.25 Tint:{1:63699:1704} action:104 resname:ora.rac.db lastCall:InstAgent::check m_comment:StartOption[1]
2021-09-02 23:40:55.025 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [check] Time:09/02/2021 23:40:55.25 Tint:{1:63699:1704} action:104 resname:ora.rac.db lastCall:InstAgent::check isCleanRequired:1 ret:5
2021-09-02 23:40:55.025 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [check] Time:09/02/2021 23:40:55.25 Tint:{1:63699:1704} action:104 resname:ora.rac.db lastCall:InstAgent::check exit clsagfw_res_status:5 }
2021-09-02 23:40:55.025 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [check] Time:09/02/2021 23:40:55.25 Tint:{1:63699:1704} action:104 resname:ora.rac.db lastCall:Agent::commonCheck check clsagfw_res_status:5
2021-09-02 23:40:55.025 :CLSDYNAM:2165122816: [ora.rac.db]{1:63699:1704} [check] Time:09/02/2021 23:40:55.25 Tint:{1:63699:1704} action:104 resname:ora.rac.db lastCall:(:CLSN00109:) Agent::commonCheck check failed action:0101 retval:5
2021-09-02 23:40:55.027 : AGFW:2163021568: {1:63699:1704} ora.rac.db 1 1 state changed from: STARTING to: FAILED
-------------------------------------
alert.log日志
2021-09-02 23:40:46.673 [ORAAGENT(82200)]CRS-8500: Oracle Clusterware ORAAGENT process is starting with operating system process ID 82200
2021-09-02 23:40:55.019 [ORAAGENT(82200)]CRS-5017: The resource action "ora.rac.db start" encountered the following error:
2021-09-02 23:40:55.019+ORA-00443: background process "CKPT" did not start
. For details refer to "(:CLSN00107:)" in "/home/oracle/app/grid/diag/crs/rac1/crs/trace/crsd_oraagent_oracle.trc".
2021-09-02 23:54:09.397 [CVUD(85079)]CRS-10051: CVU found following errors with Clusterware setup : PRVF-5431 : Oracle Cluster Voting Disk configuration check failed
我来答
添加附件
收藏
分享
问题补充
4条回答
默认
最新
既然是集群，就先把集群只能启动单节点时的状态打印出来看下。根据你的描述，我怀疑是第二个节点某些地方没配置好。最简单的方法是先在主节点上从集群中删除掉第二个节点，然后重新加入第二个节点到集群中。
crsctl status res -t 先打印集群信息出来看下
评论
有用 0rac2已经启动了，要启动单独的实例，srvctl start instance -d dbname -i instance_name
另外，看日志好像是在root下执行的srvctl start database命令？
评论 有用 0crsctl status res -t 打印的日志
rac1:~ # srvctl status database -d rac
Instance rac1 is not running on node rac1
Instance rac2 is running on node rac2
rac1:~ # crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.DATA.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.OCR.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.chad
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.net1.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ons
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE rac1 169.254.64.42 10.0.0
.12,STABLE
ora.asm
1 ONLINE ONLINE rac1 Started,STABLE
2 ONLINE ONLINE rac2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE rac1 STABLE
ora.mgmtdb
1 ONLINE ONLINE rac1 Open,STABLE
ora.qosmserver
1 ONLINE OFFLINE STABLE
ora.rac.db
1 ONLINE OFFLINE Instance Shutdown,ST
ABLE
2 ONLINE ONLINE rac2 Open,HOME=/home/orac
le/app/oracle/produc
t/12.2.0/dbhome_1,ST
ABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan1.vip
1 ONLINE ONLINE rac1 STABLE
--------------------------------------------------------------------------------
rac1:~ # srvctl start qosmserver
QoS Management Server could not be started.
PRCR-1079 : Failed to start resource ora.qosmserver
CRS-2674: Start of 'ora.qosmserver' on 'rac2' failed
CRS-2674: Start of 'ora.qosmserver' on 'rac1' failed
CRS-2632: There are no more servers to try to place resource 'ora.qosmserver' on that would satisfy its placement policy
rac1:~ #
通过sqlplus启动数据库后服务却正常
rac1:~ # su - oracle
oracle@rac1:~> sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Fri Sep 3 22:08:19 2021
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1493172224 bytes
Fixed Size 8620896 bytes
Variable Size 553649312 bytes
Database Buffers 922746880 bytes
Redo Buffers 8155136 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
oracle@rac1:~> srvctl status database -d rac
Instance rac1 is running on node rac1
Instance rac2 is running on node rac2
oracle@rac1:~> srvctl status database -d rac
Instance rac1 is running on node rac1
Instance rac2 is running on node rac2
oracle@rac1:~> crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.DATA.dg
ONLINE INTERMEDIATE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.OCR.dg
ONLINE INTERMEDIATE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.chad
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.net1.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ons
ONLINE OFFLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE rac1 169.254.64.42 10.0.0
.12,STABLE
ora.asm
1 ONLINE ONLINE rac1 Started,STABLE
2 ONLINE ONLINE rac2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE rac1 STABLE
ora.mgmtdb
1 ONLINE ONLINE rac1 Open,STABLE
ora.qosmserver
1 ONLINE OFFLINE STABLE
ora.rac.db
1 ONLINE ONLINE rac1 Open,HOME=/home/orac
le/app/oracle/produc
t/12.2.0/dbhome_1,ST
ABLE
2 ONLINE ONLINE rac2 Open,HOME=/home/orac
le/app/oracle/produc
t/12.2.0/dbhome_1,ST
ABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan1.vip
1 ONLINE ONLINE rac1 STABLE
--------------------------------------------------------------------------------
oracle@rac1:~>
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签，敬请期待~~
墨值悬赏