oracle 11g rac 监听无法启动

最新推荐文章于 2022-07-06 21:24:25 发布
最新推荐文章于 2022-07-06 21:24:25 发布
阅读量1k 收藏
点赞数
文章标签： 数据库
原文链接：http://www.cnblogs.com/pandakeeper/p/9070567.html
版权

   1.数据库启动集群报错

[root@db1 bin]# ./crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host        
----------------------------------------------------------------------
ora.BACKUP.dg  ora....up.type 0/5    0/     ONLINE    ONLINE    db1         
ora.DATA.dg    ora....up.type 0/5    0/     ONLINE    ONLINE    db1         
ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    OFFLINE               
ora....N1.lsnr ora....er.type 0/5    0/0    ONLINE    OFFLINE               
ora.OCR.dg     ora....up.type 0/5    0/     ONLINE    ONLINE    db1         
ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    db1         
ora.cvu        ora.cvu.type   0/5    0/0    ONLINE    ONLINE    db1         
ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    db1         
ora....B1.lsnr application    0/5    0/0    ONLINE    OFFLINE               
ora.db1.gsd    application    0/5    0/0    OFFLINE   OFFLINE               
ora.db1.ons    application    0/3    0/0    ONLINE    OFFLINE               
ora.db1.vip    ora....t1.type 0/0    0/0    ONLINE    ONLINE    db1         
ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    db2         
ora....B2.lsnr application    0/5    0/0    ONLINE    OFFLINE               
ora.db2.gsd    application    0/5    0/0    OFFLINE   OFFLINE               
ora.db2.ons    application    0/3    0/0    ONLINE    OFFLINE               
ora.db2.vip    ora....t1.type 0/0    0/0    ONLINE    ONLINE    db2         
ora.gsd        ora.gsd.type   0/5    0/     OFFLINE   OFFLINE               
ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    db1         
ora.oc4j       ora.oc4j.type  0/1    0/2    ONLINE    OFFLINE               
ora.ons        ora.ons.type   0/3    0/     ONLINE    OFFLINE               
ora.racdb.db   ora....se.type 0/2    0/1    ONLINE    OFFLINE               
ora....ry.acfs ora....fs.type 0/5    0/     ONLINE    ONLINE    db1         
ora.scan1.vip  ora....ip.type 0/0    0/0    ONLINE    OFFLINE               
[root@db1 bin]# ./srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is not running
[root@db1 bin]# ./srvctl start listener
PRCR-1079 : Failed to start resource ora.LISTENER.lsnr
CRS-5016: Process "/u01/app/11.2.0/grid/bin/lsnrctl" spawned by agent "/u01/app/11.2.0/grid/bin/oraagent.bin" for action "start" failed: details at "(:CLSN00010:)" in "/u01/app/11.2.0/grid/log/db2/agent/crsd/oraagent_grid/oraagent_grid.log"
CRS-5016: Process "/u01/app/11.2.0/grid/bin/lsnrctl" spawned by agent "/u01/app/11.2.0/grid/bin/oraagent.bin" for action "start" failed: details at "(:CLSN00010:)" in "/u01/app/11.2.0/grid/log/db1/agent/crsd/oraagent_grid/oraagent_grid.log"
CRS-5016: Process "/u01/app/11.2.0/grid/bin/lsnrctl" spawned by agent "/u01/app/11.2.0/grid/bin/oraagent.bin" for action "start" failed: details at "(:CLSN00010:)" in "/u01/app/11.2.0/grid/log/db2/agent/crsd/oraagent_grid/oraagent_grid.log"
CRS-5016: Process "/u01/app/11.2.0/grid/bin/lsnrctl" spawned by agent "/u01/app/11.2.0/grid/bin/oraagent.bin" for action "start" failed: details at "(:CLSN00010:)" in "/u01/app/11.2.0/grid/log/db1/agent/crsd/oraagent_grid/oraagent_grid.log"
CRS-2674: Start of 'ora.LISTENER.lsnr' on 'db2' failed
CRS-2674: Start of 'ora.LISTENER.lsnr' on 'db1' failed

