How To Scale Up/Down an Autonomous Database?

Hello,

I will describe how to scale your Autonomous Data Warehouse on demand by adding CPU cores or storage capacity.

1- Open the Oracle Cloud Infrastructure console
2- From the Oracle Cloud Infrastructure left navigation list click Autonomous Database.
3- On the Autonomous Databases page select an Autonomous Database instance from the links under the Name column.
4- From the Details page click Scale Up/Down

5- On the Scale Up/Down dialog box, select the change in resources for your scale request.
Click up arrow to select a value for CPU Core Count.
Click up arrow to select a value for Storage (TB).

Here if you want to enable auto scaling, select Auto Scaling. Select auto scaling to allow the system to automatically use up to three times more CPU and IO resources to meet workload demand, compared to the database operating with auto scaling disabled.

6- Click Update to change your resources.
7- the Lifecycle State changes to Scaling in Progress.

To see the average number of OCPUs used during an hour you can use the “Number of OCPUs allocated” graph on the Overview page on the Autonomous Data Warehouse service console.

Starting, Stopping, Restarting and Terminating an Autonomous Database

Hello,
In this blog post I will describe the necessary steps to start/stop/terminate an Autonomous Database.

To Start an Autonomous Data Warehouse;

1- Select the Oracle Cloud Infrastructure left navigation list click Autonomous Data Warehouse.
2- On the Autonomous Databases page select an Autonomous Data Warehouse instance from the links under the Name column
3- On the Details page, from the More Actions drop-down list, select Start. Start is only shown for a stopped instance.

4- Click Start to confirm

To Stop an Autonomous Data Warehouse

1- Select the Oracle Cloud Infrastructure left navigation list click Autonomous Data Warehouse.
2- On the Autonomous Databases page select an Autonomous Data Warehouse instance from the links under the Name column.
3- On the Details page, from the More Actions drop-down list, select Stop.

4- Click Stop to confirm.

To Restart an Autonomous Data Warehouse

1- Select the Oracle Cloud Infrastructure left navigation list click Autonomous Data Warehouse.
2- On the Autonomous Databases page select an Autonomous Data Warehouse instance from the links under the Name column.
3- On the Details page, from the More Actions drop-down list, select Restart.

4- In the confirmation dialog, select Restart to confirm.

To Terminate an Autonomous Data Warehouse

Terminating an Autonomous Data Warehouse database permanently deletes the instance and removes all automatic backups. So you cannot recover a terminated database.

1- Select the Oracle Cloud Infrastructure left navigation list click Autonomous Data Warehouse.
2- On the Autonomous Databases page select an Autonomous Data Warehouse instance from the links under the Name column.
3- On the Details page, from the More Actions drop-down list, select Terminate.

4- On the Terminate Database page enter the database name to confirm that you want to terminate the database. And click Terminate Autonomous Database button.

Connecting to an Oracle Autonomous Database Using SQL Developer

Hello,
In this blog post I want to describe how to connect to an Autonomous Database.

Applications and tools connect to Autonomous Databases by using Oracle Net Services (also known as SQL*Net). SQL*Net supports a variety of connection types to Autonomous Databases, including Oracle Call Interface (OCI), ODBC drivers, JDBC OC, and JDBC Thin Driver.

To support connections of any type, you’ll need to download the client security credentials and network configuration settings required to access your database. You’ll also need to supply the applicable TNS names or connection strings for a connection, depending on the client application or tool, type of connection, and service level. You can view or copy the TNS names and connection strings in the DB Connection dialog for your Autonomous Database.

Firstly let me download a wallet for an Autonomous Database on shared Exadata infrastructure.

1- Open the navigation menu. Under Database, click Autonomous Transaction Processing or Autonomous Data Warehouse.
2- Choose your Compartment.
3- In the list of Autonomous Databases, click on the display name of the database you are interested in.
4- Click DB Connection.

5-In the Download Client Credentials (Wallet) section, select the Wallet Type. You can choose to download an instance wallet or a regional wallet .

6- To obtain the client credentials, click Download Wallet. You will be prompted to provide a password to encrypt the keys inside the wallet. The password must be at least 8 characters long and must include at least 1 letter and either 1 numeric character or 1 special character. Save the client credentials zip file to a secure location

7-Take note of or copy the TNS names or connection strings you need for your connection.

8- Now, Open SQL Developer on your local computer. In the Connections panel, right-click Connections and select New Connection.

