My Oracle Support Banner

[12.2.1.3] How To Configure Datasource Using Oracle Wallet Storing Database Credentials (Doc ID 2578030.1)

Last updated on SEPTEMBER 25, 2023

Applies to:

Oracle WebLogic Server - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Goal

How to configure weblogic datasource using oracle wallet which is storing database credentials.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 1. Create a wallet to store database credentials for WebLogic JDBC data source definitions
 2. Store database credentials to wallet
 3. Create a Datasource from WebLogic Admin Console as follows
 3-1. Access WebLogic Admin Console -> "Domain name" -> "Services" -> "Data Sources", then Push "New" button and select one
 3-2. Select Database Type: Oracle
 3-3. Select Database Driver
 3-4. Select Transaction Options
 3-5. Set "Database Name", "Host Name" and "Port" only
 3-6. Set URL and Properties as follows
 3-7. Push "Test Configuration"
 4. DB Alias can be used instead of <DB_CONNECT_STRING>
 4-1. Create tnsnames.ora file under <TNS_DIRECTORY>
 4-2. Set aliases in tnsnames.ora as follows
 4-3. Store database credentials with the <ALIAS>
 4-4. Set URL and Properties as follows on Step 3-6 page.
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.