ora-01092 signalled during: ALTER DATABASE OPEN...

Ok, I have a windows XP system that was running an oracle 9i intance.  I installed a 10g instance along side of it and created a database.  Everything worked fine, I could connect to and access both databases without issue.  The 9i listener was disabled and the 10g listener was handling both instances.

The user of the system rebooted, and since then I've been unable to get the 9i db to work properly.  He doesn't think he did anything to cause this problem, but he (and the system) is not in the office, so I'm not positive on that.  

The service wouldn't start.

I used oradim to drop and recreate the service.  The service would then start, but only as an idle instance.

here's the output form sqlplus

SQL*Plus: Release 9.2.0.7.0 - Production on Wed Jan 23 16:03:32 2008



Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.



Connected to an idle instance.



SQL> startup mount

ORA-32004: obsolete and/or deprecated parameter(s) specified

ORACLE instance started.



Total System Global Area  121634816 bytes

Fixed Size                  1247636 bytes

Variable Size              92276332 bytes

Database Buffers           25165824 bytes

Redo Buffers                2945024 bytes

Database mounted.

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-01092: ORACLE instance terminated. Disconnection forced


Here's the Alert log:
Wed Jan 23 16:03:37 2008

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 2

Using LOG_ARCHIVE_DEST_1 parameter default value as c:\oracle\ora10g\RDBMS

Autotune of undo retention is turned on.

LICENSE_MAX_USERS = 0

SYS auditing is disabled

ksdpec: called for event 13740 prior to event group initialization

Starting up ORACLE RDBMS Version: 10.2.0.1.0.

System parameters with non-default values:

  processes                = 150

  timed_statistics         = TRUE

  shared_pool_size         = 50331648

  large_pool_size          = 8388608

  java_pool_size           = 33554432

  spfile                   = C:\ORACLE\ORA92\DATABASE\SPFILESPOUNIT.ORA

  control_files            = C:\ORACLE\ORADATA\SPOUNIT\CONTROL01.CTL, C:\ORACLE\ORADATA\SPOUNIT\CONTROL02.CTL, C:\ORACLE\ORADATA\SPOUNIT\CONTROL03.CTL

  db_block_size            = 8192

  db_cache_size            = 25165824

  compatible               = 9.2.0.0.0

  db_file_multiblock_read_count= 16

  fast_start_mttr_target   = 0

  undo_management          = AUTO

  undo_tablespace          = UNDOTBS1

  undo_retention           = 10800

  remote_login_passwordfile= EXCLUSIVE

  db_domain                = mcasolutions.com

  instance_name            = spounit

  dispatchers              = (PROTOCOL=TCP) (SERVICE=spounitXDB)

  job_queue_processes      = 10

  background_dump_dest     = C:\ORACLE\ADMIN\SPOUNIT\BDUMP

  user_dump_dest           = C:\ORACLE\ADMIN\SPOUNIT\UDUMP

  core_dump_dest           = C:\ORACLE\ADMIN\SPOUNIT\CDUMP

  sort_area_size           = 524288

  db_name                  = spounit

  open_cursors             = 300

  star_transformation_enabled= FALSE

  query_rewrite_enabled    = FALSE

  pga_aggregate_target     = 25165824

  aq_tm_processes          = 1

Obsolete system parameters with specified values:

  hash_join_enabled        

End of obsolete system parameter listing

PMON started with pid=2, OS id=5820

PSP0 started with pid=3, OS id=4844

MMAN started with pid=4, OS id=5064

DBW0 started with pid=5, OS id=6008

LGWR started with pid=6, OS id=4744

CKPT started with pid=7, OS id=4548

SMON started with pid=8, OS id=5492

RECO started with pid=9, OS id=5800

CJQ0 started with pid=10, OS id=5628

MMON started with pid=11, OS id=4788

Wed Jan 23 16:03:37 2008

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

MMNL started with pid=12, OS id=4836

Wed Jan 23 16:03:37 2008

starting up 1 shared server(s) ...

Oracle Data Guard is not available in this edition of Oracle.

Wed Jan 23 16:03:37 2008

ALTER DATABASE   MOUNT

Wed Jan 23 16:03:41 2008

Setting recovery target incarnation to 1

Wed Jan 23 16:03:41 2008

Successful mount of redo thread 1, with mount id 3311080025

Wed Jan 23 16:03:41 2008

Database mounted in Exclusive Mode

Completed: ALTER DATABASE   MOUNT

Wed Jan 23 16:15:49 2008

alter database open

Wed Jan 23 16:15:49 2008

Beginning crash recovery of 1 threads

Wed Jan 23 16:15:49 2008

Started redo scan

Wed Jan 23 16:15:50 2008

Completed redo scan

 1 redo blocks read, 0 data blocks need recovery

Wed Jan 23 16:15:50 2008

Started redo application at

 Thread 1: logseq 573, block 2, scn 25127539

Wed Jan 23 16:15:50 2008

Recovery of Online Redo Log: Thread 1 Group 2 Seq 573 Reading mem 0

  Mem# 0 errs 0: C:\ORACLE\ORADATA\SPOUNIT\REDO02.LOG

Wed Jan 23 16:15:50 2008

Completed redo application

Wed Jan 23 16:15:50 2008

Completed crash recovery at

 Thread 1: logseq 573, block 3, scn 25147541

 0 data blocks read, 0 data blocks written, 1 redo blocks read

Wed Jan 23 16:15:50 2008

Thread 1 advanced to log sequence 574

