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 先打印集群信息出来看下
评论
有用 0 打赏 0
rac2已经启动了，要启动单独的实例，srvctl start instance -d dbname -i instance_name
另外，看日志好像是在root下执行的srvctl start database命令？
评论 有用 0 打赏 0
crsctl 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:~>复制
评论 有用 0 打赏 0
ora.ons
ONLINE OFFLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
RAC1上的高可用是offline的。
评论 有用 0 打赏 0
回答交流
Markdown
请输入正文
提交
相关推荐
单机版的oracle19.3的静默安装GI怎么配置？
回答 1
单节点为什么要配置GI？不是可以直接安装数据库软件了嘛？https://www.modb.pro/db/45482
如何找到登录Oracle数据库失败的客户端IP
回答 3
已采纳
1、可以通过以下触发器，将登录失败的IP来源记录到alertSID.log日志中;CREATEORREPLACETRIGGERlogondeniedtoalerttestAFTERservererro
AWR分析报告问题求助：数据库出现严重的log file sync等待，如何解决
回答 4
1、存储IO可能也有问题，需要存储工程师检查一下。2、检查redolog以及alert日志，检查日志切换频率，一般建议1520分钟切换一次，重新设计redo日志组3、“usercommits”也很高，
21C的时间好像没有取时区。在操作系统中，是能看到时区的。但是使用sysdate获得的时间没有带上时区。是不是Bug
回答 1
oracle中时区和时间是分开的，这个tochar固定了输出格式，当然看不到时区的。时区是可以单独查询的：selectdbtimezonefromdual;selectsessiontimezonef
Oracle查询number类型的列不等于整数的函数是什么？
回答 1
你可以用TRUNC(num字段)和原字段减一下判断是否为0，就能找到非整数值。比如CASEWHENC1TRUNC(C1)0THEN'整数'ELSE'非整数'
以下哪种方法可以回收Oracle表段中的可用空间？
回答 3
已采纳
选ABC；解析：D.altertableshrinkspacecompact会移动表中的行并整理表上的碎片，但并不会调整高水位，也不会释放已占用的空间。只有不带compact选项时，才会调整高水位并释
oracle11.2.0.4 单实例 打补丁问题
回答 1
可以借鉴以下两篇（MOS）文章：753041.11112983.1
Oracle 11GR2 32bit客户端静默安装报错
回答 1
盲猜，设个ORACLEHOSTNAME机器名的环境变量
Oracle 中 一个事务COMMIT后能ROLLBACK吗？
回答 1
已采纳
在一个事务中，rollback和commit都代表结束一个事务，想恢复可以用flashback
oracle 数据库中的码值表是不是就是字典表?
回答 2
已采纳
Oracle中没有码值表这一说，字典表就是数据库中系统视图。
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签，敬请期待~~
