Net Configuration Assistant creates the tnsnames. By default, Oracle Universal Installer updates the PATH variable for you during the installation process, but another user may have inadvertently reset it since then. This directory is the Oracle home directory that you specified during installation. After you have checked the PATH environment variable, you can use any of the following methods to specify Oracle Database connection information for client applications:.
You can specify a connection address to an Oracle Database directly from a client application, without having to configure a tnsnames setting for the Instant Client. This method is convenient in that you do not have to create and manage a tnsnames.
However, your application users must specify the host name and port number when they want to log in to your application.
Similarly, in your application code, you can use Oracle Call Interface net naming methods to create the Instant Client-to-Oracle Database connection. For example:. By default, when you install Instant Client, Oracle Universal Installer does not include a sample tnsnames.
However, if you want to shield users from having to specify actual host names and port numbers, you may want to consider using a tnsnames. You can create the tnsnames.
Place the tnsnames. You can set the connect string to an empty connect string "" , and then set the LOCAL environment variable to one of the following values:. A tnsnames. This method allows your applications to specify internally a connection string if the application code itself uses an empty connection string. The benefit of an empty connect string is that the application itself does not need to specify the tnsnames.
Instead, when a user invokes the application, the location of the database is determined by a script or the environment, depending on where you have set the LOCAL environment variable. The disadvantage of using empty strings is that you must configure this additional information in order for your application to connect to the database. Changes have been made to the content of some of the language and territory definition files in Oracle Database 10 g and later releases.
You can't use networked file shares as the account has absolutely no network rights. It works when you use it via tnsping because your windows user is a domain account and has rights to the network share. You looked like you were on to this with this" I wondered if the SSRS account which was running the reports was unable to see this location? You find out the account by looking at services in the "log on as" column. Make sure that file permissions are OK too.
This completely solved my problem that has been stumped for 6 hours. The issue in my case was having multiple client installs 10 and Sign in. United States English. Ask a question. Quick access. Search related threads. Remove From My Forums. Active 8 years, 6 months ago.
Viewed k times. Improve this question. Mat 9, 3 3 gold badges 40 40 silver badges 40 40 bronze badges. Add a comment. Active Oldest Votes. Improve this answer. 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. Click OK to close window. Feel free to ask questions on our Oracle forum.
Verify experience!
0コメント