Tag: Oracle Cloud

Step-by-step Guide of Exadata Snapshot Based Backup of Compute Node to NFS Share

Backing up file systems on Oracle Exadata compute can be a daunting task if you are unaware of the prerequisites and best practices. To help you backup your file systems effectively and with least discrepancies, we are bringing you this interesting step-by-step guide on how to back up your file system using Oracle Exadata Sanpshot Based Backup of Compute Node to NFS Share

It is very important to take file system backup on Oracle Exadata compute nodes before we make any major changes to the operating system or critical software. On Oracle Exadata Compute nodes / (root) and /u01 file systems contains the operating system and GI/DB software respectively. These are the most critical file systems on Oracle Exadata computes.

By default, the / (root) and /u01 file system are sized 30GB and 100GB respectively.

Scenarios in which we must take file system backup are:

– Operating System Patching or Upgrade
– Grid Infrastructure Patching or Upgrade
– Database Patching or Upgrade
– Operating System configuration changes
– Increasing/decreasing file system size

In this article, we will demonstrate how to backup file system on Oracle Exadata Compute nodes running Linux Operating System to external storage NFS Share.

Environment Details

Exadata Model	X4-2 Half Rack HP 4 TB
Exadata Components	4 – Compute nodes, 7 – Storage cells & 2 – IB switches
Exadata Storage cells	DBM01CEL01 – DBM01CEL07
Exadata Compute nodes	DBM01DB01 – DBM01DB04
Exadata Software Version	19.2.3.0
Exadata DB Version	11.2.0.4.180717

Prerequisites

– Root user access on Compute nodes
– NFS mount with sufficient storage to storing file system backup

Current root and /u01 file system sizes

[root@ip01db01 ~]# df -h / /u01

Filesystem Size Used Avail Use% Mounted on

/dev/mapper/VGExaDb-LVDbSys1 59G 39G 18G 70% /

/dev/mapper/VGExaDb-LVDbOra1 197G 171G 17G 92% /u01

NFS share details

10.10.10.1:/nfs/backup/

1. As root user, log in to the Exadata Compute node you wish to backup

[root@ip01db01 ~]# id root

uid=0(root) gid=0(root) groups=0(root),1(bin),2(daemon),3(sys),4(adm),6(disk),10(wheel)

2. Create a mount point to mount NFS share

[root@dm01db01 ~]# mkdir -p /mnt/backup

[root@dm01db01 ~]# mount -t nfs -o rw,intr,soft,proto=tcp,nolock 10.10.10.1:/nfs/backup/ /mnt/backup

3. Determine the file system type extension root and u01 file system

[root@ip01db01 ~]# mount -l

sysfs on /sys type sysfs (rw,relatime)

proc on /proc type proc (rw,relatime)

devtmpfs on /dev type devtmpfs (rw,nosuid,size=131804372k,nr_inodes=32951093,mode=755)

securityfs on /sys/kernel/security type securityfs (rw,nosuid,nodev,noexec,relatime)

tmpfs on /dev/shm type tmpfs (rw,size=264225792k)

/dev/mapper/VGExaDb-LVDbSys1 on / type ext3 (rw,relatime,errors=continue,barrier=1,data=ordered) [DBSYS]

/dev/mapper/VGExaDb-LVDbOra1 on /u01 type ext3 (rw,nodev,relatime,errors=continue,barrier=1,data=ordered) [DBORA]

/dev/sda1 on /boot type ext3 (rw,nodev,relatime,errors=continue,barrier=1,data=ordered) [BOOT]

4. Note down the file system type for root and /u01: ext3. Take a snapshot-based of the root and u01 directories, Label the snapshot and Mount the snapshot

[root@dm01db01 ~]# lvcreate -L5G -s -n root_snap /dev/VGExaDb/LVDbSys1

Logical volume “root_snap” created.

[root@dm01db01 ~]# lvcreate -L5G -s -n u01_snap /dev/VGExaDb/LVDbOra1

Logical volume “u01_snap” created.

[root@dm01db01 ~]# e2label /dev/VGExaDb/root_snap DBSYS_SNAP

[root@dm01db01 ~]# e2label /dev/VGExaDb/u01_snap DBORA_SNAP

[root@dm01db01 ~]# mkdir -p /mnt/snap/root

[root@dm01db01 ~]# mkdir -p /mnt/snap/u01

[root@dm01db01 ~]# mount /dev/VGExaDb/root_snap /mnt/snap/root -t ext3

[root@dm01db01 ~]# mount /dev/VGExaDb/u01_snap /mnt/snap/u01 -t ext3

