
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ORA-12560:TNS:Protocol Adapter Error, When Trying To Connect Into Oracle Database Using ODBC or OLEDB
Aug 24, 2020 7:53:32 AM
Aug 6, 2017 11:30:40 PM
Connecting the QlikView Directory Service connector using OLDBC or OLEDB shows the following error:
ORA-12560:TNS:protocol adapter error, Oracle classify this as a 'generic protocol adapter error
This indicates that Oracle client does not know what instance to connect to or what TNS alias to use.
Cause:
Oracle classify this as a 'generic protocol adapter error'. it indicates that Oracle client does not know what instance to connect to or what TNS alias to use.
- Oracle client is not installed on Qlik product server
- Oracle Listener or database is not up
- TNSNAMES.ora has a problem
- Connection between Oracle client and server has problem (TCP/IP or network side)
- ORCL 2019.3: the SQLNET.ora has AUTHENTICATION set to TNS. Changing it to (NONE) may help with starting the Listener.
Resolution:
This error is being shown by Oracle and as of such, we recommend contacting the Oracle administrator.
Previous cases related to the issue have been resolved following these troubleshooting steps:
Check the listener status:
Go to a command prompt on the Oracle database server and run
C:\> lsnrctl status
Verify that the tnsnames entry is correct:
Go to a command prompt on the Qlik Product server and run
C:\> tnsping INSTANCENAME
Check the connection between Oracle client and database server:
Go to a command prompt on the Qlik Product server and run
C:\Document and settings\ORANGE> cd\ C:\> set oracle_sid=<DB name> e.g C:\> set oracle_sid=<rajesh> {press enter} C:\> sqlplus /nolog {press enter} sql:\>connect sys/sys as sysdba {press enter} it cant ask for password directly connected or sql:\>connect sys as sysdba {press enter} password : sys {press enter} sql:\> connected or sql:\> connect scott {press enter} Enter password :tiger {press enter} sql:\> connected or sql:\> connect system {press enter} Enter password :manager {press enter} sql:\> connected