Where is the DBA in the DevOps tools ?

  • Database administrator job has been changed and it’s not like before any more, In the past The DBA responsibility was limited within database which mean troubleshooting, backup , Performance tuning, high availability .. etc after few years new layer has been added to the responsibility which is application server layer for example weblogic ,Oracle embedded the weblogic with most of their products such as enterprise manager cloud, E-business suits, as i remember after three years another layer added to DBA knowledge which is virtualization and regarding to this virtualization  made the DBA life more easier and not like before, solution providing another layer of backup and server management.

However now everything has been changed and the market working under new term which is CLOUD including different vendor AWS, Azure, and Oracle, As DBA your knowledge shouldn’t stop by only Database, within cloud there is new tools that can help the DBA with their daily Job and it’s called Devops.

DBA usually review each change request to ensure that it is well thought out,They are in charge of monitoring their databases and keeping them available and high-performing, manage access to and the overall security of the platform.

Database automation frees the DBA from the bottleneck of the past that delayed application releases since there is different environment production, Pre-Production, Development or Testing, the DevOps Automation relieved of the pressures of constantly having to juggle and merge various teams’ database changes, are now free to help their organisations take bigger steps forward in ongoing innovation.

But what is the Devops ? And How can i use to make my Job Easier

DevOps is the combination of cultural philosophies, practices, and tools that increases an organization’s ability to deliver applications and services at high velocity: evolving and improving products at a faster pace than organizations using traditional software development and infrastructure management processes. This speed enables organizations to better serve their customers and compete more effectively in the market.

Benefits of DevOps
  • Speed
  • Rapid Delivery
  • Reliability
  • Scale
  • Security

DevOps Practices

  • Continuous Integration
  • Continuous Delivery
  • Microservices
  • Infrastructure as Code
  • Monitoring and Logging
  • Communication and Collaboration
DevOps practices for DBA and Data Team focus on the Tools, practices and techniques that are useful for the Data team to use for Development activities, Testing setup and execution, Collaboration techniques and Deployment tools and techniques. The aim of this site is to further the practice and help the DBA’s and Data team to use these practices to become productive and become part of the delivery team and embrace the devops movement.
DevOps Tools
  • Docker
  • Jenkins
  • Ansible
  • Puppet
  • Nagios
  • Monit
  • Behat
  • Chef
There is more tools for sure each one of these tools having it’s own purpose for example Docker is one of the powerful container solutions, A container image is a lightweight, stand-alone, executable package of a piece of software that includes everything needed to run it: code, runtime, system tools, system libraries, settings Available for both Linux and Windows based apps, containerized software will always run the same, regardless of the environment. Containers isolate software from its surroundings, for example differences between development and staging environments and help reduce conflicts between teams running different software on the same infrastructure.
Osama Mustafa 

Migrating From AWS to Oracle Using SQL Developer

The Data Uploaded to the Cloud Vendor Amazon web services ( AWS ) But the client decided to move their data on-premises for the first sight you will think this is hard and needs  a lot of work but thank you SQL Developer and Jeff Smith and he is the product manage for SQL Developer amazing man by the way and crossfitter  at the same time 😛

However Lets start :-

  •  Open SQL developer
  • Choose Database copy option from tools menu.
  • Select source database should be AWS
    • Provide hostname only for the AWS
    • Listener Port
    • DB Name
    • Username/Password 
    • Test your connection.
  • Select destination database should be Oracle 

  • Provide hostname only for the AWS.
      • Provide hostname/IP for the server.
      • Listener Port
      • DB Name
      • Username/Password 
      • Test your connection.

    • Press Next Button, if the migration done before on the same schema press replace and next.


    • Press Next after choose what you want to move, Data, Functions , Or trigger … etc
    • Check Proceed to summary and Press the finish button the migration will start after this,  it will take some time depend on internet connection and data size.
    Enjoy the migration
    Osama Mustafa

    Moving from VMware/KVM to the Oracle Cloud

    Are you running Vmware or KVM solution in your infrastructure and you are afraid to move your infrastructure to the cloud, Oracle provide and gives one simple solution without losing anything Now you can now easily move your virtual machines to the Oracle cloud using Ravello

    and you don’t have to change anything from network, storage or anything you did on your local infrastructure to know more about this product.

    You can request a free trial account to experience the Ravello’s unique features and
    capabilities. For any questions please contact your local Oracle Cloud Infrastructure and
    Platform Sales Executive. The following is the URL for requesting the Free Trail


    Thank you

    Access Dbaas monitor

    To access Oracle DBaaS Monitor when the HTTPS port is unblocked ( i blogged about this before and how to enable it )

    • Open the Oracle Database Cloud Service console, from the console 
    • From the right panel of the services choose Database services monitor and then press on it.
    • New Screen will be opened
      • Username –> dbaas_monitor
      • Password –>  the same password you put it for the Dbaas creation.
    Thank you 
    Osama Mustafa

    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.


    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

    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

    Are we in the Cloud

    What is The Cloud Computing ? Are We in the Cloud ? Where Can I Find it ? Simple Question but It’s has been asked a lot.

    Simply Cloud Computing Storing and accessing Data and programs Using Over Internet instead of Local Computer.

    I Found the Below Chart on the internet and it’s The Best Describe for the cloud “Source Cloud For Dummies” :

    Cloud is the next Stage for everything, Because it can be defined as set of hardware,Platforms , Databases, Networking it will safe lot of money for the companies.

    Check the below video :

    You need to know some  Definition you will heard when we are talking about Cloud:
    Xaas is Term said for number of things “X as a Services” / ” Anything as a Services”

    The Most Common Examples on the above :

    • DBaas : Database as a Service.
    • Paas : Platform as a Service.
    • SaaS : Software as a Service/Storage as a Service.
    • IaaS : Infrastructure as a Service.
    • Caas : Communication as Service.
    • Naas : Network as Service.
    It’s New Future.
    Thank you 
    Osama mustafa