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