Re: 10g Database not starting after applying patch
From: oracle, old sherwoodian <rana_gman_at_hotmail.com>
Date: Tue, 12 May 2009 14:12:42 -0700 (PDT)
Message-ID: <c6d1fc66-eef0-477d-9503-77ebb412b4ff_at_o30g2000vbc.googlegroups.com>
On May 12, 1:38 pm, "Terry Dykstra" <tddyks..._at_forestoil.ca> wrote:
> "oracle, old sherwoodian" <rana_g..._at_hotmail.com> wrote in messagenews:6c6e6961-c026-4bb4-bb22-d13c92a119a8_at_s28g2000vbp.googlegroups.com...
> On May 12, 12:43 pm, johnbhur..._at_sbcglobal.net wrote:
>
>
>
>
>
> > On May 12, 11:28 am, "oracle, old sherwoodian" <rana_g..._at_hotmail.com>
> > wrote:
>
> > > Hello,
>
> > > I initially installed 10.2.0.1.0 version of the database and then
> > > applied the 10.2.0.3.0 patch successfully.
> > > Now i cannot get the database started. I get this error:
> > > ORA-12505: TNS:listener does not currently know of SID given in
> > > connect descriptor (DBD ERROR: OCIServerAttach)
>
> > > I've not changed anything. If fact, i made a copy of the listner.ora
> > > and tnsname.ora file and they both are identical.
> > > Please help.
>
> > > Girish.
>
> > Why would anyone be applying the 10.2.0.3 patchset when 10.2.0.4 has
> > been available for so long?
>
> > 10.2.0.5 is supposed to be "out soon" ...
>
> > Let me guess you are running oracle on windows and don't have a static
> > ip address or you haven't configured the loopback adaptor or your
> > listener is not running?
> >The reason for applying the 10.2.0.3 patch was to coincide w/ our
> >client's database.
> >The IP is static and the listner and the service is running (thats
> >what the Service Manager is displaying). The instance is not starting
> >up.
>
> Here's your hint from the alert.log:
>
> ORA-00704: bootstrap process failure
> ORA-39700: database must be opened with UPGRADE option
>
> You can use the Database Upgrade Assistant to handle this for you. (look
> under oracle 10g , configuration and migration tools )
> --
> Terry Dykstra- Hide quoted text -
>
> - Show quoted text -
Date: Tue, 12 May 2009 14:12:42 -0700 (PDT)
Message-ID: <c6d1fc66-eef0-477d-9503-77ebb412b4ff_at_o30g2000vbc.googlegroups.com>
On May 12, 1:38 pm, "Terry Dykstra" <tddyks..._at_forestoil.ca> wrote:
> "oracle, old sherwoodian" <rana_g..._at_hotmail.com> wrote in messagenews:6c6e6961-c026-4bb4-bb22-d13c92a119a8_at_s28g2000vbp.googlegroups.com...
> On May 12, 12:43 pm, johnbhur..._at_sbcglobal.net wrote:
>
>
>
>
>
> > On May 12, 11:28 am, "oracle, old sherwoodian" <rana_g..._at_hotmail.com>
> > wrote:
>
> > > Hello,
>
> > > I initially installed 10.2.0.1.0 version of the database and then
> > > applied the 10.2.0.3.0 patch successfully.
> > > Now i cannot get the database started. I get this error:
> > > ORA-12505: TNS:listener does not currently know of SID given in
> > > connect descriptor (DBD ERROR: OCIServerAttach)
>
> > > I've not changed anything. If fact, i made a copy of the listner.ora
> > > and tnsname.ora file and they both are identical.
> > > Please help.
>
> > > Girish.
>
> > Why would anyone be applying the 10.2.0.3 patchset when 10.2.0.4 has
> > been available for so long?
>
> > 10.2.0.5 is supposed to be "out soon" ...
>
> > Let me guess you are running oracle on windows and don't have a static
> > ip address or you haven't configured the loopback adaptor or your
> > listener is not running?
> >The reason for applying the 10.2.0.3 patch was to coincide w/ our
> >client's database.
> >The IP is static and the listner and the service is running (thats
> >what the Service Manager is displaying). The instance is not starting
> >up.
>
> Here's your hint from the alert.log:
>
> ORA-00704: bootstrap process failure
> ORA-39700: database must be opened with UPGRADE option
>
> You can use the Database Upgrade Assistant to handle this for you. (look
> under oracle 10g , configuration and migration tools )
> --
> Terry Dykstra- Hide quoted text -
>
> - Show quoted text -
Thank you for taking the time to reply to my post. I found a link that
explained what i needed to do:
http://oldlight.wordpress.com/2008/12/17/ora-39700-in-alert-log-when-recover-from-a-full-backup/
Received on Tue May 12 2009 - 16:12:42 CDT