ORA 12560 Error
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: ORA 12560 Error

  1. #1
    Join Date
    Nov 2001
    Location
    Delhi
    Posts
    31

    Arrow ORA 12560 Error

    Dear Friend,

    Oracle 8.1.7.0 is running on win2000. Suddenly system donw. after restaring I am not able to start my database. I am getting erro ORA 12560. I also set Oracle sid and oracle home but getting same error.

    I also tried to modify SID through Oradim but getting error like

    C:\>ORADIM -EDIT -SID SNG
    DIM-00010: SYSTEM\CurrentControlSet\Services\OracleService key does not exist
    O/S-Error: (OS 2) The system cannot find the file specified.
    DIM-00010: SYSTEM\CurrentControlSet\Services\OracleService key does not exist
    O/S-Error: (OS 2) The system cannot find the file specified.

    I checked services there only one service exist that is SNGlistner.

    Kindly suggest me what should I do.

    Regards,
    Imti
    Imti
    Junior DBA

  2. #2
    Join Date
    Dec 2000
    Location
    Mumbai
    Posts
    38
    Dont get Panic.
    1. Create a new service name with the SID name of the database.
    2. Restart the service
    3. If the database donot starts, then connect as svrmgrl and manually start the database.

  3. #3
    Join Date
    Nov 2001
    Location
    Delhi
    Posts
    31
    Dear shashikumar
    Thanks,
    Pls tell me in detail how to create service.
    Thanks
    Imti
    Junior DBA

  4. #4
    Join Date
    Dec 2000
    Location
    Mumbai
    Posts
    38
    if the sid is DEMO, then

    c:\ oradim -new -sid DEMO

    Then check in the services window, u have to find the service by name oracleserviceDEMO


    Hope u should be able to do this.

  5. #5
    Join Date
    Nov 2001
    Location
    Delhi
    Posts
    31
    Dear Friend
    After creating Services I am still getting same error.

    Imti
    Imti
    Junior DBA

  6. #6
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    On the server try set oracle_sid = yoursid

    then try...

    Also check..
    you network connection
    compare your tnsnames.ora with that of the listener
    use net8 utility to check /test connection to your db.
    if succeeds it's ok if not configure the settigs within the net8 utility.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  7. #7
    Join Date
    Dec 2000
    Location
    Mumbai
    Posts
    38
    Dear Friend,
    Is this is the only one instance running on the server ?
    try setting the this parameter

    c:\set ORACLE-SID=DEMO
    c:\svrmgrl

  8. #8
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by shashikumar
    Dear Friend,
    Is this is the only one instance running on the server ?
    try setting the this parameter

    c:\set ORACLE-SID=DEMO
    c:\svrmgrl
    Its ORACLE_SID not ORACLE-SID
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  9. #9
    Join Date
    Nov 2001
    Location
    Delhi
    Posts
    31
    Dear All,
    I created Services which is working means I am able to start and stop without any error.I also set Oracle_sid, Oracle_home, TNS_admin and tried SVRMGRL
    but still getting same erro means 12560.
    I also edited TNSNAMES.ora file. But I am not able to use svrmgrl due to this error. I am using PORT 1527 (Which SAP supports)and it was working fine.
    Pls suggest me what are remaing areas where can I look. My SAP server is down for 5 days due to this error.

    Regards,
    Kich
    Imti
    Junior DBA

  10. #10
    Join Date
    Dec 2000
    Location
    Mumbai
    Posts
    38
    Is any wondows Terminal Services installed on the server.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width