Errors in file/opt/Oracle/admin/dbtest/udump/dbtest_ora_14166.trc:
ORA-00604: Error occurred at recursive SQL Level 1
The ORA-12663: services required by client not available on the server
A ORA-36961: Oracle OLAP is not available.
ORA-06512: At "SYS. olapihistoryretention", line 1
ORA-06512: At line 15
Wed Oct 25 12:34:50 2006
Completed: Alter database open
This error is rather confusing. You can find the trace file.
More/opt/Oracle/admin/dbtest/udump/dbtest_ora_14166.trc
Error in executing triggers on Database startup
* ** 12:34:50. 289
Ksedmp: internal or fatal error
ORA-00604: Error occurred at recursive SQL Level 1
The ORA-12663: services required by client not available on the server
A ORA-36961: Oracle OLAP is not available.
ORA-06512: At "SYS. olapihistoryretention", line 1
That is to say, when the instance is started, a trigger is executed.
SQL> select trigger_name, status from user_triggers where status = 'enabled ';
Trigger_name status
--------------------------------------
Aw_drop_trg Enabled
Olapistartuptrigger Enabled
Olapishutdowntrigger Enabled
Log_trigger Enabled
Disable the olapistartuptrigger and olapishutdowntrigger triggers.