When creating a new database deployment on Oracle Database Cloud Service, you have option to choose whether you want to configure automatic backup or not. The options are as follows:

Both Cloud Storage and Local Storage

30 days worth of backups are kept and the 7 most recent days worth available directly on the compute node’s local storage.

Cloud Storage Only

30 days worth of backups are kept with all backups on cloud storage container.

None

No automatic Backup are configured

In this article we will demonstrate how to Create A Database Deployment with Automatic Backup configured using Create Service Wizard.

Prerequisites:

Oracle Account
Oracle Cloud Subscription
SSH Public/Private Key pair
Oracle Storage REST Endpoint

Steps to Create a Database Deployment

Open a web browser and enter the URL you received in the Welcome email to login to Oracle Cloud Account

Enter your username and password

Get the REST Endpoint by connecting to Container Classic. This REST Endpoint will be used when creating the Database Deployment.

Open the Service Console from the Database Server as show below

Click on “Create Service”

Fill in all the details and click Next

Service Name: Enter the service name, It only accepts hyphen (-) as special character
Description (optional): Enter a description on the service
Notification Email: To send the update on Instance creation
Service level: Oracle Database Cloud Service
Metering Frequency: Monthly or Hourly
Software Release: 11gR2, 12cR1 or 12cR2
Software Edition: Enterprise, standard, Enterprise Edition – Extreme performance or Enterprise Edition – High performance
Database Type: Single Instance, Single Instance with Data Guard, RAC, RAC with Data Guard, Hybrid DR

Once the information is filled, Click Next.

Fill in all the details

DB Name: This will be your container DB name
PDB Name: This will be your pluggable DB name
Administrator password: This will be your administrator password for users sys, system, dbaas_monitor and so on
Backup and Recovery Configuration: Cloud and Local, Cloud only or None
Compute Shape: select the configuration you need for your business
SSH Public Key: choose the public key you generated in steps

Once the information is filled, Click Next.

Review the Summary and click “Create”

At this moment the Service creation is in progress. Click on the Service Name

This page shows that the provisioning is in-progress. Click on Oracle Database Cloud Services to go back to the home page

The service has been created successfully

Up on the completion you will also receive the email that the service is created and is now available for use

Connect to the Compute node and verify the database.

Conclusion

In this article we have learned how to create a database deployment and configure automatic backups in Oracle Database Cloud Service.

Oracle DBCS : Create Virtual Image Database Deployment – Part 4

By Netsoftmate on

March 17, 2018

- Uncategorized

In previous articles Oracle DBCS: Create Virtual Image Database Deployment series we have learned how to:

Oracle DBCS : Create Virtual Image Database Deployment – Part 1

https://netsoftmate.blogspot.in/2018/02/oracle-dbcs-create-virtual-image-database-deployment.html

Oracle DBCS : Create Virtual Image Database Deployment – Part 2

https://netsoftmate.blogspot.in/2018/03/oracle-dbcs-create-virtual-image-database-deployment-part2.html

Oracle DBCS : Create Virtual Image Database Deployment – Part 3

https://netsoftmate.blogspot.in/2018/03/oracle-dbcs-create-virtual-image-database-deployment-part3.html

In this article we will learn the final step on how to Create a Database in Virtual Image Database Deployment.

Prerequisites

Create Virtual Image Database Deployment
Create Storage Volumes for Oracle Database Software and Database Files
Install Oracle Database Software

Step to Create a Database in Virtual Image Database Deployment:

Get the IP address of the Compute node you want to connect from Oracle Database Cloud Service Console. Here my Deployment Service Name is “NSM-DBaaS-VM” and the IP address is 144.21.72.128

On the left pane, expand “SSH” and select “Auth”. On the right pane, click on “Browse” button. Select the Private Key that matches the Public Key for your Deployment. Click “Open”

Enter login as “opc” user. You will be connected without prompting for the password. Switch to the “root” user and “oracle user”. Verify no database is running currently.

Login as oracle user and set Oracle Home, Oracle Base and PATH variable. Make sure Oracle Executable dbca is set in PATH correctly.

Start dbca in silent mode by providing the values on the command line as shown below:

