Connecting To An Autonomous Transaction Processing Database

Description:-

This topic gives an overview of connecting a client to an Autonomous Transaction Processing database and describes how to obtain the credentials and information you need to create a connection.

Applications and tools connect to Autonomous Transaction Processing databases by using Oracle Net Services (also known as SQL*Net). SQL*Net supports a variety of connection types to Autonomous Transaction Processing databases, including Oracle Call Interface (OCI), ODBC drivers, JDBC OC, and JDBC Thin Driver.

To support connections of any type, you’ll need to download the client security credentials and network configuration settings required to access your database. You’ll also need to supply the applicable TNS names or connection strings for a connection, depending on the client application or tool, type of connection, and service level. You can view or copy the TNS names and connection strings in the DB Connection dialog for your Autonomous Transaction Processing database.

About Downloading Client Credentials
The client credentials .zip that you download contains the following files:

cwallet.sso – Oracle auto-login wallet
ewallet.p12 – PKCS #12 wallet file associated with the auto-login wallet
sqlnet.ora – SQL*Net profile configuration file that includes the wallet location and TNSNAMES naming method
tnsnames.ora – SQL*Net configuration file that contains network service names mapped to connect descriptors for the local naming method
Java Key Store (JKS) files – Key store files for use with JDBC Thin Connections

Wallet files, along with the database user ID and password, provide access to data in your Autonomous Transaction Processing 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

To access the client credentials and connection information for your Autonomous Transaction Processing database

Step1:-Open the navigation menu. Under Database, click Autonomous Transaction Processing.Step2:-Choose your Compartment.

Step3:-In the list of Autonomous Transaction Processing databases, click on the display name of the database you are interested in.

Step4:-Click DB Connection.Step5:-To obtain the client credentials, click Download.

You will be prompted to provide a password to encrypt the keys inside the wallet. 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.Save the client credentials zip file to a secure location.

Catch Me On:- Hariprasath Rajaram 

Telegram:https://t.me/joinchat/I_f4DkeGfZuxgMIoJSpQZg LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/ Facebook:https://www.facebook.com/HariPrasathdba                       FB Group:https://www.facebook.com/groups/894402327369506/                   FB Page: https://www.facebook.com/dbahariprasath/? Twitter: https://twitter.com/hariprasathdba

Creating An Autonomous Transaction Processing Database

Description:-

This topic describes how to provision a new Autonomous Transaction Processing database using the Oracle Cloud Infrastructure Console

To create an Autonomous Transaction Processing Database

Step1:-  Click Services to show the available services. In the list of available services, select Autonomous Transaction Processing.

Step2:-The console for Autonomous Transaction Processing displays. You can use the List Scope drop-down menu to select a compartment;

This console shows no databases. If there were a long list of databases, you could filter the list by using the Filters drop-down menu to filter by the state of the databases (available, stopped, terminated, and so on.)

Click Create Autonomous Transaction Processing Database to create a database instance.

Step3:-The Create Autonomous Transaction Processing Database dialog appears. At the top of the dialog, select a compartment for the database from the drop-down list.

In the Create Autonomous Transaction Processing Database dialog, enter the following:
Display Name,Database Name,CPU Core Count,Storage,Administrator Credentials,License Type,Tags

Step4:-Click Create Autonomous Transaction Processing Database.

Database creation in Progress

Step5:- Database ready for use

Successfully Created Autonomous Transaction Processing Database

 

Catch Me On:- Hariprasath Rajaram 

Telegram:https://t.me/joinchat/I_f4DkeGfZuxgMIoJSpQZg LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/ Facebook:https://www.facebook.com/HariPrasathdba                       FB Group:https://www.facebook.com/groups/894402327369506/                   FB Page: https://www.facebook.com/dbahariprasath/? Twitter: https://twitter.com/hariprasathdba