Tag: Osama mustafa

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

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

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 

Shutdown Immediate Hangs

Posted on by Osama Mustafa in Database
Today i faced Strange issue with Shutdown immediate command on cluster database which is when run shutdown immediate the command hangs and take so long and sometimes it’s working and most of the time not working.

the below command was working without any problem :-

SQL > shutdown abort

to solve this issue & trace the error since the alertlog not indicating to anything interesting i have to dump systemstate every 5 minutes  to know what going on :-

connect / as sysdba
alter session set events ‘10400 trace name context forever, level 1’; 

After this you can kill the session that preventing shutdown.

The hangs usually happened for two reasons :-

  • Query running on Database.
  • Transaction happened while you are trying to shutdown database.
For the first reason :

use v$session_longops Read more here.

Run the below query to check the query.

select count(*) from v$session_longops where time_remaining>0;

Second reason you can use

v$transaction Read from here.

Useful Document :-
Alert Log: Shutdown Waiting for Active Calls to Complete (Doc ID 1039389.6)

Thank you
Osama Mustafa

Oracle Database Patches Information

Posted on by Osama Mustafa in Database
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

Dealing with Crontab

Posted on by Osama Mustafa in Operating system
Schedule tasks under Linux is an powerful procedure which is used by almost everyone, and to do this using program called cron. more about it here .

Procedure :

make a new text file, and enter this line in that text file like the below :-

crontab myfirstjob

Formatting crontab file :-

what this file contains

Number
Meaning
Allowed range
1
Minutes
0-59
2
Hours
0-23
3
Days
1-31
4
Months
1-12 OR First 3 letters of the Month name
5
Days of the week
0-7 OR First 3 letters of the Day name
6
Name of the program
Any program

Some useful command can be used with cron :-

Show all the task running under cron.

crontab -l

edit the crontab

crontab -e

Some example from crontab file :-

# Minute   Hour      Day of Month       Month                 Day of Week        Command  
# (0-59)     (0-23)     (1-31)             (1-12 or Jan-Dec)    (0-6 or Sun-Sat)              
    0               12           *                             *                         *            /u01/backup.sh

For more example about crontab press here

Cheers
Osama Mustafa