Connect to the database and verify the status

Conclusion

In this article we have learned how to create a database in Virtual Image Database Deployment.

Oracle DBCS : Create Virtual Image Database Deployment – Part 3

By Netsoftmate on

March 17, 2018

- Uncategorized

In previous articles we have learned how to create Virtual Image deployment and Scale Up Storage Using Oracle Database Cloud Service and Create one storage volume for the Oracle Database software and one storage volume for all database files, and prepare them for use.

Oracle DBCS : Create Virtual Image Database Deployment – Part 1

https://netsoftmate.blogspot.in/2018/02/oracle-dbcs-create-virtual-image-database-deployment.html

Oracle DBCS : Create Virtual Image Database Deployment – Part 2

https://netsoftmate.blogspot.in/2018/03/oracle-dbcs-create-virtual-image-database-deployment-part2.html

In this article we will learn how to Install Oracle Database Software

Prerequisites

Create Virtual Image Database Deployment
Create Storage Volumes for Oracle Database Software and Database Files

Steps to Install Oracle Database Software in Virtual Image Database Deployment.

Get the IP address of the Compute node you want to connect from Oracle Database Cloud Service Console. Here my Deployment Service Name is “NSM-DBaaS-VM” and the IP address is 144.21.72.128

On the left pane, expand “SSH” and select “Auth”. On the right pane, click on “Browse” button. Select the Private Key that matches the Public Key for your Deployment. Click “Open”

Enter login as “opc” user. You will be connected without prompting for the password. Switch to the “root” user and “oracle user”

Login as oracle user, switch directory to /u01 and look for the zip file containing the Oracle Database software by displaying the contents of the /scratch/db directory. Extract the zip file into the current directory /u01

Ensure that the Oracle software is extracted correctly

Switch to root user and execute the set-up scripts as follows. Exit the session

Conclusion

In this article we have learned how to Install Oracle Database Software on a Virtual Image Database Deployment. Installing Oracle Software in VM Image deployment is very easy, you just need to locate the correct Oracle Software version and extract them in the correct directory.

Oracle DBCS : Create Virtual Image Database Deployment – Part 2

By Netsoftmate on

March 17, 2018

- Uncategorized

In previous article “Oracle DBCS : Create Virtual Image Database Deployment – Part 1” we have learned how to Create Virtual Image Database Deployment using Create Service Wizard.
https://netsoftmate.blogspot.in/2018/02/oracle-dbcs-create-virtual-image-database-deployment.html

In this article we will Scale Up Storage Using Oracle Database Cloud Service and Create one storage volume for the Oracle Database software and one storage volume for all database files, and prepare them for use. This will be the part 2 and continuation of the previous article.

Prerequisites
Create Virtual Image Database Deployment

Steps to Scale up Storage using Oracle Database Cloud Service Console in Virtual Image Database Deployment.

Open a web browser and enter the URL you received in the Welcome email to login to Oracle Cloud Account

https://myservices-xxxxx-xxxxxxxxxxef4b21bb7ee3b2cf4123d1.console.oraclecloud.com/mycloud/faces/dashboard.jspx

Enter your username and password

On the home page, Click “Menu” under “Database” Cloud Service as shown below

Click “Open Service Console”

Currently the Storage is 32GB. Let’s Scale Up the Storage. Click on the Instance Name

Click on the “Menu” icon and Select “Scale Up/Down”

I am adding addition 30GB storage. Click “Yes, Scale Up/Down Service”Here I am adding addition 30GB storage. Click “Yes, Scale Up/Down Service”

A message printed on the screen “Service scale up/down request is accepted”. The Instance status changed to “Service Maintenance”

After sometime we can see that the Storage is now Scale up to 62GB. Click on Instance to add more Storage

Click on the “Menu” icon and Select “Scale Up/Down”

This time I am adding addition 50GB storage. Click “Yes, Scale Up/Down Service”

A message printed on the screen “Service scale up/down request is accepted”. The Instance status changed to “Service Maintenance”

After sometime we can see that the Storage is now Scale up to 112GB.

