My Oracle Support Banner

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

Last updated on JANUARY 25, 2020

Applies to:

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


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


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

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