How to connect oracle database with QlikView Report ?

[ashish1504]

I have tried to make connection using OLEDB between Oracle db and QlikView. But qlikview is unable to read tnsnames.ora file.

I think i am unable to place the file on proper directory. Can anyone help me with this

Thank you so much.

Below is the error msg.

[Ray_Strother · Accepted solution]

Hello ,

The links below should help you successfully connect to your database. The error passed back isn't from Qlikview , but rather it's a system error.

1. Create an Oracle connection

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/Oracle...

2. How to create ODBC connection to Oracle

https://community.qlik.com/t5/QlikView-App-Dev/How-to-create-ODBC-connection-to-Oracle/td-p/788946



3. http://www.dba-oracle.com/t_ora_12154_tns_resolve_service_name.htm

[Chip_Matejowsky · Accepted solution]

Hi @ashish1504,

I agree with @Ray_Strother that this error isn't a QlikView error per se.

From http://www.dba-oracle.com/t_ora_12154_tns_resolve_service_name.htm:

The ORA-12154 is a very common error, always related to your local copy of the tnsnames.ora file, your listener configuration and your database name aliases.

• Make sure that your listener is listening for the same service name that you are using.
• Check your global_name setting with this SQL:
  select * from global_name;

The query value should match your init.ora parms for db_name and db_domain, You can change the global_name with an ALTER DATABASE command, as follows:

alter database rename global_name to xxx;

Suggest that you reach out to your Oracle DBA for further assistance.

Best Regards