Get the IP address of the Compute node you want to connect from Oracle Database Cloud Service Console. Here my Deployment Service Name is “NSM-DBaaS-VM” and the IP address is 144.21.72.128

On the left pane, expand “SSH” and select “Auth”. On the right pane, click on “Browse” button. Select the Private Key that matches the Public Key for your Deployment. Click “Open”

Enter login as “opc” user. You will be connected without prompting for the password. Switch to the “root” user

Display the list of block devices, the two volumes created are xvdc and xvdd

First format the volume for the Oracle Database software and mount it as /u01 as shown below

Now format the volume for the database files, and mount it as /u02 as shown below

Verify the mount points and display the block devices

Update the /etc/fstab file so new mount points get mounted automatically whenever the VM is rebooted

Conclusion

In this article we have learned how to Scale Up Storage using Oracle Database Cloud Service console and create storage volumes for Oracle Database Software and Database files.

Oracle DBCS : Create Virtual Image Database Deployment – Part 1

By Netsoftmate on

February 12, 2018

- Uncategorized

When you create an Oracle Database Cloud Service – Virtual Image Database Deployment, the following tasks are completed for you:

Compute Allocated
Storage Allocated
Virtual Machine Image Installed
Included software to create Oracle Database

You are responsible for Connecting to VM, create Database, perform maintenance operations such as Backup , Patching and Upgrade.

Note that Oracle Database 12c Release 2 (12.2) is not available for Oracle Database Cloud Service – Virtual Image service level.

When you create a database deployment on Oracle Database Cloud Service using the Virtual Image service level, Oracle Database software is not automatically installed and no database is created. You must perform these steps manually after the deployment is created.

To create a database on a Virtual Image Database Deployment, you perform these tasks:

Create Virtual Image Database Deployment service level
Create storage volumes for the Oracle Database software and for the database files, and then format and mount them
Stage the Oracle Database software on the mount point you created for it
Create a database and start the database instance
Start the listener for the database instance

In this article we will demonstrate how to Create Virtual Image Database Deployment using Create Service Wizard.

Prerequisites

Oracle Account
Oracle Cloud Subscription
SSH Public/Private Key pair

Steps to Create Virtual Image Database Deployment

Open a web browser and enter the URL you received in the Welcome email to login to Oracle Cloud Account

https://myservices-xxxxx-xxxxxxxxxxef4b21bb7ee3b2cf4123d1.console.oraclecloud.com/mycloud/faces/dashboard.jspx

Enter your username and password

On the home page, Click “Menu” under “Database” Cloud Service as shown below

Click “Open Service Console”

Click on “Create Service”

Fill in all the details and click Next

Service Name: Enter the service name, It only accepts hyphen (-) as special character
Description (optional): Enter a description on the service
Notification Email: To send the update on Instance creation
Service level: Oracle Database Cloud Service
Metering Frequency: Monthly or Hourly
Software Release: 11gR2 or 12cR1
Software Edition: Enterprise, standard, Enterprise Edition – Extreme performance or Enterprise Edition – High performance
Database Type: Single Instance, Single Instance with Data Guard, RAC, RAC with Data Guard, Hybrid DR

Select Compute Shape (CPU and Memory for your deployment). Click “Edit” beside “SSH Public Key” box

Click on the radio button and click browse

Select the Public Key from your desktop/laptop

Click Enter button

Click Next

Review the details for deployment and click “Create”

We can see that the deployment is being created. Click on the Instance name “NSM-DBaaS-VM”

The status shows “Creating Service…”

We can see that the status is “Ready”

Virtual Image Database Deployment “NSM-DBaaS-VM” is now ready.

You will also receive a confirmation email whent the service is created

Enter the IP address of the Compute Node

On the left pane, expand “SSH” and select “Auth”. On the right pane, click on “Browse” button. Select the Private Key that matches the Public Key for your Deployment. Click “Open”

Click Yes

Login as opc user, switch to root user, Switch to Oracle user and check if any database instance is running. With Virtual image database deployment database is not created by default

Check the file systems. We can see that no users files systems are created. You need to allocate extra storage and create the users file systems.

Conclusion

