ORA-600 [OCIKDBLinkConn-8], [24327], [ORA-24327: need explicit attach before authenticating a user ] on 12c CDB
(Doc ID 1614432.1)
Last updated on FEBRUARY 26, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.1 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Running Oracle 12.1.0.1 on Linux x86-64, next error shows up repeatedly in the alert log of a CDB (12.1.0.1) database:
...
Wed Jan 08 15:29:32 2014
Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_p001_22904.trc (incident=208827):
ORA-00600: internal error code, arguments: [OCIKDBLinkConn-8], [24327], [ORA-24327: need explicit attach before authenticating a user
], [], [], [], [], [], [], [], [], []
Incident details in: <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_208827<instname>_p001_22904_i208827.trc
Wed Jan 08 15:29:34 2014
...
Wed Jan 08 15:29:32 2014
Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_p001_22904.trc (incident=208827):
ORA-00600: internal error code, arguments: [OCIKDBLinkConn-8], [24327], [ORA-24327: need explicit attach before authenticating a user
], [], [], [], [], [], [], [], [], []
Incident details in: <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_208827<instname>_p001_22904_i208827.trc
Wed Jan 08 15:29:34 2014
...
The parallel query server trace file shows next characteristics:
*** 2014-01-08 15:29:32.275
*** SESSION ID:(1164.27011) 2014-01-08 15:29:32.275
*** CLIENT ID:() 2014-01-08 15:29:32.275
*** SERVICE NAME:(SYS$USERS) 2014-01-08 15:29:32.275
*** MODULE NAME:(emagent_SQL_oracle_database) 2014-01-08 15:29:32.275
*** ACTION NAME:(cdb_high_water_mark_stats) 2014-01-08 15:29:32.275
*** CONTAINER ID:(1) 2014-01-08 15:29:32.275
Dump continued from file: <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_p001_22904.trc
ORA-00600: internal error code, arguments: [OCIKDBLinkConn-8], [24327], [ORA-24327: need explicit attach before authenticating a user
], [], [], [], [], [], [], [], [], []
========= Dump for incident 208827 (ORA 600 [OCIKDBLinkConn-8]) ========
*** 2014-01-08 15:29:32.278
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=4yjv7tztvr0hn) -----
SELECT count(*) FROM SYS."DBA_HIGH_WATER_MARK_STATISTICS" "DBA_HIGH_WATER_MARK_STATISTICS" WHERE 1=1 AND 1=1 AND "DBA_HIGH_WATER_MARK_STATISTICS"."VERSION"= (SELECT MAX(SYS_OP_CSR(SYS_OP_MSR(MAX("HWM"."VERSION")),0)) FROM SYS."WRI$_DBU_HIGH_WATER_MARK"@! "HWM",SYS."WRI$_DBU_HWM_METADATA"@! "MT")
...
*** SESSION ID:(1164.27011) 2014-01-08 15:29:32.275
*** CLIENT ID:() 2014-01-08 15:29:32.275
*** SERVICE NAME:(SYS$USERS) 2014-01-08 15:29:32.275
*** MODULE NAME:(emagent_SQL_oracle_database) 2014-01-08 15:29:32.275
*** ACTION NAME:(cdb_high_water_mark_stats) 2014-01-08 15:29:32.275
*** CONTAINER ID:(1) 2014-01-08 15:29:32.275
Dump continued from file: <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_p001_22904.trc
ORA-00600: internal error code, arguments: [OCIKDBLinkConn-8], [24327], [ORA-24327: need explicit attach before authenticating a user
], [], [], [], [], [], [], [], [], []
========= Dump for incident 208827 (ORA 600 [OCIKDBLinkConn-8]) ========
*** 2014-01-08 15:29:32.278
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=4yjv7tztvr0hn) -----
SELECT count(*) FROM SYS."DBA_HIGH_WATER_MARK_STATISTICS" "DBA_HIGH_WATER_MARK_STATISTICS" WHERE 1=1 AND 1=1 AND "DBA_HIGH_WATER_MARK_STATISTICS"."VERSION"= (SELECT MAX(SYS_OP_CSR(SYS_OP_MSR(MAX("HWM"."VERSION")),0)) FROM SYS."WRI$_DBU_HIGH_WATER_MARK"@! "HWM",SYS."WRI$_DBU_HWM_METADATA"@! "MT")
...
The call stack from the trace file includes functions like:
... OCIKSIN kpndbcon OCIKDBLinkConn ddfnet2NormalHelper ddfnet2Normal kkmfcbrm kkmpfcbk qcsprfro qcsprfro_tree qcsprfro_tree ...
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |