Oracle client credentials (wallet files) are downloaded from Autonomous Data Warehouse by a service administrator. If you are not an Autonomous Data Warehouse administrator, your administrator should provide you with the client credentials.
To download client credentials, do the following from Oracle Cloud Infrastructure console:
- Navigate to the Autonomous Data Warehouse details page.
- Click DB Connection.
- On the Database Connection page click Download.
- In the Download Wallet dialog, enter a wallet password in the
Password field and confirm the password in the Confirm
Password field.The password must be at least 8 characters long and must include at least 1 letter and either 1 numeric character or 1 special character.
Note:This password protects the downloaded Client Credentials wallet. This wallet is not the same as the Transparent Data Encryption (TDE) wallet for the database; therefore, use a different password to protect the Client Credentials wallet.
- Click Download to save the client security credentials zip file.
By default the filename is:
.zip. You can save this file as any filename you want.
You must protect this file to prevent unauthorized database access.
The zip file includes the following:
sqlnet.ora: Network configuration files storing connect descriptors and SQL*Net client side configuration.
ewallet.p12: Auto-open SSO wallet and PKCS12 file. PKCS12 file is protected by the wallet password provided in the UI.
truststore.jks: Java keystore and truststore files. They are protected by the wallet password provided while downloading the wallet.
ojdbc.properties: Contains the wallet related connection property required for JDBC connection. This should be in the same path as
Wallet files, along with the Database user ID and password provide access to data in your Autonomous Data Warehouse database. Store wallet files in a secure location. Share wallet files only with authorized users. If wallet files are transmitted in a way that might be accessed by unauthorized users (for example, over public email), transmit the wallet password separately and securely.
Autonomous Data Warehouse uses strong password complexity rules for all users based on Oracle Cloud security standards. For more information on the password complexity rules see Create Users with Autonomous Data Warehouse.