In this article we have learned how to Create Virtual Image Database Deployment using Create Service Wizard. When you create an Oracle Database Cloud Service – Virtual Image Database Deployment, Compute Allocated, Storage Allocated Virtual Machine Image Installed and Included software to create Oracle Database. You are responsible for Connecting to VM, create Database, perform maintenance operations such as Backup , Patching and Upgrade.

Oracle DBCS : Restart An Oracle Database Cloud Service Database Deployment

By Netsoftmate on

February 9, 2018

- Uncategorized

You made some configuration changes to the Oracle Cloud Compute Node and it requires a restart/reboot take affect.

In this article we will demonstrate how to restart a Database Cloud Service Database Deployment.

Steps to Restart a Database Cloud Service Database Deployment.

Method 1:

Open a web browser and enter the URL you received in the Welcome email to login to Oracle Cloud Account

Enter your username and password

On the home page, Click “Menu” under “Database” Cloud Service as shown below

Click “Open Service Console”

On the this page, Click “Menu” as shown

Click “Restart” from the list

Click “OK” to confirm

A message displays that the restart request is accepted. Click on Instance name “NSM-DBaaS”

We can see that the status has changed to “Service Maintenance..”

We can now see that the status has changed to Ready”. This completed the restart process

Method 2

Open PuTTY session on your desktop and enter Compute Node IP address

On the left pane, expand “SSH” and select “Auth”. On the right pane, click on “Browse” button. Select the Private Key that matches the Public Key for your Deployment. Click “Open”

Wait for few minutes and execute steps 1 and 2 above.

Switch to oracle user and start the databsae if it not started already

Verify the database status. This completed the restart process

Conclusion

In this article we have learned how to restart a Database Cloud Service Database Deployment.

Oracle DBCS : Start An Oracle Database Cloud Service Database Deployment

By Netsoftmate on

February 7, 2018

- Uncategorized

You want to start a Database Cloud Service Database Deployment after completing your maintenance work. When you start a database deployment, you can access it again and can perform any management operations.

Starting a database deployment is very simple and it is similar to powering on a computer or laptop.

When database deployment is started, its CPU and RAM are allocated. As a result, it consumes OCPU and memory resources and so metering and billing of these resources are started.

In this article we will demonstrate how to start a Database Cloud Service Database Deployment.

Steps to Start a Database Cloud Service Database Deployment.

Open a web browser and enter the URL you received in the Welcome email to login to Oracle Cloud Account

Enter your username and password

On the home page, Click “Menu” under “Database” Cloud Service as shown below

Click “Open Service Console”

On the this page, Click “Menu” as shown

Click “Start” from the list

Click “OK” to confirm

A message displays that the start request is accepted

We can see that the status has changed to “Service Maintenance”. Click on Instance name “NSM-DBaaS”

We can see that the status is still under “Service Maintenance..”

We can now see that the status has changed to Ready”

Open PuTTY session on your desktop and enter Compute Node IP address

On the left pane, expand “SSH” and select “Auth”. On the right pane, click on “Browse” button. Select the Private Key that matches the Public Key for your Deployment. Click “Open”

Conclusion

In this article we have learned how to start a Database Cloud Service Database Deployment. Starting a database deployment is very simple and it is similar to powering on a computer or laptop. When database deployment is started, its CPU and RAM are allocated. As a result, it consumes OCPU and memory resources and so metering and billing of these resources are started.

Oracle DBCS : Stop An Oracle Database Cloud Service Database Deployment

By Netsoftmate on

February 6, 2018

- Uncategorized

You want to stop a Database Cloud Service Database Deployment as you are not using it or for some maintenance work. When you stop a database deployment, you can’t access it and can’t perform any management operations other than starting or deleting the Database Deployment.

Stopping a database deployment is very simple and it is similar to powering off a computer or laptop.

It is important to note that when database deployment is stopped, its CPU and RAM are stopped. As a result, it consumes no OCPU or memory resources and so metering and billing of these resources stop. However, all the other resources of the database deployment continue to exist and so continue to be metered and billed, including.

In this article we will demonstrate how to stop a Database Cloud Service Database Deployment.

Steps to Stop a Database Cloud Service Database Deployment

