ORA 12560 - TNS - Protocal Adapter Error

[OracleDBA]

Hi Everyone,

Can someone please tell me what does this error means? and how to fix it :

"ORA 12560 - TNS - Protocal Adapter Error"

I recently installed "Oracle 8i Enterprise Edition" on my laptop, I am using Window 2000. I decided to do a "Custom" installation since I also want the "Enterprise Manager" and "DBA Studio", the intallation went fine without any glitch. After the installation, I tried to log in SQL Plus using the default "UserName/Password" of "System/Manager" and got the above message. "Sys" and "Internal" yield the same error. Am I missing something? How do I fix this error? TIA

 

[eewagner]

It usually means something is not set up properly in your tnsnames.ora file which is used to keep information about the database you are connecting to.

Entries in this file typically look like:

STATS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 208.18.152.62)(PORT = 1521))
)
(CONNECT_DATA =
(SID = stats)
)
)


Have you set up your tnsnames.ora file yet? On NT it is in the /orant/network/admin directory.

If you installed everything, there should be a NET8 Configuration Assistant or something like that that you can use to make the necessary entries in this file.

Eric Wagner

 

[nettyman]

Did you elect to create a database upon completion of the Oracle installation? If not, then there is nothing to connect to yet. To find out, goto control panel and click services. Scroll down till you see services related to oracle. See if you have a service called OracleORAHOME81TNSListener. Check if there is something called OracleServiceORCL. See if these services are started. The TNSListener listens for incoming requests to connect to an instance of oracle. The OracleServiceORCL is a service that supports an instance named ORCL. THis may be named differently depending on whether you made changes. IF it doesn't exist then you did not create a database.

 

[bookouri]

Ive had several problems connecting lately. On several clients Ive gotten the tnsrotocol adapter error even though the tnsnames file is set up correctly. I can tnsping the database, but when trying to connect in sqlplus, or with odbc connections I get tns errors and no connection. The problems seem to occur mostly when the client is attempting to connect with a 9i database, or if using the 9i client trying to connect to an 8.0, or 8i database. If I can tnsping, but sqlplus wont connect... where do I look next?

thanks for any suggestions

 

[Turkbear]

Hi,
Look to be sure the correct tnsnames.ora file is being used, if there is more than one. If tnsping works and sqlplus does not, it must be using a different tnsnames.ora file or there is an error in the syntax of the file used that does not affect tnsping..AFAIK,Tnsping only checks for the existance of a listener and the address specified in the tnsnames.ora file but it does not check for a valid sid or service_name.

 

[DaveNeubauer]

I have an application that uses Oracle in the back-end, but I am not in any way an Oracle DBA. That said, here's my problem:

Someone who was helping me perform a domain change on a number of servers decided to also convert the application server of note. The subsequent message in the Windows 2000 event log is:

Source: Service Control Manager
The OracleOra81TNSListener failed to start due to the following error: Access is denied.

Similarly, when I attempt to start the service, I get the message "Could not start the OracleOra81TNSListener service on Local Computer. Error 5: Access is denied."

I have gone over shares, permissions, and services but cannot resolve this error.

Here's a copy of my listener.ora file:

# LISTENER.ORA Network Configuration File: D:\Oracle\Ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bsfw2k1)(PORT = 1521))
)
)
)

####################################
# Filename......: listener.ora
####################################



I'm quite certain that this error is the result of the domain changing out from under Oracle.

Does anyone have suggestions? TIA, Dave N.

 

[SantaMufasa]

All,

Typically, when this problem occurs, it results from having an incorrect/undefined ORACLE_HOME system variable. Please confirm that your ORACLE_HOME system variable has a value and that it points to your current ORACLE_HOME on the machine from which you are trying to connect.

Looking forward to seeing your results,

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 00:11 (25Jan05) UTC (aka "GMT" and "Zulu"),
@ 17:11 (24Jan05) Mountain Time

Click here to Donate to Tsunami Relief. 100% of your contributions here go to the victims...0% to administration.
They were "The First-Responder" to the disaster, with relief deliveries arriving before Red Cross and U.S. aid.