Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 8i ORA-12560

Eric Workman
Occasional Visitor

Oracle 8i ORA-12560

Hi-

I am trying to export an Oracle 8i database via the command line on Windows 2000 Server. Whenever I try to connect I get the error.

ORA-12560 TNS Protocol Adapter Error

Any help would be greatly appreciated.

Thanks,

Eric Workman
6 REPLIES
Jon Mattatall
Esteemed Contributor

Re: Oracle 8i ORA-12560

Hi there...

Oracle is not my strong suit (I install it, the DBA's configure) but here are a few links
with common causes for the error.

This one indicates that 8.1.6 and W2K has a known problem if you connect using svrmgrl..

http://www.oracle-error.com/ora-12560.htm

These suggest using "oradim" to recreate the service..

http://www.orafaq.com/msgboard/windows/messages/480.htm

http://www.cryer.co.uk/brian/oracle/ORA12560.htm

Me, I'd check all the SID's first, then try SQLPlus, but as I say the DBA's here deal with
the exotic Oracle problems.

HTH (a little)

Jon
A little knowledge is dangerous - none is absolutely terrifying!!!
Wodisch
Honored Contributor

Re: Oracle 8i ORA-12560

Hello Eric,

that TNS error is not that important...

Open a DOS box (i.e. CMD.EXE), and set your environment variables:

set ORACLE_HOME=c:\Oracle\Ora81
set ORACLE_SID=DEMO

Use your local values, of course ;-)

Then start "svrmgrl.exe" and try the "connect internal".
If you do have a local password file, you have to know the correct password (or you move it aside, and create a new one with "orapwd.exe", which then contains the password which you pass as command-line parameter).

HTH,
Wodisc
Rita C Workman
Honored Contributor

Re: Oracle 8i ORA-12560

Also double check the entries in your tnsnames.ora file. It is possible a typing error is the problem. Check file for correct IP, correct protocol name and correct SID name reference.

Just a thought,
Rita
Eric Workman
Occasional Visitor

Re: Oracle 8i ORA-12560

Hi-

I have managed to get into the db through svrmgrl, thanks, but when I try to create a database using the database creation wizard I get the same TNS error, do I have to create the database through svrmgrl as well, and if so, what is the best way to do that?


Thanks again,

Eric
Andreas D. Skjervold
Honored Contributor

Re: Oracle 8i ORA-12560

Hi

This is from Metalink as I'm not to familiar with Oracle on Windows:

Starting database via SVRMGRL or SQL*PLUS
Problem:
Launching svrmgr, or attempting a connection in sqlplus to start up the
database, you get an ORA-12560

Solution:
- 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 =
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.

Explanation:
An ORA-12560 using svrmgrl on WinNT is usually an indication that
the OS system/environment is not set up correctly.


--

Andreas
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!
Faris Hussain
Occasional Visitor

Re: Oracle 8i ORA-12560

Hi,
sound like you may need to add your database name to tnsname.
To add:
go to orahome81 --> network administration-->
net8 config assistant.

click on local net service name config. next
-- add next
for service name give you global db name..

MAKE SURE TO CHECK TEST CONNECTION
IF YOU HAVE PROBLEM WITH CONNECTING CHANGE THE LOGING INFO.. AND TEST IT.


DBA