Continuing from my OCI series: Moving On-Premises Oracle Apex application to OCI Oracle Autonomous Transaction Processing
Once the database is provisioned, you can connect from various clients.
Click Test, Save and Connect.
Link to the ObE - Connecting SQL Developer to Autonomous Transaction Processing
Next: OCI-Oracle ATP- Connect via SQLPlus on Linux
Sachin
Chief Architect
Oracle Apex Enthusiast
BuzzClan
Once the database is provisioned, you can connect from various clients.
- Credential Zip File
The Credential zip contains the following files:
- Wallet and keystore:
- cwallet.sso
- ewallet.p12
- keystore.jks
- truststore.jks
- Configuration
- sqlnet.ora
- tnsnames.ora
TNS entries are as follows:
- High
- Low
- Medium
- TP
- TPurgent
Connecting to SQLDeveloper
Various versions will have different options when it comes to the connection type. I am sharing a couple of things I have seen. Either way, here are a few pointers.
Download the latest SQL Developer. Cloud connections and secure connections are not available in older versions.
Open SQL Developer on your local computer. In the Connections panel, right-click Connections and select New Connection.
Note:
Depending on your version of SQL Developer, do not right-click Cloud Connection or Database Schema Service Connections. That menu selection is for connecting to a different Oracle cloud service, the Oracle Database Schema Service.
To start a new connection, start with New Connection, not the Cloud Connection.
The New/Select Database Connection dialog appears. Enter the following information:
- Connection Name - Enter the name for this cloud connection.
- Username - Enter the database username. Use the default administrator database account (admin) that is provided as part of the service.
- Password - Enter the admin user's password that you or your Autonomous Transaction Processing administrator specified when creating the service instance.
- Connection Type - Select Cloud Wallet. (or Cloud PDB)
- Configuration File - Click Browse, and select the Client Credentials zip file, downloaded from the Autonomous Transaction Processing service console by you.
- Service - In the drop-down menu, service selections are prepended with database names. Select the tpurgent, tp, high, medium, or low menu item for your database. These service levels map to the TPURGENT, TP, HIGH, MEDIUM and LOW consumer groups, which provide different levels of priority for your session.
- Wallet and keystore:
- cwallet.sso
- ewallet.p12
- keystore.jks
- truststore.jks
- Configuration
- sqlnet.ora
- tnsnames.ora
- High
- Low
- Medium
- TP
- TPurgent
Connecting to SQLDeveloper
Open SQL Developer on your local computer. In the Connections panel, right-click Connections and select New Connection.
Note:
Depending on your version of SQL Developer, do not right-click Cloud Connection or Database Schema Service Connections. That menu selection is for connecting to a different Oracle cloud service, the Oracle Database Schema Service.
The New/Select Database Connection dialog appears. Enter the following information:
- Connection Name - Enter the name for this cloud connection.
- Username - Enter the database username. Use the default administrator database account (admin) that is provided as part of the service.
- Password - Enter the admin user's password that you or your Autonomous Transaction Processing administrator specified when creating the service instance.
- Connection Type - Select Cloud Wallet. (or Cloud PDB)
- Configuration File - Click Browse, and select the Client Credentials zip file, downloaded from the Autonomous Transaction Processing service console by you.
- Service - In the drop-down menu, service selections are prepended with database names. Select the tpurgent, tp, high, medium, or low menu item for your database. These service levels map to the TPURGENT, TP, HIGH, MEDIUM and LOW consumer groups, which provide different levels of priority for your session.
OR
Click Test, Save and Connect.
Link to the ObE - Connecting SQL Developer to Autonomous Transaction Processing
Next: OCI-Oracle ATP- Connect via SQLPlus on Linux
Sachin
Chief Architect
Oracle Apex Enthusiast
BuzzClan
No comments:
Post a Comment