Re: 10g Database not starting after applying patch

From: joel garry <>
Date: Tue, 12 May 2009 11:35:59 -0700 (PDT)
Message-ID: <>

On May 12, 8: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.

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.



-- is bogus.
Received on Tue May 12 2009 - 13:35:59 CDT

Original text of this message