Re: 10g Database not starting after applying patch

From: oracle, old sherwoodian <rana_gman_at_hotmail.com>
Date: Tue, 12 May 2009 14:15:06 -0700 (PDT)
Message-ID: <398c6280-f4eb-42da-98e1-dfc5878df4c1_at_t11g2000vbc.googlegroups.com>



On May 12, 2:35 pm, joel garry <joel-ga..._at_home.com> wrote:
> On May 12, 8: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.
>
> You may have to change things as part of the instructions.  You might
> be able to fix this with what Terry Dykstra suggested, but I would
> wonder what other things you didn't do.  My advice would be to start
> over and be real careful about following the patch instructions and
> the upgrade manual (unless you've been careful and are quite sure you
> only missed putting it in upgrade mode, and other things that need to
> modified were already big enough.  My own experience on other
> platforms tells me there are other things that can go wrong even if
> you do follow the instructions, so I'm a bit more paranoid).  Also
> check metalink for the things that are known to be wrong.
>
> Seehttp://download.oracle.com/docs/cd/B19306_01/server.102/b14238/upgrad...
>
> jg
> --
> _at_home.com is bogus.http://voices.washingtonpost.com/securityfix/2009/05/hackers_break_in...

thank you for taking the time to help me out. I took similar steps to get my instance back up. The site that helped me was: 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:15:06 CDT

Original text of this message