8i | 9i | 10g | 11g | 12c | 13c | 18c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Articles » Vm » Here

Oracle Cloud : Autonomous Data Warehouse (ADW) - Create Service

This article provides a run through of creating a new Autonomous Data Warehouse (ADW) service on the Oracle Cloud.

The screens change a little with each quarterly release of Oracle Cloud. Even so, the screen shots in this article will give you a good idea of what is involved.

Related articles.

Create Autonomous Data Warehouse (ADW) Service

Log into Oracle Cloud and click the "Create Instance" link.

Autonomous Data Warehouse (ADW) : Dashboard

Click on the "Create" button in the "Database (OCI)" tile.

Autonomous Data Warehouse (ADW) : Create Instance

Open the menu by clicking the hamburger on the top-left of the screen.

Autonomous Data Warehouse (ADW) : Menu

Click on the "Autonomous Data Warehouse" menu option.

Autonomous Data Warehouse (ADW) : ADW Menu Item

Select the compartment you want to build the service in, then click the "Create Autonomous Data Warehouse" button.

Autonomous Data Warehouse (ADW) : OCI Dashboard

Enter the details of the service you want to create. The default sizes are 1 CPU core and 1TB of storage. Remember to select the appropriate licensing model. Click the "Create Autonomous Data Warehouse" button.

Autonomous Data Warehouse (ADW) : Creation Details

Wait while the service is provisioned. You will see the state is marked as "Provisioning".

Autonomous Data Warehouse (ADW) : Privisioning

Once the state changes to "Available", drill down into the service by clicking on the service name in the list.

Autonomous Data Warehouse (ADW) : Available

The details screen allows you to perform some basic operations with the service, including scale up/down, manual backups and restores from backups. Click on the "Service Console" button.

Autonomous Data Warehouse (ADW) : Details

Enter the credentials you specified during the service creation and sign in.

You are presented with the dashboard, which will look quite empty as the service has just been provisioned. Click the "Activity" button on the top-right of the screen.

Autonomous Data Warehouse (ADW) : Console

You are presented with the activity screen, which will look relatively quiet as the service has just been provisioned. Click the "Administration" button on the top-right of the screen.

Autonomous Data Warehouse (ADW) : Activity

The administration screen allows you to perform some basic administration of the service.

Autonomous Data Warehouse (ADW) : Administration

Connecting to the Autonomous Data Warehouse (ADW) Service Using SQL Developer

Go to the administration screen for the service and click the "Download Client Credentials" like.

Autonomous Data Warehouse (ADW) : Administration

Enter the password to protect the credentials store.

Autonomous Data Warehouse (ADW) : Download Credentials

Open SQL Developer and create a new connection. Use the username and password specified when you provisioned the service. Use a connection type of "Cloud PDB" and enter the zip file location and keystore password you associated with it. You can now click the "Test" or "Connect" button.

Autonomous Data Warehouse (ADW) : SQL Developer Connection

Connecting to the Autonomous Data Warehouse (ADW) Service Using SQL*Plus

If you want to use SQL*Plus or SQLcl you will need to do a bit of setup. Start by downloading the credentials zip file as described in the previous section.

Create a location for the wallet, place the zip file into it and unzip it.

mkdir -p /tmp/adw_wallet
cd /tmp/adw_wallet
# Download the credentials zip and place it in this new directory.
unzip wallet_OBADW.zip

Edit the "sqlnet.ora" file, specifying the correct wallet location.

cat > sqlnet.ora <<EOF
WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY="/tmp/adw_wallet")))
SSL_SERVER_DN_MATCH=yes
EOF

Set the TNS_ADMIN environment variable if you are using a non-standard location, as we are here.

export TNS_ADMIN=/tmp/adw_wallet

You should now be able to connect using the wallet by specifying one of the entries provided in the "tnsnames.ora" file from the zip.

sqlplus my_user/MyPassword123@obadw_high
impdp my_user/MyPassword123@obadw_high ....

Create a New User

Log into your ADW cloud service, as described above.

Create a new user and grant it the DWROLE role. You can grant other roles and privileges, but the code>DWROLE role will give the user access to the DBMS_CLOUD package.

--DROP USER my_user CASCADE;
CREATE USER my_user IDENTIFIED BY "MyPassword123";
GRANT dwrole TO my_user;

You can now connect to the user in a similar way to that described above.

For more information see:

Hope this helps. Regards Tim...

Back to the Top.