Database Administration (MOSC)

MOSC Banner

oradim startup service ends with ORA-24327: need explicit attach before authenticating a user

edited May 4, 2017 5:05AM in Database Administration (MOSC) 10 commentsAnswered
 Hi Community,
I have this problem in some databases:
Oracle 10.2 on Windows 2003 32-bit - very stable;
Oracle 10.2 on Windows 2003 64-bit - rather stable;
Oracle 11.2 on Windows 2008 64-bit - random.

Starting OracleService<ORACLE_SID> not starts the database instance, but after this I need to execute startup from SQL*Plus.
The file oradim.log in %ORACLE_HOME%\database contains error messages:
ORA-24327: need explicit attach before authenticating a user

As a result the database on such machine does not start automatically (or not always starts automatically) on server reboot. As a result on each reboot a manual intervention is required.

I faced the same problem on both real and virtual (VMvare) machines. And I cannot find any solution in My Oracle Support Knowledge Base.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center