Monday, September 5, 2016

Weblogic Version

java -cp weblogic.jar weblogic.version  -verbose

Wednesday, July 6, 2016

Tar a folder

tar cvzf MyImages-14-09-12.tar.gz /home/MyImages

Wednesday, May 18, 2016

Oracle E-Business suite on Oracle Cloud

I think this was the most awaited thing for any Applications DBA for not being left out in the race to the cloud. Oracle did support implementation of E-Buisness suite in the AWS cloud but there was always a question unanswered until now as to why would Oracle not use there own cloud service. As per this article dated 27th October 2015 Oracle launched their Compute cloud services 9 years after Amazon's EC2.
If you look at Oracles cloud website it offers the following services:
  • Software as a Service (Saas).
  • Database as a Service (Daas).
  • Platform as a Service (Paas).
  • Infrastructure as a Service (Iaas).
and IaaS is the service which contains the compute cloud service. So to come to the point E-Business suite can be hosted onto Oracle's cloud in the compute cloud space. The cloud market place offers pre build images of E-Business suite and OS only for E-Business suite. At the time of writing this article following images are available on the market place:
  • EBS 12.2.5 Demo Install Image.
  • EBS 12.2.5 Fresh Install Image.
  • EBS Provisioning Tools Image.
  • EBS Development Tools Image.
  • EBS OS-Only Image (supports 12.2 and 12.1.3 cloning).
So if you look at it you either can spin off a OS with pre build RPM's and install E-Business suite instance, clone an existing E-Business suite instance from on-premise to the cloud or use a virgin or demo (vision) instance. You can do a single node, multi-node install by using the provisioning image. Following are some documentations links for your reference:
You may note that RAC is currently not supported on the compute cloud but is available as a service on the Database cloud service or Exadata cloud service. At the time of writing this article there is not RAC image available and has to implemented by contacting the respective service teams through an SR.
Good Read:
FAQ is a good document to go through for any more queries.
Getting Started with Oracle E-Business Suite on Oracle Cloud (Doc ID 2066260.1).

Monday, November 9, 2015

Oracle Database Migration to AWS

I have been wanting to read about how to move oracle databases to the AWS cloud. The initial thought was that it should not be more complicated than a simple import / export and wallah!! I was not too far away from my guess.
AWS offers two types of services to host oracle database:

  • AWS RDS for Oracle
  • EC2
AWS RDS for Oracle
The AWS RDS for Oracle is a managed database service, you may also categorize it under PaaS service offered by Oracle cloud.
This service is good for clients who do not want to spend time and money on database administrative tasks such as backup & recovery, database administration (monitoring, table space management, disk provisioning, etc), patching. You can either Bring Your Own License (BYOL) or use the included license by AWS.

Running a self managed database is nothing different compared to running a database in a datacenter. The client has the full control of the database with the sys and system account as well as control of the operating system. The licensing on EC2 hosted database is BYOL.

So how do we move our on premise databases on to the AWS cloud? well there are more than a couple of ways to migrate the database I will touch upon the more practical and feasible options.

Import / Export using data pump
Using oracle's data pump utility export the objects and data from the source database and move the exported files on to the AWS instance. Now there are different ways to achieve this in case you are using a database on RDS or using a database on the EC2 instance. The export process remains the same for both. While importing into a database hosted on a,
EC2 instance:
Transfer the files from from the source database to the AWS EC2 instance, There is a tool mentioned in the AWS white paper - Tsunami UDP, is an open-source file transfer protocol that uses TCP control and UDP data transfer over long distance networks.
Once you have the files on the EC2 instance import them using the datapump utility.
AWS RDS for Oracle:
RDS does not give you any control over the file system nor any operating system. You would require here is a bridge instance. A bridge instance is nothing but a  EC2 instance. Move all the exported data pump files on this bridge instance. Using a perl script move the files on the externally exposed DATA_PUMP_DIR directory. Perl script available at
once the files are available at the location use a PL/SQL script that uses DBMS_DATAPUMP to import the files into the database.

RMAN can be used by backing up the data on the source system, moving it to a S3 bucket and moving it on to a EC2 instance. Restore the RMAN backup to create a database on the AWS EC2 instance.
It is to be noted that you can use the RMAN method only on databases hosted on EC2 instances.