9- The New/Select Database Connection dialog appears. Enter the following information:

Connection Name – Enter the name for this cloud connection.
Username – Enter the database username .
Password – Enter the password.
Connection Type – Select Cloud Wallet.
Configuration File – Click Browse, and select the path to your local copy of the Client Credentials zip file, downloaded from the Autonomous Transaction Processing console by you, or given to you by your Autonomous Transaction Processing administrator.
Keystore Password –
If using SQL Developer 18.2.0 or newer: Starting with version 18.2.0, SQL Developer does not require that you enter a Keystore Password and does not provide the Keystore Password field.
If using a version of SQL Developer older than 18.2.0: Enter the password that was generated when you or your Autonomous Transaction Processing administrator downloaded the Client Credentials zip file from the Autonomous Transaction Processing console.
Service – In the drop-down menu, service selections are prepended with database names. Select the tpurgent, tp, high, medium, or low menu item for your database. These service levels map to the TPURGENT, TP, HIGH, MEDIUM and LOW consumer groups, which provide different levels of priority for your session.

10- Click Test. Status: Success displays at the bottom left of the New/Select Database Connection dialog.
11- Click Connect. An entry for the new connection appears under Connections.

Now you connected to Autonomous Transaction Processing Database.

Creating an Oracle Autonomous Container Database

Hello,
In this blog post I want to describe how to provision a new Autonomous Container Database using the Oracle Cloud Infrastructure Console. Container databases are only necessary for Autonomous Databases on dedicated Exadata infrastructure.
To create an Autonomous Container Database;
1- Open the navigation menu on the left side of page. Under Database, click Autonomous Transaction Processing or Autonomous Data Warehouse

2-Click Create Autonomous Container Database.

3-In the Create Autonomous Container Database dialog, enter the following database information:

Compartment: Specify the compartment in which the container database will be created.
Display Name: A user-friendly description or other information that helps you easily identify the resource. The display name does not have to be unique. Avoid entering confidential information.

4-Choose the Autonomous Exadata Infrastructure you wish to use to create your container database. We already created in previous post https://taliphakanozturken.wordpress.com/2020/04/02/creating-an-oracle-autonomous-exadata-infrastructure-resource/

5-You can select Advanced Options:

Tags – Optionally, you can apply tags.
Management – Optionally, you can specify the backup retention policy, which controls the length of time you retain backups in the Autonomous Container Database. The choices are 7 days, 15 days, 30 days, and 60 days. The default setting is 60 days.

6- Click Create Autonomous Container Database.

Signing Up for the Free Oracle Cloud Promotion

Hello,

Signing up for the Free Oracle Cloud Promotion is easy. You create an Oracle Cloud account, and then you get a welcome email with the details in 1-2 days.

1-Go to the  Oracle Cloud website. https://www.oracle.com/index.html

2- Click Oracle Cloud Free Tier, and then click Start for free button

3-Fill out the Sign Up for Free Oracle Cloud Promotion form( Country, email ,etc.). Provide a valid email address. Instructions about signing in to your new cloud account are sent to this address. If your email address is already associated with a cloud account, then you can click the link to get all your accounts associated with your email address.

Your email ID is also used to check if you are eligible for any special offers. If you are, then you’ll be prompted to select a special offer from a list of applicable offers.

4-Create a cloud account name, which is used to identify your cloud account.
Select a Home Region, where your services will be hosted.
Note:Your home region contains your account information and identity resources. It is not changeable after your tenancy is provisioned. If you are unsure which region to select as your home region, contact your sales representative before you create your account. Enter a valid cell phone number, so we can text you a verification code and click Next:Verify Mobile Number. VOIP or internet-only mobile numbers are not accepted. Your address is validated and displayed with corrections, if any. Confirm your address if prompted. Enter the SMS code you received on your phone and click Verify Code. If you already have a verification code, then follow the on-screen instructions to verify your phone number.
You can also request another code if you don’t receive a verification code soon.


5-Enter Password for your account.


6- Payment information. If you provided a credit card during sign-up, it was only used for verification and will not be charged unless you upgrade to a paid account. Note that usage during your promotional period is discounted


7- Accept the terms and conditions, and then click Complete Sign-Up to submit your request for a new Oracle Cloud account.

8-After the services in your tenancy are provisioned, you’ll be redirected to the login page and you’ll get a welcome (Get Started) email with your sign-in credentials.

Now,You can start using the console to create/manage/monitor instances.