My Oracle Support Banner

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

Last updated on JANUARY 04, 2020

Applies to:

Oracle Database - 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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.