-
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
-
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.
-
Dear shashikumar
Thanks,
Pls tell me in detail how to create service.
Thanks
Imti
Junior DBA
-
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.
-
Dear Friend
After creating Services I am still getting same error.
Imti
Imti
Junior DBA
-
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)
--- Everything was meant to be---
-
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
-
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."
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|