connect / as sysdba Fails with Ora-12547 And Tns-12514 (Doc ID 381566.1)

Last updated on JULY 06, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.4 to 11.2.0.4 [Release 8.1.7 to 11.2]
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 8.1.7.4 to 11.1.0.7
***Checked for relevance on 03-Feb-2016***


Symptoms

connect / as sysdba
fails with ORA-12547.

The OS Oracle environment variables are correctly set: ORACLE_HOME, ORACLE_SID, PATH etc.
When tracing the sqlplus session using the truss utility as follows:

truss -aefo sqlplus.trc sqlplus /nolog
connect / as sysdba
(AIX, Solaris)
or
strace -f -o sqlplus.trc sqlplus /nolog
connect / as sysdba
(Linux)


and analyzing the resulting trace file there are additional errors discovered inside, among which the most important is ORA-27100:

2654: write(5, " O R A - 0 0 6 0 0 : i".., 81) = 81
2654: write(5, "\n", 1) = 1
2654: write(5, " O R A - 2 7 1 0 0 : s".., 45) = 45

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