- Dowload Oracle instant client
- Create a directory called oracle with the following subdirectories
- Uncompress the instant client under the bin directory
- Add the following environment variables:
- SQL_PATH = c:\Program Files\oracle
- TNS_ADMIN c:\Program Files\oracle\network\admin
- LD_LIBRARY_PATH = c:\Program Files\oracle\bin
- Copy the tnsnames.ora in the following directory: c:\Program Files\oracle\network\admin. Here’s a simple tnsnames.ora:
DEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = foo)(PORT = 1531))
)
(CONNECT_DATA =
(SERVICE_NAME = foo)
)
)
c:\Program Files\oracle
├─bin
└─network
└──admin