Re: 10g Database not starting after applying patch
Date: Tue, 12 May 2009 11:35:59 -0700 (PDT)
Message-ID: <950cda90-a4f9-4e56-854a-9372e8a16dfc_at_d7g2000prl.googlegroups.com>
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.
See http://download.oracle.com/docs/cd/B19306_01/server.102/b14238/upgrade.htm#CACGGHJC
jg
-- _at_home.com is bogus. http://voices.washingtonpost.com/securityfix/2009/05/hackers_break_into_virginia_he.htmlReceived on Tue May 12 2009 - 13:35:59 CDT