Oracle 8i ORA-12560

[Eric Workman]

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

[Jon Mattatall]

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

[Wodisch]

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]

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]

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]

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

[Faris Hussain]

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.