Ошибка адаптера протокола oracle

Vishwanath DalviVishwanath Dalvi

34.8k41 gold badges122 silver badges153 bronze badges

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

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

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

answered Aug 22, 2013 at 5:19

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 Oct 6, 2013 at 7:03

Flow the flowing steps :

1. Edit your listener.ora and tnsnames.ora file in
   $Oracle_homeproduct11.2.0client_1NETWORKADMIN 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)
    )
  )

1. 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

answered Aug 1, 2011 at 5:46

ORA-12560: TNS:erro de adaptador de protocolo

1. set Environment Variables: ORACLE_BASE, ORACLE_HOME, ORACLE_SID
2. make sure your user is part of ORACLE_GROUP_NAME (Windows)
3. make sure the file ORACLE_HOME/network/admin/sqlnet.ora is:
   SQLNET.AUTHENTICATION_SERVICES = (NTS)
4. (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:

1. You change service OracleService in Service Tab -> Running
2. 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

1. Get Latest patch for SQL*NET client software
2. Set $ORACLE_HOME and $PATH variable (should be accessible for System user)
3. Check permissions on PC client
4. Check $TNS_ADMIN variable
5. Check if network has firewall or antivirus issues
6. 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

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

Vishwanath DalviVishwanath Dalvi

34.8k41 gold badges122 silver badges153 bronze badges

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

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

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

answered Aug 22, 2013 at 5:19

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 Oct 6, 2013 at 7:03

Flow the flowing steps :

1. Edit your listener.ora and tnsnames.ora file in
   $Oracle_homeproduct11.2.0client_1NETWORKADMIN 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)
    )
  )

1. 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

answered Aug 1, 2011 at 5:46

ORA-12560: TNS:erro de adaptador de protocolo

1. set Environment Variables: ORACLE_BASE, ORACLE_HOME, ORACLE_SID
2. make sure your user is part of ORACLE_GROUP_NAME (Windows)
3. make sure the file ORACLE_HOME/network/admin/sqlnet.ora is:
   SQLNET.AUTHENTICATION_SERVICES = (NTS)
4. (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:

1. You change service OracleService in Service Tab -> Running
2. 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

1. Get Latest patch for SQL*NET client software
2. Set $ORACLE_HOME and $PATH variable (should be accessible for System user)
3. Check permissions on PC client
4. Check $TNS_ADMIN variable
5. Check if network has firewall or antivirus issues
6. 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

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

Vishwanath DalviVishwanath Dalvi

34.8k41 gold badges122 silver badges153 bronze badges

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

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

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

answered Aug 22, 2013 at 5:19

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 Oct 6, 2013 at 7:03

Flow the flowing steps :

1. Edit your listener.ora and tnsnames.ora file in
   $Oracle_homeproduct11.2.0client_1NETWORKADMIN 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)
    )
  )

1. 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

answered Aug 1, 2011 at 5:46

ORA-12560: TNS:erro de adaptador de protocolo

1. set Environment Variables: ORACLE_BASE, ORACLE_HOME, ORACLE_SID
2. make sure your user is part of ORACLE_GROUP_NAME (Windows)
3. make sure the file ORACLE_HOME/network/admin/sqlnet.ora is:
   SQLNET.AUTHENTICATION_SERVICES = (NTS)
4. (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:

1. You change service OracleService in Service Tab -> Running
2. 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

1. Get Latest patch for SQL*NET client software
2. Set $ORACLE_HOME and $PATH variable (should be accessible for System user)
3. Check permissions on PC client
4. Check $TNS_ADMIN variable
5. Check if network has firewall or antivirus issues
6. 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

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