[root@dm01db01 ~]# df -h /mnt/snap/root

[root@dm01db01 ~]# df -h /mnt/snap/u01

5. Change to the directory for the backup and Create the backup file

[root@dm01db01 ~]# cd /mnt/backup

[root@dm01db01 ~]# tar -pjcvf /mnt/backup/mybackup.tar.bz2 * /boot –exclude /mnt/backup/mybackup.tar.bz2 > /tmp/backup_tar.stdout 2> /tmp/backup_tar.stderr

6. Monitor the /tmp/backup_tar.stderr file for errors. Errors such as failing to tar open sockets can be ignored.

7. Unmount the snapshots and remove the snapshots for the root and /01 directories.

[root@dm01db01 ~]# cd /

[root@dm01db01 /]# umount /mnt/snap/u01

[root@dm01db01 /]# umount /mnt/snap/root

[root@dm01db01 /]# df -h /mnt/snap/u01

[root@dm01db01 /]# df -h /mnt/snap/root

[root@dm01db01 /]# ls -l /mnt/snap

[root@dm01db01 /]# rm -rf /mnt/snap

[root@dm01db01 /]# lvremove /dev/VGExaDb/u01_snap

Do you really want to remove active logical volume u01_snap? [y/n]: y

Logical volume “u01_snap” successfully removed

[root@dm01db01 /]# lvremove /dev/VGExaDb/root_snap

Do you really want to remove active logical volume root_snap? [y/n]: y

Logical volume “root_snap” successfully removed

8. Unmount the NFS share

[root@dm01db01 /] umount /mnt/backup

Repeat the above steps on the remaining compute nodes to backup root & u01 file system

We hope this article helps you smoothly backup your file system on Oracle Exadata Compute node running Oracle Linux using NFS Share. Stay tuned for more step-by-step guides on implementing and using Oracle Database Systems exclusively on Netsoftmate

Netsoftmate provides the best standard services when it comes to Oracle databases management, covering all comples database products. Sign-up for a free 30 minutes call by clicking on the link below –

Click here and fill the contact us form for a free 30 minutes consultation

February 1, 2020

Here’s Everything You Need to Know About Oracle Autonomous Database Cloud
- What is Oracle Autonomous Database?
  
  Oracle Autonomous Database allows you rapidly & easily create mission critical databases, It protects data from both external and internal threats, automates all infrastructure & database maintenance, recovers from any failure without downtime and scales online for highest performance & lower cost.
  
  Components of Oracle Autonomous Database:
  
  An Oracle Autonomous database comprises of 3 components:
  
  Oracle Exadata
  Oracle database
  Automated Data Center Operations and Machine Learning
  
  How Does Oracle Database Works:
  
  An Oracle Autonomous Database is self driving, self securing and self repairing.
- Self Driving: It Automates all databases and infrastructure management, Patching, tune Queries and Monitoring
- Self Securing: Protects database from both external and malicious internal users by automatically encrypting data both at rest and in transit
- Self Repairing: Automatically recover from any failure. Protects from all downtime including planned maintenance
  
  Machine Learning:
  
  Automation built up on the revolutionary machine learning platform enables the Customers with greater database autonomy and capabilities.
- Workload Optimization: Automatically adapts to the changing workload and optimization of query execution. So Customers doesn’t have to tune queries manually.
- Monitoring & Diagnostics: Detects anomalies and fixes issues ensuring optimal performance and availability. So Customers doesn’t have to install or waiting for monitoring and alerting notification.
- Security: Protects database from both external attacks and malicious internal users by automatically encrypting data and apply security updates.
  
  Oracle Autonomous Database Family:
- Oracle Autonomous Data Warehouse (ADW): It is optimized for Data Warehouse, Data Mart & Data lake. Easy provision, connect, load data and execute queries.
- Oracle Autonomous Transaction Processing (ATP): It is optimized for Transaction processing, batch, Report, Mixed workload, IoT & Application Development. Easy provision, connect, load data and execute queries.
- Benefits of Autonomous Database:
- Fast Provisioning: Create the database in minutes, load data & execute queries
- Autonomous: Automatically tune queries without DBA intervention
- Extreme Performance: Run Oracle workload up to 13x faster on Oracle Exadata
  
  Steps to create an Autonomous Database:
  
  It just takes 4 steps to create an Autonomous Database (DW, Data mart or OLTP) and in few minutes the customers can have Autonomous database ready to connect and load data and start using it.
  
  Migrating to Oracle Autonomous Database:
