How To Configure the Oracle Connection Tester
Create a configuration file
Copy config.json.sample
to config.json
and set the variables within:
oracle_host
is the address of the Oracle host server.
oracle_port
is the open port on the server, probably 1521.
oracle_database
is the name of the database on the server.
oracle_username
and oracle_password
are the credentials we will use to authenticate with the database.
Set up Oracle client and environment variables
If you don't already have an Oracle client installed on the machine:
- download and install the Oracle Instant Client. Get the Instant Client Package - Basic Lite and the Instant Client Package - SDK packages appropriate for your system and database version.
- Unzip the Instant Client into a directory, like
C:\Oracle\instantclient_11_1
- Unzip the SDK and copy the
sdk
folder into that directory; so it will be atC:\Oracle\instantclient_11_1\sdk
Create an ORACLE_HOME
environment variable that contains the Instant Client path:
Control Panel
->System and Security
->System
- Click
Advanced System Settings
in the left panel - Click the
Environment Variables...
button - Click the
New...
button in either User or System variables. - Create a new variable named
ORACLE_HOME
and set its value to the client path, likeC:\Oracle\instantclient_11_1\
And add that same path to the end of the PATH
environment variable:
- In the Environment Variables window (after steps 1-3 above), select the
Path
system variable in the bottom scroll window and clickEdit...
- To the end of
Variable
value, add the client path, like;C:\Oracle\instantclient_11_1\
If you already have an Oracle client installed on the machine, set ORACLE_HOME
and append to PATH
the appropriate path, like C:\oracle\product\11.1.0\client_1\