CRS-5017: 资源操作 “ora.asm start“ 遇到以下错误: ORA-01017: invalid username

最新推荐文章于 2024-01-29 08:00:00 发布
最新推荐文章于 2024-01-29 08:00:00 发布
阅读量1.4k 收藏
点赞数
文章标签： 数据库 oracle 服务器
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/MFW333/article/details/131334558
版权

Oracle RAC启动CRS报错：登陆权限问题


2023-06-21 20:42:15.735: [ora.asm][1872455424]{0:0:116} [start] InstConnection::connectInt (2) Exception OCIException
2023-06-21 20:42:15.735: [ora.asm][1872455424]{0:0:116} [start] InstConnection:connect:excp OCIException OCI error 1017
2023-06-21 20:42:15.735: [ora.asm][1872455424]{0:0:116} [start] InstAgent::start: 1 errcode 1017
2023-06-21 20:42:15.735: [ora.asm][1872455424]{0:0:116} [start] InstAgent::start: untrapped error
2023-06-21 20:42:15.735: [ora.asm][1872455424]{0:0:116} [start] InstAgent::start: 2 errcode 1017
2023-06-21 20:42:15.735: [ USRTHRD][1872455424]{0:0:116} InstConnection:~InstConnection: this 54105bf0
2023-06-21 20:42:15.736: [ora.asm][1872455424]{0:0:116} [start] clean {
2023-06-21 20:42:15.736: [ora.asm][1872455424]{0:0:116} [start] InstAgent::stop_option stop mode immediate option 1
2023-06-21 20:42:15.736: [ora.asm][1872455424]{0:0:116} [start] InstAgent::stop { 
2023-06-21 20:42:15.736: [ora.asm][1872455424]{0:0:116} [start] getResAttrib: attrib name USR_ORA_OPI value false len 5
2023-06-21 20:42:15.736: [ora.asm][1872455424]{0:0:116} [start] InstAgent::stop original reason system do shutdown abort
2023-06-21 20:42:15.736: [ora.asm][1872455424]{0:0:116} [start] ConnectionPool::resetConnection  s_statusOfConnectionMap 00ae9760
2023-06-21 20:42:15.736: [ora.asm][1872455424]{0:0:116} [start] ConnectionPool::resetConnection sid +ASM1 status  2
2023-06-21 20:42:15.736: [ora.asm][1872455424]{0:0:116} [start] Gimh::check OH /oracle/11.2.0.4/grid SID +ASM1
2023-06-21 20:42:15.736: [ora.asm][1872455424]{0:0:116} [start] Gimh::check condition changes to (GIMH_NEXT_NUM) 1 exists
2023-06-21 20:42:15.736: [ora.asm][1872455424]{0:0:116} [start] CrsCmd::ClscrsCmdData::stat entity 5 statflag 32 useFilter 1
2023-06-21 20:42:15.904: [ COMMCRS][1831016192]clsc_connect: (0x7f3f540964c0) no listener at (ADDRESS=(PROTOCOL=IPC)(KEY=CRSD_UI_SOCKET))

2023-06-21 20:42:15.904: [ora.asm][1872455424]{0:0:116} [start] checkCrsStat 2 CLSCRS_STAT ret: 184
2023-06-21 20:42:15.905: [ora.asm][1872455424]{0:0:116} [start] clsnUtils::error Exception type=2 string=

2023-06-21 20:42:15.905: [ora.asm][1872455424]{0:0:116} [start] AsmAgent::checkCbk: Exception UserErrorException
2023-06-21 20:42:15.905: [ora.asm][1872455424]{0:0:116} [start]  
2023-06-21 20:42:15.905: [ USRTHRD][1872455424]{0:0:116} Gimh::destructor gimh_dest_query_ctx rc=0
2023-06-21 20:42:15.905: [ USRTHRD][1872455424]{0:0:116} Gimh::destructor gimh_dest_inst_ctx rc=0
2023-06-21 20:42:15.905: [ora.asm][1872455424]{0:0:116} [start] ConnectionPool::stopConnection
2023-06-21 20:42:15.905: [ora.asm][1872455424]{0:0:116} [start] ConnectionPool::removeConnection connection count 0
2023-06-21 20:42:15.905: [ora.asm][1872455424]{0:0:116} [start] ConnectionPool::removeConnection freed 0
2023-06-21 20:42:15.905: [ora.asm][1872455424]{0:0:116} [start] ConnectionPool::stopConnection sid +ASM1 status  1
2023-06-21 20:42:15.905: [ora.asm][1872455424]{0:0:116} [start] InstAgent::check 1 prev clsagfw_res_status 3 current clsagfw_res_status 2
2023-06-21 20:42:20.905: [ora.asm][1872455424]{0:0:116} [start] InstAgent::check prev clsagfw_res_status 2 current clsagfw_res_status 2
2023-06-21 20:42:20.905: [ora.asm][1872455424]{0:0:116} [start] InstAgent::stop  shutdown mode: 4
2023-06-21 20:42:20.905: [ora.asm][1872455424]{0:0:116} [start] ConnectionPool::getConnection 160 ERROR sid +ASM1 pool status 1
2023-06-21 20:42:20.905: [ora.asm][1872455424]{0:0:116} [start] InstAgent::stop pool pConnxn 00000000
2023-06-21 20:42:20.905: [ora.asm][1872455424]{0:0:116} [start] clsnInstConnection::makeConnectStr UsrOraEnv  m_oracleHome /oracle/11.2.0.4/grid Crshome /oracle/11.2.0.4/grid
2023-06-21 20:42:20.905: [ora.asm][1872455424]{0:0:116} [start] makeConnectStr = (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0.4/grid/bin/oracle)(ARGV0=oracle+ASM1)(ENVS='ORACLE_HOME=/oracle/11.2.0.4/grid,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=+ASM1)))
2023-06-21 20:42:20.906: [ora.asm][1872455424]{0:0:116} [start] InstAgent::stop non pool pConnxn 1 54105e30
2023-06-21 20:42:20.906: [ora.asm][1872455424]{0:0:116} [start] InstConnection::connectInt: server not attached
2023-06-21 20:42:20.922: [ora.asm][1872455424]{0:0:116} [start] ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
进程 ID: 0
会话 ID: 0 序列号: 0

2023-06-21 20:42:20.922: [ora.asm][1872455424]{0:0:116} [start] InstConnection::connectInt (2) Exception OCIException
2023-06-21 20:42:20.922: [ora.asm][1872455424]{0:0:116} [start] InstConnection:connect:excp OCIException OCI error 1034
2023-06-21 20:42:20.922: [ora.asm][1872455424]{0:0:116} [start] InstAgent::stop: connect1 errcode 1034
2023-06-21 20:42:20.922: [ora.asm][1872455424]{0:0:116} [start] InstAgent::stop: connect2 oracleHome /oracle/11.2.0.4/grid oracleSid +ASM1
2023-06-21 20:42:20.922: [ora.asm][1872455424]{0:0:116} [start] InstConnection::connectInt: server not attached
2023-06-21 20:42:20.936: [ora.asm][1872455424]{0:0:116} [start] ORA-01017: invalid username/password; logon denied

2023-06-21 20:42:20.936: [ora.asm][1872455424]{0:0:116} [start] InstConnection::connectInt (2) Exception OCIException
2023-06-21 20:42:20.936: [ora.asm][1872455424]{0:0:116} [start] InstConnection:connect:excp OCIException OCI error 1017
2023-06-21 20:42:20.936: [ora.asm][1872455424]{0:0:116} [start] InstAgent::stop: connect2 errcode 1017
2023-06-21 20:42:20.936: [ora.asm][1872455424]{0:0:116} [start] clsnUtils::error Exception type=2 string=
ORA-01017: invalid username/password; logon denied

2023-06-21 20:42:20.936: [    AGFW][1872455424]{0:0:116} sending status msg [ORA-01017: invalid username/password; logon denied
] for start for resource: ora.asm 1 1
2023-06-21 20:42:20.936: [ora.asm][1872455424]{0:0:116} [start] ConnectionPool::removeConnection connection count 1
2023-06-21 20:42:20.936: [ora.asm][1872455424]{0:0:116} [start] ConnectionPool::removeConnection sid  +ASM1, InstConnection 54105e30
2023-06-21 20:42:20.936: [ USRTHRD][1872455424]{0:0:116} InstConnection::breakCall pConnxn:54105e30  DetachLock:00ae3228 m_pSvcH:540e57e0
2023-06-21 20:42:20.936: [ USRTHRD][1872455424]{0:0:116} InstConnection:~InstConnection: this 54105e30
2023-06-21 20:42:20.937: [ora.asm][1872455424]{0:0:116} [start] ConnectionPool::removeConnection delete InstConnection 54105e30
2023-06-21 20:42:20.937: [ora.asm][1872455424]{0:0:116} [start] ConnectionPool::removeConnection freed 1
2023-06-21 20:42:20.937: [ora.asm][1872455424]{0:0:116} [start] ConnectionPool::stopConnection
2023-06-21 20:42:20.937: [ora.asm][1872455424]{0:0:116} [start] ConnectionPool::removeConnection connection count 0
2023-06-21 20:42:20.937: [ora.asm][1872455424]{0:0:116} [start] ConnectionPool::removeConnection freed 0
2023-06-21 20:42:20.937: [ora.asm][1872455424]{0:0:116} [start] ConnectionPool::stopConnection sid +ASM1 status  1
2023-06-21 20:42:20.937: [ora.asm][1872455424]{0:0:116} [start] InstAgent::stop db/asm
2023-06-21 20:42:20.937: [ora.asm][1872455424]{0:0:116} [start] ConnectionPool::stopConnection
2023-06-21 20:42:20.937: [ora.asm][1872455424]{0:0:116} [start] ConnectionPool::removeConnection connection count 0
2023-06-21 20:42:20.937: [ora.asm][1872455424]{0:0:116} [start] ConnectionPool::removeConnection freed 0
2023-06-21 20:42:20.937: [ora.asm][1872455424]{0:0:116} [start] ConnectionPool::stopConnection sid +ASM1 status  1
2023-06-21 20:42:20.937: [ora.asm][1872455424]{0:0:116} [start] getResAttrib: attrib name USR_ORA_OPI value false len 5
2023-06-21 20:42:20.937: [    AGFW][1874843392]{0:0:116} Agent sending reply for: RESOURCE_START[ora.asm 1 1] ID 4098:1274
2023-06-21 20:42:20.937: [ora.asm][1872455424]{0:0:116} [start] InstAgent::stop Container->stop, isShutdown = 0
2023-06-21 20:42:20.937: [ora.asm][1872455424]{0:0:116} [start] InstAgent::stop: } 
2023-06-21 20:42:20.937: [ora.asm][1872455424]{0:0:116} [start] clean  }
2023-06-21 20:42:20.937: [ora.asm][1872455424]{0:0:116} [start] InstAgent::start exception }
2023-06-21 20:42:20.938: [ora.asm][1872455424]{0:0:116} [start] clsnUtils::error Exception type=2 string=
CRS-5017: The resource action "ora.asm start" encountered the following error: 
ORA-01017: invalid username/password; logon denied
. For details refer to "(:CLSN00107:)" in "/oracle/11.2.0.4/grid/log/pgis-rac1/agent/ohasd/oraagent_grid/oraagent_grid.log".

