Re: 10g Database not starting after applying patch

From: oracle, old sherwoodian <rana_gman_at_hotmail.com>
Date: Tue, 12 May 2009 10:25:28 -0700 (PDT)
Message-ID: <0212534a-59a3-4448-88d6-f4433a35ad72_at_n4g2000vba.googlegroups.com>



On May 12, 12:51 pm, ddf <orat..._at_msn.com> wrote:
> On May 12, 11:40 am, "oracle, old sherwoodian" <rana_g..._at_hotmail.com>
> wrote:
>
>
>
>
>
> > On May 12, 12:19 pm, gar..._at_jamms.org wrote:
>
> > > On 12 May, 17:14, "oracle, old sherwoodian" <rana_g..._at_hotmail.com>
> > > wrote:
>
> > > > The OS is XP- Hide quoted text -
>
> > > So, what happens if you try the following:
>
> > > 1.  Open a command prompt
> > > 2.  At the command prompt, type:
>
> > > set ORACLE_SID=<database sid>
> > > sqlplus / as sysdba
>
> > > SQL>  startup?
>
> > > HTH
>
> > > -g
>
> > I did what you asked of me and i still get the same error. The details
> > of this error is:
> > SQL*Plus: Release 10.2.0.3.0 - Production on Tue May 12 12:38:23 2009
>
> > Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.
>
> > SQL> SQL> Connected to an idle instance.
> > SQL> ORACLE instance started.
>
> > Total System Global Area  612368384 bytes
> > Fixed Size                  1292036 bytes
> > Variable Size             218106108 bytes
> > Database Buffers          385875968 bytes
> > Redo Buffers                7094272 bytes
> > Database mounted.
> > ORA-01092: ORACLE instance terminated. Disconnection forced
>
> > Disconnected from Oracle Database 10g Enterprise Edition Release
> > 10.2.0.3.0 - Production
> > With the Partitioning, OLAP and Data Mining options- Hide quoted text -
>
> > - Show quoted text -
>
> At this point you should have been looking in the alert log for the
> error causing this disconnection.  We certainly can't tell  you what
> that error is.  So go read your alert log and tell us what error
> you're experiencing.
>
> David Fitzjarrell- Hide quoted text -
>
> - Show quoted text -

I do appreciate all of your help. Thank you for taking the time to help me out.

Here's what my alert.log says:

Tue May 12 13:25:12 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. IMODE=BR
ILAT =18
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.3.0. System parameters with non-default values:

  processes                = 150
  __shared_pool_size       = 218103808
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  spfile                   = C:\ORACLE10G\PRODUCT\10.2.0\DB_3\DBS
\SPFILEORCL.ORA
  sga_target               = 612368384
  control_files            = C:\ORACLE10G\PRODUCT\10.2.0\ORADATA\ORCL
\CONTROL01.CTL, C:\ORACLE10G\PRODUCT\10.2.0\ORADATA\ORCL \CONTROL02.CTL, C:\ORACLE10G\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 377487360
  compatible               = 10.2.0.1.0

  db_file_multiblock_read_count= 16
  db_recovery_file_dest = C:\oracle10g\product\10.2.0/ flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  dispatchers              = (PROTOCOL=TCP) (SERVICE=orclXDB)
  job_queue_processes      = 10
  audit_file_dest          = C:\ORACLE10G\PRODUCT\10.2.0\ADMIN\ORCL
\ADUMP
  background_dump_dest     = C:\ORACLE10G\PRODUCT\10.2.0\ADMIN\ORCL
\BDUMP
  user_dump_dest           = C:\ORACLE10G\PRODUCT\10.2.0\ADMIN\ORCL
\UDUMP
  core_dump_dest           = C:\ORACLE10G\PRODUCT\10.2.0\ADMIN\ORCL
\CDUMP
  db_name                  = orcl
  open_cursors             = 300
  pga_aggregate_target     = 203423744
