Re: 10g Database not starting after applying patch
From: oracle, old sherwoodian <rana_gman_at_hotmail.com>
Date: Tue, 12 May 2009 09:40:16 -0700 (PDT)
Message-ID: <0e07b188-f875-4370-9ef7-40024ffb4fa4_at_j12g2000vbl.googlegroups.com>
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
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
Date: Tue, 12 May 2009 09:40:16 -0700 (PDT)
Message-ID: <0e07b188-f875-4370-9ef7-40024ffb4fa4_at_j12g2000vbl.googlegroups.com>
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
Received on Tue May 12 2009 - 11:40:16 CDT