Latest Updates

Post Top Ad

10 April, 2023

Oracle Cloud: Provision Autonomous Transaction Processing Database

Provision Autonomous Transaction Processing Database


Sign up for an Oracle Cloud account: To create an Autonomous Transaction Processing database, you will need an Oracle Cloud account. If you don't have one, you can sign up for a free trial.




Oracle Cloud Free Tier Signup




Create a new Autonomous Transaction Processing instance: Once you have logged in to your Oracle Cloud account, navigate to the Autonomous Transaction Processing console and create a new ATP instance.

a.      Click on Oracle Database > Autonomous Transaction Processing


 


 

b.      Choose the compartment > and click on Create Autonomous Database

 



Configure the instance: You will need to configure the instance by specifying the number of OCPUs, amount of storage, and other settings. You can also choose to enable features like Data Guard and backups.




 Oracle now allows creating 21c database or 19c database.

 









 Click on Create Autonomous Database

 





 Login to Oracle ATP Database:

 



Connect to the database: Once the ATP instance is created and configured, you can connect to it using any SQL client tool such as SQL Developer or SQL*Plus.

 



Create database schema, database objects: You can create database objects such as tables, indexes, and views using SQL commands or a database modeling tool.

 



 Assign a role to the user

 







 



Download wallet file

 





Manage and monitor the database: You can monitor the performance of your database and make changes to the configuration as needed using the ATP console.

 

Click on Performance Hub and monitor the database.

 




 How to Enable the ACL in ATP Database

 







Read More:

No comments:

Post Top Ad

Your Ad Spot

Pages