PMON started with pid=2, OS id=3636
PSP0 started with pid=3, OS id=2496
MMAN started with pid=4, OS id=2380
DBW0 started with pid=5, OS id=6044
LGWR started with pid=6, OS id=536
CKPT started with pid=7, OS id=4828
SMON started with pid=8, OS id=3632
RECO started with pid=9, OS id=4572

CJQ0 started with pid=10, OS id=4552
MMON started with pid=11, OS id=3564
Tue May 12 13:25:13 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES) (PROTOCOL=TCP))'...
Tue May 12 13:25:13 2009
starting up 1 shared server(s) ...
Tue May 12 13:25:13 2009
ALTER DATABASE MOUNT
MMNL started with pid=12, OS id=4624
Tue May 12 13:25:19 2009
Setting recovery target incarnation to 2 Tue May 12 13:25:20 2009
Successful mount of redo thread 1, with mount id 1214417081 Tue May 12 13:25:20 2009
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Tue May 12 13:25:20 2009
ALTER DATABASE OPEN
Tue May 12 13:25:21 2009
Beginning crash recovery of 1 threads
 parallel recovery started with 2 processes Tue May 12 13:25:25 2009
Started redo scan
Tue May 12 13:25:25 2009
Completed redo scan
 1 redo blocks read, 0 data blocks need recovery Tue May 12 13:25:26 2009
Started redo application at
 Thread 1: logseq 13, block 2, scn 826070 Tue May 12 13:25:26 2009
Recovery of Online Redo Log: Thread 1 Group 3 Seq 13 Reading mem 0   Mem# 0: C:\ORACLE10G\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG Tue May 12 13:25:26 2009
Completed redo application
Tue May 12 13:25:26 2009
Completed crash recovery at
 Thread 1: logseq 13, block 3, scn 846072  0 data blocks read, 0 data blocks written, 1 redo blocks read Tue May 12 13:25:31 2009
Thread 1 advanced to log sequence 14
Thread 1 opened at log sequence 14
  Current log# 1 seq# 14 mem# 0: C:\ORACLE10G\PRODUCT\10.2.0\ORADATA \ORCL\REDO01.LOG
Successful open of redo thread 1
Tue May 12 13:25:31 2009
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Tue May 12 13:25:31 2009
SMON: enabling cache recovery
Tue May 12 13:25:32 2009
Errors in file c:\oracle10g\product\10.2.0\admin\orcl\udump \orcl_ora_6200.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option

Tue May 12 13:25:32 2009
Error 704 happened during db open, shutting down database USER: terminating instance due to error 704 Tue May 12 13:25:34 2009
Errors in file c:\oracle10g\product\10.2.0\admin\orcl\bdump \orcl_lgwr_536.trc:
ORA-00704: bootstrap process failure

Tue May 12 13:25:35 2009
Errors in file c:\oracle10g\product\10.2.0\admin\orcl\bdump \orcl_pmon_3636.trc:
ORA-00704: bootstrap process failure

Tue May 12 13:25:35 2009
Errors in file c:\oracle10g\product\10.2.0\admin\orcl\bdump \orcl_mman_2380.trc:
ORA-00704: bootstrap process failure

Tue May 12 13:25:36 2009
Errors in file c:\oracle10g\product\10.2.0\admin\orcl\bdump \orcl_psp0_2496.trc:
ORA-00704: bootstrap process failure

Tue May 12 13:25:36 2009
Errors in file c:\oracle10g\product\10.2.0\admin\orcl\bdump \orcl_reco_4572.trc:
ORA-00704: bootstrap process failure

Tue May 12 13:25:36 2009
Errors in file c:\oracle10g\product\10.2.0\admin\orcl\bdump \orcl_dbw0_6044.trc:
ORA-00704: bootstrap process failure

Tue May 12 13:25:37 2009
Errors in file c:\oracle10g\product\10.2.0\admin\orcl\bdump \orcl_ckpt_4828.trc:
ORA-00704: bootstrap process failure

Instance terminated by USER, pid = 6200
ORA-1092 signalled during: ALTER DATABASE OPEN... Received on Tue May 12 2009 - 12:25:28 CDT

Original text of this message