2023-06-21 20:42:20.938: [    AGFW][1872455424]{0:0:116} sending status msg [CRS-5017: The resource action "ora.asm start" encountered the following error: 
ORA-01017: invalid username/password; logon denied
. For details refer to "(:CLSN00107:)" in "/oracle/11.2.0.4/grid/log/pgis-rac1/agent/ohasd/oraagent_grid/oraagent_grid.log".
] for start for resource: ora.asm 1 1
2023-06-21 20:42:20.938: [ora.asm][1872455424]{0:0:116} [start] (:CLSN00107:) clsn_agent::start }
2023-06-21 20:42:20.938: [    AGFW][1872455424]{0:0:116} Command: start for resource: ora.asm 1 1 completed with status: FAIL
2023-06-21 20:42:20.938: [    AGFW][1874843392]{0:0:116} Agent sending reply for: RESOURCE_START[ora.asm 1 1] ID 4098:1274
2023-06-21 20:42:20.938: [ora.asm][1872455424]{0:0:116} [check] ConnectionPool::resetConnection  s_statusOfConnectionMap 00ae9760
2023-06-21 20:42:20.938: [ora.asm][1872455424]{0:0:116} [check] ConnectionPool::resetConnection sid +ASM1 status  2
2023-06-21 20:42:20.938: [ora.asm][1872455424]{0:0:116} [check] Gimh::check OH /oracle/11.2.0.4/grid SID +ASM1
2023-06-21 20:42:20.939: [    AGFW][1874843392]{0:0:116} Agent sending reply for: RESOURCE_START[ora.asm 1 1] ID 4098:1274
2023-06-21 20:42:20.939: [ora.asm][1872455424]{0:0:116} [check] Gimh::check condition changes to (GIMH_NEXT_NUM) 1 exists
2023-06-21 20:42:20.939: [ora.asm][1872455424]{0:0:116} [check] CrsCmd::ClscrsCmdData::stat entity 5 statflag 32 useFilter 1
2023-06-21 20:42:21.104: [ COMMCRS][1831016192]clsc_connect: (0x7f3f54096900) no listener at (ADDRESS=(PROTOCOL=IPC)(KEY=CRSD_UI_SOCKET))