[root@db1 oraagent_grid]# tail -50 oraagent_grid.log
2018-05-22 09:53:56.551: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] Adding Environment Variables TNS_ADMIN=/u01/app/11.2.0/grid/network/admin/
2018-05-22 09:53:56.551: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] Adding Environment variable from USR_ORA_ENV ORACLE_BASE=/u01/app/grid
2018-05-22 09:53:56.551: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] Utils:execCmd action = 3 flags = 38 ohome = (null) cmdname = lsnrctl.
2018-05-22 09:53:56.551: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] getOracleHomeAttrib: oracle_home = /u01/app/11.2.0/grid
2018-05-22 09:53:56.653: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] (:CLSN00010:)
2018-05-22 09:53:56.653: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] (:CLSN00010:)LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 22-MAY-2018 09:53:56
2018-05-22 09:53:56.653: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] (:CLSN00010:)
2018-05-22 09:53:56.653: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] (:CLSN00010:)Copyright (c) 1991, 2013, Oracle. All rights reserved.
2018-05-22 09:53:56.653: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] (:CLSN00010:)
2018-05-22 09:53:56.653: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] (:CLSN00010:)Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
2018-05-22 09:53:56.653: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] (:CLSN00010:)
2018-05-22 09:53:58.255: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] (:CLSN00010:)TNS-12541: TNS:no listener
2018-05-22 09:53:58.255: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] (:CLSN00010:) TNS-12560: TNS:protocol adapter error
2018-05-22 09:53:58.255: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] (:CLSN00010:) TNS-00511: No listener
2018-05-22 09:53:58.255: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] (:CLSN00010:) Linux Error: 111: Connection refused
2018-05-22 09:53:58.255: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] (:CLSN00010:)
2018-05-22 09:53:58.256: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] (:CLSN00010:)Utils:execCmd scls_process_join() uret 1

2018-05-22 09:53:58.256: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] execCmd ret = 1
2018-05-22 09:53:58.256: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] (:CLSN00010:)
2018-05-22 09:53:58.256: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] (:CLSN00010:)LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 22-MAY-2018 09:53:56
2018-05-22 09:53:58.256: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] (:CLSN00010:)
2018-05-22 09:53:58.256: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] (:CLSN00010:)Copyright (c) 1991, 2013, Oracle. All rights reserved.
2018-05-22 09:53:58.256: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] (:CLSN00010:)
2018-05-22 09:53:58.256: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] (:CLSN00010:)Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
2018-05-22 09:53:58.256: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] (:CLSN00010:)TNS-12541: TNS:no listener
2018-05-22 09:53:58.256: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] (:CLSN00010:) TNS-12560: TNS:protocol adapter error
2018-05-22 09:53:58.256: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] (:CLSN00010:) TNS-00511: No listener
2018-05-22 09:53:58.256: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] (:CLSN00010:) Linux Error: 111: Connection refused
2018-05-22 09:53:58.256: [ora.LISTENER.lsnr][3503482624]{1:4489:169} [check] (:CLSN00010:)
2018-05-22 09:53:58.256: [ AGFW][3501381376]{1:4489:169} ora.LISTENER.lsnr db1 1 state changed from: STARTING to: OFFLINE
2018-05-22 09:53:58.257: [ AGFW][3501381376]{1:4489:169} Agent sending last reply for: RESOURCE_START[ora.LISTENER.lsnr db1 1] ID 4098:850
2018-05-22 09:54:07.297: [CLSFRAME][3522594592] TM [MultiThread] is changing desired thread # to 5. Current # is 6
2018-05-22 09:54:07.298: [CLSFRAME][2876454656]{0:1:8} Worker thread is exiting in TM [MultiThread] to meet the desired count of 5. New count is 5
2018-05-22 09:54:37.120: [ AGFW][3501381376]{1:4489:2} Agent received the message: AGENT_HB[Engine] ID 12293:956
2018-05-22 09:54:37.120: [ AGFW][3501381376]{1:4489:2} Deleting the resource: ora.LISTENER_SCAN1.lsnr 1 1
2018-05-22 09:54:37.272: [ora.asm][2882758400]{1:4489:2} [check] AsmProxyAgent:setAttrsFromSrcRes 2 m_oracleSid +ASM1 cmdId 260 checkType 3 flag 32
2018-05-22 09:54:37.272: [ora.asm][2882758400]{1:4489:2} [check] CrsCmd::ClscrsCmdData::stat entity 1 statflag 32 useFilter 0
2018-05-22 09:54:37.299: [ USRTHRD][2882758400]{1:4489:2} Thread:ASM DedicatedThreadstart {
2018-05-22 09:54:37.299: [ USRTHRD][2882758400]{1:4489:2} Thread:ASM DedicatedThreadstart }
2018-05-22 09:54:37.299: [ USRTHRD][2876454656]{1:4489:2} ASM Dedicated Thread {
2018-05-22 09:54:37.299: [ USRTHRD][2876454656]{1:4489:2} AsmProxyAgent::setGenUsrOraInst updating GEN_USR_ORA_INST_NAME@SERVERNAME(db1) to +ASM1
2018-05-22 09:54:37.299: [ora.asm][2882758400]{1:4489:2} [check] CrsCmd::ClscrsCmdData::stat entity 1 statflag 33 useFilter 0
2018-05-22 09:54:37.300: [ USRTHRD][2876454656]{1:4489:2} CrsCmd::ClscrsCmdData::stat entity 1 statflag 32 useFilter 0
2018-05-22 09:54:37.320: [ora.asm][2882758400]{1:4489:2} [check] AsmProxyAgent::check clsagfw_res_status 0
2018-05-22 09:54:37.327: [ USRTHRD][2876454656]{1:4489:2} setResAttrib: attr GEN_USR_ORA_INST_NAME@SERVERNAME(db1) clsagfw attribVal +ASM1 clscrs tmpAttrValue +ASM1
2018-05-22 09:54:37.327: [ USRTHRD][2876454656]{1:4489:2} setResAttrib clsagfw_modify_attribute attr GEN_USR_ORA_INST_NAME@SERVERNAME(db1) value +ASM1 retCode 0
2018-05-22 09:54:37.327: [ USRTHRD][2876454656]{1:4489:2} ASM Dedicated Thread }
2018-05-22 09:54:37.327: [ USRTHRD][2876454656]{1:4489:2} Thread:ASM DedicatedThreadisRunning is reset to false here
2018-05-22 09:55:07.122: [ AGFW][3501381376]{1:4489:2} Agent received the message: AGENT_HB[Engine] ID 12293:975

