ORA-01092: ORACLE instance terminated. Disconnection forced

[Former Member]

Hi Oracle Experts,

I have installed Oracle 10.2.0.2. My OS is : IBM AIX 5L.

I have logged in to SQL Prompt as SYSDBA.

I want to open the database.

If I say :

SQL> alter database noarchivelog;

Database altered.

SQL> alter database open;

I am getting the below error message:Please assist me to resolve the same.

*

ERROR at line 1:

ORA-01092: ORACLE instance terminated. Disconnection forced

What might the issue,Please explain.

Regards,

Karthick

[Former Member]

Hi,

Its common error, with this error code its very difficult to find a solution.

Try to send alert<SID>.log file it will be saptrace folder, with that file we can to R&D.

Regards

KT

[former_member204746]

My guess is that your database is not at the same version of your Oracle binaries.

refer to previous answer, this log will tell you what went wrong.

[markus_doehr2]

Check your alert log in $ORACLE_HOME/saptrace/background

Markus