ORA-600 [OCIKDBLinkConn-8],, [ORA-24327: need explicit attach before authenticating a user]
Last updated on FEBRUARY 07, 2014
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.5 and later
Information in this document applies to any platform.
***Checked for relevance on 22-Feb-2013***
The following error is seen:
ORA-00600: internal error code, arguments: [OCIKDBLinkConn-8], , [ORA-24327: need explicit attach before authenticating a user], , , , , 
The failing SQL statement is executed by an application.
The database is in 10.2.0.5 and the application is using an Oracle client of version 10.1.0.5
The error happens always when there is a remote query.
Removing the PARALLEL clause of the involved table prevents the error.
an ORA-24327 error for statements containing an "@!" construct (which we see
here also in our SQL statement).
This construct is used internally for reverse database link operations so can
appear in SQL which has been issued to the instance across a database link
from a remote database.
Unpublished Bug 4714078 which represents the above fact has been fixed in 10.2.0.5.
The database was upgraded to 10.2.0.5
The application and database were separated to different machines after which this error is seen. Before that it was fine.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms