| ora-12500 and ora-12560 [message #66167] |
Mon, 07 January 2002 10:55  |
George
Messages: 68
Registered: April 2001
|
Member |
|
|
Hi,
Please help me to fix these problems:
I get a ora-12560 from svrmgrl (on win2k) and ora-12500 from
sqlplus, the OTN suggests to check if executables are there,
could you tell me which executables are related to these
problems? and how to check that correct Protocol Adapter are
successfully linked?
Thanks
|
|
|
|
|
|
| Re: ora-12500 and ora-12560 [message #66173 is a reply to message #66167] |
Tue, 08 January 2002 02:23  |
Farid
Messages: 5
Registered: January 2002
|
Junior Member |
|
|
Edit the registry and navigate to HEY_LOCAL_MACHINE. Continue to open
folders SOFTWARE/ORACLE and verify parameter LOCAL= is present. Note the
entry for LOCAL= value and remove it (make it blank). You may have to reboot the server after
altering the registry.
If the above does not help then go through the following steps:
If the drive is NTFS then check the permissions on the drive or oracle home to be sure SYSTEM has full control on all subdirectories and files.
Be sure the instance is started Goto
Start-->Settings-->Control Panel-->Services
and check if the database service is started.
Be sure the ORACLE_SID is set in the registry correctly. Goto
Start button-->RUN-->type regedt32-->
Goto the following directory tree within the registry -
HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE -
highlight ORACLE - look on the left side look for ORACLE_SID = <sid>
To change you can highlight ORACLE_SID - right click on your mouse and
select modify.
Enter the SID.
The above is only valid when using DEFAULT_HOME, when you have another
home then you need to highlight that HOME under ORACLE key
usually HOME1-HOMEx
No spaces can be entered after the = when setting ORACLE_SID at the DOS Prompt, set oracle_sid=xyz should be used and not set oracle_sid = xyz.
If you have verified that ORACLE_SID is properly set, and the service is running, yet you still get an ORA-12560, then it is possible that you
have created an instance with a non-alphanumeric character.
The Getting Started Guide for Oracle8i on Windows NT documents that SID names can contain only alphanumerics, however if you attempt to create a SID with an underscore or a dash on Oracle8i you are not prevented from doing so. The service will be created and started successfully, but attempts to connect will fail with an ORA-12560.
If doing the above and the error still occurs on a new instance creation then the createdb scripts did not run correctly.
|
|
|
|
| Re: ora-12500 and ora-12560 [message #66286 is a reply to message #66167] |
Wed, 06 March 2002 05:02 |
Eric
Messages: 78
Registered: April 1999
|
Member |
|
|
|
For what its worth, I get the ora-12500 when my tnslistener is up and running, but the underlying database isn't. The fix in my case was to stop the listener, start the database, restart the listener.
|
|
|
|
|
|
|
|
| Re: ora-12500 and ora-12560 [message #66316 is a reply to message #66167] |
Tue, 26 March 2002 12:49 |
Will
Messages: 32
Registered: January 2000
|
Member |
|
|
|
If your running Win NT/2000 and have verified that the SID_LIST section of the LISTENER.ORA file and the system identifier (SID) in the CONNECT DATA section of the TNSNAMES.ORA file are correct, and still getting the error. Then go with Eric's solution. Stop the listner start the databse and restart the listener. It works for me everytime.
|
|
|
|
|
|
| Re: ora-12500 and ora-12560 [message #66536 is a reply to message #66167] |
Thu, 25 July 2002 11:25 |
kONDA REDDY
Messages: 4
Registered: April 2002
|
Junior Member |
|
|
Hi all,
ORALCE 8 DATABASE ON SCO UNIXWARE 7.0
Size of the database is 4 GB.
3 LOG Groups each having one member of 0.5MB Size.
I have serious problem with Redolog space requests.
It should be zero(0) as per oracle suggestion.
If i query from v$sysstat it showing the value 225
What should i do now??
would be thankful to u all for reply.
regards,
konda reddy.
|
|
|
|
| Re: ora-1250 and ora-12560 [message #67196 is a reply to message #66168] |
Tue, 03 February 2004 15:43 |
eilison
Messages: 22
Registered: August 2003
|
Junior Member |
|
|
My environment:
=================================
Red Hat Linux release 7.3
Kernel 2.4.18-3 on an i686
Oracle8i Enterprise Edition Release 8.1.7.0.1
=================================
The same error kept popping up to me when I connect to db in sqlplus like scott/tiger@orcl untill I modified another tnsname.ora at
$ORACLE_HOME/config/
Good luck!
eilison
eilisonl@yahoo.com
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
