ORA-01092

[Former Member]

Hi all,

I did a system refresh by backup and restore method. The database recovery part has been completed, now when I enter 'Alter database open'; it says:

ORA-01092: ORACLE instance terminated. Disconnection forced

The Oracle instance gets terminated, so when I execute the startup command it says datafile is corrup and needs media recovey, so I executed recover database and within few seconds media recovery is complete.

Again when i try to open the database it throws me ORA 01092 error. Please help me out in fixing up.

Regards,

Balakrishnan

[sunny_pahuja2 · Accepted solution]

Hi,

please go through below links

https://websmp130.sap-ag.de/sap(bD1kZSZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=636475 (SAP note 636475)

http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/ora01092-oracle-instance-termina...

As per SAP note 636475, ora-01092 is secondary error...could you please look into other errors ?

Thanks

Sunny

[Former Member]

Hi ,

I thnk you upgraded Database but not upgraded properly as showing usertrace log.

Check which DB version you are having and do below

SQL> Startup Upgrade

Run below sql script

SQL >

8.0.6 u0800060.sql

8.1.7 u0801070.sql

9.0.1 u0900010.sql

9.2.0 u0902000.sql

If u have not upgraded then send alert<SID>.log file not usertrace.

Thnx

SurendraJain

[Former Member]

Hi All,

The problem was with the patch set, Issue fixed.

Balakrishnan

[Former Member]

Dear Balakrishna,

Ora-01092 due to Shutdown abort .Can You check alert<SID>.log file which is available in

saptrace/background/ as defined in background_dump_dest.

Might be error in undo tablespace .

SurendraJain

[Former Member]

Hi All,

Yes the source and target database are at same patch level.

The Log in alert_<sid>.log files content is:

ARC0: STARTING ARCH PROCESSES

ARC2 started with pid=18, OS id=2188

Fri Jun 05 10:36:03 2009

Errors in file e:\oracle\tqs\saptrace\usertrace\tqs_ora_512.trc:

ORA-00704: bootstrap process failure

ORA-39700: database must be opened with UPGRADE option

Fri Jun 05 10:36:03 2009

Error 704 happened during db open, shutting down database

USER: terminating instance due to error 704

Fri Jun 05 10:36:03 2009

Errors in file e:\oracle\tqs\saptrace\background\tqs_pmon_2360.trc:

ORA-00704: bootstrap process failure

ARC1 started with pid=17, OS id=1704

Fri Jun 05 10:36:04 2009

ARC2: Archival started

Fri Jun 05 10:36:04 2009

Errors in file e:\oracle\tqs\saptrace\background\tqs_arc0_1060.trc:

ORA-00449: background process 'ARC2' unexpectedly terminated with error 704

ORA-00704: bootstrap process failure

Fri Jun 05 10:36:04 2009

Errors in file e:\oracle\tqs\saptrace\background\tqs_arc0_1060.trc:

ORA-00449: background process 'ARC2' unexpectedly terminated with error 704

ORA-00704: bootstrap process failure

Fri Jun 05 10:36:04 2009

ARC0: Detected ARCH process failure

ARC0: STARTING ARCH PROCESSES COMPLETE

ARC0: Becoming the 'no FAL' ARCH

ARC0: Becoming the 'no SRL' ARCH

Fri Jun 05 10:36:04 2009

Errors in file e:\oracle\tqs\saptrace\background\tqs_psp0_576.trc:

ORA-00704: bootstrap process failure

Fri Jun 05 10:36:04 2009

Errors in file e:\oracle\tqs\saptrace\background\tqs_mman_2824.trc:

ORA-00704: bootstrap process failure

Fri Jun 05 10:36:04 2009

Errors in file e:\oracle\tqs\saptrace\background\tqs_lgwr_2872.trc:

ORA-00704: bootstrap process failure

Fri Jun 05 10:36:04 2009

Errors in file e:\oracle\tqs\saptrace\background\tqs_dbw0_232.trc:

ORA-00704: bootstrap process failure

Fri Jun 05 10:36:05 2009

Errors in file e:\oracle\tqs\saptrace\background\tqs_reco_940.trc:

ORA-00704: bootstrap process failure

Fri Jun 05 10:36:05 2009

Errors in file e:\oracle\tqs\saptrace\background\tqs_smon_1400.trc:

ORA-00704: bootstrap process failure

Fri Jun 05 10:36:05 2009

Errors in file e:\oracle\tqs\saptrace\background\tqs_ckpt_1640.trc:

ORA-00704: bootstrap process failure

Fri Jun 05 10:36:06 2009

Instance terminated by USER, pid = 512

ORA-1092 signalled during: alter database open

...

Most of the above mentioned trace file contains the following error:

ORA-00704: bootstrap process failure

ORA-39700: database must be opened with UPGRADE option

ORA-00447: fatal error in background process

Please let me know how to proceed.

Regards,

Balakrishnan

[Former Member]

Bala,

Check Note 582427 - Error due to inconsistent Oracle DDIC

Thanks,

Sushil

[Former Member]

ORA-39700: database must be opened with UPGRADE option

So I would double-check if Oracle versions and patch levels really are the same.

[former_member204746]

are both source and refreshed system using the same exact Oracle version and patch level?

check alert_SID.log file for clues on why this is failing.

[Former Member]

Bala,

Can you Check the oracle alert log (alert<SID>.log) for errors.

If you are getting ORA-600 in alert log file then see Note 613714 - Oracle 9i: ORA-00600 [qctstc2o1].

Also check this link.

Hope this helps.

Thanks

Sushil