Re: 10g Database not starting after applying patch

From: oracle, old sherwoodian <rana_gman_at_hotmail.com>
Date: Tue, 12 May 2009 09:14:22 -0700 (PDT)
Message-ID: <ddcb8886-0928-4628-a02c-32c6aa56b890_at_t10g2000vbg.googlegroups.com>



On May 12, 11:45 am, gar..._at_jamms.org wrote:
> On 12 May, 16:28, "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.
>
> What O/S?  What happens if you try a bequeath connection?
>
> i.e.  Assuming UNIX:
>
> $ set ORACLE_SID=<database sid>
> $ sqlplus / as sysdba;
>
> SQL>  startup;
>
> I suspect that the listener doesn't know the status of the database
> as, presumably, it's down.
>
> HTH
>
> -g

The OS is XP Received on Tue May 12 2009 - 11:14:22 CDT

Original text of this message