Friday, March 31, 2017

Top 60 Oracle Blogs And Websites for Oracle DBAs

My Blog Ranked as #29, The Top Oracle Blogs Around the world Here .

I would like to thank everyone for this and for the people who supporting me all the time.

Pleasure to be on the list with big names in Oracle world.

Thank you guys without you it will impossible

And Wish you to enjoy my blog more & more.
Osama Mustafa

Wednesday, March 29, 2017

Deleting a Backup On The Cloud

In this post i will show you how to delete backup on the cloud using the command line :-

  • Connect to the compute node as the opc user.
  • Start a root-user command shell using sudo command 
    • sudo su -
  • List the backup
    • # /var/opt/oracle/bkup_api/bkup_api recover_list --keep
  • Delete the backup 
    • # /var/opt/oracle/bkup_api/bkup_api bkup_delete --bkup=backup-tag
      • where backup-tag is the tag of the backup you want to delete.

Thank you
Osama Mustafa

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.


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

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

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 

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

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.


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

SQL Developer :- Enable SSH for Oracle cloud

In the last post i mentioned how to create Dbaas, In this post i want to use the SQL Developer to manage my Dbaas and connect on the cloud but each time the following error appeared :-

Remember this is not local database , these steps only for the Oracle Cloud.

  • Access to your account from then Dbaas --> my services 
  • The Dashboard will be look like the following :-

  • Press on the upper left panel --> Compute 
  • New Screen will be opened , From the upper tabs press on network 

  • In the same page Search under security application you will find Ora-DBListener and the status is Disabled 
  • By Pressing the Right Panel  From the list choose Update.
  • New Screen will be opened like the following, Change the status to enabled and press update :-

  • Now Try again in the SQL Developer :-
Enjoy the Cloud !!!

Thank you
Osama Mustafa

Monday, March 6, 2017

Generating an SSH Key Pair Using the PuTTYgen

This post to teach how you generate SSH Key For the Cloud , 

  • Download and install PuTTY or PuTTYgen from here.
  • Open the software it will be like this 

  • Set the Type of key to generate option to SSH-2 RSA.
  • In the Number of bits in a generated key box, enter 2048.
  • Click Generate to generate a public/private key pair, move the mouse on the clean bar after press generate,

  • After it's done it will be like the following:-

  • Select all of the characters in the Public key for pasting into OpenSSH authorized_keys file box and copy it.
  • Open a text editor and paste the characters, just as you copied them.
  • Save the text file in the same folder where you saved the private key, using the .pub extension to indicate that the file contains a public key.

Thank you

Creating Database on Oracle cloud ( DBaas )

How to create database instances in the Oracle Database Cloud Service - Database as a Service (DBaaS) , Very simple steps :-

  • After creating your Oracle Cloud Account, i will show the post how to create it.
  • To create a new database instance, in the Database Cloud Service console click Create Instance.
  • Choose which cloud services you want, in our case we want Database :-

  • The Create Database Cloud Service wizard is invoked, displaying the Subscription Type page.

  • Now you have to fill the information, one by one like the following screen, 

You can choose the Oracle Database Cloud Service - Virtual Image service level to define a database instance manually or using the Oracle Database Creation Assistant (DBCA).
You can choose the Oracle Database Cloud Service service level to have the wizard create a database instance for you, using configuration options provided in the wizard. This service level also makes additional cloud tooling available for backup, recovery and patching.

Also you can choose database version 11gR2, 12cR1 or 12cR2. 

After this press next.

  • Now Fill the information for DB configuration screen like the below :-

In this screen you should create SSH key in this post here,

generated a secure shell (SSH) private/public key pair, with copies of the private and public key files on your local computer. You will point to the SSH public key when you create the database instance. For details on generating an SSH private/public key pair, refer to the Generating a Secure Shell (SSH) Private/Public Key Pair section of the Using Oracle Database Cloud Service (Database as a Service) documentation.

  • The Summary for your DBaas, Press create it will take some time:-

Thank you
Osama Mustafa

Wednesday, March 1, 2017

Oracle Database 12c Release 2

Oracle Database 12c Release 2 is now available for Linux, Oracle Solaris SPARC, Oracle Solaris Intel 

To Download Just access here