oradim startup service ends with ORA-24327: need explicit attach before authenticating a user
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.
0