If your'e working with OBIEE then you can't deny facing the issue "The connection has failed". The most common issue faced by almost everyone when we are trying to use import metadata option.
It clearly stated that it is not able to connect or what ever we have given is not helping the application to establish a connection with the database. So if your'e using a OCI interface then you must be doing the only thing wrong. Your'e not pointing the interface to proper directory with connection descriptions i.e. tnsnames.ORA file.
Resolution: We must point the interface to the proper directory by passing the path using a environment variable.
Path to Environment Variables Menu:
My Computer --> Properties --> Advanced System Settings --> Environment Variables
click New to add a new variable as TNS_ADMIN variable. The value needs to be the path to your tnsnames.ora file, typically located at [ORACLE_HOME]\network\admin. The path will look something like the value shown below (it depends on where Oracle is installed on your system).
It clearly stated that it is not able to connect or what ever we have given is not helping the application to establish a connection with the database. So if your'e using a OCI interface then you must be doing the only thing wrong. Your'e not pointing the interface to proper directory with connection descriptions i.e. tnsnames.ORA file.
Resolution: We must point the interface to the proper directory by passing the path using a environment variable.
Path to Environment Variables Menu:
My Computer --> Properties --> Advanced System Settings --> Environment Variables
click New to add a new variable as TNS_ADMIN variable. The value needs to be the path to your tnsnames.ora file, typically located at [ORACLE_HOME]\network\admin. The path will look something like the value shown below (it depends on where Oracle is installed on your system).
Hope this helps !!!
No comments:
Post a Comment