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.
asked Aug 1, 2011 at 5:39
Vishwanath DalviVishwanath Dalvi
34.8k41 gold badges122 silver badges153 bronze badges
- Go to the windows machine that hosts the Oracle database server
-
Go to Start -> Run -> Services.msc in Windows.
Locate OracleService < SID > (hereOracleServiceORCL) and click onStartto start the oracle database service (if not already running)
-
Once it is up and running, from the command prompt run the following:
tnsping < tnsalias >(tnsalias entry you can find it in
tnsnames.orafile)
answered Aug 1, 2011 at 21:06
BharathiBharathi
1,5332 gold badges10 silver badges13 bronze badges
6
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
answered Dec 6, 2012 at 6:32
Yasir AhmedYasir Ahmed
2993 silver badges2 bronze badges
2
from command console, if you get this error you can avoid it by typing
c:> sqlplus /nolog
then you can connect
SQL> conn user/pass @host:port/service
maruf
5593 gold badges6 silver badges22 bronze badges
answered Feb 26, 2016 at 17:27
demiandemian
5926 silver badges14 bronze badges
Add to the enviroment vars the following varibale and value to identify the place of the tnsnames.ora file:
TNS_ADMIN
C:oracleproduct10.2.0client_1networkadmin
answered May 14, 2013 at 14:33
1
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]apporacleproduct11.2.0serverbin). 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]apporacleproduct11.2.0servernetworkADMIN
answered Mar 14, 2017 at 14:09
walkeroswalkeros
4,5804 gold badges34 silver badges46 bronze badges
After searching alot got a simple way to solve it.
Just follow the steps.
- Check status of your listener.
- open command prompt and type
lsnrctl status - You will get no listener.
- open command prompt and type
-
Now open
listener.orafile which is present in following directory:C:oraclexeapporacleproduct11.2.0servernetworkADMIN- Open that file and change the host parameter with you computer name
-
You can get your computer name by right click on
My Computerand 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. -
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.
Ori Lentz
3,6586 gold badges21 silver badges28 bronze badges
answered Jan 19, 2016 at 6:56
MrinmoyMrinmoy
1,3702 gold badges18 silver badges28 bronze badges
1
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.)
answered Aug 1, 2011 at 10:15
APCAPC
143k19 gold badges172 silver badges281 bronze badges
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.
answered Aug 22, 2013 at 5:19
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.
answered Jul 15, 2016 at 14:01
0
If none the above work, then try this :
Modify the LISTENER.ora (mine is found in : oracleproduct11.2.0dbhome_1NETWORKADMINlistener.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:oracleproduct11.2.0dbhome_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
answered Sep 22, 2013 at 16:20
It really has worked on my machine. But instead of OracleServiceORCL I found OracleServiceXE.
answered Oct 6, 2013 at 7:03
Flow the flowing steps :
-
Edit your listener.ora and tnsnames.ora file in
$Oracle_homeproduct11.2.0client_1NETWORKADMIN locationa. 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.
answered May 22, 2017 at 9:02
Just to add up, follow the screenshot and choose local account to start if not selected. Then start the service.
answered Jul 31, 2020 at 6:12
VaibsVaibs
1,97822 silver badges29 bronze badges
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.
answered Aug 1, 2011 at 5:46
Andrew CooperAndrew Cooper
32k5 gold badges79 silver badges115 bronze badges
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.
answered Sep 25, 2017 at 17:24
I try 2 option:
- You change service OracleService in Service Tab -> Running
- Login with cmd command: sqlplus user_name/pass_word@orcl12C
Note: orcle12c -> name of OracleService name run in you laptop
answered Oct 19, 2020 at 6:58
Below fixes can be applied to resolve TNS 12560 error
- Get Latest patch for
SQL*NETclient software - Set
$ORACLE_HOMEand$PATHvariable (should be accessible for System user) - Check permissions on PC client
- Check
$TNS_ADMINvariable - Check if network has firewall or antivirus issues
- Check if windows services Run >> Services.msc has OracleXE or OracleORCL service running
Check below link in case of net tracing error:
http://dba-oracle.com/t_sql_net_tracing.htm
C. Peck
3,5763 gold badges18 silver badges36 bronze badges
answered May 24, 2021 at 17:41
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.
answered Feb 13, 2017 at 12:27
muthukumarmuthukumar
1481 silver badge10 bronze badges
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.
asked Aug 1, 2011 at 5:39
Vishwanath DalviVishwanath Dalvi
34.8k41 gold badges122 silver badges153 bronze badges
- Go to the windows machine that hosts the Oracle database server
-
Go to Start -> Run -> Services.msc in Windows.
Locate OracleService < SID > (hereOracleServiceORCL) and click onStartto start the oracle database service (if not already running)
-
Once it is up and running, from the command prompt run the following:
tnsping < tnsalias >(tnsalias entry you can find it in
tnsnames.orafile)
answered Aug 1, 2011 at 21:06
BharathiBharathi
1,5332 gold badges10 silver badges13 bronze badges
6
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
answered Dec 6, 2012 at 6:32
Yasir AhmedYasir Ahmed
2993 silver badges2 bronze badges
2
from command console, if you get this error you can avoid it by typing
c:> sqlplus /nolog
then you can connect
SQL> conn user/pass @host:port/service
maruf
5593 gold badges6 silver badges22 bronze badges
answered Feb 26, 2016 at 17:27
demiandemian
5926 silver badges14 bronze badges
Add to the enviroment vars the following varibale and value to identify the place of the tnsnames.ora file:
TNS_ADMIN
C:oracleproduct10.2.0client_1networkadmin
answered May 14, 2013 at 14:33
1
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]apporacleproduct11.2.0serverbin). 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]apporacleproduct11.2.0servernetworkADMIN
answered Mar 14, 2017 at 14:09
walkeroswalkeros
4,5804 gold badges34 silver badges46 bronze badges
After searching alot got a simple way to solve it.
Just follow the steps.
- Check status of your listener.
- open command prompt and type
lsnrctl status - You will get no listener.
- open command prompt and type
-
Now open
listener.orafile which is present in following directory:C:oraclexeapporacleproduct11.2.0servernetworkADMIN- Open that file and change the host parameter with you computer name
-
You can get your computer name by right click on
My Computerand 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. -
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.
Ori Lentz
3,6586 gold badges21 silver badges28 bronze badges
answered Jan 19, 2016 at 6:56
MrinmoyMrinmoy
1,3702 gold badges18 silver badges28 bronze badges
1
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.)
answered Aug 1, 2011 at 10:15
APCAPC
143k19 gold badges172 silver badges281 bronze badges
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.
answered Aug 22, 2013 at 5:19
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.
answered Jul 15, 2016 at 14:01
0
If none the above work, then try this :
Modify the LISTENER.ora (mine is found in : oracleproduct11.2.0dbhome_1NETWORKADMINlistener.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:oracleproduct11.2.0dbhome_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
answered Sep 22, 2013 at 16:20
It really has worked on my machine. But instead of OracleServiceORCL I found OracleServiceXE.
answered Oct 6, 2013 at 7:03
Flow the flowing steps :
-
Edit your listener.ora and tnsnames.ora file in
$Oracle_homeproduct11.2.0client_1NETWORKADMIN locationa. 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.
answered May 22, 2017 at 9:02
Just to add up, follow the screenshot and choose local account to start if not selected. Then start the service.
answered Jul 31, 2020 at 6:12
VaibsVaibs
1,97822 silver badges29 bronze badges
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.
answered Aug 1, 2011 at 5:46
Andrew CooperAndrew Cooper
32k5 gold badges79 silver badges115 bronze badges
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.
answered Sep 25, 2017 at 17:24
I try 2 option:
- You change service OracleService in Service Tab -> Running
- Login with cmd command: sqlplus user_name/pass_word@orcl12C
Note: orcle12c -> name of OracleService name run in you laptop
answered Oct 19, 2020 at 6:58
Below fixes can be applied to resolve TNS 12560 error
- Get Latest patch for
SQL*NETclient software - Set
$ORACLE_HOMEand$PATHvariable (should be accessible for System user) - Check permissions on PC client
- Check
$TNS_ADMINvariable - Check if network has firewall or antivirus issues
- Check if windows services Run >> Services.msc has OracleXE or OracleORCL service running
Check below link in case of net tracing error:
http://dba-oracle.com/t_sql_net_tracing.htm
C. Peck
3,5763 gold badges18 silver badges36 bronze badges
answered May 24, 2021 at 17:41
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.
answered Feb 13, 2017 at 12:27
muthukumarmuthukumar
1481 silver badge10 bronze badges
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.
asked Aug 1, 2011 at 5:39
Vishwanath DalviVishwanath Dalvi
34.8k41 gold badges122 silver badges153 bronze badges
- Go to the windows machine that hosts the Oracle database server
-
Go to Start -> Run -> Services.msc in Windows.
Locate OracleService < SID > (hereOracleServiceORCL) and click onStartto start the oracle database service (if not already running)
-
Once it is up and running, from the command prompt run the following:
tnsping < tnsalias >(tnsalias entry you can find it in
tnsnames.orafile)
answered Aug 1, 2011 at 21:06
BharathiBharathi
1,5332 gold badges10 silver badges13 bronze badges
6
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
answered Dec 6, 2012 at 6:32
Yasir AhmedYasir Ahmed
2993 silver badges2 bronze badges
2
from command console, if you get this error you can avoid it by typing
c:> sqlplus /nolog
then you can connect
SQL> conn user/pass @host:port/service
maruf
5593 gold badges6 silver badges22 bronze badges
answered Feb 26, 2016 at 17:27
demiandemian
5926 silver badges14 bronze badges
Add to the enviroment vars the following varibale and value to identify the place of the tnsnames.ora file:
TNS_ADMIN
C:oracleproduct10.2.0client_1networkadmin
answered May 14, 2013 at 14:33
1
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]apporacleproduct11.2.0serverbin). 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]apporacleproduct11.2.0servernetworkADMIN
answered Mar 14, 2017 at 14:09
walkeroswalkeros
4,5804 gold badges34 silver badges46 bronze badges
After searching alot got a simple way to solve it.
Just follow the steps.
- Check status of your listener.
- open command prompt and type
lsnrctl status - You will get no listener.
- open command prompt and type
-
Now open
listener.orafile which is present in following directory:C:oraclexeapporacleproduct11.2.0servernetworkADMIN- Open that file and change the host parameter with you computer name
-
You can get your computer name by right click on
My Computerand 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. -
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.
Ori Lentz
3,6586 gold badges21 silver badges28 bronze badges
answered Jan 19, 2016 at 6:56
MrinmoyMrinmoy
1,3702 gold badges18 silver badges28 bronze badges
1
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.)
answered Aug 1, 2011 at 10:15
APCAPC
143k19 gold badges172 silver badges281 bronze badges
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.
answered Aug 22, 2013 at 5:19
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.
answered Jul 15, 2016 at 14:01
0
If none the above work, then try this :
Modify the LISTENER.ora (mine is found in : oracleproduct11.2.0dbhome_1NETWORKADMINlistener.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:oracleproduct11.2.0dbhome_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
answered Sep 22, 2013 at 16:20
It really has worked on my machine. But instead of OracleServiceORCL I found OracleServiceXE.
answered Oct 6, 2013 at 7:03
Flow the flowing steps :
-
Edit your listener.ora and tnsnames.ora file in
$Oracle_homeproduct11.2.0client_1NETWORKADMIN locationa. 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.
answered May 22, 2017 at 9:02
Just to add up, follow the screenshot and choose local account to start if not selected. Then start the service.
answered Jul 31, 2020 at 6:12
VaibsVaibs
1,97822 silver badges29 bronze badges
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.
answered Aug 1, 2011 at 5:46
Andrew CooperAndrew Cooper
32k5 gold badges79 silver badges115 bronze badges
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.
answered Sep 25, 2017 at 17:24
I try 2 option:
- You change service OracleService in Service Tab -> Running
- Login with cmd command: sqlplus user_name/pass_word@orcl12C
Note: orcle12c -> name of OracleService name run in you laptop
answered Oct 19, 2020 at 6:58
Below fixes can be applied to resolve TNS 12560 error
- Get Latest patch for
SQL*NETclient software - Set
$ORACLE_HOMEand$PATHvariable (should be accessible for System user) - Check permissions on PC client
- Check
$TNS_ADMINvariable - Check if network has firewall or antivirus issues
- Check if windows services Run >> Services.msc has OracleXE or OracleORCL service running
Check below link in case of net tracing error:
http://dba-oracle.com/t_sql_net_tracing.htm
C. Peck
3,5763 gold badges18 silver badges36 bronze badges
answered May 24, 2021 at 17:41
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.
answered Feb 13, 2017 at 12:27
muthukumarmuthukumar
1481 silver badge10 bronze badges
As we all know that Oracle is free and open business management software that is available for both personal and commercial use. Oracle database uses object-relational database management system that allows to process credit card payments, support and manages customer orders, handles customers, etc.
This networking software does the task of exchange of data between machines using underlying services to establish communication between the components. Establishment of communication happens due to some set of services, these services are known as Transparent Network Substrate (TNS). However, sometimes due to some uncertain reasons, when this service is taken into action, throws an error stated as ‘ORA-12560 TNS Protocol Adapter Error’
So, here, in this blog today, I will let you know how to fix ora-12560 tns protocol adapter error in easy ways. But before that, let us have a brief look at the Oracle TNS which throws an error.
About Oracle Transparent Network Substrate (TNS)
Transparent Network Substrate is a service that handles communication with oracle components with its database codes and pre-programmed schema. The acronym TNS occurs in various instances, when you get an error. TNS uses various protocols, which could be TCP/IP, DECNET, SPX/IPX, AppleTalk etc.
All these combination of TNS and the hidden protocols used to help in networking makes the connection establish between components. The Oracle Transparent Network Substrate (TNS) facilitates simple inter-database communication and has an built-in management layer over the standard network topology. But sometimes there may occur some communication error while connecting to the database. And one of the errors is ORA-12560 TNS Protocol Adapter Error which happens whenever there is a problem in accessing a specific server of the database.
ORA-12560 TNS Protocol Adapter Error takes place due to several reasons, but the most common is the server problem. This problem arises when a user does not specify which database or server was being accessed or there may be incorrect password provided to the database. Instead of giving exact reasons for the connection error, Oracle simply prompts ORA-12560 TNS Protocol Adapter Error. In short, if you want to troubleshoot this error, then you have to ensure the following:
- Listener is up and pointing to the desired database service
- Database service is up
- Oracle variables are configured in a correct manner which includes ORACLE_BASE, ORACLE_HOME, ORACLE_SID, PATH, TNS_ADMIN
- Cross check the firewall and the network configurations
- Full access is applicable to ORACLE_HOME including its sub-directories
Ways To Fix ORA-12560 TNS Protocol Adapter Error
Here are the best ways you can try to fix ORA-12560 TNS Protocol Adapter Error. Try them one by one and see which fix works in your case. Let’s get started with the first solutions…..
Fix #1: Set Correct ORACLE_SID
If you are running on a server that is running the database (i.e. database is local to machine) then it is important to first make sure that you have set a correct ORACLE_SID. If it is set correctly then it is good and if not then you have to try the below steps:
First of all, go to the command prompt and then run the below command:
- Set Oracle Database SID as
Set oracle_sid=ORCL
- Next, run Net Start command
Net start oracleserviceORCL
Fix #2: Check The Service Name ‘Oracleservice<SID>’ Ties Up With The Actual Database SID
Another method you can try to fix ora-12560 tns protocol adapter error is to check the service name ties up with the actual database SID. If, in any case, database SID changes without recreating service then this can lead this error. In this case, you have to recreate this service by following this step:
oradimxx -delete -sid <old-sid>
oradimxx -new -sid <SID> –intpwd <internal-password> AUTO –pfile <full-init-ora-filename>
Fix #3: Restart The Oracle Service
If the above method doesn’t work, maybe the OracleService for the database is not running. Check for the service, if it is not running then starts the service. If it is running then restart the service. To do so, you have to follow the below steps:
- First of all, you have to go to Start option.
- Next, you have to type Run and open it.
- Now, on the dialogue box, you have to type services.msc and then hit Enter.
- After this, you have to navigate to find OracleServicesORCL and then select the service and simply click on Start to initiate oracle database server if it’s not already running.
- After it has been done and running, from the command prompt run the following:
Tnsping<tnsalias> (tnsalias entry you can find it in tnsnames.ora file)
Fix #4: Try Oracle File Repair Tool To Fix ORA 12560: TNS: protocol adapter Error
If the above guides are out of your mind and you are perplexed what to do and wonder now how to fix ORA 12560 TNS protocol adapter error then don’t worry. For your rescue, there is a tool named Oracle File Repair Tool which will help you out. This tool doesn’t require any technical knowledge to use the steps.
Steps To Fix ORA 12560 TNS Protocol Adapter Using Tool
Step 1: Run Oracle File Repair Tool and you would see options to select or search corrupt Oracle databases in your computer.
Step:2 Click on Scan File to start the scan process after selecting the oracle database. On the left-side pane, recoverable objects get listed.
Step 3: Click an object to see its preview.
Step 4: : Click Start Repair in the icon bar to start the repair process. A prompt message occurs which will guide you further. Click next and continue.
Step 5: Provide user name, password and path of the blank database where you want to save the repaired database objects.
Step 6: Repairing and restoring various database objects after establishing a connection with blank oracle database.
This way you could fix ORA 12560: TNS protocol adapter error. Hope it helps.
Final Verdict
While using Oracle database if you ever come across and error stated as ‘ora-12560 tns protocol adapter error’ then you have come to the right place. I am saying so because I have already mentioned here the best fixes you can try to fix ora-12560 tns protocol adapter error.
All these fixes are easy to apply and the best part is that you do not need any technical knowledge to perform these fixes. All you have to do is to just follow the step by step guide to resolve ora-12560 tns protocol adapter error.
Jacob Martin is a technology enthusiast having experience of more than 4 years with great interest in database administration. He is expertise in related subjects like SQL database, Access, Oracle & others. Jacob has Master of Science (M.S) degree from the University of Dallas. He loves to write and provide solutions to people on database repair. Apart from this, he also loves to visit different countries in free time.
In my previous articles i have given the explanation of different types of errors like ORA-01000 error,ORA-03113 error,ORA-01722 error with examples and its probable solutions.In this article i will try to explain another most common error which will be searched 22 K times on google per month.As there are multiple type of errors like syntax errors,semantic errors,database connectivity error,Server Error.ORA-12560 error lies in connectivity error of oracle.To resolve this error user needs to check the connectivity of database with servers.There are some possible steps to resolve this error.
“ORA-12560 will be searched approximately 22000 times on google per month.”
Why ORA-12560 error will come?
There are lot of types of errors like syntax errors,server errors,connectivity error.ORA-12560 is server connectivity error when user tries to connect the database.Most of the times when user installs oracle first time this error will occur.
Situation :
First time installation
This error will occur mostly when user installs oracle first time and tries to connect it.When user tries to insert the username and password the following error come :
Enter password: ERROR: ORA-12560: TNS:protocol adapter error
This error will come if Listener is not up or problem in tnsnames or database is not up.After installation of oracle user needs to up all the services including listener.
NO TIME TO READ CLICK HERE TO GET THIS ARTICLE
Resolution of the Error :
As i explained you this error pure connectivity error.When database tries to connect but it will not be able to get listener or services are not up then this error will come.To resolve this errors user needs to do some checkpoints and take corrective actions to resolve this error. Following are some checkpoint to resolve this error :
Solution 1:
Check listener status
User needs to check the listener status.The listener should be up and running.For checking the listener status kindly execute lsnrctl status.
Solution 2:
Check Oracle variables
User needs to check $ORACLE_HOME and $PATH variables.
Solution 3 :
Check updated patches
While connecting with SQL PLUS check that patches are updated one and if that are not updated then get the latest patch.
Solution 4 :
Services are up and running.
Check all services are up and running.
Solution 5 :
Check permissions and network firewall
Check all permissions as well as firewall settings
Solution 6:
Check TNSNAMES entry
User needs to check TNSNAMES entry.
Solution 7:
ORACLE_SID parameters
User needs to check the ORACLE_SID parameters set properly in registry.
These are above some possible solutions of this most common error.Hope everyone likes this article.Don’t forget to share this article by clicking the share button below.