Connect an Oracle Java Cloud Service Instance to an Application Database
After you provision the service instance, you can create new data sources that enable you to connect to either an Oracle Autonomous Database (Oracle Autonomous Transaction Processing) or an Oracle Cloud Infrastructure database.
Topics:
Connect to an Oracle Autonomous Database
You can create an Oracle Autonomous Database (Oracle Autonomous Transaction Processing) using the Oracle Cloud Infrastructure Console, then provision an Oracle Java Cloud Service instance with the Oracle Autonomous Database for the schema infrastructure database, but not the application database. After you provision the Oracle Java Cloud Service, you can configure an additional data source that enables you to connect the provisioned service instance to an Oracle Autonomous Database.
Topics
Download the Oracle Autonomous Database Wallet
The first step in connecting an Oracle Autonomous Database (Oracle Autonomous Transaction Processing) is to download the database's wallet file, which contains client credentials.
Oracle wallet files are downloaded from Oracle Autonomous Database by a service administrator. If you are not an Oracle Autonomous Database administrator, ask your administrator to provide you with the wallet file.
- Sign in to access the Oracle Cloud Infrastructure Console, if it's not open already. If you are currently in the Oracle Java Cloud Service Console, select Compute from the Navigation menu and sign in.
- On the Oracle Cloud Infrastructure Console, select the region in which your Oracle Autonomous Database and Oracle Java Cloud Service instance are located.
- Select Autonomous Transaction Processing from the Oracle Database section of the Navigation menu.
- Select the Compartment that contains your Oracle Autonomous Database.
- Click the name of the Oracle Autonomous Database you want to connect to your service instance.
- On the Oracle Autonomous Transaction Processing 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.
- Click Download to save the wallet zip file.
Copy and Unpack the Wallet
After you download the wallet, copy and unpack the wallet to the Administration Server node. If your service instance contains multiple nodes, copy the wallet to each node.
Create a Data Source in the WebLogic Server Console
After you download the wallet file and copy it to all servers in the instance, you can create a data source in the WebLogic Server Console that enables you to connect your Oracle Java Cloud Service instance to your Oracle Autonomous Database (Oracle Autonomous Transaction Processing).
Connect to an Oracle Cloud Infrastructure Database
You can create an Oracle Cloud Infrastructure database using the Oracle Cloud Infrastructure Console, then provision an Oracle Java Cloud Service instance with the Oracle Cloud Infrastructure database for the schema infrastructure database, but not for the application database. After you provision the Oracle Java Cloud Service instance, you can configure an additional data source that enables you to connect the provisioned service instance to an Oracle Cloud Infrastructure database.
For details, see the Connect an Oracle Java Cloud Service Instance to an Oracle Cloud Infrastructure Database System tutorial.
Note:
In addition to creating a data source, you must also create a security list with the stateless ingress rule to allow the incoming traffic from the Oracle Java Cloud Service instance to the Oracle Cloud Infrastructure database.