Use the Oracle Autonomous Transaction Processing console to create an instance
and create a user.
Log in to Oracle Cloud Infrastructure using the information from your welcome
email or your cloud administrator. On the sign-in page, enter your account's cloud
tenant name, then click Continue.
Enter your user name and password. Click Sign In.
Click the menu icon in the upper corner of the Oracle Cloud Infrastructure
screen. From the navigation pane, click
Autonomous Transaction Processing. The console for Autonomous Transaction
Processing appears. You can use the List Scope drop-down menu to select a
compartment. In this example, the Doc compartment is selected. Although this
console shows that no databases have yet been created, if there were a long list
of databases, you could filter the list by using the Filters drop-down menu to
filter the state of the database (available, stopped, terminated, and so on...)
Click Create Autonomous Transaction Processing.
The Create Autonomous Transaction Processing dialog appears. At the top of
the dialog, click the Click Here link to select a compartment for the database.
Select a compartment for the database from the drop-down list.
In the Create Autonomous Transaction Processing dialogue, enter a database
display name for display purposes. Enter the database name. Specify the number of
CPUs for your service. Select your storage capacity and
terabytes, and specify an administrator password for the admin user of the
service instance. For licence type, select whether you are using an included
license or bringing your own license. Click Create Autonomous Transaction
Processing. The Create Autonomous Transaction
Processing dialog closes. On the console, the State field indicates that the
database is provisioning. When creation is completed, the State field changes
from Provisioning to Available.
Once you have created the instance, download the credential zip file for
client access to that instance. From the main console, click Service Console.
A dialog opens to sign in to the service console. In the user name field,
enter admin, the default administrative user that was created for your
autonomous transaction processing account. In the password field, enter the
administrator password you specified when you created your service instance.
The service console opens in the Overview mode. Click Administration to
switch to the Administration mode. Download a zip file containing the
security credentials and network configuration files to access your
instance. You're prompted to create a password for
the credential zip file. Enter a password and click Download to download the file.
Store the file and make note of the password. You will use the file and
password later to define a SQL Developer connection to your Autonomous
Transaction Processing database. Now you can define a SQL Developer
connection to the database in your Autonomous Transaction Processing
service. Click New Connection to open SQL Developer and define a connection.
Specify a connection name. Enter the database user name using the default
administrator database account, admin, that is provided as part of the service.
Enter the admin user's password that you or your cloud administrator specified
when creating the service instance. For connection type, select Cloud PDB. For the
configuration file, click Browse and select the client credentials zip file,
and if you're using a version of SQL Developer older than 18.2, there is a
Keystore Password field for entering the client credentials zip file password. For
the service select low, medium, or high. These service levels map to the low,
medium, and high consumer groups which provide different levels of performance
and concurrency. Click Connect to connect to your database.
Once you have connected SQL Developer to your Autonomous Transaction
Processing database, use a SQL Developer worksheet to define database
users. Autonomous Transaction Processing databases come with a predefined
database role named dwrole. This role provides the common privileges for a
database user.
For detailed steps on performing the example shown in this video, go to the
Oracle Learning Library and open the tutorial named Provisioning Autonomous
Transaction Processing.
Find out more at cloud.oracle.com/atp