Forum Discussion
Error - Oracle: ORA-12154: TNS
Am unable to connect to the Oracle Database. The error is - "Oracle: ORA-12154: TNS:could not resolve the connect identifier specified". Can anybody offer a solution. Thanks
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)))