Tuesday, August 8, 2017

Weblogic 101 for DBA Webinar

if you want to learn more about web-logic, Register now "Weblogic 101 for DBA"

i will cover different topic during the webinar to give you a better idea about the weblogic concept

Register now here

Thank you
Osama

Sunday, August 6, 2017

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 :P

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






    Thursday, June 1, 2017

    Getting Started with Pentesting

    Today i received an email for the official publish for Penetration testing tutorial videos , this is another achievement will be added to my security list.

    If you want to have alook on the video here

    Thank you PackIT for this opportunity

    Thank you
    Osama 

    Monday, May 29, 2017

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

    https://www.ravellosystems.com/.


    Thank you
    Osama 

    Wednesday, April 5, 2017

    Plug and unplug PDB on the Cloud

    You can use DBaaS Monitor to plug/Unplug in a pluggable database.


    • Open Dbaas Monitor like usual 


    • Once you did this the, you will redirected to new page, in my case i have 2 PDB let's choose one of them and try to unplug it then Plug it again.

    • From the Right Panel press on the Unplug new screen will be open, As you see from the below picture you should the XML path in your mind in case you need to Plug the database again , put the password same as you use it when you create PDB.



    The output should be "PDB unplugged successfully"..


    Let's Plug again.

    • Press on Plug PDB on the right new screen will be opened.




    Enter the following ;-

      • Name of the new PDB You want.
      • The XML file should be saved under directory you choose it



    Output should be successfully done.

    Cheers

    Osama Mustafa







    Administrating Pluggable Database on the cloud - Other Operation you can do on the cloud

    In my previous post i discussed how to clone Pluggable database on the cloud using Dbaas monitor, but what else i can do on the cloud


    Closing a Pluggable Database

    • Open Dbaas Monitor





    • Click on modify State, once you press on it new screen will be open contain which PDB you want to close ( if you have more than once ) and the state ( Open or Close ) with two option immediate and normal.





    • Press on Show SQL to check the command 


    • Press OK


    Drop Pluggable Database 


    • Same screen you can drop the database by press on the panel then drop like the following, new screen will be opened you can choose keep the datafiles or delete them it's refer to you




    Create Pluggable Database 



    • The same screen there is option called create PDB press on it.

    • New Screen will be opened contains different parameters such as the name of the PDB, Password and file name conversion once you enter everything press ok



    Cheers
    Osama Mustafa







    Administrating Pluggable Database on the cloud - Clone


    • You can use DBaaS Monitor to create and drop a pluggable database, open and close a pluggable database, plug in and unplug a pluggable database, and clone a pluggable database.



    Let's Start with Clone Database :-


    • On the DBaaS Monitor home page.

    • Enter the username and the password of the Dbaas Monitor , username : Dbaas_monitor.

    • From the upper tab press on database --> Manage 

    • you will be redirected to new page , this page contains what pluggable database you have , once you choose which one you want to clone, press on the panel and Press on clone

    • Once you press on clone , new page will be open contains the following 

      • New PDB Name --> New name for the clone Database.
      • Source PDB --> From where you want to clone.
      • File Name Conversion --> You are using this option in case  you want to change anything in the location of database file/ Storage.

    • Press on Show SQL 


    • Once you are done Press on Ok it will take 30 Sec to clone depend on data you have






    Cheers
    Enjoy the Cloud

    Osama Mustafa