查看/etc/hosts文件，发现127.0.0.1被注释，打开注释，重启crs

[root@db1 oraagent_grid]# cat /etc/hosts
#127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
#::1         localhost localhost.localdomain localhost6 localhost6.localdomain6


[root@db1 oraagent_grid]# vi /etc/hosts
#127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
#::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

　　

[root@db1 oraagent_grid]# cd /u01/app/11.2.0/grid/bin
[root@db1 bin]# ./crsctl stop cluster -all
CRS-2673: Attempting to stop 'ora.crsd' on 'db1'
CRS-2673: Attempting to stop 'ora.crsd' on 'db2'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'db1'
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'db1'
CRS-2673: Attempting to stop 'ora.db1.vip' on 'db1'
CRS-2673: Attempting to stop 'ora.OCR.dg' on 'db1'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'db1'
CRS-2673: Attempting to stop 'ora.racdb.db' on 'db1'
CRS-2673: Attempting to stop 'ora.oc4j' on 'db1'
CRS-2673: Attempting to stop 'ora.cvu' on 'db1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'db2'
CRS-2673: Attempting to stop 'ora.db2.vip' on 'db2'
CRS-2673: Attempting to stop 'ora.OCR.dg' on 'db2'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'db2'
CRS-2673: Attempting to stop 'ora.racdb.db' on 'db2'
CRS-2677: Stop of 'ora.cvu' on 'db1' succeeded
CRS-2677: Stop of 'ora.db2.vip' on 'db2' succeeded
CRS-2677: Stop of 'ora.racdb.db' on 'db1' succeeded
CRS-2673: Attempting to stop 'ora.BACKUP.dg' on 'db1'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'db1'
CRS-2677: Stop of 'ora.racdb.db' on 'db2' succeeded
CRS-2673: Attempting to stop 'ora.BACKUP.dg' on 'db2'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'db2'
CRS-2677: Stop of 'ora.registry.acfs' on 'db2' succeeded
CRS-2677: Stop of 'ora.registry.acfs' on 'db1' succeeded
CRS-2677: Stop of 'ora.scan1.vip' on 'db1' succeeded
CRS-2677: Stop of 'ora.BACKUP.dg' on 'db1' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'db2' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'db1' succeeded
CRS-2677: Stop of 'ora.BACKUP.dg' on 'db2' succeeded
CRS-2677: Stop of 'ora.db1.vip' on 'db1' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'db1' succeeded
CRS-2677: Stop of 'ora.OCR.dg' on 'db2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'db2'
CRS-2677: Stop of 'ora.OCR.dg' on 'db1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'db1'
CRS-2677: Stop of 'ora.asm' on 'db2' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'db2'
CRS-2677: Stop of 'ora.net1.network' on 'db2' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'db2' has completed
CRS-2677: Stop of 'ora.asm' on 'db1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'db1'
CRS-2677: Stop of 'ora.net1.network' on 'db1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'db1' has completed
CRS-2677: Stop of 'ora.crsd' on 'db2' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'db2'
CRS-2673: Attempting to stop 'ora.evmd' on 'db2'
CRS-2673: Attempting to stop 'ora.asm' on 'db2'
CRS-2677: Stop of 'ora.crsd' on 'db1' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'db1'
CRS-2673: Attempting to stop 'ora.evmd' on 'db1'
CRS-2673: Attempting to stop 'ora.asm' on 'db1'
CRS-2677: Stop of 'ora.evmd' on 'db2' succeeded
CRS-2677: Stop of 'ora.evmd' on 'db1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'db2' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'db1' succeeded
CRS-2677: Stop of 'ora.asm' on 'db2' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'db2'
CRS-2677: Stop of 'ora.asm' on 'db1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'db1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'db1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'db1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'db2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'db2'
CRS-2677: Stop of 'ora.cssd' on 'db1' succeeded
CRS-2677: Stop of 'ora.cssd' on 'db2' succeeded
[root@db1 bin]# ./crsctl start cluster -all
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'db1'
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'db2'
CRS-2676: Start of 'ora.cssdmonitor' on 'db2' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'db2'
CRS-2672: Attempting to start 'ora.diskmon' on 'db2'
CRS-2676: Start of 'ora.diskmon' on 'db2' succeeded
CRS-2676: Start of 'ora.cssdmonitor' on 'db1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'db1'
CRS-2672: Attempting to start 'ora.diskmon' on 'db1'
CRS-2676: Start of 'ora.diskmon' on 'db1' succeeded
CRS-2676: Start of 'ora.cssd' on 'db2' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'db2'
CRS-2676: Start of 'ora.cssd' on 'db1' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'db1'
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'db1'
CRS-2676: Start of 'ora.ctssd' on 'db2' succeeded
CRS-2672: Attempting to start 'ora.evmd' on 'db2'
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'db2'
CRS-2676: Start of 'ora.ctssd' on 'db1' succeeded
CRS-2672: Attempting to start 'ora.evmd' on 'db1'
CRS-2676: Start of 'ora.evmd' on 'db2' succeeded
CRS-2676: Start of 'ora.evmd' on 'db1' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'db1' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'db1'
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'db2' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'db2'
CRS-2676: Start of 'ora.asm' on 'db1' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'db1'
CRS-2676: Start of 'ora.asm' on 'db2' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'db2'
CRS-2676: Start of 'ora.crsd' on 'db1' succeeded
CRS-2676: Start of 'ora.crsd' on 'db2' succeeded
[root@db1 bin]# ./crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host        
----------------------------------------------------------------------
ora.BACKUP.dg  ora....up.type 0/5    0/     ONLINE    ONLINE    db1         
ora.DATA.dg    ora....up.type 0/5    0/     ONLINE    ONLINE    db1         
ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    db1         
ora....N1.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    db1         
ora.OCR.dg     ora....up.type 0/5    0/     ONLINE    ONLINE    db1         
ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    db1         
ora.cvu        ora.cvu.type   0/5    0/0    ONLINE    ONLINE    db1         
ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    db1         
ora....B1.lsnr application    0/5    0/0    ONLINE    ONLINE    db1         
ora.db1.gsd    application    0/5    0/0    OFFLINE   OFFLINE               
ora.db1.ons    application    0/3    0/0    ONLINE    ONLINE    db1         
ora.db1.vip    ora....t1.type 0/0    0/0    ONLINE    ONLINE    db1         
ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    db2         
ora....B2.lsnr application    0/5    0/0    ONLINE    ONLINE    db2         
ora.db2.gsd    application    0/5    0/0    OFFLINE   OFFLINE               
ora.db2.ons    application    0/3    0/0    ONLINE    ONLINE    db2         
ora.db2.vip    ora....t1.type 0/0    0/0    ONLINE    ONLINE    db2         
ora.gsd        ora.gsd.type   0/5    0/     OFFLINE   OFFLINE               
ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    db1         
ora.oc4j       ora.oc4j.type  0/1    0/2    ONLINE    ONLINE    db1         
ora.ons        ora.ons.type   0/3    0/     ONLINE    ONLINE    db1         
ora.racdb.db   ora....se.type 0/2    0/1    ONLINE    ONLINE    db1         
ora....ry.acfs ora....fs.type 0/5    0/     ONLINE    ONLINE    db1         
ora.scan1.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    db1

　　

