ORA-12560: TNS: protocol adapter error

Question

I Google [d] for this error ORA-12560: TNS: protocol adapter error , but cannot find the actual cause and how to solve this error?

Can someone tell me the perfect solution to solve the login problem.

Answer 1

• Navigate to the Windows machine hosting the Oracle database server.
• Go to Start → Run → .msc Services in the windows. Find OracleService (here OracleServiceORCL) and click "Start" to start the oracle database service (if it is not already running).

• After starting and starting from the command line, do the following:

  tnsping <tnsalias>

(you can find the tnsalias entry in the tnsnames.ora file)

Answer 2

The database seems to be down. Perhaps this is due to a reboot of the machine, and the instance is not configured to autorun, and therefore it does not start manually after starting from the services screen.

Just go to the command line

• Install Oracle SID C:> set oracle_sid = ORCL

• Now run the Net start command. C:> net start oracleserviceORCL

Answer 3

In my case, I did not have OracleService (OracleServiceORCL) in Windows Services.msc as described in Bharati's answer .

I ran this command:

 C:\> ORADIM -NEW -SID ORCL 

and then OracleService , called OracleServiceORCL, just appeared and started in Services.msc. Really nice.

---

Source: https://forums.oracle.com/forums/message.jspa?messageID=4044655#4044655

Answer 4

Add the following variable and value to the vars environment to determine the location of the tnsnames.ora file:

TNS_ADMIN

C: \ oracle \ product \ 10.2.0 \ client_1 \ network \ admin

Answer 5

Quite often, this means that the listener did not start. Check the Services panel.

On Windows (like you), another common reason is that ORACLE_SID is not defined in the registry. Either edit the registry or set ORACLE_SID in the CMD field. (Since you want to run sqlplusw.exe, I suggest you edit the registry.)

Answer 6

from the command console, if you get this error, you can avoid it by typing sqlplus / nolog

then you can connect conn user / pass @host: port / service

Answer 7

I solved the problem in a simple way. In the past, my oracle worked just fine. After installing MS SQL Server, I noticed this problem. I just uninstalled MS SQL Server on my machine, then the problem disappeared. After that, restart the computer. Now I can reconnect to the Oracle database through SQLPlus. I assume that there is a conflict between them. Hope this helps.

Answer 8

After searching, he has an easy way to solve it. Just follow these steps.

• Check the status of your listener.
  • open a command prompt and enter lsnrctl status
  • You will not get a listener.

• Now open the listener.ora file, which is present in the following directory: C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN

  • Open this file and change the host parameter with the computer name

  • You can get the name of your computer by right-clicking on My Computer and checking the computer name and replacing the host parameter with the computer name as follows:

    LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = Electron-PC)(PORT = 1521) ) ) )

    So, here you can observe HOST = Electron-PC , which is my computer name.

  • Save the listener.ora file and return to cammand support again

  3. At the command prompt, type the following lsnrctl start

This will launch OracleTNSListner .

you can check it in the service by opening the task manager services tab. if it does not start automatically, you can start it.

There are just so many, and you are ready to work on the oracle again.

The best happiness.

Answer 9

If this does not work, try the following: Change LISTENER.ora (mine found in: oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora ) ==> add a custom listener that points to your database (SID ), for example, my SID is XZ0301, therefore:

 ## Base XZ03001 SID_LIST_LISTENER_XZ03001=(SID_LIST=(SID_DESC=(ORACLE_HOME = E:\oracle\product\11.2.0\dbhome_1)(SID_NAME= XZ03001))) LISTENER_XZ03001=(DESCRIPTION_LIST=(ADDRESS=(PROTOCOL = TCP)(HOST=MyComputerName)(PORT= 1521))) DIAG_ADR_ENABLED_LISTENER_XZ03001=ON ADR_BASE_LISTENER_XZ03001=E:\oracle 

Restart your computer

For Windows 7, to modify LISTENER.ora, follow these steps: - Go to the Start menu> All Programs> Accessories - Right-click Notepad and select Run as Administrator. - File> open and go to the tnsnames.ora file. - Make changes, after which it will allow you to save

Answer 10

Another possible solution that just worked for me ... given that I used my local login as dba permissions.

Follow the instructions to get to the Services. Right-click on the instance and go to the "Login" section? (perhaps this is not a name, but one of the tabs containing permissions). Change the settings to use LOCAL.

Answer 11

You need to tell SQLPlus which database you want to log in to. The host string must be either a connection string or an alias configured in your TNSNames.ora file.

Answer 12

It really worked on my car. But instead of OracleServiceORCL, I found OracleServiceXE.

Answer 13

In my case ( ORA-12560: TNS protocol adapter error ) Problem Cause of a problem connecting to the database, for example, the database, username and password.

As soon as you have a problem. Initially, you need to check the connection information after checking the oracle service and beyond.

I missed some connection details, so only I got a TNS protocol adapter error , I changed the connection details, it will work fine .

Answer 14

In my case (for OracleExpress) the service was running, but I got this problem when trying to access the database via sqlplus without a connection identifier:

 sqlplus sys/mypassword as sysdba 

To make it work, I needed to add a connection identifier (XE for Oracle Express), so the following command worked fine:

 sqlplus sys/mypassword@XE as sysdba 

If you are still getting the ORA-12560, make sure you can execute the XE command. Using:

 tnsping XE 

And you should get an OK message along with the full connection string (the tnsping command is in the oracle installation directory: [oracle express install dir] \ app \ oracle \ product \ 11.2.0 \ server \ bin). If you cannot ping, make sure your tnsnames.ora file is available for sqlplus. You may need to set the TNS_ADMIN environment variable pointing to your ADMIN directory where the file is located, for example:

 TNS_ADMIN=[oracle express installation dir]\app\oracle\product\11.2.0\server\network\ADMIN 

Answer 15

Flow of current steps:

• Change listener.ora and tnsnames.ora in $ Oracle_home \ product \ 11.2.0 \ client_1 \ NETWORK \ ADMIN location

  but. add listener.ora file

   LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) 

  )

ADR_BASE_LISTENER = C: [here c is the home directory of the orgs]

b. add tnsnames.ora file

  SCHEMADEV = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dabase_ip)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = SCHEMADEV) ) ) 

2. Open a command prompt and enter
   Sqlplus / passowrd username @oracle_connection_alias

Example:
username: your_database_username
password: Your_database_password
oracle_connection_alias: SCHEMADEV for the above example.

Answer 16

ORA-12560: TNS: Protocol Security Protocol

• set environment variables: ORACLE_BASE, ORACLE_HOME, ORACLE_SID
• make sure your user is part of ORACLE_GROUP_NAME (Windows)
• make sure the file ORACLE_HOME / network / admin / sqlnet.ora: SQLNET.AUTHENTICATION_SERVICES = (NTS)
• (Windows) Be careful when adding a new Oracle client: adding a new path to PATH env. a variable can ruin things. The first entry in this variable makes a difference: make sure that the sqlplus executable in ORACLE_HOME (ORACLE_HOME / bin) first goes into PATH env. variable.