Good Contents Are Everywhere, But Here, We Deliver The Best of The Best.Please Hold on!
Database Management Services, Oracle Exadata, Oracle Exadata X8M, Remote Database Management

If you are looking for highest levels of database performance for your Oracle database then, Oracle Exadata is an outstanding solution. It delivers finest performance for mixed data, data warehousing (DW), analytics, and OLTP (online transaction processing) workloads. Enriched with a variety of deployment options, it lets you run your Oracle Database and other data workloads anywhere you need, whether its on-premises or in the Oracle Cloud. Oracle Exadata storage provides a cutting-edge technology which is simple to use, manage and provides mission-critical accessibility and reliability. Here are 5 reasons stating why should you run the Oracle Database on Oracle Exadata.


5 Reasons Why you Should Run Your Oracle Database on Oracle Exadata | Netsoftmate


1. Bespoke for Oracle Database


Following a standard approach to build your database infrastructure will hamper your business growth. With time, databases grow, which means, your business needs more servers, more storage solutions and more labor to manage it. As a result, the management cost will go up and there is a huge exposure to risk of errors, ultimately hampering your business growth. That’s why each business, big or small, needs a new approach that’s engineered to cater the critical database workloads.
The only technique to handle these critical database workloads is through Oracle Exadata. It is specially equipped to provide high storage bandwidth to seamlessly manage the Oracle Database and other data workloads. Oracle Exadata, as a part of Oracle Engineered System offers a highly integrated platform that delivers more power with less hardware. It eliminates the IT complexity while supplying greater performance, scalability, security and data protection.


5 Reasons Why you Should Run Your Oracle Database on Oracle Exadata | Netsoftmate


2. Increase Employee Productivity


Timely delivery of persuasive data that supports business operations and lessens the time required to deliver new business applications will surely result in better revenue. Oracle Exadata’s congregated and optimized infrastructure platform for database workloads helps the IT staff to spend less time on everyday operations and work more towards other IT development efforts. Accidental outages have less effect on employees and business operations that have lesser database related failures.
The consolidated Oracle Exadata platform provides an economical base for Oracle database operations. It increases employee productivity and helps grow revenues with less cost and complexity. With an enhanced performance up to 100X faster, accessing the data becomes easy and you can engage with customers quickly. With the same power, you can consolidate your databases onto a single platform, and deliver more than four times the density


5 Reasons Why you Should Run Your Oracle Database on Oracle Exadata | Netsoftmate


3. Achieve Operational Benefits


Businesses that rely on multiple vendors may face problems in managing a complex database infrastructure. Retaining and managing each database and server overstrains IT staff, and establishing new applications can take longer than usual. You may also need IT specialists to take care of each different component. As the number of applications and their associated databases increases, your admin costs go up, and so will your data center footprint.
Oracle Exadata delivers greater database and application performance with less hardware—and fewer licenses. Oracle Exadata, from Oracle Engineered Systems means easier upgrades, tuning, patching, observing and support, so you can manage your costs. They process transactions faster, complete queries in less time, and have decreased load and backup recovery times.


5 Reasons Why you Should Run Your Oracle Database on Oracle Exadata | Netsoftmate


4. Maximize Accessibility


Positive data security and database uptime are critical components that directly impact the business operations and revenue progress. Database collapse makes it tough to establish dependable security, plan and policies for sensitive data. There are too many points of control to monitor and maintain. A larger base is vulnerable to attack and there’s hardly enough budget for the specialist skills vital to manage it.
That’s the reason; businesses use Oracle Exadata to run their most important Oracle database and other data workloads. With software and hardware operational together, Oracle Exadata eliminates system downtime, using its in-built flexibility and redundancy. With Oracle Maximum Availability Architecture, you can get the ultimate in invincible uptime. The benefits include, less business impact from outages, less IT impact in managing downtime and reliable application and developer productivity.


5 Reasons Why you Should Run Your Oracle Database on Oracle Exadata | Netsoftmate


5. Invest in the Cloud


Businesses always plan for a simple and comprehensive cloud strategy and application. Ideally, businesses strategize to invest in an architecture offering an apt pathway to a cloud consumption model for the future. A full-proof plan that is flexible to mix and match on-premises deployment with a well-matched public cloud option, whether that’s for development, improvement and testing or ensuring business endurance.
Oracle Exadata offers the best of both worlds for the database and the business. Businesses can either purchase and manage on-premises Oracle Exadata or choose an Oracle Database Cloud Exadata Service. Oracle Cloud service is equivalent to an on-premises Oracle Exadata, just with a different consumption model. That’s why all the components of Oracle Engineered System are a powerful set of options. They are designed with the same architecture, with all the same benefits. All you need to do is choose which consumption model works best for you.




About Netsoftmate Technologies Inc.

