My Oracle Support Banner

DBUA fails with Error ‘ORA-12547: TNS:lost contact’ (Doc ID 2034896.1)

Last updated on NOVEMBER 13, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Generic UNIX

Symptoms

DBUA fails with Error :”ORA-12547: TNS:lost contact”

trace.log shows that:

[main] [ 2015-06-17 07:53:24.369 MESZ ] [OracleHome.initOptionsStopOnError:1409] ORA-12547: TNS:lost contact

[main] [ 2015-06-17 07:53:24.369 MESZ ] [OracleHome.initOptionsStopOnError:1410] ORA-12547: TNS:lost contact

oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1739)
oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:987)
oracle.sysman.assistants.util.OracleHome.initOptionsStopOnError(OracleHome.java:1362)
oracle.sysman.assistants.dbma.backend.CompManager.obtainDatabaseInformation(CompManager.java:4118)
oracle.sysman.assistants.dbma.backend.SilentCompManager.startOperation(SilentCompManager.java:535)
oracle.sysman.assistants.dbma.Dbma.execute(Dbma.java:165)
oracle.sysman.assistants.dbma.Dbma.statusMain(Dbma.java:241)
oracle.sysman.assistants.dbma.Dbma.main(Dbma.java:225)

  And When connected the database to be upgraded from the target ORACLE_HOME ,it fails with “ORA-12547: TNS:lost contact”

export ORACLE_HOME=<Target Home>
export ORACLE_SID=<SID to be Upgrade>
$ORACLE_HOME/bin/sqlplus / as sysdba
ERROR:
ORA-12547: TNS:lost contact

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.