- Oracle Database is same in the cloud as on-premises. You can move it to the cloud without having to change application code.Quickly obtain environments for testing and development. Take on-premises data, move onto the cloud storage for fast analysis, backup or archiving. Get an enterprise production ready database in minutes for fast migration to cloud. Tuning, patching, backup, disaster recovery, high availability for them automatically.
  
  Oracle Autonomous database Security Capabilities:
- Autonomous database automatically applies patches and upgrades eliminating human error, keeping the system protected. Oracle Database Vault protects the database from internal administrator access, allows administrators to perform their job, but not access the data itself. By default, Oracle Autonomous database uses TDE to protect data at rest. It also protects data in transit when the client uses SSL/TLS 1.2.
  
  Oracle Autonomous Database Deployment option:
- Autonomous Database Serverless: Simple & Elastic. Oracle automates and manages everything. You just choose the compute , storage and region. Start with minimum 1 OCPU & 1 hour minimum commitment time and Instantly grow or shrink online.
- Autonomous Database Dedicated: Provides a Private database cloud running on a dedicated Exadata cloud infrastructure in the Public cloud. Highly isolated and Customizable operation policies. Available as Cloud at Customer solution.
  
  Which Autonomous Database Deployment is best for me?
  
  Regardless of which Autonomous Database deployment you chose you will get the same great features, functionality, security and performance you have grown to expect from the Oracle Database.
  
  For users that are simply looking for a database for a specific application or project and don’t want to be involved in choosing any database details like versions, patching, etc., Serverless is right choice. Whereas users that want to rethink their IT strategy and care about things like patching schedules, software versions, workload isolation, and want to be involved in choosing these, then Dedicated is the right choice.
  
  Conclusion:
  
  In this article we have learned about Oracle Autonomous database cloud, its components, benefits and capabilities and different autonomous database deployment options available.
July 10, 2019
Steps to Deploy Exadata Database Machine on Oracle Cloud Infrastructure
In this article we will demonstrate quick steps to deploy Exadata Database Machine in Oracle Cloud Infrastructure (OCI).

Prerequisites:
- Exadata Cloud Subscription
- Credentials to Login Oracle Cloud
- Access to Deploy Exadata in OCI
- Compartment
- VCN & Subnet
Steps to Deploy Exadata on OCI
- Open a browser and enter the URL you have received from Oracle to connect to the Oracle Cloud
- Enter your Oracle Cloud credentials
- Click on “Create Instance”
- Click on “All Services” and search for Exadata keyword. Click on Create.
- Select your “Compartment” on left and Click on “Launch DB System”
- Enter the details as per your requirement and the Exadata subscription procured
- Browse and upload the public key
- Choose your desired storage allocation and timezone
- Fill in the required VCN and Subnet details. Work with your network engineer to gather the correct details on VCN and Subnet created for your environment
- Fill the database details, name, version, CDB and Password
- Select the Workload type and database character set for your database
- Optionally specify the TAG Key and click “Launch DB System” to deploy Exadata DBM
Conclusion

In this article we have learned how to deploy an Exadata Database Machine in Oracle Cloud Infrastructure (OCI).
April 25, 2019
Oracle DBCS : Create A Database Deployment With Automatic Backup
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
Once the information is filled, Click Next.
- Fill in all the details
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.
January 22, 2019
Oracle DBCS : Create Virtual Image Database Deployment – Part 4
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.
March 17, 2018
Oracle DBCS : Create Virtual Image Database Deployment – Part 3
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.
March 17, 2018
Oracle DBCS : Create Virtual Image Database Deployment – Part 2
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.
March 17, 2018
Oracle DBCS : Create Virtual Image Database Deployment – Part 1
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:
1. Create Virtual Image Database Deployment service level
2. Create storage volumes for the Oracle Database software and for the database files, and then format and mount them
3. Stage the Oracle Database software on the mount point you created for it
4. Create a database and start the database instance
5. 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.
February 12, 2018
Oracle DBCS : Restart An Oracle Database Cloud Service Database Deployment
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”
- Login as opc user, switch to root user, check uptime and issue reboot command.
Wait for few minutes and execute steps 1 and 2 above.
- Login as opc user, switch to root user, check uptime and Verify the databsae and listener status
- 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.
February 9, 2018
Oracle DBCS : Start An Oracle Database Cloud Service Database Deployment
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”
Login to the Oracle Cloud Compute Node to verify that the server is not accessible.
- 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”
- Login as opc user, check uptime and verify the database status
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.
February 7, 2018