Netsoftmate is an Oracle Gold Partner and a boutique IT services company specializing in installation, implementation and 24/7 support for Oracle Engineered Systems like Oracle Exadata, Oracle Database Appliance, Oracle ZDLRA, Oracle ZFS Storage and Oracle Private Cloud Appliance. Apart from OES, we have specialized teams of  experts providing round the clock remote database administration support for any type of database and cyber security compliance and auditing services.

 

Feel free to get in touch with us by signing up on the link below –


Priority Suport for Oracle Engineered Systems | Netsoftmate
0

Database Management Services, Oracle Database Appliance - ODA, Oracle Database Management Solution, Oracle Databases, Remote Database Management, Technology Consulting Services

September 2019 Oracle announced Oracle Database Appliance X8-2 (Small, Medium and HA). ODA X8-2 comes with more computing resources compared with X7-2 Models.

Let’s take a quick look at few benefits of ODA followed by the technical specification on ODA X8-2 Small/Medium and HA.

Oracle Database Appliance is an Engineered System. Software, server, storage, and networking, all co-engineered and optimized to run Oracle Database and applications.


Benefits of Oracle Database Appliance (ODA):

  1. Software, server, storage, and networking engineered and optimized to run Oracle Database and applications.

  2. Supports Oracle Database Standard Edition, Standard Edition One, Standard Edition 2, and Enterprise Edition. Optimized for Cloud.

  3. Capacity on Demand Licensing – Reduced Cost.

  4. Ease of deployment, patching, management, and support.

  5. Increased performance and reliability with NVMe flash storage.

  6. Reliable hardware architecture with redundant power, cooling, networking, and storage.

  7. Browser User Interface (BUI)


In this article we will compare the technical specifications of ODA X8-2 model family (Small, Medium and HA). This comparison table comes handy when you want to quickly take a look at the resources available for a given model.

 

For more information on the technical specification loot at the ODA X8-2 HA and Small/Medium Data Sheet at:

https://www.oracle.com/technetwork/database/database-appliance/oda-x8-2-ha-datasheet-5730739.pdf

https://www.oracle.com/technetwork/database/database-appliance/oda-x8-2sm-datasheet-5730738.pdf



Component

ODA X8-2 Small

ODA X8-2 Medium

ODA X8-2 HA


Database Server

1

1

2

Storage Shelf

NA

NA

1 4U DE3-24C Storage Shelf per System

Optional Second Storage Shelf for Expansion

Rack Size

1 2RU Server

1 2RU Server

2 2RU Servers & 1 4U Storage Shelf

Processor

One 16-core Intel Xeon Gold 5218

Two 16-core Intel Xeon Gold 5218

Two 16-core Intel Xeon Gold 5218 Per Server

Physical Memory

192 GB

Expandable to 384 GB

384 GB

Expandable to 768 GB

384 GB

Expandable to 768 GB per server

Storage

Two 6.4 TB NVMe SSDs

12.8 TB (raw)

Base: Two 6.4 TB NVMe SSDs

12.8 TB (raw)

Base: Six 7.68 TB SSDs

46 TB (raw)

Storage Expansion

Not expandable

Expandable up to 76.8 TB (raw)

Expandable up to 369 TB SSD or up to 92 TB SSD / 504 TB HDD (Raw)

Network

4 x 10GBase-T ports (RJ45) expandable up to 12 x 10GBase-T ports or

2 x 10/25 GbE ports (SFP28) expandable up to 6 x 10/25 GbE ports

4 x 10GBase-T ports (RJ45) expandable up to 12 x 10GBase-T ports or

2 x 10/25 GbE ports (SFP28) expandable up to 6 x 10/25 GbE ports

4 x 10GBase-T ports (RJ45) expandable up to 12 x 10GBase-T ports or

2 x 10/25 GbE ports (SFP28) expandable up to 6 x 10/25 GbE ports

Oracle Database

Oracle Database 18c/19c EE & SE 2

Oracle Database 12c R1/R2 EE & SE 2

Oracle Database 11g R2 EE, SE & SE 1

Oracle Database 18c/19c EE & SE 2

Oracle Database 12c R1/R2 EE & SE 2

Oracle Database 11g R2 EE, SE & SE 1

Oracle Database 18c/19c EE & SE 2

Oracle Database 12c R1/R2 EE & SE 2

Oracle Database 11g R2 EE, SE & SE 1

Database Deployment

Single Instance

Single Instance

Single Instance, RAC & RAC One node

Virtualization

Oracle Linux KVM

Oracle Linux KVM

Oracle VM & Oracle Linux KVM

Operating System

Oracle Linux

Oracle Linux

Oracle Linux





Are you and your team considering setting up Oracle Database Appliance? Let Netsoftmate help you choose the right product keeping under consideration your budget, requirement and usage forecasting. Click on the image below to sign-up NOW!



0

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.

0


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.
0


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.
0

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.

0

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.
2

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.

2

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.

0

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”



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”


  • 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.


0

PREVIOUS POSTSPage 1 of 3NO NEW POSTS