Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

oracle user can startup db but grid user startup db with srvctl start databas -d orcl13 show error i

Quanwen ZhaoAug 10 2017 — edited Aug 10 2017

Hi,

my test environment is Oracle ASM 11.2.0.4.0 for Linux x86_64 on CentOS 6.6 x86_64, and there is a strange phenomemon,

i could startup db in oracle user,but execute 'srvctl start database -d orcl13' in grid user and show error as follows,

[grid@orcl13 ~]$ srvctl start database -d orcl13

PRCR-1079 : Failed to start resource ora.orcl13.db

ORA-12546: TNS:permission denied

CRS-5017: The resource action "ora.orcl13.db start" encountered the following error:

ORA-12546: TNS:permission denied

. For details refer to "(:CLSN00107:)" in "/u01/app/11.2.0/grid/log/orcl13/agent/ohasd/oraagent_grid/oraagent_grid.log".

CRS-2674: Start of 'ora.orcl13.db' on 'orcl13' failed

ORA-12546: TNS:permission denied

at the same time, resource info in ASM 'ora.orcl13.db' and its target is online,state is offline,

[grid@orcl13 ~]$ crs_stat -t -v

Name           Type           R/RA   F/FT   Target    State     Host       

------------------------------------------------------------------------------------------

ora.DATA.dg    ora....up.type 0/5    0/     ONLINE    ONLINE    orcl13     

ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    orcl13     

ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    orcl13     

ora.cssd       ora.cssd.type  0/5    0/5    ONLINE    ONLINE    orcl13     

ora.diskmon    ora....on.type 0/10   0/5    OFFLINE   OFFLINE              

ora.evmd       ora.evm.type   0/10   0/5    ONLINE    ONLINE    orcl13     

ora.ons        ora.ons.type   0/3    0/     OFFLINE   OFFLINE              

ora.orcl13.db  ora....se.type 1/2    0/1    ONLINE    OFFLINE  

so,i check '/u01/app/11.2.0/grid/log/orcl13/agent/ohasd/oraagent_grid/oraagent_grid.log',details as follows,

2017-08-10 15:48:16.287: [ora.LISTENER.lsnr][3656840960]{0:0:14236} [check] execCmd ret = 0

2017-08-10 15:48:17.846: [ora.evmd][1281734400]{0:0:3816} [check] clsdmc_respget return: status=0, ecode=1

2017-08-10 15:48:17.846: [ora.evmd][1281734400]{0:0:3816} [check] DaemonAgent::check returned 0

2017-08-10 15:48:17.846: [ora.evmd][1281734400]{0:0:3816} [check] Deep check returned 1

2017-08-10 15:48:20.291: [    AGFW][1305069312]{0:0:2} Agent received the message: AGENT_HB[Engine] ID 12293:11140143

2017-08-10 15:48:47.850: [ora.evmd][3656840960]{0:0:3816} [check] clsdmc_respget return: status=0, ecode=1

2017-08-10 15:48:47.850: [ora.evmd][3656840960]{0:0:3816} [check] DaemonAgent::check returned 0

2017-08-10 15:48:47.850: [ora.evmd][3656840960]{0:0:3816} [check] Deep check returned 1

2017-08-10 15:48:50.295: [    AGFW][1305069312]{0:0:2} Agent received the message: AGENT_HB[Engine] ID 12293:11140151

2017-08-10 15:49:16.186: [ora.LISTENER.lsnr][1281734400]{0:0:14236} [check] Utils:execCmd action = 3 flags = 38 ohome = (null) cmdname = lsnrctl.

2017-08-10 15:49:16.296: [ora.LISTENER.lsnr][1281734400]{0:0:14236} [check] execCmd ret = 0

2017-08-10 15:49:17.855: [ora.evmd][3656840960]{0:0:3816} [check] clsdmc_respget return: status=0, ecode=1

2017-08-10 15:49:17.855: [ora.evmd][3656840960]{0:0:3816} [check] DaemonAgent::check returned 0

2017-08-10 15:49:17.855: [ora.evmd][3656840960]{0:0:3816} [check] Deep check returned 1

2017-08-10 15:49:20.300: [    AGFW][1305069312]{0:0:2} Agent received the message: AGENT_HB[Engine] ID 12293:11140159

2017-08-10 15:49:47.861: [ora.evmd][1309271808]{0:0:3816} [check] clsdmc_respget return: status=0, ecode=1

2017-08-10 15:49:47.861: [ora.evmd][1309271808]{0:0:3816} [check] DaemonAgent::check returned 0

2017-08-10 15:49:47.861: [ora.evmd][1309271808]{0:0:3816} [check] Deep check returned 1

2017-08-10 15:49:50.304: [    AGFW][1305069312]{0:0:2} Agent received the message: AGENT_HB[Engine] ID 12293:11140167

2017-08-10 15:50:16.197: [ora.LISTENER.lsnr][3656840960]{0:0:14236} [check] Utils:execCmd action = 3 flags = 38 ohome = (null) cmdname = lsnrctl.

2017-08-10 15:50:16.308: [ora.LISTENER.lsnr][3656840960]{0:0:14236} [check] execCmd ret = 0

2017-08-10 15:50:17.865: [ora.evmd][3656840960]{0:0:3816} [check] clsdmc_respget return: status=0, ecode=1

2017-08-10 15:50:17.865: [ora.evmd][3656840960]{0:0:3816} [check] DaemonAgent::check returned 0

2017-08-10 15:50:17.865: [ora.evmd][3656840960]{0:0:3816} [check] Deep check returned 1

2017-08-10 15:50:20.308: [    AGFW][1305069312]{0:0:2} Agent received the message: AGENT_HB[Engine] ID 12293:11140175

and how to solve this problem ?

Best Regards

Quanwen Zhao

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 7 2017
Added on Aug 10 2017
3 comments
2,069 views