Forum Discussion
Error - Oracle: ORA-12154: TNS
Super UserLook like the connection info you specified can't be resolved
Please see the following taken from http://stackoverflow.com/questions/7957955/ora-12154-could-not-resolve-the-connect-identifier-specified
- Is there a tnsnames.ora file
- Is there an entry in the file for the service
- Can the application find the tnsnames.ora?
Your problem may well be number 3 - does the application run as a different user than when you run the console?
Oracle looks for the tnsnames.ora file in the directory defined in the TNS_ADMIN environment variable - If you are running as different users, then maybe the TNS_ADMIN environment variable is not set, and therefore it cannot find the file?
Hope this helps,
dniedrauerResolver I
In simple terms, would you mind explaining the steps to resolve # 3? Thank you.
1. How do I determine what user the application runs as? This isn't immediately clear.
2. Not sure what the TNS_ADMIN environment variable is or how to set it in this case or whether google instructions on "how to set TNS environent variable" which I followed are even relevant, or if there's something else I need to do.
Please expand.
Try like this please
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=101.21.29.218)(PORT=3090))(CONNECT_DATA=(SERVICE_NAME=TST)(INSTANCE_NAME=TST)))
Hello blopez11,
I checked what your link suggested 1) sqlplus user - no errors there. 2) defined the TNS_ADMIN string in the registry in the two homes I had. I am still getting the same error. Mine is on premise and not a web application.
Don't know what else I need to do.
Thanks
Minoo28
Did you try adding the Host and Service Name to the PowerBI.
If your hostname is System24 and ServiceName is DEV1 then you can try System24/DEV1