Open a web browser and enter the URL you received in the Welcome email to login to Oracle Cloud Account

Enter your username and password

On the home page, Click “Menu” under “Database” Cloud Service as shown below

Click “Open Service Console”

On the this page, Click “Menu” as shown

Click “Stop” from the list

Click “OK” to confirm

A message displays that the stop request is accepted

We can see that the status has changed to “Service Maintenance..”. Click on Instance name “NSM-DBaaS”

We can see that the status is still under “Service Maintenance..”. Under Overview section it says “Stopping service..”

We can now see that the status has changed to “Service Stopped”

Open PuTTY session on your desktop and enter Compute Node IP address

On the left pane, expand “SSH” and select “Auth”. On the right pane, click on “Browse” button. Select the Private Key that matches the Public Key for your Deployment. Click “Open”

Connection timed out. It means that the server is down and not accessible

Conclusion

In this article we have learned how to stop a Database Cloud Service Database Deployment. When database deployment is stopped, its CPU and RAM are stopped. As a result, it consumes no OCPU or memory resources and so metering and billing of these resources stop. However, all the other resources of the database deployment continue to exist and so continue to be metered and billed, including.

Oracle DBCS : Configure and Use VNC (GUI) On Oracle Cloud Compute Node

By Netsoftmate on

February 5, 2018

- Uncategorized

When you create a Database Deployment in Oracle Database Cloud Service, the following tasks are completed for you:

Compute Node Allocated
Storage Allocated
Virtual Machine Image Installed
Set Keys and Privileges
Install and Configure Database
Configure Backup
Configure Tools
Configure Access

Network access to the Compute Node associated with Oracle Database Cloud Service is primarily provided by SSH connections on port 22. By default SSH port 22 is opened to allow access to the tools, utilities and other resources on the Compute Node associated with the Oracle Database Cloud Services. You can use SSH client software such as PuTTY on Windows to establish a secure connection and log in as “opc” or “oracle” user. You can also connect to Compute node using GUI interface, for this you can use VNC.

In this article we will demonstrate how to connect to Compute Node using VNC.

Prerequisites

IP address of Compute Node
TigerVNC Viewer client software
TigerVNC Server package installed on Compute Node

Steps to connect to Oracle Database Cloud Compute Node using VNC on Windows Operating System

Open PuTTY session on your desktop and enter Compute Node IP address

On the left pane, expand “SSH” and select “Auth”. On the right pane, click on “Browse” button. Select the Private Key that matches the Public Key for your Deployment. Click “Open”

Enter login as “opc”. This will connect you to the compute node without password

Switch to root by executing “sudo -s” command. Confirm that you are switched to root by executing “id” command

Verify your Operating System version. Here the OS is OEL and version is 6 with update 8

Navigate to the yum repository directory and open the public yum repository file

In the file look for your operating system version, example ol6_latest and make sure “enabled=1” is set

Next look for operating system base update, example ol6_u8_base and make sure “enabled=1” is set

Verify the file is updated successfully

Install the Tigervnc* package using the yum utility

Type y and hit return

We can see that the package installation completed successfully

Verify that the package is installed using rpm -qa command

Verify if vnc server is running or not as root and oracle user. We can see that vnc server is not running

Let’s start the vnc server as oracle users. Enter a password of your choice and verify. From the ‘ps -ef|grep vnc’ command output note down the port numbers :1 and 5901

Open Tiger VNC Viewer on your desktop/laptop and enter the port :1

Connection failed…. This is because the port 5901 is not opened on the Compute Node. We should open the port 5901 and try again

Follow the procedure below to configure custom Security List and Rules to enable access to specific security applications (VNC application and port range 5901 – 5905) on the compute node.

Open a web browser and enter the URL you received in the Welcome email to login to Oracle Cloud Account

Enter your username and password

On the home page, Click “Menu” under “Compute Classic” Cloud Service as shown below

Click “Open Service Console”

Click on “Network”

Expand “Shared Network”

Click “Security Applications” and then “Create Security Application”

Enter a Security Application Name, Port Type, Port Range Start, Port Range End and a Description and click Create. In our scenario we are enabling access to VNC application on the ports between 5901 and 5905

Make sure the Security Application is created by searching it

Click “Security Lists” and then “Create Security List”

Enter Security List Name and leave Inbound Policy and Outbound Policy to DEFAULT value and click Create

Make sure the Security List is created by searching it

Click “Security Rules” and then “Create Security Rule”

Enter the details as show below:

Name: Any desired meaningful name
Status: Enabled to enable the rule
Security Application: we create above
Source: Security IP List -> public-internet
Destination: select security list created above from drop down
Click Create

Make sure the Security Rule is created by searching it

Click “Instances”

Select your Instance and scroll down

Click “Add Security List”

Select “Security List” create above from the drop down list

Make sure the Security List added to your Instance

Open VNC on your desktop/Laptop and enter the IP address of your Database Deployment

Enter VNC password used at the time of starting VNC server software on the compute node

Enter Oracle user password given at the time of configuring VNC Server to connect to the Compute node

We are now connected to the compute node in GUI interface using VNC

Enjoy working with Compute Node in GUI mode…

Conclusion
In this article we have learned how to connect to Oracle Cloud Compute Node using VNC in GUI Mode. To accomplish this we need to install Operating System packages and create custom Security List and Rules to enable access to specific security applications (VNC application and port range 5901 – to 5905) on the compute node. Oracle Compute Cloud Service networking create resources to provide network access to the compute node.

Oracle DBCS : Installing Operating System Packages or RPMs

By Netsoftmate on

February 1, 2018

- Uncategorized

When you create a database deployment in Oracle Database Cloud Service, a Compute node is created with a virtual machine image installed and the necessary operating system users are created. You can use the opc users to login to the compute node and execute root command by switching to root user. Since you have access to the compute node and root users access you can install the operating system packages based on your business needs.

In this article we will demonstrate how to install operating system packages on a Oracle Cloud Compute Node.

Steps to Install Operating System Packages

Open PuTTY session on your desktop and enter Compute Node IP address

On the left pane, expand “SSH” and select “Auth”. On the right pane, click on “Browse” button. Select the Private Key that matches the Public Key for your Deployment. Click “Open”

Enter login as “opc”. This will connect you to the compute node without password

Switch to root by executing “sudo -s” command. Confirm that you are switched to root by executing “id” command

Verify that the packages you want to install already exist or not. Here I am installing, tigervnc, gedit, firefox, desktop and gnome system monitor packages

Verify your Operating System version. Here the OS is OEL and version is 6 with update 8

Navigate to the yum repository directory and open the public yum repository file

In the file look for your operating system version, example ol6_latest and make sure “enabled=1” is set

Next look for operating system base update, example ol6_u8_base and make sure “enabled=1” is set

Verify the file is updated successfully

Install the package using the yum utility. Here I am installing gedit package

Type y and hit return

We can see that the package installation completed successfully

Verify that the package is installed using rpm -qa command

Let’s install Tigervnc package

Similarly install the required packages and verify that they are installed successfully

Conclusion

In this article we have learned how to install Operating System packages on the Oracle Cloud Compute node.

PREVIOUS POSTSPage 1 of 3NO NEW POSTS

Good Contents Are Everywhere, But Here, We Deliver The Best of The Best.Please Hold on!

Home

About

Services

Blog

Contact

Oracle DBCS : Create A Database Deployment With Automatic Backup

Oracle DBCS : Create Virtual Image Database Deployment – Part 4

Oracle DBCS : Create Virtual Image Database Deployment – Part 3

Oracle DBCS : Create Virtual Image Database Deployment – Part 2

Oracle DBCS : Create Virtual Image Database Deployment – Part 1

Oracle DBCS : Restart An Oracle Database Cloud Service Database Deployment

Oracle DBCS : Start An Oracle Database Cloud Service Database Deployment

Oracle DBCS : Stop An Oracle Database Cloud Service Database Deployment

Steps to Stop a Database Cloud Service Database Deployment

Oracle DBCS : Configure and Use VNC (GUI) On Oracle Cloud Compute Node

ABOUT US

Services

CONTACT US

Follow Us!