Monday , January 30 2023

Oracle Cloud Database As A Service

In today’s article, we will create an Instance for Oracle Database 18C, which provides automatic recovery and automatic performance without any outside intervention.

“Oracle Database”, which is one of the important structures of Oracle company, also appears with different features on cloud technologies.

Although controversial, Oracle Database 18C, which introduces itself as the world’s first autonomous database, runs its infrastructure entirely on the cloud and provides services to us by providing stable use.

It positions itself in a different lane with ambitious definitions such as higher security, accessibility and performance, while automating the processes such as patching, which is the fearful dream of all of us.

If you do not have an Oracle Cloud account, you can open a free trial account for a period of time by using the address below.

To create an instance for Oracle Database 18C, we will first need an SSH Key. I create a key by connecting to my Oracle Linux operating system with Putty.

During key creation, you can enter any password you want, which will ask me for a password. I set my password as “Cozumpark”.

After entering my password 2 times, SSH key will be created automatically.

Now I enter my new permission parameters with “chmod 600 myOracleCloudKey*”.

Our work with Putty is complete for now.

I will now continue from my Oracle Cloud screen.

I connect to the cloud service from the address “https://cloud.oracle.com/tr_TR/sign-in” and from there I connect to the “Database” screen.

On the screen that opens, we will say “Create Instance” as you can see in the picture.

clip_image007

One of the biggest benefits of doing the operations on the cloud is to be able to easily choose which version of the database we will set up.

Normally, they all mean a separate license fee.

In the cloud, this is flexible. As seen in the picture below, we will proceed to the next step by filling in the relevant fields.

Service Level: Oracle Database Cloud Service

Metering Frequency: How the payments will be part, can be optional at the selected hourly here.

Software Resease: Currently, Oracle Database 18C is selected, but you can test from 11gR2, 12cR1, 12cR2 options.

Software Edition: Enterprise Edition is selected, but you can choose one of the Standard Edition, Enterprise Edition, Enterprise Edition – High Performance, Enterprise Edition – Extreme Performance versions.

This is the part that affects the costs the most.

On this screen, we enter our database properties. How many processors will the database run on, what will be the memory, and most importantly, what will the database name be.

As you can see there is a line named PDB(PDB = Pluggable Database) here. This issue came into our lives with Oracle Database 12C.

It’s different from Container Database. Apart from that, we continue by filling out the information as in the example below.

clip_image009

it gives us a summary of our actions. In this step, if everything is ok for you, we say “Create” and we create our database.

Our database will be created in 3-7 minutes. It gives us the current status information on the screen below.

clip_image011

And our database was created.

clip_image012

It seems that we can easily perform administrative operations such as stopping, restarting our database or using the Enterprise Manager console.

clip_image013

We can also see the general status of our database by entering it.

clip_image014

If we want to connect to our database remotely with Putty, you can connect with the command below where we created our SSH ke file.

We can quickly create and manage our test databases. In my opinion, using cloud technologies now yields very smart and effective results.

This product, which makes you think deeply about the future of database management, is sure to always be on the side as an alternative if data backup and performance issues are examined.

 

Buğra PARLAYAN
Author: Buğra PARLAYAN

Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical / relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat & Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.

About Buğra PARLAYAN

Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical / relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat & Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.

Leave a Reply

Your email address will not be published. Required fields are marked *