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 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 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 /u01/app/oracle/diag/rdbms/abasin/abasin1/trace/abasin1_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: /u01/app/oracle/diag/rdbms/abasin/abasin1/incident/incdir_208827/abasin1_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: /u01/app/oracle/diag/rdbms/abasin/abasin1/trace/abasin1_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 ...

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