Use the Oracle Autonomous Data Warehouse cloud 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 Cloud Account page, enter your
cloud account name and click Next.
Enter your username and password. Click Sign In.
On the Oracle Cloud console click the navigation menu in the upper left to
show the top-level navigation choices. From the navigation pane, click
Autonomous Data Warehouse.
The console for Autonomous Database appears. You can use the
List Scope drop-down menu to select a compartment. In this example, the ADWCSQA
compartment is selected. Although this console shows that no data warehouses
have yet been created, if there were a long list of data warehouses you could
filter the list by using the Filters drop-down menu to filter the state of
the data warehouse (available, stopped, terminated, and so on.) You can also filter
the list by workload type (all workload types, only Autonomous Data Warehouse,
or only Autonomous Transaction Processing. Click Create Autonomous
Database.
In the Create Autonomous Database dialog, select Autonomous Data Warehouse as the workload type.
Select a compartment for the data warehouse from the drop-down list.
Enter a data warehouse display name for display purposes. Enter the database name.
Specify the number of CPUs for your service. Select your storage capacity in
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 Database.
The Create Autonomous Database dialog closes. On the console, the State field
indicates that the data warehouse is provisioning. When creation is completed
the State field changes from provisioning to available.
Once you have created the instance, download the credentials zip file for
client access to that instance. From the Autonomous Database Details page, click
DB Connection. 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. Some database clients require both the credentials wallet and the
password to connect to the database. SQL Developer 18.2 and later does not
require this password. Now you can define a SQL Developer
connection to the database in your Autonomous Data Warehouse cloud 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 Wallet. For
the configuration file, click Browse and select the client credentials zip file
downloaded from the Autonomous Data Warehouse cloud service. 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 Data Warehouse cloud
database, use a SQL Developer worksheet to define database users.
Autonomous Data Warehouse cloud databases come with a predefined
database role named "dwrole". This role provides the common privileges for a
data warehouse developer. For detailed steps on performing the
example shown in this video, go to the Oracle Learning Library and open the
tutorial named Provisioning Autonomous Data Warehouse Cloud.
Find out more at cloud.oracle.com/ datawarehouse