BLOG

Enterprise Manager : Performance Across Enterprise Databases

Posted on by Osama Mustafa in Application
The below link is very to understand the performance under #EM12c Provided by oracle, This demonstration shows you how to use AWR Warehouse a new feature of Oracle Enterprise Manager 12c Release 4.

https://www.youtube.com/watch?v=StydMitHtuI&feature=youtu.be

Cheers
Osama Mustafa

[INS-30131] Initial setup required for execution of installer validation failed.

Posted on by Osama Mustafa in Database
When trying to install Oracle client 12c the above error appeared , this issue can happened on windows Or linux.

The cause i really simple :-

On linux there is no enough space under /tmp.

On windows the solution like the following :-

  • Open Windows Services.
  • Stop Oracle Services –> OracleRemExec
  • Remove the OracleRemExecService
  • then try to install Oracle client again

Thank you 
Osama Mustafa

ldap utility BINDASAPPUSER FAILED DUE TO INVALID PASSWORD Siebel

Posted on by Osama Mustafa in Application

ldap utility BINDASAPPUSER FAILED DUE TO INVALID PASSWORD

The above error happened to Siebel CRM.

the solution is so simple :-

In my version Siebel configured as SSO because of this OID hold all the application user after check o i found that orcladmin have only one week for password expiration Siebel consider this as error so i increase password policy in OID.

Cheers
Osama  

Creating a Local Yum Repository Using ISO Image

Posted on by Osama Mustafa in Operating system
In this post i will show you how to create Yum repository Using ISO Image, will save more time :-

  • Download The ISO Image and Upload it to the server.
  • Create Folder Under Root User Like the below

cp /OEL6.6. iso /ISOs

  • now create mount point for this ISO.

mkdir p /var/ISO/OEL6.6
Run the below command to mount it :-

mount o loop,ro /ISOs/OEL6.6. iso /var/ISO/OEL6.6

  • Now under /etc/yum.respos.d you can rename it or set enable=0
  •  Create the following file /etc/yum.respos.d/OEL66.repo
  • Edit the file and add 

[OL66]
name=Oracle Linux 6.6
baseurl=file:///var/ISO/OEL6.6
gpgkey=file:///etc/pki/rpmgpg/
RPMGPGKEY
gpgcheck=1
enabled=1

  • Run the below command to clean yum

yum clean all
yum respolist

The output should be like the below :-

repo id repo name status
OL66 Oracle Linux 6.6 25,459 

Thank you
Osama Mustafa

New Features in ORAchk 12.1.0.2.3

Posted on by Osama Mustafa in News
The new ORAchk release 12.1.0.2.3 is now available to download from http://support.oracle.com

Is your database healthy ?

ORAchk can be used with any database depend on your Platform Solaris Intel, Solaris SPARC, ,HP , Linux , you can check the Oracle Support Document :-

ORAchk – Health Checks for the Oracle Stack (Doc ID 1268927.2)

That include the userGuide and how to Use ORAchk with any platforms,

New Features :-

Database performance, install, scalability & ASM
Cross stack checks for Oracle Applications running on Solaris & Oracle Hardware
Enterprise Manager Agents performance and failure to run
Oracle EBS Accounts Payables

Usually the usage like the below :-

./orachk  —> regular healtcheck  + HA best practices
./orachk-c hacheck —> HA best practices Only

Cheers
Osama Mustafa

Apply Jdeveloper Patch

Posted on by Osama Mustafa in Application
This blog post will show you how to apply Patch on Jdeveloper :-

  • Download the latest version of Opatch from http://support.oracle.com
  • Unzip the Patch Folder.
  • Set/export ORACLE_HOME to Jdeveloper hope depend on Operating system
  • Finally Opatch Apply to Jdeveloper Home.
If you faced any error with opatch commad try the below :-

opatch apply -jdk /u01/app/oracle/JDK/160_24

Cheers
Osama Mustafa

OPATCH : Problems with the lock file

Posted on by Osama Mustafa in Database

Problems with the lock file
Lock file exists, details are:
Interim Patch is holding the lock from ……
probably due to previous unsuccessful operation

Seems the Opatch has been interrupted or hanged therefore the .opatch_storage still exists under Oracle Home

ls -ltr $ORACLE_HOME

Search for .patch_storage and delete it

Try Again..

Osama Mustafa

Prerequisite check "CheckActiveFilesAndExecutables" failed

Posted on by Osama Mustafa in Database

Oracle Home       : /u01/app/oracle/product/11.2.0/db_home1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/db_home1/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/db_home1/cfgtoollogs/opatch/opatch2015-03-09_16-45-09PM_1.log
Verifying environment and performing prerequisite checks…
Prerequisite check “CheckActiveFilesAndExecutables” failed.
The details are:

Following executables are active :
/u01/app/oracle/product/11.2.0/db_home1/lib/libclntsh.so.11.1
UtilSession failed: Prerequisite check “CheckActiveFilesAndExecutables” failed.
Log file location: /u01/app/oracle/product/11.2.0/db_home1/cfgtoollogs/opatch/opatch2015-03-09_16-45-09PM_1.log

When trying to apply OPatch the above error appear , 
Some process hanged 

oracle@–:~/database_patches/19769496$ fuser /u01/app/oracle/product/11.2.0/db_home1/lib/libclntsh.so.11.1
/u01/app/oracle/product/11.2.0/db_home1/lib/libclntsh.so.11.1:    58536m

Kill -9 58536

Cheers
Thank you 

Configure DBConsole as Active/passive

Posted on by Osama Mustafa in Database
Sometimes Database Configured as Active/Passive ( Cluster ) Which mean one node working/time and regarding to this if the failover happened on 2nd node the customer will expected that everything will be the same as it was on node 1 include to this Dbconsole.

To do this follow the below steps :-

  • Database should be configured on VIP.
  • Listener should be configured on VIP.
  • Database , Configuration should be installed on Shared Storage
  • inventory Files should be on shared storage as well.
  • ORACLE_HOSTNAME Should be set to VIP Hostname.
Listener example :-

LISTENER  =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = VIP-HOST )(PORT = 1521))
)

Don’t forget to set the LOCAL_LISTENER Parameter :-

SQL> alter system set local_listener=’LISTENER’;

Or

SQL> alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = VIP-HOST )(PORT = 1521)) ‘;

Now

export ORACLE_HOSTNAME=VIP-HOSTNAME
emca -config dbcontrol db -repos create

Test the failover on node #2

if for some reason when you try to start emctl and the error still asking for oc4j then export ORACLE_HOSTNAME is bash_profile.

It should work

Cheers
Osama