Client Connections Fail With TNS-12154 / ORA-12154
Last updated on OCTOBER 24, 2013
Applies to:
Oracle Net Services - Version 10.2.0.1 and laterInformation in this document applies to any platform.
***Checked for relevance on 15-Jan-2012***
Symptoms
Connection to the database, error with ORA-12154: TNS:could not resolve the connect identifier specified.
C:\Documents and Settings\>sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jul 15 05:45:36 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: system@orcl/****
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jul 15 05:45:36 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: system@orcl/****
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
In this case,TNSping also intermittently failing, reporting:
TNSPING.EXE - Application Error : The instruction at "0x609fc63c" referenced memory at "0x0000007c". The memory could not be "read".
Oracle Net level 16, client trace of a SQL*plus connection failure, attempting to lookup entry "orcl" shows the following:
[15-JUL-2010 05:45:36:773] nnfgrne: Switching to TNSNAMES adapter
[15-JUL-2010 05:45:36:773] nnftboot: entry
[15-JUL-2010 05:45:36:773] nlpaxini: entry
[15-JUL-2010 05:45:36:773] nlpaxini: exit
[15-JUL-2010 05:45:36:773] nnftmlf_make_local_addrfile: entry
[15-JUL-2010 05:45:36:773] nnftmlf_make_local_addrfile: construction of local names file failed
[15-JUL-2010 05:45:36:773] nnftmlf_make_local_addrfile: exit
[15-JUL-2010 05:45:36:773] nlpaxini: entry
[15-JUL-2010 05:45:36:773] nlpaxini: exit
[15-JUL-2010 05:45:36:773] nnftmlf_make_system_addrfile: entry
[15-JUL-2010 05:45:36:773] nnftmlf_make_system_addrfile: construction of system names file failed
[15-JUL-2010 05:45:36:773] nnftmlf_make_system_addrfile: exit
[15-JUL-2010 05:45:36:773] nnftboot: exit
[15-JUL-2010 05:45:36:773] nnftrne: entry
[15-JUL-2010 05:45:36:773] nnftrne: Original name: orcl
[15-JUL-2010 05:45:36:773] nnfttran: entry
[15-JUL-2010 05:45:36:773] nnfttran: Error querying orcl of attribute A.SMD
[15-JUL-2010 05:45:36:773] nnftboot: entry
[15-JUL-2010 05:45:36:773] nlpaxini: entry
[15-JUL-2010 05:45:36:773] nlpaxini: exit
[15-JUL-2010 05:45:36:773] nnftmlf_make_local_addrfile: entry
[15-JUL-2010 05:45:36:773] nnftmlf_make_local_addrfile: construction of local names file failed
[15-JUL-2010 05:45:36:773] nnftmlf_make_local_addrfile: exit
[15-JUL-2010 05:45:36:773] nlpaxini: entry
[15-JUL-2010 05:45:36:773] nlpaxini: exit
[15-JUL-2010 05:45:36:773] nnftmlf_make_system_addrfile: entry
[15-JUL-2010 05:45:36:773] nnftmlf_make_system_addrfile: construction of system names file failed
[15-JUL-2010 05:45:36:773] nnftmlf_make_system_addrfile: exit
[15-JUL-2010 05:45:36:773] nnftboot: exit
[15-JUL-2010 05:45:36:773] nnftrne: entry
[15-JUL-2010 05:45:36:773] nnftrne: Original name: orcl
[15-JUL-2010 05:45:36:773] nnfttran: entry
[15-JUL-2010 05:45:36:773] nnfttran: Error querying orcl of attribute A.SMD
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms