//
you're reading...
Oracle Database Toubleshooting

ORA-15055: unable to connect to ASM instance and ORA-12547: TNS:lost contact

ORA-15055: unable to connect to ASM instance and ORA-12547: TNS:lost contact

After completed to installation of the Oracle RAC, I got following error when I try restart the database

oracle@testdbnode1:>sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.3.0 Production on Fri Mar 2 14:17:02 2014

Copyright (c) 1982, 2009, <strong>Oracle</strong>.  All rights reserved.

Connected to an idle instance.

SQL> startup

ORA-01078: failure in processing system parameters

ORA-01565: error in identifying file '+TESTDBDATA1/testdb/spfilerac.ora'

ORA-17503: ksfdopn:2 Failed to open file +TESTDBDATA1/testdb/spfilerac.ora

ORA-12547: TNS:lost contact

Check the alert log file, I found following errors

TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517
TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oragi/app/grid/11.2.03/grid/bin/oracle)(ARGV0=oracle+ASM1_asmb_rac1)(ENVS='ORACLE_HOME=/oragi/app/grid/11.2.03/grid,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))

Errors in file /oragi/app/oracle/diag/rdbms/rac/rac1/trace/rac1_asmb_31756.trc:

ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact

Fatal NI connect error 12547, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/opt/rac/11.2.0/grid/bin/oracle)(ARGV0=oracle+ASM1_asmb_rac1)(ENVS='ORACLE_HOME=/opt/rac/11.2.0/grid,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle@rac1)(HOST=rac1)(USER=oracle))))

VERSION INFORMATION:

TNS for Linux: Version 11.2.0.3.0 - Production

Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production

Time: 03-Mar-2014 14:32:35

Tracing not turned on.
Tns error struct:
ns main err code: 12547
TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517
TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR:<strong>Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oragi/app/grid/11.2.03/grid/bin/oracle)(ARGV0=oracle+ASM1_asmb_rac1)(ENVS='ORACLE_HOME=/oragi/app/grid/11.2.03/grid,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))</strong>
Fri Mar 02 15:31:18 2014
Starting background process ASMB
Fri Sep 02 13:31:18 2011
ASMB started with pid=26, OS id=21450

Check the asm instance,the status of the asm diskgroup shows online:

Check the ASM instance, the ASM Diskgroup is online:

grid@testdbnode1:/home/grid>crsctl stat res -t
NAME                TARGET STATE    SERVER       STATE_DETAILS    Local Resources
--------------------------------------------------------------------------------
<strong>ora.TESTDBDATA1.dg       ONLINE ONLINE    testdb1                    ========>DG are online</strong>
<strong>ora.TESTDBDATA2.dg       ONLINE ONLINE    testdb1  </strong>
ora.LISTENER.lsnr  ONLINE ONLINE    testdb1
ora.asm            ONLINE ONLINE    testdb1          Started
ora.ons            OFFLINE OFFLINE  testdb1
--------------------------------------------------------------------------------
NAME              TARGET STATE    SERVER       STATE_DETAILS Cluster Resources
--------------------------------------------------------------------------------
ora.cssd1         ONLINE ONLINE    rac1
ora.diskmon1      ONLINE ONLINE    rac1
ora.evmd1         ONLINE ONLINE    rac1
ora.jrdwyf.db1    OFFLINE OFFLINE                Instance Shutdown

The solution for this issue

The cause of the issue is the permission of the two programs

  • $ORACLE_HOME/bin/oracle
  • $GRID_HOME/bin/oracle
grid@testdbnode1:/oragi/app/11.2.0.3/grid/bin>ls -al oracle
-rwxr-x--x 1 grid oinstall 204716107 Nov 13  2013 oracle
oracle@testdbnode1:/ora01/app/oracle/product/11.2.0.3/dbhome_1/bin>ls -al oracle
-rwxr-x--x 1 oracle asmadmin 220606903 Nov 13  2013 oracle

Login to the ASM Instance

grid@testdbnode1:/home/grid>sqlplus "/ as sysasm"

SQL*Plus: Release 11.2.0.3.0 Production on Thu Mar 5 16:20:47 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL>

The correct permission and user/group for $GI_HOME/bin/oracle should be:

$ls -l $GI_HOME/bin/oracle:
-rwsr-s--x 1 grid oinstall 152400480   Sep   2 15:49 oracle

The correct permission and user/group for $ORACLE_HOME/bin/oracle should be:

$ls -l $ORACLE_HOME/bin/oracle:
-r-sr-sr-x 1 oracle asmadmin 173389085 Sep  2 15:51 oracle

change the permission on all RAC nodes for $GI_HOME/bin/oracle

#cd /oragi/app/11.2.0.3/grid/bin
#chmod 6751 oracle
#ls -l oracle

Check the correct permission and user/group should be:

-rwsr-s--x 1 grid oinstall 152400480 09-02 16:12 oracle

change the permission on all RAC nodes for $ORACLE_HOME/bin/oracle

#cd /ora01/app/oracle/product/11.2.0.3/dbhome_1/bin
#chmod 6555 oracle
#ls -l oracle

Check the correct permission should be:

-r-sr-sr-x 1 oracle asmadmin 173389085 09-02 16:16 oracle

after the permission modified,then we can startup the database.

Advertisements

About daviewning

I am an Oracle DBA

Discussion

2 thoughts on “ORA-15055: unable to connect to ASM instance and ORA-12547: TNS:lost contact

  1. Thanks for this. Quick fix to a issue I just had.

    Like

    Posted by Matt | July 21, 2016, 6:54 am

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: