ORA-24327: need explicit attach before authenticating a user

[varajan]

Hi,

I am having an Oracle instance (Oracle 8.1.6) , and it starts ok, but as soon as I post a transactions, the log files get updated with this error code.

[ORA-24327: need explicit attach before authenticating a user

I jave looked into the documentation, but couldn't understand much.

Any suggestions?

Thanks,
Rajan

 

[gbraden]

Error: ORA-24327
Text: need explicit attach before authenticating a user
---------------------------------------------------------------------------
Cause: A server context must be initialized before creating a session.
Action: Create and initialize a server handle.

Metalinks (

http://metalink.oracle.com)

indicates this is caused by several problems, including problems with iCache, and Weblogic. Other suggestions include looking for duplicate IP numbers in the TNSNAMES.ORA and LISTENER.ORA, looking for faulty hardware, etc, etc.

What changed in your environment that this should start happening? Is anyone else having the same problem?