Skip to Content
author's profile photo Former Member
Former Member

TNS-12547: TNS:lost contact

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 16, 2009 at 06:11 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 15, 2009 at 08:40 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 20, 2010 at 03:49 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.