Thread 1 opened at log sequence 574

  Current log# 3 seq# 574 mem# 0: C:\ORACLE\ORADATA\SPOUNIT\REDO03.LOG

Successful open of redo thread 1

Wed Jan 23 16:15:51 2008

SMON: enabling cache recovery

Wed Jan 23 16:15:51 2008

Errors in file c:\oracle\admin\spounit\udump\spounit_ora_4340.trc:

ORA-00704: bootstrap process failure

ORA-39700: database must be opened with UPGRADE option



Wed Jan 23 16:15:51 2008

Error 704 happened during db open, shutting down database

USER: terminating instance due to error 704

Wed Jan 23 16:15:52 2008

Errors in file c:\oracle\admin\spounit\bdump\spounit_lgwr_4744.trc:

ORA-00704: bootstrap process failure



Wed Jan 23 16:15:52 2008

Errors in file c:\oracle\admin\spounit\bdump\spounit_pmon_5820.trc:

ORA-00704: bootstrap process failure



Wed Jan 23 16:15:52 2008

Errors in file c:\oracle\admin\spounit\bdump\spounit_mman_5064.trc:

ORA-00704: bootstrap process failure



Wed Jan 23 16:15:52 2008

Errors in file c:\oracle\admin\spounit\bdump\spounit_reco_5800.trc:

ORA-00704: bootstrap process failure



Wed Jan 23 16:15:52 2008

Errors in file c:\oracle\admin\spounit\bdump\spounit_ckpt_4548.trc:

ORA-00704: bootstrap process failure



Wed Jan 23 16:15:53 2008

Errors in file c:\oracle\admin\spounit\bdump\spounit_dbw0_6008.trc:

ORA-00704: bootstrap process failure



Wed Jan 23 16:15:53 2008

Errors in file c:\oracle\admin\spounit\bdump\spounit_psp0_4844.trc:

ORA-00704: bootstrap process failure



Instance terminated by USER, pid = 4340

ORA-1092 signalled during: alter database open...


I checked the bdump folder, nothing productive in the trace files...  

here's the udump tracefile that might have some decent info.  
Dump file c:\oracle\admin\spounit\udump\spounit_ora_5832.trc

Wed Jan 23 14:25:36 2008

ORACLE V10.2.0.1.0 - Production vsnsta=0

vsnsql=14 vsnxtr=3

Oracle Database 10g Release 10.2.0.1.0 - Production

Windows XP Version V5.1 Service Pack 2

CPU                 : 2 - type 586

Process Affinity    : 0x00000000

Memory (Avail/Total): Ph:670M/2014M, Ph+PgF:2066M/3906M, VA:1785M/2047M

Instance name: spounit



Redo thread mounted by this instance: 1



Oracle process number: 16



Windows thread id: 5832, image: ORACLE.EXE (SHAD)





*** SERVICE NAME:() 2008-01-23 14:25:36.985

*** SESSION ID:(159.3) 2008-01-23 14:25:36.985

Thread 1 checkpoint: logseq 567, block 2, scn 25007515

  cache-low rba: logseq 563, block 20144

    on-disk rba: logseq 563, block 23690, scn 24927501

  start recovery at logseq 567, block 2, scn 25007515

----- Redo read statistics for thread 1 -----

Read rate (ASYNC): 0Kb in 0.41s => 0.00 Mb/sec

Total physical reads: 4096Kb

Longest record: 0Kb, moves: 0/1 (0%)

Last redo scn: 0x0000.017d959c (25007516)

----------------------------------------------

----- Recovery Hash Table Statistics ---------

Hash table buckets = 32768

Longest hash chain = 0

Average hash chain = 0/0 = 0.0

Max compares per lookup = 0

Avg compares per lookup = 0/0 = 0.0

----------------------------------------------

*** 2008-01-23 14:25:37.422

KCRA: start recovery claims for 0 data blocks

*** 2008-01-23 14:25:37.422

KCRA: blocks processed = 0/0, claimed = 0, eliminated = 0

*** 2008-01-23 14:25:37.485

Recovery of Online Redo Log: Thread 1 Group 2 Seq 567 Reading mem 0

----- Recovery Hash Table Statistics ---------

Hash table buckets = 32768

Longest hash chain = 0

Average hash chain = 0/0 = 0.0

Max compares per lookup = 0

Avg compares per lookup = 0/0 = 0.0

----------------------------------------------

ORA-00704: bootstrap process failure

ORA-39700: database must be opened with UPGRADE option

Dump file c:\oracle\admin\spounit\udump\spounit_ora_5832.trc

Wed Jan 23 15:48:59 2008

ORACLE V10.2.0.1.0 - Production vsnsta=0

vsnsql=14 vsnxtr=3

Oracle Database 10g Release 10.2.0.1.0 - Production

Windows XP Version V5.1 Service Pack 2

CPU                 : 2 - type 586

Process Affinity    : 0x00000000

Memory (Avail/Total): Ph:618M/2014M, Ph+PgF:2012M/3906M, VA:1783M/2047M

Instance name: spounit



Redo thread mounted by this instance: 0 <none>



Oracle process number: 15



Windows thread id: 5832, image: ORACLE.EXE (SHAD)





*** SERVICE NAME:() 2008-01-23 15:48:59.633

*** SESSION ID:(159.1) 2008-01-23 15:48:59.633

kccsga_update_ckpt: num_1 = 1, num_2 = 0, num_3 = 0, lbn_2 = 0, lbn_3 = 0





Is this a salvageable database, or is it hosed?



Start Free Trial