Posts

Showing posts from March, 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

Deleting a Backup On The Cloud

Image
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 --keepDelete the backup # /var/opt/oracle/bkup_api/bkup_api bkup_delete --bkup=backup-tagwhere backup-tag is the tag of the backup you want to delete.

Thank you Osama Mustafa

Failed to perform patching of Database Cloud Service

Image
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

Image
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 storageCloud Storage Only: 30 daysLocal Storage Only: 7 days

Enjoy the cloud Osama 

Configure Putty to connect to the cloud

Image
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 :- By Default you are connecting as Oracle user.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

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


Viewing Available PatchesCheck 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 th…

Scaling a Database Deployment - Oracle Cloud

Image
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 shapesstorage 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 exi…

Monitor Oracle Dbaas using Oracle Cloud EM

Image
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

Image
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 https://cloud.oracle.com 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



Generating an SSH Key Pair Using the PuTTYgen

Image
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 Osama

Creating Database on Oracle cloud ( DBaas )

Image
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). Or  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 c…

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