sqlplus "/ as sysdba" fails with ORA-12154 / ORA-12541 (Doc ID 883298.1)

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Server - Enterprise Edition - Version 8.1.7.0 to 11.1.0.7 [Release 8.1.7 to 11.1]
Oracle Net Services - Version 8.1.7.0 to 11.1.0.7.0 [Release 8.1.7 to 11.1]
Information in this document applies to any platform.
Oracle Net Services - Version: 8.1.7.0 to 11.1.0.7.0
This problem can occur on any platform.

Symptoms

sqlplus "/ as sysdba" failing with ORA-12154 / ORA-12541 .

Client sqlent shows :
--------------------- 

[06-SEP-2009 08:44:07:875] nnftrne: entry
[06-SEP-2009 08:44:07:875] nnftrne: Original name: PROD
[06-SEP-2009 08:44:07:875] nnfttran: entry
[06-SEP-2009 08:44:07:875] nnfttran: Error querying PROD of attribute A.SMD errcode 408
[06-SEP-2009 08:44:07:875] nnfgrne: Query unsuccessful, skipping to next adapter
[06-SEP-2009 08:44:07:875] nnfgrne: exit
[06-SEP-2009 08:44:07:875] nnfun2a: address for name "PROD" not found
[06-SEP-2009 08:44:07:875] niqname: Return code from nnfsn2a is 1

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