Wednesday, December 14, 2016

Srvctl is not able to start database (ORA-12547: TNS:lost contact)

Srvctl is not able to start database

[oracle@orcldb-n2 ~]$ srvctl start database -d orcl
PRCR-1079 : Failed to start resource ora.orcl.db
ORA-12547: TNS:lost contact
CRS-5017: The resource action "ora.orcl.db start" encountered the following error:
ORA-12547: TNS:lost contact
. For details refer to "(:CLSN00107:)" in "/u01/app/oracle/diag/crs/orcldb-n1/crs/trace/crsd_oraagent_oracle.trc".

CRS-2674: Start of 'ora.orcl.db' on 'orcldb-n1' failed
ORA-12547: TNS:lost contact
CRS-5017: The resource action "ora.orcl.db start" encountered the following error:
ORA-12547: TNS:lost contact
. For details refer to "(:CLSN00107:)" in "/u01/app/oracle/diag/crs/orcldb-n2/crs/trace/crsd_oraagent_oracle.trc".

CRS-2674: Start of 'ora.orcl.db' on 'orcldb-n2' failed
ORA-12547: TNS:lost contact
CRS-2632: There are no more servers to try to place resource 'ora.orcl.db' on that would satisfy its placement policy
ORA-12547: TNS:lost contact
[oracle@orcldb-n2 ~]$


Below document can help you. It can happen if the it is a cloned env.

Local SQL*Plus Connection and DBCA Fails With: ORA-12547: TNS:Lost Contact (Doc ID 422173.1)

1. Check kernel parameters settings
2. Check permission of permissions on the ORACLE executable, and config.o
[oracle@orcldb-n2 orcl]$ ls -lrt $ORACLE_HOME/rdbms/lib/config.o
-rw-r--r-- 1 oracle dba 1328 Dec 14 13:06 /u01/app/oracle/product/12.1.0.2/orcl/rdbms/lib/config.o
[oracle@orcldb-n2 orcl]$ ls -lrt $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle dba 324021455 Dec 14 13:06 /u01/app/oracle/product/12.1.0.2/orcl/bin/oracle
[oracle@orcldb-n2 orcl]$
3. Do relink all  on the database nodes
[oracle@orcldb-n2 orcl]$ relink all
writing relink log to: /u01/app/oracle/product/12.1.0.2/orcl/install/relink.log
[oracle@orcldb-n2 orcl]$ 

No comments:

Post a Comment

Troubleshooting ACFS-07981: Metadata Validation Errors

  Troubleshooting ACFS-07981: Metadata Validation Errors Introduction The ACFS-07981 error indicates that an attempt to run an online file ...