Home » Infrastructure » Windows » ORA-12547 TNS : lost contact (Databse on Windows server 2003 enterprise edition sp2)
ORA-12547 TNS : lost contact [message #419456] Sat, 22 August 2009 11:06 Go to next message
rkoracle
Messages: 4
Registered: August 2009
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:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ORACLE.apps.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VIS)(INSTANCE_NAME=VIS)(CID=(PROGRA M=C:\Virtual_Server\product\11.1.0\client_2\BIN\sqlplus.exe)(HOST=PLUTO)(USER=Rk))))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 11.1.0.6.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.1.0.6.0 - 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?

Thanks
Rk
Re: ORA-12547 TNS : lost contact [message #419457 is a reply to message #419456] Sat, 22 August 2009 11:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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
 startup.
 *Action: Investigate partner application for abnormal termination. On an
 Interchange, this can happen if the machine is overloaded

Regards
Michel
Re: ORA-12547 TNS : lost contact [message #419461 is a reply to message #419456] Sat, 22 August 2009 14:31 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>TNS-00517: Lost contact
>nt secondary err code: 54
>nt OS err code: 0

Some sort of OS (Windows) error.
post tail end of listener.log file
post tail end of alert_<SID>.log
post tail end of OS system error log
Re: ORA-12547 TNS : lost contact [message #419480 is a reply to message #419461] Sat, 22 August 2009 19:14 Go to previous messageGo to next message
rkoracle
Messages: 4
Registered: August 2009
Junior Member
Hi,

1) Here is the listener log
Fatal NI connect error 12638, connecting to:
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.2.0.6.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 9.2.0.6.0 - Production
Time: 22-AUG-2009 18:45:44
Tracing not turned on.
Tns error struct:
ns main err code: 12638
TNS-12638: Credential retrieval failed
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0


2)The OS error log says

The Computer Browser service entered the stopped state

3) The alert_SID.log is

Sat Aug 22 19:47:22 2009
Database Characterset is UTF8
Sat Aug 22 19:48:07 2009
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Re: ORA-12547 TNS : lost contact [message #419487 is a reply to message #419456] Sun, 23 August 2009 01:00 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Listener reports error
Time: 22-AUG-2009 18:45:44
Tracing not turned on.
Tns error struct:
ns main err code: 12638
TNS-12638: Credential retrieval failed
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
===================================
You post 3) The alert_SID.log from
>Sat Aug 22 19:47:22 2009

which is more than an hour after failure to be fixed.

Since you won't assist with clues, enjoy your mystery.

[Updated on: Sun, 23 August 2009 01:00]

Report message to a moderator

Re: ORA-12547 TNS : lost contact [message #419499 is a reply to message #419487] Sun, 23 August 2009 09:15 Go to previous messageGo to next message
rkoracle
Messages: 4
Registered: August 2009
Junior Member
Hi,

I am very new to this area and trying to learn new things. I am sorry if I didn't post enough information. Unfortunately my virtual machine crashed today, I am working on re-installation.Let's see if this problem recurs on the new installation.

Thanks for your help
Rk
Re: ORA-12547 TNS : lost contact [message #419501 is a reply to message #419456] Sun, 23 August 2009 10:47 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Unfortunately my virtual machine crashed today
Did it ever occur to you the the Oracle problem may be due to flawed virtual system configuration?

Re: ORA-12547 TNS : lost contact [message #419504 is a reply to message #419501] Sun, 23 August 2009 11:07 Go to previous message
rkoracle
Messages: 4
Registered: August 2009
Junior Member
I was able to access the front end through browser but the problem is with accessing back-end through client. I am not sure if the source of problem is virtual machine.
Previous Topic: Unable to Login in Oracle Enterprise Manager console on Windows Vista
Next Topic: How to monitor memory consumption?
Goto Forum:
  


Current Time: Fri Mar 29 02:32:08 CDT 2024