TNS-12547: TNS:lost contact

[Former Member]

Hi

When I tried to login to sqlplus prompt, I am not able to login, I get the below error

kdqasap2:orakgq 2> sqlplus "/as sysdba

" SQL*Plus: Release 9.2.0.4.0 - Production on Sat Nov 14 11:14:57 2009 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR: ORA-12547: TNS:lost contact Enter user-name:

I checked the listener and tnsnames.ora file

kdqasap2:orakgq 68> cat listener.ora

################

1. Filename......: listener.ora

2. Created.......: created by SAP AG, R/3 Rel. >= 4.0A

3. Name..........:

4. Date..........:

################

LISTENER =

(ADDRESS_LIST =

(ADDRESS=

(PROTOCOL=IPC)

(KEY= KGQ.WORLD)

)

(ADDRESS=

(PROTOCOL=IPC)

(KEY= KGQ)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = kdqasap2)

(PORT = 1527)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SDU = 32768)

(SID_NAME = KGQ)

(ORACLE_HOME = /oracle/KGQ/920_64)

)

)

kdqasap2:orakgq 69>

TNS

kdqasap2:orakgq 70> cat tnsnames.ora

################

1. Filename......: tnsnames.ora

2. Created.......: created by SAP AG, R/3 Rel. >= 4.0A

3. Name..........:

4. Date..........:

################

KGQ.WORLD=

(DESCRIPTION =

(SDU = 32768)

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = kdqasap2)

(PORT = 1527)

)

)

(CONNECT_DATA =

(SID = KGQ)

(GLOBAL_NAME = KGQ.WORLD)

)

)

kdqasap2:orakgq 71>

kdqasap2:orakgq 71> cat sqlnet.ora

################

1. Filename......: sqlnet.ora

2. Created.......: created by SAP AG, R/3 Rel. >= 4.0A

3. Name..........:

4. Date..........:

################

AUTOMATIC_IPC = ON

TRACE_LEVEL_CLIENT = OFF

SQLNET.EXPIRE_TIME = 0

NAMES.DEFAULT_DOMAIN = WORLD

NAME.DEFAULT_ZONE = WORLD

kdqasap2:orakgq 72>

kdqasap2:orakgq 72> cat protocol.ora

tcp.nodelay = true

kdqasap2:orakgq 73>

But the sqlnet.log files gives the below error

***********************************************************************

Fatal NI connect error 12547, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/KGQ/920_64/bin/oracle)(ARGV0=oracleKGQ)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=kdqasap2)(USER=orakgq))))

VERSION INFORMATION:

TNS for HPUX: Version 9.2.0.4.0 - Production

Oracle Bequeath NT Protocol Adapter for HPUX: Version 9.2.0.4.0 - Production

Time: 14-NOV-2009 10:20:17

Tracing not turned on.

Tns error struct:

nr err code: 0

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: 32

nt OS err code: 0

kdqasap2:orakgq 74>

There is not error message in the alert log file

Should I need to check some other things?

Thanks & Regards

Senthil

Edited by: J. Senthil Murugan on Nov 14, 2009 5:28 PM

Edited by: J. Senthil Murugan on Nov 14, 2009 5:28 PM

[Former Member · Accepted solution]

Hi,

SAP note 131561 lists several possible causes of TNS-12547 and related errors. Make sure you check that note first. Also look at note 441518, which covers ORA-12560 (reported as the secondary error in your log).

Just to make sure: your system is called KGQ, and I suppose from the "Q" in the name that it is a quality assurance system. Did you recently refresh KGQ with a copy of your production system? Has SQLPLUS ever worked in the KGQ environment or have you had this error since the beginning?

Regards,

Mark

[Former Member]

Hi.

I had the same problem and after I has saw a lot of messages and SAP Notes, the problem was related to the /PROC files system

In my case, the AIX server had a problem and didin't mount this file system and all the time the SQLPLUS try to contact the files, a core dump file was generated.

I hope it can help you.

Best regards,

Reinaldo.

[Former Member]

Hey Reinaldo,

Thanks for posting that last comment. That was our exact issue!

Regards,

Paul Fassnacht

[Former Member]

Also can occur when set userid bit not set for $ORACLE_HOME/bin/oracle

-rwxr-x--x  on executable oracle instead of set userid bit

chmod 6751 $ORACLE_HOME/bin/oracle if not rwsr_s__x

See thread https://scn.sap.com/thread/1822764

This note, however, more likely to come up than above referenced note.

regards

[rajendra_golegaonkar]

Rename or delete the log file $ORACLE_HOME/network/log/listener.log if it has reached 2 GB limit and restart the listener

Make sure /etc/host contains following

127.0.0.1 localhost.localdomain localhost

Regards.

Rajendra