Re: 10g Database not starting after applying patch



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.
.



Relevant Pages

  • Re: Develop Database on Local machine?? MSDE
    ... >>service manager does not appear. ... > if you set up MSDE without enabling network protocols, ... > the Dev edition of SQL Server comes only in VS.Net enterprise package... ... when i create a database i get a suspect next ...
    (microsoft.public.sqlserver.msde)
  • Re: 10g Database not starting after applying patch
    ... Now i cannot get the database started. ... what the Service Manager is displaying). ... You can use the Database Upgrade Assistant to handle this for you. ... under oracle 10g, configuration and migration tools) ...
    (comp.databases.oracle.server)
  • Re: 10g Database not starting after applying patch
    ... Now i cannot get the database started. ... what the Service Manager is displaying). ... You can use the Database Upgrade Assistant to handle this for you. ... under oracle 10g, configuration and migration tools) ...
    (comp.databases.oracle.server)
  • SQL server service manager
    ... the service manager tray icon does not detect my ... How do I get the service manager to recognise my database ...
    (microsoft.public.sqlserver.msde)
  • SourceForge.net Sitewide Update: Jan 26th, 2005 (fwd)
    ... I just returned from an enjoyable Open Source conference in Hawaii ... open sourced the database under the name Derby. ... The CVS client SF.net staff recommend for MS Windows users is ... priority technical support. ...
    (comp.os.linux.announce)