Pular para o conteúdo

Create Autonomous Data Warehouse

Create Autonomous Data Warehouse

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

Log into Oracle Cloud and click the “Create Instance” link.

Create Autonomous Data Warehouse

Click on the “Create” button in the Autonomous Data Warehouse

image 35

Select the compartment you want to build the service in, then click the “Create Autonomous Database” button.

image 36

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 Database” button.

image 37
image 38
image 39

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

image 40

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.

image 41

You are presented with the dashboard, which will look quite empty as the service has just been provisioned. Click the “Activity” link on the left menu.

image 42

You are presented with the activity screen, which will look relatively quiet as the service has just been provisioned. Click the “Administration” link on the left menu.

image 43

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

image 44

Connecting to the Autonomous Data Warehouse Service Using SQL Developer

Go to the administration screen for the service and click the “Download Client Credentials (Wallet)”.

Enter the password to protect the credentials store.

image 45

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 Wallet” and enter the zip file location. You can now click the “Test” or “Connect” button.

image 46

Now all ready to use

image 47

Quão útil foi este post ?

Clique em uma estrela para classificar o post

nota média 5 / 5. Contagem de votos: 23

Sem votos ! Seja o primeiro a classificar !

Deixe um comentário

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

plugins premium WordPress