My Oracle Support Banner

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

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.