Re: 10g Database not starting after applying patch
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