Re: 10g Database not starting after applying patch

From: ddf <oratune_at_msn.com>
Date: Tue, 12 May 2009 09:51:58 -0700 (PDT)
Message-ID: <20d36617-3e21-4137-8a6f-81b0435fd071_at_g19g2000vbi.googlegroups.com>



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 Received on Tue May 12 2009 - 11:51:58 CDT

Original text of this message