Sunday, March 19, 2017

Failed to perform patching of Database Cloud Service

I mentioned before how to Patching database on the cloud, But today when i was trying to apply the new one i faced an issue, while i was searching i found a post that could solve this issue like here


From the above picture you see that database trying to download the patch but useless,using the command Line :-


After searching online for couple of hours my friend Gokhan Atil here , describe it very well an explained the issue.

Regarding to the Post and Oracle Community i should update my dbaascli



After following oracle documentation and the blog you will be able to patch the database successfully.


Osama






Create Backup On Demand On the Cloud

In This Post i will show how to create backup for Dbaas :-


  • Open the Oracle Database Cloud Service console.
  • Click the database deployment for which you want to create a backup.
  • Click the Administration tile.
  • Click Backup Now and then confirm the action.


Or you can use the command line by connect to your compute node as root use and run the following command :-

  • To create a backup that follows the current retention policy

# /var/opt/oracle/bkup_api/bkup_api bkup_start

  • To create a long-term backup
# /var/opt/oracle/bkup_api/bkup_api bkup_start --keep

  • Check Status 
# /var/opt/oracle/bkup_api/bkup_api bkup_status

Rentation in the cloud like the following :-


  • Both Cloud Storage and Local Storage: 30 days, with the 7 most recent days' backups available on local storage
  • Cloud Storage Only: 30 days
  • Local Storage Only: 7 days


Enjoy the cloud
Osama 


Tuesday, March 14, 2017

Configure Putty to connect to the cloud

After posting different blog about Cloud and how to use the console what about the putty ?

How to use it :-


  • Download and install PuTTY from here.
  • Run the PuTTY program.
  • In host name put the ip address for the cloud services.
  • Connection type should be SSH.


  • After This On the left Panel Choose SSH --> Auth, and Click the Browse button next to the Private key file for authentication box. Then, in the Select private key file window, navigate to and open the private key file that matches the public key that is associated with the deployment .

You should remember the password for this or you need to add another SSH key.

Notes :-
  1. By Default you are connecting as Oracle user.
  2. if you want to use root access you should connect as opc user then ssh password and run "sudo -s" to switch to root user.
Thank you
Osama




Patching Database Cloud Service

There is nothing simple more than this , Applying patch on the cloud (Dbaas), Oracle Cloud allow you to check the following :-


  • Viewing Available Patches
  • Check Prerequisites.
  • Apply Patch.
  • Rollback Patch.

In this post it will show you how to do all the above steps :-

  • Open the Oracle Database Cloud Service console.


  • Click the database deployment on which you want to check patching.

  • Click the Administration tile and then click the Patching tab.

  • If you want to use command line it's possible as well, you have to connect to the cloud using Putty on windows check the post from here that will tell you how to connect using putty to the cloud, however if the below you will see that the available patch in the picture for my Dbaas, you can check the prerequisites again by press on it. 




If you want to run the same without GUI ( Cloud Console ) you can do the following 




Remember you should configure Putty to be able to access the root on the cloud.

  • Now If you want to apply the patch on the cloud Using the console it's very easy. 



Enjoy the Cloud 

Thank you 
Osama




















Sunday, March 12, 2017

Scaling a Database Deployment - Oracle Cloud

If a database deployment on Oracle Database Cloud Service is performing poorly or is running out of storage, you can scale up the environment supporting the database deployment.

follow these steps to scale up/Down your Dbaas :-


  • Open the Oracle Database Cloud Service console.


  • Click the name of the deployment you want to scale.

  • Choose the scaling command:

  • The Scale Up/Down Service overlay is displayed. 


Choose which resource you want to Press Yes.

Thank you
Osama









Oracle Cloud Services

During the last week i was working on Oracle Cloud Closely and i would like to summarize what Oracle Cloud Services Provide,and Short Description for each services :-


  • Oracle Compute Cloud Service
In this Services you control the cloud, use a variety of Oracle Compute Cloud Service resources and you can control form here the following :
    • disk images.
    • compute shapes
    • storage volumes.
    • IP reservations.
    • security lists.
    • security rules.
    • secure shell.
  • Oracle Storage Cloud Service containers
 In this Following servvices, back up to cloud storage, vy  using Oracle Storage Cloud Service containers as repositories for backups to the cloud But before you start working on this you should create container and active account.
  • Oracle Application container Services 
Provides a lightweight infrastructure so that you can run applications in the Oracle Cloud.
  • Oracle Big Data Cloud Services 
The power of Hadoop and Spark delivered as a secure, automated, high-performance service, which can be fully integrated with existing enterprise data but in the cloud.
  • Oracle Cloud Stack Services 
to create and use templates that automate the provisioning of services like Oracle Compute Cloud Service in different format HTML, PDF, ePub and Mobi formats.
  • Oracle Event Hub Cloud Services 
delivers the power of Kafka as a managed streaming data platform integrated with the rest of Oracle's Cloud. with services you can loading and analyzing streaming data.
  • Oracle Golden Gate Cloud Services.
GoldenGate Cloud Service is a cloud based real-time data integration and replication service, which provides seamless data movement from various on-premises relational databases to databases in the cloud with sub-second latency while maintaining data consistency and offering fault tolerance and resiliency. 
  • Oracle Java Cloud Services 
provides an enterprise-grade platform to develop and deploy Java applications in the public cloud.
  • Oracle MYSQL Cloud Services
Delivers a secure, cost-effective and enterprise-grade MySQL database service. Built on MySQL Enterprise Edition and powered by the Oracle Cloud, it provides a simple, automated, integrated and enterprise ready MySQL cloud service, enabling organizations to increase business agility and reduce costs.

  •  Oracle SOA Cloud Services 

Provides a PaaS computing platform for running Oracle SOA Suite, Oracle Service Bus and Integration Analytics in the cloud this cloud services supports multiple service types in case any of integration will happened.


I tried to make everything simple, each one of these services have a complete Oracle documentation how to work on it.

Thanks
Osama

Wednesday, March 8, 2017

Monitor Oracle Dbaas using Oracle Cloud EM

Now in this post after creating Dbaas and connect the database using SQL developer, Oracle Provide you with Enterprise manager to manage your DB and giving you General Information about the database status and Storage ... etc

Before start working on the EM You should Enable the https Connection ,


  • Press on the upper left panel, and choose compute Cloud.
  • Press on network tab.
  • Choose ora_httpssl and console and update then Enabled.


  • Now Back to Database cloud console, press on the Dbaas you want and Open the panel, EM Console Login.


And Enjoy



Enjoy the Cloud !!!


Thank you
Osama Mustafa