OraFAQ Forum: Windows » ORA-12547 TNS : lost contact

Home » Infrastructure » Windows » ORA-12547 TNS : lost contact (Databse on Windows server 2003 enterprise edition sp2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12547 TNS : lost contact [message #419456]

Sat, 22 August 2009 11:06

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

Report message to a moderator

Re: ORA-12547 TNS : lost contact [message #419457 is a reply to message #419456]

Sat, 22 August 2009 11:56

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: ORA-12547 TNS : lost contact [message #419461 is a reply to message #419456]

Sat, 22 August 2009 14:31

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

Report message to a moderator

Re: ORA-12547 TNS : lost contact [message #419480 is a reply to message #419461]

Sat, 22 August 2009 19:14

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

Report message to a moderator

Re: ORA-12547 TNS : lost contact [message #419487 is a reply to message #419456]

Sun, 23 August 2009 01:00

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

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

Report message to a moderator

Re: ORA-12547 TNS : lost contact [message #419501 is a reply to message #419456]

Sun, 23 August 2009 10:47

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?

Report message to a moderator

Re: ORA-12547 TNS : lost contact [message #419504 is a reply to message #419501]

Sun, 23 August 2009 11:07

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.

Report message to a moderator

Previous Topic:	Unable to Login in Oracle Enterprise Manager console on Windows Vista
Next Topic:	How to monitor memory consumption?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 05:30:27 CST 2024