Re: 10g Database not starting after applying patch
From: oracle, old sherwoodian <rana_gman_at_hotmail.com>
Date: Tue, 12 May 2009 09:56:38 -0700 (PDT)
Message-ID: <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?
Date: Tue, 12 May 2009 09:56:38 -0700 (PDT)
Message-ID: <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.
Received on Tue May 12 2009 - 11:56:38 CDT