Re: 10g Database not starting after applying patch

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

"oracle, old sherwoodian" <> wrote in message On May 12, 12:43 pm, wrote:
> On May 12, 11:28 am, "oracle, old sherwoodian" <>
> wrote:
> > Hello,
> > I initially installed version of the database and then
> > applied the 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 patchset when has
> been available for so long?
> 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 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

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