Hope this has helped you in some way to design your migration strategy to move your on premise databases to the AWS cloud.

Reference: cng-oracle-database-to-aws.pdf

Wednesday, August 12, 2015

IDM and Access Management Suite

Oracle Identity Management products are bundled as two product sets:
  • Oracle Identity Management
  • Oracle Identity and Access Management.
Oracle Identity Management consists of:
-    Oracle Internet Directory
-    Oracle Virtual Directory
-    Oracle Directory Services Manager (ODSM)
-    Oracle Identity Federation

Oracle Identity and Access Management consists:
 -   Oracle Access Manager 11g
 -   Oracle Identity Manager

Monday, August 10, 2015

Upgrade Oracle Identity & Access Management (IDM) to 11g R2 PS3 ( from

Oracle Identity & Access Management 11g R2 PS3 ( was released on 18th May 2015. It was recently certified by Oracle with E-Business suite 12.1.3 and 12.2 - Steven Chan's blog

The software components that need to be upgraded:

Oracle Fusion Middleware Web Tier utilities 11g Patch Set 7 ( -- OHS (Download from Delivery)
Webgate- - Patch 20996156: ORACLE ACCESS MANAGER WEBGATES (

Upgrade approach:

  • Upgrade weblogic server to 10.3.6 if not at this version.
  • Upgrade oracle internet directory to
  • Upgrade the OID schema using the Patch Set Assistant utility (PSA).
  • Upgrade Oracle Access Manager
  • Upgrade the Oracle Access Manager schema - upgrade OAM Schema, OPSS Schema and IAU Schema with PSA.
  • Upgrade the MDS schema again with the PSA
  • Upgrade the Platform Security Services
  • Un-deploy Coherence Library
  • use the upgradeConfig to upgrade the security config.
    • There were a few errors reported while executing the command upgradeConfig.
    • Remove javax.xml.bind_2.1.1.jar file from$MW_HOME/jdk/jre/lib/endorsed/
    • Remove jar files "coherence.jar" and "tangosol.jar" from $M_HOME/iam/oam/server/lib/jmx/
    • After running the command"
    • Note: Rename the jmx folder and copy the jmx from $STAGE/Disk2/stage/Components/oracle.oam.server/ to $MW_HOME/iam/oam/server/lib
    • Restore the javax.xml.bind_2.1.1.jar from the backup
  • Upgrade Webgate
  • Upgrade OHS
Note: the jps_mbeans.xml was corrupted and had to be restored from the backup.

Note: Restart the server from the Unix console and not from the graphical /console.
Follow the metalink id: Oracle Access Management 11gR2 PS3 ( Upgrade Advisor (Doc ID 2001106.2)
Oracle Access Manager 11gr2ps3 (OAM Keberos/WNA Authentication Fails "User account is locked. Contact the Administrator" (Doc ID 2039164.1)

Friday, July 3, 2015

Increase Weblogic Managed Server Memory

In the file find the following line

# IF USER_MEM_ARGS the environment variable is set, use it to override ALL MEM_ARGS values

and add the following statements.

##Custom Argument for memory to set value for individual server
case "${SERVER_NAME}" in
"AdminServer") USER_MEM_ARGS="-Xms512m -Xmx1024m" ;;
"bam_server1") USER_MEM_ARGS="-Xms512m -Xmx1g" ;;
"soa_server1") USER_MEM_ARGS="-Xms1536m -Xmx3g" ;;
"osb_server1") USER_MEM_ARGS="-Xms512m -Xmx512m" ;;*)

echo “Unknown Server Detected!!. Memory set as Xms1g Xmx1g.”;

USER_MEM_ARGS="-Xms1g -Xmx1g" ;;


USER_MEM_ARGS="${USER_MEM_ARGS} -d64 -XX:PermSize=256m -XX:MaxPermSize=512m -Djava.awtheadless=true -Djbo.ampool.maxpoolsize=600000"
##Custom Argument End

Saturday, October 25, 2014

Check installed RPM's on Linux

rpm -qa --qf "%{NAME}-%{VERSION}-%{RELEASE}_%{ARCH}\\n" | grep "package name"

replace the "package name" with the library or package that you require to check.

Tuesday, June 3, 2014

Release Linux Cached Memory

free && sync && echo 3 > /proc/sys/vm/drop_caches && free

Thanks to: