Prerequisites for Connecting to Autonomous Databases
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 (on page 9)
- 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:
Related Topics
Running Database Configuration After Installation
Configuring a Microsoft SQL Server Database Connection From the Command Line
Configuring an Oracle Database Connection From the Command Line
Configuring a Microsoft SQLite Database Connection From the Command Line
Database Administrator Settings for a Non-Default Microsoft SQL Server Port
Running Database Configuration Manually
Last Published Monday, March 11, 2024