2023-06-21 20:42:21.105: [ora.asm][1872455424]{0:0:116} [check] checkCrsStat 2 CLSCRS_STAT ret: 184
2023-06-21 20:42:21.105: [ora.asm][1872455424]{0:0:116} [check] clsnUtils::error Exception type=2 string=

2023-06-21 20:42:21.105: [ora.asm][1872455424]{0:0:116} [check] AsmAgent::checkCbk: Exception UserErrorException
2023-06-21 20:42:21.105: [ora.asm][1872455424]{0:0:116} [check]  
2023-06-21 20:42:21.105: [ USRTHRD][1872455424]{0:0:116} Gimh::destructor gimh_dest_query_ctx rc=0
2023-06-21 20:42:21.105: [ USRTHRD][1872455424]{0:0:116} Gimh::destructor gimh_dest_inst_ctx rc=0
2023-06-21 20:42:21.105: [ora.asm][1872455424]{0:0:116} [check] ConnectionPool::stopConnection
2023-06-21 20:42:21.105: [ora.asm][1872455424]{0:0:116} [check] ConnectionPool::removeConnection connection count 0
2023-06-21 20:42:21.105: [ora.asm][1872455424]{0:0:116} [check] ConnectionPool::removeConnection freed 0
2023-06-21 20:42:21.105: [ora.asm][1872455424]{0:0:116} [check] ConnectionPool::stopConnection sid +ASM1 status  1
2023-06-21 20:42:21.105: [ora.asm][1872455424]{0:0:116} [check] InstAgent::check 1 prev clsagfw_res_status 2 current clsagfw_res_status 2
2023-06-21 20:42:26.105: [ora.asm][1872455424]{0:0:116} [check] InstAgent::check prev clsagfw_res_status 2 current clsagfw_res_status 2
2023-06-21 20:42:26.106: [    AGFW][1874843392]{0:0:116} ora.asm 1 1 state changed from: STARTING to: PLANNED_OFFLINE
2023-06-21 20:42:26.106: [    AGFW][1874843392]{0:0:116} Agent sending last reply for: RESOURCE_START[ora.asm 1 1] ID 4098:1274
2023-06-21 20:42:26.109: [    AGFW][1874843392]{0:0:116} Agent received the message: RESOURCE_CLEAN[ora.asm 1 1] ID 4100:1282
2023-06-21 20:42:26.109: [    AGFW][1874843392]{0:0:116} Preparing CLEAN command for: ora.asm 1 1
2023-06-21 20:42:26.109: [    AGFW][1874843392]{0:0:116} ora.asm 1 1 state changed from: PLANNED_OFFLINE to: CLEANING
2023-06-21 20:42:26.109: [ora.asm][1872455424]{0:0:116} [clean] (:CLSN00106:) clsn_agent::clean {
2023-06-21 20:42:26.109: [ora.asm][1872455424]{0:0:116} [clean] clean {
2023-06-21 20:42:26.109: [ora.asm][1872455424]{0:0:116} [clean] InstAgent::stop_option stop mode immediate option 1
2023-06-21 20:42:26.109: [ora.asm][1872455424]{0:0:116} [clean] InstAgent::stop { 
2023-06-21 20:42:26.109: [ora.asm][1872455424]{0:0:116} [clean] getResAttrib: attrib name USR_ORA_OPI value false len 5
2023-06-21 20:42:26.109: [ora.asm][1872455424]{0:0:116} [clean] InstAgent::stop original reason system do shutdown abort
2023-06-21 20:42:26.109: [ora.asm][1872455424]{0:0:116} [clean] ConnectionPool::resetConnection  s_statusOfConnectionMap 00ae9760
2023-06-21 20:42:26.109: [ora.asm][1872455424]{0:0:116} [clean] ConnectionPool::resetConnection sid +ASM1 status  2
2023-06-21 20:42:26.109: [ora.asm][1872455424]{0:0:116} [clean] Gimh::check OH /oracle/11.2.0.4/grid SID +ASM1
2023-06-21 20:42:26.109: [ora.asm][1872455424]{0:0:116} [clean] Gimh::check condition changes to (GIMH_NEXT_NUM) 1 exists
2023-06-21 20:42:26.109: [ora.asm][1872455424]{0:0:116} [clean] CrsCmd::ClscrsCmdData::stat entity 5 statflag 32 useFilter 1
2023-06-21 20:42:26.274: [ COMMCRS][1831016192]clsc_connect: (0x7f3f540968b0) no listener at (ADDRESS=(PROTOCOL=IPC)(KEY=CRSD_UI_SOCKET))

2023-06-21 20:42:26.275: [ora.asm][1872455424]{0:0:116} [clean] checkCrsStat 2 CLSCRS_STAT ret: 184
2023-06-21 20:42:26.275: [ora.asm][1872455424]{0:0:116} [clean] clsnUtils::error Exception type=2 string=

2023-06-21 20:42:26.275: [ora.asm][1872455424]{0:0:116} [clean] AsmAgent::checkCbk: Exception UserErrorException
2023-06-21 20:42:26.275: [ora.asm][1872455424]{0:0:116} [clean]  
2023-06-21 20:42:26.275: [ USRTHRD][1872455424]{0:0:116} Gimh::destructor gimh_dest_query_ctx rc=0
2023-06-21 20:42:26.275: [ USRTHRD][1872455424]{0:0:116} Gimh::destructor gimh_dest_inst_ctx rc=0
2023-06-21 20:42:26.275: [ora.asm][1872455424]{0:0:116} [clean] ConnectionPool::stopConnection
2023-06-21 20:42:26.275: [ora.asm][1872455424]{0:0:116} [clean] ConnectionPool::removeConnection connection count 0
2023-06-21 20:42:26.275: [ora.asm][1872455424]{0:0:116} [clean] ConnectionPool::removeConnection freed 0
2023-06-21 20:42:26.275: [ora.asm][1872455424]{0:0:116} [clean] ConnectionPool::stopConnection sid +ASM1 status  1
2023-06-21 20:42:26.275: [ora.asm][1872455424]{0:0:116} [clean] InstAgent::check 1 prev clsagfw_res_status 2 current clsagfw_res_status 2
2023-06-21 20:42:31.275: [ora.asm][1872455424]{0:0:116} [clean] InstAgent::check prev clsagfw_res_status 2 current clsagfw_res_status 2
2023-06-21 20:42:31.275: [ora.asm][1872455424]{0:0:116} [clean] InstAgent::stop  shutdown mode: 4
2023-06-21 20:42:31.275: [ora.asm][1872455424]{0:0:116} [clean] ConnectionPool::getConnection 160 ERROR sid +ASM1 pool status 1
2023-06-21 20:42:31.275: [ora.asm][1872455424]{0:0:116} [clean] InstAgent::stop pool pConnxn 00000000
2023-06-21 20:42:31.276: [ora.asm][1872455424]{0:0:116} [clean] clsnInstConnection::makeConnectStr UsrOraEnv  m_oracleHome /oracle/11.2.0.4/grid Crshome /oracle/11.2.0.4/grid
2023-06-21 20:42:31.276: [ora.asm][1872455424]{0:0:116} [clean] makeConnectStr = (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0.4/grid/bin/oracle)(ARGV0=oracle+ASM1)(ENVS='ORACLE_HOME=/oracle/11.2.0.4/grid,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=+ASM1)))
2023-06-21 20:42:31.276: [ora.asm][1872455424]{0:0:116} [clean] InstAgent::stop non pool pConnxn 1 541467b0
2023-06-21 20:42:31.276: [ora.asm][1872455424]{0:0:116} [clean] InstConnection::connectInt: server not attached
2023-06-21 20:42:31.292: [ora.asm][1872455424]{0:0:116} [clean] ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
进程 ID: 0
会话 ID: 0 序列号: 0

2023-06-21 20:42:31.292: [ora.asm][1872455424]{0:0:116} [clean] InstConnection::connectInt (2) Exception OCIException
2023-06-21 20:42:31.292: [ora.asm][1872455424]{0:0:116} [clean] InstConnection:connect:excp OCIException OCI error 1034
2023-06-21 20:42:31.292: [ora.asm][1872455424]{0:0:116} [clean] InstAgent::stop: connect1 errcode 1034
2023-06-21 20:42:31.292: [ora.asm][1872455424]{0:0:116} [clean] InstAgent::stop: connect2 oracleHome /oracle/11.2.0.4/grid oracleSid +ASM1
2023-06-21 20:42:31.292: [ora.asm][1872455424]{0:0:116} [clean] InstConnection::connectInt: server not attached
2023-06-21 20:42:31.306: [ora.asm][1872455424]{0:0:116} [clean] ORA-01017: invalid username/password; logon denied

2023-06-21 20:42:31.306: [ora.asm][1872455424]{0:0:116} [clean] InstConnection::connectInt (2) Exception OCIException
2023-06-21 20:42:31.306: [ora.asm][1872455424]{0:0:116} [clean] InstConnection:connect:excp OCIException OCI error 1017
2023-06-21 20:42:31.307: [ora.asm][1872455424]{0:0:116} [clean] InstAgent::stop: connect2 errcode 1017
2023-06-21 20:42:31.307: [ora.asm][1872455424]{0:0:116} [clean] clsnUtils::error Exception type=2 string=
ORA-01017: invalid username/password; logon denied

2023-06-21 20:42:31.307: [    AGFW][1872455424]{0:0:116} sending status msg [ORA-01017: invalid username/password; logon denied
] for clean for resource: ora.asm 1 1
2023-06-21 20:42:31.307: [ora.asm][1872455424]{0:0:116} [clean] ConnectionPool::removeConnection connection count 1
2023-06-21 20:42:31.307: [ora.asm][1872455424]{0:0:116} [clean] ConnectionPool::removeConnection sid  +ASM1, InstConnection 541467b0
2023-06-21 20:42:31.307: [ USRTHRD][1872455424]{0:0:116} InstConnection::breakCall pConnxn:541467b0  DetachLock:00ae3228 m_pSvcH:54132b00
2023-06-21 20:42:31.307: [ USRTHRD][1872455424]{0:0:116} InstConnection:~InstConnection: this 541467b0
2023-06-21 20:42:31.307: [    AGFW][1874843392]{0:0:116} Agent sending reply for: RESOURCE_CLEAN[ora.asm 1 1] ID 4100:1282
2023-06-21 20:42:31.307: [ora.asm][1872455424]{0:0:116} [clean] ConnectionPool::removeConnection delete InstConnection 541467b0
2023-06-21 20:42:31.307: [ora.asm][1872455424]{0:0:116} [clean] ConnectionPool::removeConnection freed 1
2023-06-21 20:42:31.307: [ora.asm][1872455424]{0:0:116} [clean] ConnectionPool::stopConnection
2023-06-21 20:42:31.307: [ora.asm][1872455424]{0:0:116} [clean] ConnectionPool::removeConnection connection count 0
2023-06-21 20:42:31.307: [ora.asm][1872455424]{0:0:116} [clean] ConnectionPool::removeConnection freed 0
2023-06-21 20:42:31.307: [ora.asm][1872455424]{0:0:116} [clean] ConnectionPool::stopConnection sid +ASM1 status  1
2023-06-21 20:42:31.307: [ora.asm][1872455424]{0:0:116} [clean] InstAgent::stop db/asm
2023-06-21 20:42:31.307: [ora.asm][1872455424]{0:0:116} [clean] ConnectionPool::stopConnection
2023-06-21 20:42:31.307: [ora.asm][1872455424]{0:0:116} [clean] ConnectionPool::removeConnection connection count 0
2023-06-21 20:42:31.307: [ora.asm][1872455424]{0:0:116} [clean] ConnectionPool::removeConnection freed 0
2023-06-21 20:42:31.307: [ora.asm][1872455424]{0:0:116} [clean] ConnectionPool::stopConnection sid +ASM1 status  1
2023-06-21 20:42:31.308: [ora.asm][1872455424]{0:0:116} [clean] getResAttrib: attrib name USR_ORA_OPI value false len 5
2023-06-21 20:42:31.308: [ora.asm][1872455424]{0:0:116} [clean] InstAgent::stop Container->stop, isShutdown = 0
2023-06-21 20:42:31.308: [ora.asm][1872455424]{0:0:116} [clean] InstAgent::stop: } 
2023-06-21 20:42:31.308: [ora.asm][1872455424]{0:0:116} [clean] clean  }
2023-06-21 20:42:31.308: [ora.asm][1872455424]{0:0:116} [clean] (:CLSN00106:) clsn_agent::clean }
2023-06-21 20:42:31.308: [    AGFW][1872455424]{0:0:116} Command: clean for resource: ora.asm 1 1 completed with status: SUCCESS
2023-06-21 20:42:31.308: [    AGFW][1874843392]{0:0:116} Agent sending reply for: RESOURCE_CLEAN[ora.asm 1 1] ID 4100:1282
2023-06-21 20:42:31.308: [ora.asm][1872455424]{0:0:116} [check] ConnectionPool::resetConnection  s_statusOfConnectionMap 00ae9760
2023-06-21 20:42:31.308: [ora.asm][1872455424]{0:0:116} [check] ConnectionPool::resetConnection sid +ASM1 status  2
2023-06-21 20:42:31.308: [ora.asm][1872455424]{0:0:116} [check] Gimh::check OH /oracle/11.2.0.4/grid SID +ASM1
2023-06-21 20:42:31.308: [ora.asm][1872455424]{0:0:116} [check] Gimh::check condition changes to (GIMH_NEXT_NUM) 1 exists
2023-06-21 20:42:31.308: [ora.asm][1872455424]{0:0:116} [check] CrsCmd::ClscrsCmdData::stat entity 5 statflag 32 useFilter 1
2023-06-21 20:42:31.474: [ COMMCRS][1831016192]clsc_connect: (0x7f3f540968f0) no listener at (ADDRESS=(PROTOCOL=IPC)(KEY=CRSD_UI_SOCKET))

2023-06-21 20:42:31.474: [ora.asm][1872455424]{0:0:116} [check] checkCrsStat 2 CLSCRS_STAT ret: 184
2023-06-21 20:42:31.474: [ora.asm][1872455424]{0:0:116} [check] clsnUtils::error Exception type=2 string=

2023-06-21 20:42:31.474: [ora.asm][1872455424]{0:0:116} [check] AsmAgent::checkCbk: Exception UserErrorException
2023-06-21 20:42:31.474: [ora.asm][1872455424]{0:0:116} [check]  
2023-06-21 20:42:31.474: [ USRTHRD][1872455424]{0:0:116} Gimh::destructor gimh_dest_query_ctx rc=0
2023-06-21 20:42:31.475: [ USRTHRD][1872455424]{0:0:116} Gimh::destructor gimh_dest_inst_ctx rc=0
2023-06-21 20:42:31.475: [ora.asm][1872455424]{0:0:116} [check] ConnectionPool::stopConnection
2023-06-21 20:42:31.475: [ora.asm][1872455424]{0:0:116} [check] ConnectionPool::removeConnection connection count 0
2023-06-21 20:42:31.475: [ora.asm][1872455424]{0:0:116} [check] ConnectionPool::removeConnection freed 0
2023-06-21 20:42:31.475: [ora.asm][1872455424]{0:0:116} [check] ConnectionPool::stopConnection sid +ASM1 status  1
2023-06-21 20:42:31.475: [ora.asm][1872455424]{0:0:116} [check] InstAgent::check 1 prev clsagfw_res_status 2 current clsagfw_res_status 2
2023-06-21 20:42:36.475: [ora.asm][1872455424]{0:0:116} [check] InstAgent::check prev clsagfw_res_status 2 current clsagfw_res_status 2
2023-06-21 20:42:36.475: [    AGFW][1874843392]{0:0:116} ora.asm 1 1 state changed from: CLEANING to: PLANNED_OFFLINE
2023-06-21 20:42:36.475: [    AGFW][1874843392]{0:0:116} Agent sending last reply for: RESOURCE_CLEAN[ora.asm 1 1] ID 4100:1282
2023-06-21 20:42:40.487: [ora.evmd][1872455424]{0:0:2} [check] clsdmc_respget return: status=0, ecode=0
2023-06-21 20:42:40.487: [ora.evmd][1872455424]{0:0:2} [check] DaemonAgent::check returned 0
2023-06-21 20:42:40.487: [ora.evmd][1872455424]{0:0:2} [check] Deep check returned 0
2023-06-21 20:42:42.778: [ora.mdnsd][1852385024]{0:0:2} [check] clsdmc_respget return: status=0, ecode=0
2023-06-21 20:42:43.890: [ora.gpnpd][1836046080]{0:0:2} [check] clsdmc_respget return: status=0, ecode=0
2023-06-21 20:42:44.901: [ora.gipcd][1836046080]{0:0:2} [check] clsdmc_respget return: status=0, ecode=0
2023-06-21 20:43:10.493: [ora.evmd][1852385024]{0:0:2} [check] clsdmc_respget return: status=0, ecode=0
2023-06-21 20:43:10.493: [ora.evmd][1852385024]{0:0:2} [check] DaemonAgent::check returned 0
2023-06-21 20:43:10.493: [ora.evmd][1852385024]{0:0:2} [check] Deep check returned 0
2023-06-21 20:43:11.732: [    AGFW][1874843392]{0:0:58} Agent received the message: AGENT_HB[Engine] ID 12293:1298
2023-06-21 20:43:12.784: [ora.mdnsd][1836046080]{0:0:2} [check] clsdmc_respget return: status=0, ecode=0

该问题完美匹配以下解决方案：

http://blog.itpub.net/28612416/viewspace-1820666/

APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

SYMPTOMS

One of the node CRS was not coming up properly.

ASM did not come up automatically - it  failed to start  with "ORA-01017: invalid username/password; logon denied" error in the <grid home>/log/<host name>/agent/ohasd/oraagent_grid/oraagent_grid.log

alert<hostname>.log
~~~~~~~~~~~~~~~~~~~~
[client(3990)]CRS-10001:10-Jun-14 14:35 ACFS-9156: Detecting control device '/dev/ofsctl'.
[client(4002)]CRS-10001:10-Jun-14 14:35 ACFS-9322: completed
2014-06-10 14:36:18.128:
[ohasd(48895)]CRS-2807:Resource 'ora.asm' failed to start automatically.
2014-06-10 14:36:18.128:
[ohasd(48895)]CRS-2807:Resource 'ora.crsd' failed to start automatically.

oraagent_grid.log
~~~~~~~~~~~~~~~~~~
2014-06-10 14:35:15.585: [ora.asm][3219122496]{0:0:2} [start] makeConnectStr = (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/u01/app/11.2.0.4/grid/bin/oracle)(ARGV0=oracle+ASM1)(ENVS='ORACLE_HOME=/u01/app/11.2.0.4/grid,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=+ASM1)))
2014-06-10 14:35:15.587: [ora.asm][3219122496]{0:0:2} [start] Container:start oracle home /u01/app/11.2.0.4/grid
2014-06-10 14:35:15.587: [ora.asm][3219122496]{0:0:2} [start] InstConnection::connectInt: server not attached
2014-06-10 14:35:15.621: [ora.asm][3219122496]{0:0:2} [start] ORA-01017: invalid username/password; logon denied  <<<<<<<<<


2014-06-10 14:36:12.960: [ A**][2622531904]{0:0:2} A** Proxy Server sending the reply to PE for message:RESOURCE_CLEAN[ora.asm 1 1] ID 4100:456
2014-06-10 14:36:12.960: [ CRSPE][2543831360]{0:0:2} Received reply to action [Clean] message ID: 456
2014-06-10 14:36:12.960: [ CRSPE][2543831360]{0:0:2} Got agent-specific msg: ORA-01017: invalid username/password; logon denied

ASM instance can be started manually  using sqlplus "/as sysasm" but the CRSD fails to start with same error.

crsd.log
~~~~~~~~~
2014-06-05 11:05:28.617: [ CRSMAIN][4003182320] Initializing OCR
[ CLWAL][4003182320]clsw_Initialize: OLR initlevel [70000]
2014-06-05 11:05:29.938: [ OCRASM][4003182320]proprasmo: Error in open/create file in dg [DATA]
[ OCRASM][4003182320]SLOS : SLOS: cat=7, opn=kgfoAl06, dep=1017, loc=kgfokge

2014-06-05 11:05:29.938: [ OCRASM][4003182320]ASM Error Stack : ORA-01017: invalid username/password; logon denied <<<<<<<<

2014-06-05 11:05:30.985: [ OCRASM][4003182320]proprasmo: kgfoCheckMount returned [7]
2014-06-05 11:05:30.985: [ OCRASM][4003182320]proprasmo: The ASM instance is down
2014-06-05 11:05:30.985: [ OCRRAW][4003182320]proprioo: Failed to open [+DATA]. Returned proprasmo() with [26]. Marking location as UNAVAILABLE.
2014-06-05 11:05:30.985: [ OCRRAW][4003182320]proprioo: No OCR/OLR devices are usable

CAUSE

 SQLNET.ORA has below entry

# sqlnet.ora.Network Configuration File:
/u01/app/11.2.0.4/grid/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
SQLNET.AUTHENTICATION_SERVICES=none <<<<<<<<<<<<<<<<<<<<
ADR_BASE = /u01/app/grid

CRS uses OS authentication method to connect ASM instance.

If   SQLNET.AUTHENTICATION_SERVICES=none then a valid username and password is need to connect to ASM instance.

SOLUTION

1) Remove "SQLNET.AUTHENTICATION_SERVICES=none" from the Grid Home SQLNET.ORA file (location $ORACLE_HOME/network/admin)

2) Restart the CRS with force.

