Re: 10g Database not starting after applying patch

On May 12, 1:38 pm, "Terry Dykstra" <tddyks...@xxxxxxxxxxxx> wrote:
"oracle, old sherwoodian" <rana_g...@xxxxxxxxxxx> wrote in messagenews:6c6e6961-c026-4bb4-bb22-d13c92a119a8@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On May 12, 12:43 pm, johnbhur...@xxxxxxxxxxxxx wrote:





On May 12, 11:28 am, "oracle, old sherwoodian" <rana_g...@xxxxxxxxxxx>
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.

Why would anyone be applying the 10.2.0.3 patchset when 10.2.0.4 has
been available for so long?

10.2.0.5 is supposed to be "out soon" ...

Let me guess you are running oracle on windows and don't have a static
ip address or you haven't configured the loopback adaptor or your
listener is not running?
The reason for applying the 10.2.0.3 patch was to coincide w/ our
client's database.
The IP is static and the listner and the service is running (thats
what the Service Manager is displaying). The instance is not starting
up.

Here's your hint from the alert.log:

ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option

You can use the Database Upgrade Assistant to handle this for you. (look
under oracle 10g , configuration and migration tools )
--
Terry Dykstra- Hide quoted text -

- Show quoted text -

Thank you for taking the time to reply to my post. I found a link that
explained what i needed to do:
http://oldlight.wordpress.com/2008/12/17/ora-39700-in-alert-log-when-recover-from-a-full-backup/
.

Relevant Pages

  • Idiomatic Expressions to Operating System Architecture: Transforming Rigids
    ... <Subject: Re: Idiomatic Expressions to Operating ... <endpoint during a single session * DATABASE + by ... <statements is a new feature of SQL Server 2005. ...
    (sci.math)
  • Config for OLTP system
    ... extrenal disks fo the 60GByte database server. ... IBM Informix Dynamic Server Configuration Parameters ... # BUFFSIZE - OnLine no longer supports this configuration parameter. ...
    (comp.databases.informix)
  • Re: Web.Config AppSettings & Caching
    ... Terry Burns ... often does the application have to check the "DataSet configuration ... The only difference here between your database solution and your ... unless its an app that already uses a database. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Web.Config AppSettings & Caching
    ... IO have to be employed to read and deserialize the "DataSet configuration ... The only difference here between your database solution and your "DataSet ... .Net Developer ... unless its an app that already uses a database. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Vista, CreateFile and Shadow Copy
    ... I have an applicaiton that works fine on Windows XP, ... to do with the shadow copy fieature of Vista. ... I have an application that runs as a service and uses a sqlite database ... certain configuration parameters. ...
    (microsoft.public.vc.language)