uses standard Oracle Client software (OCI) and TNS name.
There are two prerequisites you need to solve:
- Install the Oracle Client SW on the PC
- Configure TNS record in the file tnsnames.ora
TNS name (respectively alias)
is the name of the entry in tnsnames.ora file which is kept in $ORACLE_HOME/network/admin.
TNS name describe the connection to Oracle database with using host name, port and other connection arguments.
Please read more about the Oracle Client and TNS records here:
What is TNS name on community.oracle.com
Database Client Installation Guide on docs.oracle.com
Do not remember you have to install correct 32 or 64 Bit version of ShedOra in depend the Bit version of the Oracle Client you have installed!
When you install the InstantClient binaries, you often want to use your existing TNSNAMES.ORA file containing all your databases.
So how do you specify the location of your TNSNAMES.ORA file?
The Oracle website has the answer:
Always set the TNS_ADMIN environment variable or registry to the location of the tnsnames.ora file (full directory path only, do not include the file name).
This practice will ensure that you are using the appropriate tnsnames.ora for your application when running with Instant Client.
For UNIX and Linux systems set the variable TNS_ADMIN like so in your .profile or .bash_profile:
On Windows systems, set the environment variables via the Advanced System properties:
1. Open CMD, enter sysdm.cpl
2. In the Advanced tab, select Environment Variables.
3. Under “System Variables”, click on New… and enter “TNS_ADMIN” as the name and the path where your TNSNAMES.ORA resides as your value.
Now, you can use your TNS names for your InstantClient.
©2016 Agama Software - Agama Software, the Agama Software logo, Agama Web Buttons, Agama Web Menus, SchedOra and Ruler In Pocket are trademarks of Agama Software company.
This site is independent of and does not represent Oracle Corporation in any way.
Product and company names mentioned in this website may be the trademarks of their respective owners.