Home » RDBMS Server » Networking and Gateways » Oracle 12457 erro
Oracle 12457 erro [message #478588] Mon, 11 October 2010 02:33 Go to next message
Messages: 5
Registered: October 2010
Junior Member
Hi all,

I am trying to connect to the Oracle apps 11i(residing on windows server 03), through Sql * plus client from windows 7 machine.

I get an error ORA-12547 TNS : lost contact

Here is the log file content

Fatal NI connect error 12547, connecting to:

TNS for 32-bit Windows: Version - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version - Production
Time: 21-AUG-2009 17:06:43
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: 54
nt OS err code: 0

Can anybody help me find out what's the problem with my settings?
Re: Oracle 12457 erro [message #478589 is a reply to message #478588] Mon, 11 October 2010 02:56 Go to previous message
Michel Cadot
Messages: 68310
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12547: TNS:lost contact
 *Cause: Partner has unexpectedly gone away, usually during process
 *Action: Investigate partner application for abnormal termination. On an
 Interchange, this can happen if the machine is overloaded.

Previous Topic: tnsnames.ora file not present
Next Topic: Listener Log
Goto Forum:

Current Time: Sat Nov 26 22:39:49 CST 2022