Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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
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.
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