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

Configure RMAN Backup On Windows

Database is supported on windows and some people using Windows As Production and RMAN need to be configured to ensure backup for Database in such failure or something to do this follow the below steps :-

  • Create first text file called backup and change the format to “bat”, inside the file add the following lines :-

C:
cd E:\app\ADM-BSS01\product\11.2.0\dbhome_1\BIN
rman @E:\RMAN\Scripts\backup.rman

  • Create 3 folders in E for example :-
    • backup
    • Archivelog
    • Controlfile
  • Create second file name it Backup.rman and add the Rman Script like below 

connect target /
run
{
ALLOCATE CHANNEL c1 DEVICE TYPE disk;
ALLOCATE CHANNEL c2 DEVICE TYPE disk;
ALLOCATE CHANNEL c3 DEVICE TYPE disk;
ALLOCATE CHANNEL c4 DEVICE TYPE disk;
backup AS COMPRESSED BACKUPSET tag Full_database_open format ‘E:\RMAN\backup\db_%t_%s_p%p.bkp’ database;
backup AS COMPRESSED BACKUPSET archivelog all format ‘E:\RMAN\backup\archivelog\al_%t_%s_p%p.arch’ delete all input;
backup AS COMPRESSED BACKUPSET current controlfile tag =cf1 format ‘E:\RMAN\backup\cf_%t_%s_p%p.bkp’;
backup tag ORCL_CONTROL current controlfile format ‘E:\RMAN\Controlfile\%d_%T_%s_%p_CONTROL’;
delete noprompt expired backup;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}

  • Follow the screen now :-
      • Add Task Name and Description :-
      • Add The Time for this Task in this tab 
      • Another Screen :-
      • In This Screen Add Bat File in our case backup.bat
       

      Oracle Database Patches Information

      A number of questions has been asked here and in Oracle Community Forum When/What/Date for Next Database patches ?

      in the all way you should have valid account for http://support.oracle.com.

      I see it’s worth it to post and share the information how to find the desire patch number and how to know next patch release, i will only share MOS document number that will help you understand what i mean.

      How to Find Patch ? 

      • Oracle Recommended Patches — Oracle Database (Doc ID 756671.1)
      • Quick Reference to Patch Numbers for Database PSU, SPU(CPU), Bundle Patches and Patchsets [1454618.1]
      • Release Schedule of Current Database Releases [742060.1]
      • Introduction to Oracle Recommended Patches [756388.1]
      • Oracle Database Patchset Information, Versions 10.2.0 to 12.1.0 (Doc ID 268895.1)
      • ALERT: Oracle 11g Release 1 (11.1) Support Status and Alerts (Doc ID 454507.1)
      The above MOS document will guide you and help you to know the next release of database patch, also as you see i included some document that helps for recommended patch.
      REGISTRY$HISTORY contains information about the applied patches PSU, SRU or CPU and you can use Oracle Base Script from here.
      Or 
      $ORACLE_HOME/OPatch/opatch lsinventory
      Cheers
      Osama Mustafa

      Increase Transaction timeout in SOA Server

      I received the below error in soa_server1 :-

      Transaction Rolledback.: weblogic.transaction.internal.TimedOutException: Transaction timed out after 603 seconds BEA1-3FB6FB464035C13E3227 at 

      From the above error, transaction timeout should be increased regarding to heavy transaction on soa server.

      to do this follow the following steps :-

      access weblogic console –> Deployment –> and search for Soa_infra. ( expand it)

      Check the below EJBS services and click on it configuration tab :-
      BPELActivityManagerBean
      BPELEngineBean
      BPELInstanceManagerBean
      BPELProcessManagerBean
      BPELServerManagerBean

      If this not working on you have to increase transaction timeout for JTA, Access Weblogic Console select Services > JTA
      Thank you 
      Osama Mustafa

      WSM-02557 When Trying to Deploy On SOA Server.

      AdminServer indicates to the following error:-

      AdminServer-diagnostic.log:[2014-07-16T10:40:43.681+02:00] [AdminServer] [ERROR] [WSM-02353] [oracle.wsm.resources.policymanager] [tid: [ACTIVE].ExecuteThread: ‘0’ for queue: ‘weblogic.kernel.Default (self-tuning)’] [userId: admin] [ecid: bf57ca3361a7ecd1:-39746f30:1473e26749c:-8000-000000000000026a,0] [APP: em] Unable to get the Action Executor.

      to solve this issue make sure the following Users were created in Weblogic console :-

      From AdminConsole –> Security —> myrealms –> Choose Users and Group Tab.

      Create the below user :-

      OracleSystemUser

      Create the below Group

      OracleSystemGroup

      The following Pictures describes users and Group ( how supposed to be ) :-

      and assign this group to OracleSystemUser , Restart Console and managed Server Try again.

      Thank you
      Osama Mustafa

      [Security:090482]BAD_CERTIFICATE alert was received from Hostname

      [Security:090482]BAD_CERTIFICATE alert was received from Hostname. Check the peer to determine why it rejected the certificate chain (trusted CA configuration, hostname verification). SSL debug tracing may be required to determine the exact reason the certificate was rejected.>
      javax.net.ssl.SSLKeyException: [Security:090482]BAD_CERTIFICATE alert was received from Hostname. Check the peer to determine why it rejected the certificate chain (trusted CA configuration, hostname verification). SSL debug tracing may be required to determine the exact reason the certificate was rejected.
      at com.certicom.tls.interfaceimpl.TLSConnectionImpl.fireException(Unknown Source)
      at com.certicom.tls.interfaceimpl.TLSConnectionImpl.fireAlertReceived(Unknown Source)
      at com.certicom.tls.record.alert.AlertHandler.handle(Unknown Source)
      at com.certicom.tls.record.alert.AlertHandler.handleAlertMessages(Unknown Source)
      at com.certicom.tls.record.MessageInterpreter.interpretContent(Unknown Source)
      at com.certicom.tls.record.MessageInterpreter.decryptMessage(Unknown Source)
      at com.certicom.tls.record.ReadHandler.processRecord(Unknown Source)
      at com.certicom.tls.record.ReadHandler.readRecord(Unknown Source)
      at com.certicom.tls.record.ReadHandler.readUntilHandshakeComplete(Unknown Source)
      at com.certicom.tls.interfaceimpl.TLSConnectionImpl.completeHandshake(Unknown Source)
      at com.certicom.tls.record.ReadHandler.read(Unknown Source)
      at com.certicom.io.InputSSLIOStreamWrapper.read(Unknown Source)
      at sun.nio.cs.StreamDecoder.readBytes(StreamDecoder.java:264)
      at sun.nio.cs.StreamDecoder.implRead(StreamDecoder.java:306)
      at sun.nio.cs.StreamDecoder.read(StreamDecoder.java:158)
      at java.io.InputStreamReader.read(InputStreamReader.java:167)
      at java.io.BufferedReader.fill(BufferedReader.java:136)
      at java.io.BufferedReader.readLine(BufferedReader.java:299)
      at java.io.BufferedReader.readLine(BufferedReader.java:362)
      at weblogic.nodemanager.server.Handler.run(Handler.java:71)
      at java.lang.Thread.run(Thread.java:662)

      You need to recreate the certification again :-
      Depend on your Operating system :-

      $WL_HOME/server/bin/setWLSEnv.sh Or setWLSEnv.cmd

      cd $WL_HOME/server/lib

       Copy DemoIdentity.jks to another directory as backup.

      then inside the WLS_HOME/server/lib run:-

      Generate the private key.

      java utils.CertGen -keyfilepass DemoIdentityPassPhrase -certfile newcert -keyfile newkey 

      Import the key generated

      java utils.ImportPrivateKey -keystore DemoIdentity.jks -storepass DemoIdentityKeyStorePassPhrase -keyfile newkey.pem -keyfilepass DemoIdentityPassPhrase -certfile newcert.pem -alias demoidentity 

       Restart AdminConsole and Nodemanager and try to start managed server.

      Thank you
      Osama mustafa

      java.lang.ClassNotFoundException: oracle.dms.wls.DMSServletFilter

      This Error Appeared while trying to start managed Server “edq_server1” , The starting results it’s completed with successfully status but some deployment end with Failed status , which mean edq_server will not work correctly, therefore i checked the logs which the below error :-

      Caused By: java.lang.ClassNotFoundException: oracle.dms.wls.DMSServletFilter
              at weblogic.utils.classloaders.GenericClassLoader.findLocalClass(GenericClassLoader.java:297)
              at weblogic.utils.classloaders.GenericClassLoader.findClass(GenericClassLoader.java:270)
              at weblogic.utils.classloaders.ChangeAwareClassLoader.findClass(ChangeAwareClassLoader.java:64)
              at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
              at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
              at weblogic.utils.classloaders.GenericClassLoader.loadClass(GenericClassLoader.java:179)
              at weblogic.utils.classloaders.ChangeAwareClassLoader.loadClass(ChangeAwareClassLoader.java:43)
              at weblogic.servlet.internal.WebComponentContributor.getNewInstance(WebComponentContributor.java:224)

      To solve this error :-

      cd /u01/app/oracle/product/fmw/wlserver_10.3/common/nodemanager
      vi nodemanager.properties

      And search for 

      StartScriptEnabled=false

      change it to

      StartScriptEnabled=true

      Restart Node manager and try again.
      Thank you
      Osama Mustafa

      Middle east Tour 2014

      Courtesy of the Oracle Technology Network (OTN) and the ARABOUG ( Arab Oracle User Group ), the inaugural 2014 OTN MENA Tour brings a star-studded cast, consisting of some of the world’s best Oracle ACEs, ACE Directors and Rock Star Speakers to the region. The tour aims at sharing cutting edge knowledge and independent research in the MENA region, by accomplished Oracle experts from all over the world – “The 2014 OTN Middle East & North Africa (MENA) Tour” – 5 Cities, 3 Countries, 2 Continents with more than 50 Action-Packed Oracle Sessions, last stop at Dubai June 1 – Dubai, UAE.
      Speakers List :-
      Bjoern Rost
      Michael Ault
      Syed Jaffar Hussain
      Edward Roske
      Osama Mustafa.
      Dr.Mohammad Houri 
      Joel Perez
      Tariq Farooq
      Jim Czuprynski
      We Are Glad to see you there and chatting with you.

      Link Here

      Thank you 
      Osama Mustafa

      OTech Magazine 2014

      Independent magazine for Oracle technology professionals. OTech Magazine will be published digitally four times a year. Every season. 

      The first edition will be published Fall 2013. OTech Magazine articles are written by the Top-100 consultants in the Oracle-field around the globe. Only selected authors can publish in OTech Magazine.

      OTech Magazine offers insight in complex Oracle projects and solutions.

      My Article Included in this Version of OTech Magazine You Can Check The Magazine Here

       I Want to take this Opportunity to Thanks Douwe Pieter for his great efforts.

      Thank you 
      Osama Mustafa