Re: 10g Database not starting after applying patch

From: <gareth_at_jamms.org>
Date: Tue, 12 May 2009 08:45:16 -0700 (PDT)
Message-ID: <623be5a4-9919-4ca5-864a-a605c5be9887_at_b1g2000vbc.googlegroups.com>

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 Received on Tue May 12 2009 - 10:45:16 CDT