This topic describes the systematic instructions to create and configure the ATP.

1. Create a Virtual Cloud Network (VCN) and Subnet.

   Note:

   User can create a separate VCN for ADB's in their tenancy.
2. Create an ATP Instance by following the process below:
   1. User can navigate to the Autonomous Transaction Processing.
   2. From the Menu, under Databases, select Autonomous Database.

      Figure 2-20 Oracle Database

      
      

      
      Description of "Figure 2-20 Oracle Database"

      
      
   3. Create Autonomous Database by following the process below:
      1. Click Create Autonomous Database.
      2. Select the Autonomous Transaction Processing option.

      Figure 2-21 Create Autonomous Database

      
      

      
      Description of "Figure 2-21 Create Autonomous Database"

      
      
   4. User should provide the following database details:

      Table 2-1 Database Details

      Field	Description
      Compartment	Select the compartment where the ATP instance will be created.
      Display Name	Provide a display name for the instance.
      Database Name	Provide a database name.
      Workload Type	Ensure Transaction Processing is selected.
      OCPU Count	Specify the number of OCPU's.
      Storage (TB)	Specify the storage size.

      Figure 2-22 Create Autonomous Database Details

      
      

      
      Description of "Figure 2-22 Create Autonomous Database Details"

      
      
   5. Configure the following network access:

      Table 2-2 Network Access

      Field	Description
      Choose Network Access	Select the Virtual Cloud Network.
      VCN and Subnet	Select the VCN and subnet created earlier.
      Access Type	Select between Private Endpoint (for private access) or Public Endpoint (for public access).

      Figure 2-23 Create Autonomous Database – Private endpoint access only
      
      Description of the illustration create-autonomous-database-private-endpoint-access-only.png
      

   6. Configure the following database options:

      Table 2-3 Database Options

      Field	Description
      License Type	Select the appropriate license type.
      Auto Scaling	Enable or disable auto scaling based on your needs.
      Tags	Optionally, add tags for resource management.

   7. Create ATP instances by clicking the Create Autonomous Database button.
   8. Configure the ATP Instance by following the process below:
      1. User can access the ATP Instance. Once the ATP instance is created, navigate to its details page from the Autonomous Database section.
      2. Download the Wallet. For secure connectivity, download the database wallet by clicking DB Connection and then Download Wallet. Also, provide a password to secure the wallet.
      3. Setup the security rules. If using a private endpoint, ensure the network security groups (NSGs) or security lists allow necessary traffic to and from the ATP instance.

      Note:

      Port 1522 should be allowed.

      Figure 2-24 OBCS_POC_ATP1

      
      

      
      Description of "Figure 2-24 OBCS_POC_ATP1"

      
      

      Figure 2-25 Private Subnet-OBCS_POC_VCN

      
      

      
      Description of "Figure 2-25 Private Subnet-OBCS_POC_VCN"

      
      

      1. User can access the ATP Instance. Once the ATP instance is created, navigate to its details page from the Autonomous Database section.
      2. Download the Wallet. For secure connectivity, download the database wallet by clicking DB Connection and then Download Wallet. Also, provide a password to secure the wallet.
      3. Setup the security rules. If using a private endpoint, ensure the network security groups (NSG's) or security lists allow necessary traffic to and from the ATP instance.

      Note:

      Port 1522 should be allowed.

      Figure 2-26 SL - Add Ingress Rules

      
      

      
      Description of "Figure 2-26 SL - Add Ingress Rules"

      
      

      Figure 2-27 Security List for Private Subnet-OBCS_POC_VCN

      
      

      
      Description of "Figure 2-27 Security List for Private Subnet-OBCS_POC_VCN"