ORA-12560 TNS protocol adaptor error

Question

I Google d  for this error ORA-12560  TNS protocol adaptor error but not able to find the actual reason and how to solve this error    Can anyone tell me a perfect solution to solve login problem

User · Answer

After searching alot got a simple way to solve it. Just follow the steps.

Check status of your listener.
1. open command prompt and type lsnrctl status
2. You will get no listener.
Now open listener.ora file which is present in following directory: C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN
1. Open that file and change the host parameter with you computer name
2. You can get your computer name by right click on My Computer and check you computer name, and replace host parameter with your 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.
3. Save the listener.ora file and again return to cammand propt
3.Type the following in command prompt lsnrctl start

This will start the OracleTNSListner.

you can check it in the service by opening services tab of Task Manager. if not started automatically you can start it.

Just this much and you are ready to work again on oracle.

Best of Luck.

User · Answer

Seems like database is not up  It might be due to restarting machine and the instance is not set to autostart and it so not started munually after starting from services Screen   Just goto Command prompt   Set Oracle SID C  set oracle sid ORCL Now run Net start command  C  net start oracleserviceORCL

User · Answer

I try 2 option   You change service OracleService in Service Tab - gt  Running Login with cmd command  sqlplus user name pass word orcl12C Note  orcle12c - gt  name of OracleService name run in you laptop

User · Answer

In my case   ORA-12560  TNS protocol adapter error Issue cause of database connection issue like database  user name and password   Once you got the issue  Initially you have to check connection details  after check the oracle service and further more   I missed some connection details  So only i got TNS protocol adapter error   I will changed the connection details  It would be working fine

User · Answer

You need to tell SQLPlus which database you want to log on to   Host String needs to be either a connection string or an alias configured in your TNSNames ora file

User · Answer

Add to the enviroment vars the following varibale and value to identify the place of the tnsnames ora file   TNS ADMIN  C  oracle product 10 2 0 client 1 network admin

User · Answer

from command console  if you get this error you can avoid it by typing c   gt  sqlplus  nolog  then you can connect SQL gt  conn user pass  host port service

User · Answer

If none the above work  then try this   Modify the LISTENER ora  mine is found in   oracle product 11 2 0 dbhome 1 NETWORK ADMIN listener ora      add a custom listener that points to your database SID   example my SID is XZ0301  so       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 machine  For Windows 7  use the following to modify the LISTENER ora   - Go to Start   All Programs   Accessories  - Right click Notepad and then click Run as Administrator    - File open and navigate to the tnsnames ora file   - Make the changes then it should allow you to save

User · Answer

In my case  for OracleExpress  the service was running  but I got this issue when trying to access the database via sqlplus without connection identifier   sqlplus sys mypassword as sysdba     To make it work I needed to add the connection identifier  XE for Oracle Express   so following command worked ok   sqlplus sys mypassword XE as sysdba   If you still get ORA-12560  make sure you can ping the XE service  Use   tnsping XE   And you should get OK message along with full connection string  tnsping command is located in oracle s installation dir   oracle express installation dir  app oracle product 11 2 0 server bin   If you can not ping make sure your tnsnames ora file is reachable for sqlplus  You might need to set 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

User · Answer

It really has worked on my machine  But instead of OracleServiceORCL I found OracleServiceXE

User · Answer

Flow the flowing steps     Edit your listener ora and tnsnames ora file in   Oracle home product 11 2 0 client 1 NETWORK ADMIN location  a  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 oralce home directory   b  add in tnsnames ora file      SCHEMADEV                DESCRIPTION                         ADDRESS LIST                         ADDRESS    PROTOCOL   TCP  HOST   dabase ip  PORT   1521              CONNECT DATA          SERVICE NAME   SCHEMADEV               Open command prompt and type  sqlplus username passowrd oracle connection alias   Example   username   your database username           password   Your database password           oracle connection alias   SCHEMADEV  for above example

User · Answer

In my case I didn t have an OracleService  OracleServiceORCL  in Windows Services msc as described in Bharathi s answer   I executed this command   C   gt  ORADIM -NEW -SID ORCL   and then the OracleService called OracleServiceORCL just showed up and got started in Services msc  Really nice     Source  https   forums oracle com forums message jspa messageID 4044655 4044655

User · Answer

I have solved the problem the easy way  My oracle was running just fine in the past  After I installed MS SQL Server was when I noticed this problem  I just uninstalled MS SQL Server on my machine then the problem was gone  Make sure you restart your computer after that  Now I can connect to Oracle database through SQLPlus again  My guess is that there s some conflict between the two  Hope this helps

User · Answer

Quite often this means that the listener hasn t started   Check the Services panel      On Windows  as you are  another common cause is that the ORACLE SID is not defined in the registry   Either edit the registry or set the ORACLE SID in a CMD box    Because you want to run sqlplusw exe I suggest you edit the registry

User · Answer

Go to the windows machine that hosts the Oracle database server  Go to Start -  Run -  Services msc in Windows  Locate OracleService  lt  SID    here OracleServiceORCL  and click on Start to start the oracle database service  if not already running   Once it is up and running  from the command prompt run the following    tnsping  lt  tnsalias  gt      tnsalias entry you can find it in tnsnames ora file

User · Answer

Just to add up  follow the screenshot and choose local account to start if not selected  Then start the service

User · Answer

ORA-12560  TNS erro de adaptador de protocolo   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 is  SQLNET AUTHENTICATION SERVICES    NTS   Windows  Be carefull when you add a new Oracle client  adding a new path to the PATH env  variable can mess things up  The first entry in this variable makes a difference  certify that the sqlplus executable in the ORACLE HOME  ORACLE HOME bin  comes first in the PATH env  variable

User · Answer

I had  ORA-12560  TNS protocol adaptor error  problem  and I googled it for 2 hours for not paying attention to details  I opened command prompt and then I had this   C  Users Frodo gt set oracle sid  lt DB name gt        while it should be lie this   C   gt set oracle sid  lt DB name gt    C   should be instead of C  Users Frodo  - that was my problem  so this worked   C  Users Frodo gt  cd c  C   gt set oracle sid  lt DB name gt  C   gt exp

User · Answer

Another possible solution that just worked for me   considering I was using my local login as the dba permissions     Follow the steps to get to Services   Right click on the instance and go to  Log On    might not be the name but it s one of the tabs containing permissions    Change the settings to use LOCAL

[sql] ORA-12560: TNS:protocol adaptor error

Examples related to sql

Examples related to oracle

Examples related to oracle9i

Examples related to ora-12560