When the Oracle client is installed for the first time, it does not come with a TNSnames. Add the file to your Oracle driver's home directory; you may need administrative access on your machine to access these folders.
The Oracle home directory will have a path similar to this:. If you have both and bit Oracle clients installed, be sure to add the TNSnames. This will list all of the files in the folder from which you can determine the path.
In some situations, your machine may have an out-of-date TNSnames. I need to do this as i am getting access denied message when i take tnsname. Fantastic article that explains the function and syntax of the tnsnames. ORA it will work. But i dont understand how to use it all. Pls help. Your email address will not be published. Notify me of follow-up comments by email. Notify me of new posts by email. This site uses Akismet to reduce spam.
Learn how your comment data is processed. ORA file? ORA File Located? If the file is not found in this directory, it is assumed the file does not exist. You may need to create one. To start, open the Control Panel. Then, open System. Click on Advanced System Settings, on the left. Type regedit and press Enter. Copy the Value here, and paste it into Windows Explorer.
According to the docs, the precedence in which Oracle Net Configuration files are resolved is:. For more details, see this related thread on managing the tnsnames.
To do so: 1. Logon as Administrator. From System Properties, select Environment tab. The Environment tab lists System environment variables defined by Windows NT - these are the same no matter which user is logged on to the computer. When logged as as a member of the Administrator group, you can modify, add or delete values. Click Set, then apply.
0コメント