Re: 10g Database not starting after applying patch

From: Terry Dykstra <tddykstra_at_forestoil.ca>
Date: Tue, 12 May 2009 17:38:40 GMT
Message-ID: <AuiOl.26600$Db2.19621_at_edtnps83>



"oracle, old sherwoodian" <rana_gman_at_hotmail.com> wrote in message news: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 
Received on Tue May 12 2009 - 12:38:40 CDT

Original text of this message