转载于:https://www.cnblogs.com/pandakeeper/p/9070567.html

weixin_33716557
关注
Oracle R2 11g rac监听启动/停止
weixin_33804990的博客
01-07 1万+
切换到grid用户，在其中一个节点执行如下： srvctl stop listener -n ams2 srvctl start listener -n ams2 srvctl stop listener -n ams1 srvctl start listener -n ams1 crs_stop ora.LISTENER_SCAN1.lsnr crs_stop ora.scan1.vip ...
集群起不来oracle,Oracle11g rac 集群无法启动分析及处理
weixin_42410477的博客
04-03 1338
n this DocumentApplies to:Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterInformation in this document applies to any platform.Purpose本文档的目的是总结可能阻止 Grid Infrastructure (GI) 成功启动的 5 大问...
oracle11g监听打不开,Oracle11g 监听程序无法启动个案解决方法
weixin_30697437的博客
04-06 969
今天启动oracle服务的时候，发现listener起不来了。使用lsnrctlLSNRCTL> start启动tnslsnr: 请稍候...TNSLSNR for 32-bit Windows: Version 11.1.0.6.0 - Production系统参数文件为d:\app\qiao\product\11.1.0\db_1\network\admin\listener.ora写入...
oracle rac监听程序,Oracle 11g RAC 监听程序offline
weixin_30022923的博客
04-06 158
Oracle 11gRAC 监听程序在调整过网络后出现监听进程offline，而且两台节点之间频繁切换，查看日志/var/log/message 发现有频繁的注册撤销动作。监听日志 /u01/app/oracle/diag/tnslsnr/rac1/listener/trace/listener.log监听文件 /u01/app/11.2.0/grid/network/admin/listene...
oracle rac监听重启,Oracle 11g RAC 监听日常管理
weixin_27727467的博客
04-11 3616
需要必须掌握的命令，上周遇到了一个小问题，就是需要重启数据库监听，有的同学竟然使用oracle用户重启监听，原理就搞错了怎么行。以下操作都需要再grid用户下进行操作。1、查看监听状态$srvctl status listenerListener LISTENER is enabledListener LISTENER is running on node(s): roidb1,roidb2$sr...
oracle重启rac2监听,RAC监听服务
weixin_35612315的博客
04-09 1352
一.服务器端均衡(Server-SideLB)工作原理：1.该均衡实现是依赖于Listener收集的负载信息。在数据库运行过程中，PMON后台进程会收集数系统的负载信息，然后登记到Listener中。2.PMON进程不仅会向本地的Listener注册，也会想其他节点上的Listener注册，但到底向何处注册，是由Remote_Listeners和Local_Listener这两个参数决定。Loc...
Oracle 11g RAC+DG安装配置
08-09
Oracle 11g RAC (Real Application Clusters) 和 Data Guard 是两个重要的 Oracle 数据库高可用性和灾难恢复解决方案。RAC 允许多个实例在同一个数据库上并行工作，提供故障切换和负载均衡，而 Data Guard 提供了...
Oracle 11g RAC+DG 非常牛逼的部署手册
09-19
2.2 配置 Oracle 11g RAC：配置 Oracle 11g RAC 的数据库参数，包括数据库名称、实例名称、监听器配置等。 3. 配置 ASM 磁盘组 3.1 创建 ASM 磁盘组：创建 ASM 磁盘组，以便存储数据库的数据文件。 3.2 配置 ASM ...
Oracle 11g RAC--安装参考手册 pdf.zip
04-26
Oracle 11g Real Application Clusters (RAC) 是Oracle数据库的一个重要特性，它提供了高可用性和可伸缩性，允许多个数据库实例共享同一物理数据库。这个安装参考手册是为那些希望部署Oracle 11g RAC环境的IT专业...
Linux7.6+Oracle 11g+RAC+multipath.pdf
09-23
《Linux7.6+Oracle 11g+RAC+multipath》的文档详细介绍了如何在VMware环境下搭建和管理Oracle数据库系统。本教程适用于数据库工程师、软件工程师以及对数据库学习感兴趣的人员，旨在帮助读者熟练掌握Linux7.6的安装...
shutdown immediate 导致数据库无法重启(上)
weixin_30307267的博客
07-01 224
1.shutdown immediate 长时间没反应，直接关闭SQLPLUS，导致数据库无法连接：ORA-12514TNS监听程序当前无法识别连接描述符中请求服务 如下是解决思路： 根据出错信息判断出客户端未监听到实例服务名 1、通过重启服务的方式启动数据库，再次连接仍无法连接服务器。 2、既然第一种方法不能解决问题，那就第二种方法。考虑监听list...
RAC环境下listener无法启动案例分析
lb517290079的专栏
04-26 201
RAC系统重新配置listener后无法启动: [root@rac02 admin]# [root@rac01 bin]# ./crs_start ora.rac02.LISTENER1_RAC02.lsnrAttempting to start `ora.rac02.LISTENER1_RAC02.lsnr` on member `rac02`Start of `ora.rac02.LIS...
【Oracle】RAC11gR2Grid启动顺序及启动故障诊断思路
lzw5210的博客
03-03 2297
从11gR2开始，Oracle RAC的架构有了比较大的变化，集群层面相交于之前的版本有了比较大的变动，原来的rac架构基本上属于cssd、crsd、evmd三大光秃秃的主干进程，日志数量较少，对于rac无法启动原因，采用最原始的方法逐一查看各个进程的日志也可找到无法启动的原因。然而从11gR2之后，集群层发生了比较大的变动，以下是$GRID_HOME/log/rac1/下的目录情况：   [
oracle监听、启动等命令
s9434的博客
07-06 2003
lsnrctl status 查看状态 lsnrctl start启动 lsnrctl stop停止监听
ORACLE RAC数据库的启动与关闭
曾经是个DBA
04-14 1432
RAC数据库与单实例的差异主要表现在多个实例通过集群件来统一管理共享的资源。因此原有的单实例的管理方式，如数据库、监听器等的关闭启动等可以使用原有的方式进行，也可以通过集群管理工具，命令行来集中管理，这也是推荐的管理方式。由于集群件crs位于数据库之上，即RAC数据库依赖于集群件，因此数据库的启动与关闭应该结合集群来考虑，下面以11g RAC来描述数据库启动与关闭过程。 一、RAC 数据
Start Of ONS Resource Fails With CRS-2672, CRS-5016, CRS-2674 and CRS-4000
DBA never sleep-DBA，永不眠
08-22 5247
(Doc ID 1633123.1)Applies to: Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterInformation in this document applies to any platform.SymptomsThe ONS resource shows state OFFLINE for on
Troubleshooting 12C node2 CRS start fail with ORA-12547 and ORA-15077 in Flex ASM 案例
u010692693的专栏
11-20 814
Flex ASM 在12c以前的版本数据库实例使用操作系统认证连接ASM实例，因为ASM CLIENT(DB INSTANCE)和ASM Server总是在同一个主机上，从12c版本开始引入的FLEX ASM架构允许数据库实例可以和ASM运行在不同的主机中，使用FLEX ASM user password文件认证， ASM密码文件存储在ASM DISKGROUP中，同时在创建Flex...
rac数据库的服务无法启动，报错ORA-03113: end-of-file on communication channel
jingleli21的博客
05-21 9187
启动数据库服务出现如下错误： [grid@rac2 ~]$ srvctl start database -d orcl PRCR-1079 : 无法启动资源 ora.orcl.db CRS-5017: The resource action "ora.orcl.db start" encountered the following error: ORA-03113: end-of-fi
Rac grid用户启停监听报错无权限
weixin_30297281的博客
11-04 321
[grid@max1 ~]$ lsnrctl stop LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-NOV-2016 00:20:54 Copyright (c) 1991, 2011, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PR...
ORACLE 11g RAC部署实战指南
"ORACLE+11g_RAC部署方案，主要涵盖了ORACLE11gRAC的硬件、软件环境需求，网络配置，以及详细的实施步骤，包括系统环境准备、安装Clusterware、数据库安装、配置OracleNet和创建RAC数据库等。" 在ORACLE+11g_RAC...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值