Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
we have an application which fetches data from Oracle EDW. when i open the application on server and reload, it runs fine. but when try to run the same application through a base load in QEMC it fails with below error.
Error: ErrorSource: OraOLEDB, ErrorMsg: ORA-12154: TNS:could not resolve the connect identifier specified.
This application used to run all fine through QEMC before.
Can anyone figure out what might be the issue? Please suggest.PFA log file for the same.
Probably not a QlikView issue; more of a configuration issue. See this post for further information.
This particular error message is a very general error message and can happen for quite a number of reasons. For general understanding of the error, you can review oracle documentation like this http://ora-12154.ora-code.com/
In SQL Server Linked Server, it could indicate a few things (not limited to)–
Hi,
Plz check the TNS name or Connection String in .ora file
Check this link: ORA-12154: TNS tips
Probably not a QlikView issue; more of a configuration issue. See this post for further information.
This particular error message is a very general error message and can happen for quite a number of reasons. For general understanding of the error, you can review oracle documentation like this http://ora-12154.ora-code.com/
In SQL Server Linked Server, it could indicate a few things (not limited to)–
Jyothi,
It seems to be a Oracle issue, if you do a simple Google search you can find thousands of people with same issue. Have you tried with ODBC connection, and if you try that make sure that you are setting up a system DNS not user DNS.
Gio
Thank You Everyone.
Issue was, tns file did not have the Datasource entry.
now it is resolved by DBA team.
HI Jyothi KV,
Can you Please tell me what your DBA team did so that i can recommend the same to my Oracle DBA team .
Regards,
Kshitiz