crsctl stop crs -f
crsctl start crs

末点
关注
RAC集群启动实例遭遇PRCR-1079、CRS-5017、ORA-01102cannot mount database in EXCLUSIVE mode
qq_28538637的博客
05-13 3453
环境：Oracle 11g R2 RAC集群 在做异机恢复时，通过srvctl start database -d 命令启动数据实例，遇到了如下错误。导致只有一个节点能起来。 [grid@orcl02 grid_1]$ srvctl start database -d orcl PRCR-1079 : Failed to start resource ora.orcl.db CRS-5017...
RAC解决单节点报 CRS-4047: No Oracle Clusterware components configured.
csdn426523的博客
02-20 666
[root@linux1 install]# ./rootcrs.pl -h Unknown option: h Usage: ...
11gr2安装Grid 时 node2 root.sh失败Start of resource “ora.asm -init” failed
乡下人
11-17 2200
在安装GI，第一个节点的root.sh一般不易出错，但是第二个节点就遇到了下面的错误 Start of resource “ora.asm -init” failed Failed to start ASM Failed to start Oracle Clusterware stack 检查错误日志 grid@znode2 crsconfig]$ pwd /u01/app/11.
Start of resource "ora.asm -init" (failedRAC11gR2安装grid报错)
数据库
04-07 447
在第二个节点运行root.sh报错，信息如下： CRS-4000: Command Start failed, or completed with errors. Command return code of 1 (256) from command: /app/11.2.0/grid/bin/crsctlstart resource ora.asm -init ...
CRS-5017
喝醉酒的小白
06-10 1368
CRS-5017: The resource action “ora.OCRVOTE.dg check” encountered the following error: . For details refer to “(:CLSN00109:)” in “/opt/grid/products/11.2.0/log/主机名/agent/crsd/oraagent_grid/oraagent_grid.log”.CRS-05017: The resource action “string string” en
asm oracle 启动,oracle 11g R2 单实例 ASM 启动：ORA
weixin_39620370的博客
04-03 260
今天启动之前安装好的 oracle 11g R2 单实例 ASM的时候，连接启动ASM实例时，报错： SQL startup ORA-01078: failure in processing system parameters ORA-29701: unable to connect to Cluster Synchronization Service 从报错说.应该是CSS服务没有启动起今天启动...
[CRS-2800] Cannot start resource 'ora.asm' as it is already in the INTERMEDIATE
weixin_30700099的博客
01-14 1219
在安装ORACLE RAC的Grid Infrastructure时，在节点1运行/u01/app/11.2.0/grid/root.sh正常，当在节点2运行/u01/app/11.2.0/grid/root.sh时发生报错： Entries will be added to the /etc/oratab file as needed by Database Configuration Assi...
ORA-12547: TNS:lost contact导致数据库无法启动
Enmotech的博客
06-30 3151
墨墨导读：一个诡异的案例：ORA-12547: TNS:lost contact导致数据库无法启动，甚至sqlplus都无法登录，让我们一一来解开这个案例的真面目。1. 背景概述某客户出...
oracle修改crs启动延迟,关于crs无法启动的分析
weixin_42519126的博客
04-06 584
不久前安装了一套rac但在启动时报错，无法启动集群。环境：11.2.0.4.0 ProductionRed Hat Enterprise Linux Server release 5.7 (Tikanga)执行启动：[root@dbrac1 bin]# ./crsctl start crsCRS-4640: Oracle High Availability Services is already ...
CRS-4995: The command 'Start resource' is invalid in crsctl. Use srvctl for this command.
06-04
如果您在使用 crsctl 命令启动资源时遇到 CRS-4995 错误，错误消息建议您使用 srvctl 命令而不是 crsctl 命令来启动资源。在 Oracle 数据库环境中，srvctl 命令用于管理和配置 Oracle 服务，例如数据库实例、监听器...
ORA-15096: lost disk write detected的解决与修复
Enmotech的博客
11-18 1001
案例背景4节点Extend RAC，存储RAID 5校验异常，修复之后SOLDATA磁盘组无法mount，报错ORA-15096: lost disk write detected。mou...
oracle12c ora 12547,Oracle 12c DBCA出现PRCR-1079 ORA-12547 CRS-5017
weixin_33605464的博客
04-12 598
Oracle 12c用dbca创建数据库时出现了PRCR-1079 ORA-12547 CRS-5017不能启动数据库。因为这里安装了Oracle Restart，所以尝试使用srvctl start database命令来手动启动数据库，但是结果还是一样不能启动。[grid@oracle12c 12.1]$ srvctl start database -db jycsPRCR-1079 : Fa...
Oracle 11gR2启动ASM实例时遭遇ORA-29701
weixin_34122810的博客
01-16 203
grid@linux:~>sqlplus"/assysasm"SQL*Plus:Release11.2.0.1.0ProductiononSunOct2814:16:222014Copyright(c)1982,2009,Oracle.Allrightsreserved.Connectedtoanidl...
Oracle-srvctl 启动关闭数据库报ORA-01017问题
最新发布
sinat_36757755的博客
01-29 1685
使用集群的srvctl工具去关闭或者启动数据库时出现ORA-01017: invalid username/password; logon denied报错，无法通过srvctl工具去启动关闭数据库
“ORA-01017（：用户名/口令无效； 登录被拒绝）” ORA-28000： the accout is locked（用户账号被锁）解决方法
热门推荐
睡不醒的每天
07-17 3万+
2.第二种情况（theaccoutislocked）时，cmd登陆sqlplus/assysdba利用【ALTERUSER用户名ACCOUNTUNLOCK;】命令为账号解锁，然后通过【alteruser用户名identifiedby密码】修改密码方可登陆成功。总结1.遇到第一情况时cmd登陆sqlplus/assysdba利用【alteruser用户名identifiedby密码】命令修改密码即可正常登陆。...
12.2.0.1 RAC CRS Cannot Start With Error CRS-5017 CRS-5818 (Doc ID 2521346.1)
u010692693的专栏
11-20 1866
12.2.0.1 RAC CRS Cannot Start With Error CRS-5017 CRS-5818 (Doc ID 2521346.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 12.2.0.1 and later Information in this document applies to an...
srvctl start database 失败 ORA-01017: invalid username/password； logon denied
姚远OracleACE的博客
09-23 714
现象 vctl start database -database orcl PRCR-1079 : Failed to start resource ora.orcl.db CRS-5017: The resource action "ora.orcl.db start" encountered the following error: ORA-01017: invalid username/password; logon denied . For details refer to "(:CLSN001
RAC 不能启动之 OCR/CRS/controlfile 故障
上帝之手&传奇 - MartinLee
03-26 1774
方案简述：   客户公司一台测试库已近半年没有启动了，听说当时因为数据宕掉以后，就没有用了，最近客户公司分析员需要里面的部分数据，看能否启动起来。  说是这套一直没动什么配置，只是在原来基础上创建了单实例。 1， 通过公司协议授权及等公司层面以后，我这边开始针对这个问题case 处理！   2  通过vpn 连接以后，通过几个系统命令查看两台实例可否检索隐射的
oracle asm连不上,RAC节点启动失败--ASM无法连接
weixin_35867994的博客
04-12 1122
近日遇到一个RAC问题，一个节点无法启动，经过分析后解决，解决过程如下。11.2.0.3 RAC环境，其中一个节点instance启动失败，显示如下错误[oracle@exadbmel04 ~]$ crsctl start res ora.dbm.dbCRS-2672: Attempting to start 'ora.dbm.db' on 'exadbmel04'CRS-5017: The ...
PRCR-1079 : Failed to start resource ora.asm CRS-5017: The resource action "ora.asm start" encountered the
04-03
following error: ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+DATA/asm/asm_parameterfile/registry.253.1031905195' ORA-17503: ksfdopn:2 Failed to open file +DATA/asm/asm_parameterfile/registry.253.1031905195 ORA-15056: additional error message ORA-17503: ksfdopn:2 Failed to open file +DATA/asm/asm_parameterfile/registry.253.1031905195 This error message indicates that the ASM resource failed to start because there is an issue with the ASM parameter file. Specifically, the error suggests that the ASM instance was unable to access the parameter file, which is located in the +DATA/asm/asm_parameterfile directory. To resolve this issue, you will need to check the permissions and ownership of the ASM parameter file and ensure that the ASM instance has the necessary rights to access it. You may also need to check the disk space and ensure that there is enough space available for the ASM instance to operate. If the issue persists, you may need to recreate the ASM parameter file and restart the ASM instance. You can do this using the ASMCA utility or by manually editing the parameter file. Note: It is recommended to take a backup of the parameter file before making any changes to it.
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

末点

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值