Thursday, December 15, 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

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...