Before connecting to a database hosted on Oracle Autonomous Database, you must install client software (for example, Oracle Instant Client), download the wallet containing client credentials, and configure certain files and environment variables.
To prepare for connection to an Autonomous Database:
- If you have not already installed an Oracle Database client, see: Oracle Server Database Client Software
- Download the wallet from the URL provided by your sales contact.
- Extract the wallet file to a suitable location on your local machine, for example,
C:\OracleWallet
. - Open the
sqlnet.ora
file at the extracted wallet location in a text editor.- Find the following line, and replace the text in quotation marks with the location of the extracted wallet file.
(DIRECTORY="?/network/admin")
For example,
(DIRECTORY="C:\OracleWallet")
- Save the file.
- Find the following line, and replace the text in quotation marks with the location of the extracted wallet file.
- Create the TNS_ADMIN environment variable and set it to the location of the credentials file.
- On Windows, open the command line and enter:
set TNS_ADMIN=
<wallet_location>Where <wallet_location> is the path to the extracted wallet files.
- On Linux, open a terminal and enter:
export TNS_ADMIN=
<wallet_location>Where <wallet_location> is the path to the extracted wallet files.
- On Windows, open the command line and enter: