SYSDBA Connections Fail With ORA-12547 Error
(Doc ID 782276.1)
Last updated on FEBRUARY 23, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.3 [Release 11.1 to 11.2]IBM AIX on POWER Systems (64-bit)
IBM AIX Based Systems (64-bit)
Symptoms
When attempting to connect to the database as SYSDBA the following error occurs:
sqlplus / as sysdba
ERROR
ORA-12547: TNS: lost contact
truss of sqlplus connection shows a trace file being generated in $ORACLE_HOME/rdbms/log directory instead of the BDUMP location.
Excerpt from truss output:
569536: statx("<$ORACLE_HOME>/rdbms/log/<FILENAME>.trc", 0x0FFFFFFFFFFF7DF0, 176, 01) = 0
569536: statx("<$ORACLE_HOME>/rdbms/log/<FILENAME>.trc", 0x0FFFFFFFFFFF7DF0, 176, 0) = 0
569536: open("<$ORACLE_HOME>/rdbms/log/<FILENAME>.trc", O_WRONLY|O_APPEND|O_LARGEFILE) = 3
569536: kwrite(3, " D u m p f i l e ", 10) = 10
569536: kwrite(3, " / o p t / o r a c l e /".., 63) = 63
569536: kwrite(3, "\n", 1) = 1
569536: kwrite(3, "\n * * * 2 0 0 9 - 0 2".., 29) = 29
569536: kwrite(3, " O r a c l e D a t a b".., 200) = 200
Trace file shows:
EXTSHM should not be set to ON in the environment EXTSHM should not be set to ON in the environment
----- Error Stack Dump -----
ORA-00600: internal error code, arguments: [SKGMINVALID], [5], [0], [44], [0], [], [], []
----- SQL Statement (None) -----
Current SQL information unavailable - no SGA.
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 |