Showing posts from 2016

When the last time the password has been changed ?

Do you want to know what is the last time the DBA or developers change the password ?
Using the below table :-
Name Null Type USER#        NOT NULL NUMBER NAME         NOT NULL NUMBER         TYPE#        NOT NULL VARCHAR2(30)   PASSWORD     NUMBER         DATATS#      NOT NULL NUMBER         TEMPTS#      NOT NULL DATE           CTIME        NOT NULL

Oracle Database 12c Release 2


OCP Upgrade 1Z0-060 Exam guide

This guide will get Oracle admins up to date with the latest developments in Oracle 12c. It includes all the necessary information that you need to implement in your existing systems.

All of the information in this book has been handpicked to help you study for the Oracle 12c upgrade exam. Each chapter has been written with the objective of helping you pass this exam with ease. Content in this book is aligned with the objectives of the exam, making it really easy to follow the course content. Every example mentioned in this book has been tried and tested in actual environment. Real-world examples will help you learn about new features such as multitenant containers database architecture, managing containers, pluggable databases, database administration enhancements, database auditing, tuning, backup, and flashback enhancements.

You will also learn about storage enhancements, security updates, tuning, troubleshooting, and backup enhancements. This book also covers section 2 of the exa…

2016 Another Year In this world

I don't know if it is early to write something now, most of people will share this during the end of December but i choose to write mine earlier, i will not share anything technical this time but i will share what i did during this year maybe it will be useful for someone :) so enjoy reading.

I did a lot of things during 2016 and most of them related to my work and what i love which is Oracle and contribution in Oracle community there was differenct conference during this year which took a lot of time and travel i don't how much time i spent in the air but i am sure it's more than 10 days since i am living in the other side of the world which is Jordan - Amman or Sometimes Dubai.

I start the year with one of the best conference and the well known one which is Rocky mountains and this is was my first time in this amazing conference during the conference i celebrate my birthday in Denver with my friends, alot of the conference and traveling so i will mention them as point (…

adop exiting with status = 255 (Fail)

[oracle@ebsnew appl]$ adop phase=abort

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

 Please wait. Validating credentials...

Enter the RUN file system context file name [/u01/oracle/EBSTST/fs1/inst/apps/EBSTST_ebsnew/appl/admin/EBSTST_ebsnew.xml]:

Enter the PATCH file system context file name [/u01/oracle/EBSTST/fs2/inst/apps/EBSTST_ebsnew/appl/admin/EBSTST_ebsnew.xml]:

[STATEMENT] [END   2016/11/22 17:15:45] Performing verification of parameters
[STATEMENT] [START 2016/11/22 17:15:45] Checking for the required ENV setup
[STATEMENT] [END   2016/11/22 17:15:45] Checking for the required ENV setup

************* Start of  session *************
 version: 12.2.0
 started at: Tue Nov 22 2016 17:15:45

APPL_TOP is set to /u01/oracle/EBSTST/fs1/EBSapps/appl
[STATEMENT] [START 2016/11/22 17:15:45] Determining admin node
[STATEMENT] [END   2016/11/22 17:15:47] Determining admin node
[STATEMENT] [START 2016/11/22 17:15:49] Acquiring lock on sessions table

Remove Conflict Patch From Weblogic

When trying to apply new patch to the weblogic the following error shown up :-

[oracle@ebsnew bsu]$ ./ -prod_dir=/u01/oracle/EBSTST/fs1/FMW_Home/wlserver_10.3/ -patch_download_dir=/u01/oracle/EBSTST/fs1/FMW_Home/utils/bsu/cache_dir/                                 -patchlist=EJUW -verbose -install
Checking for conflicts...

Conflict(s) detected - resolve conflict condition and execute patch installation again
Conflict condition details follow:
Patch EJUW is mutually exclusive and cannot coexist with patch(es): Y5AP,BLTG,FCX7,1LRI,VKXF,2GYW,CW9T

To solve this issue you have to remove the patch and reapply the one again;-

[oracle@ebsnew bsu]$ ./ -prod_dir=/u01/oracle/EBSTST/fs1/FMW_Home/wlserver_10.3/ -patchlist=Y5AP,BLTG,FCX7,1LRI,VKXF,2GYW,CW9T -verbose -remove
Checking for conflicts..........

After this try to apply the patch again.
Thanks Osama

RMOUG - Training day 2017


One of the best conference Where all the geeks around the world will be there in one place.

Meet me there i will present in RMOUG



Installing SIEBEL 15 on RAC took a lot of time

The Situation like the following when we was trying to install SIEBEL On RAC 12C its took 10 hours for importing 2 database which is usually takes 2 hours at max, storage was NFS , enabled DNFS for sure.

simulate the following case :-

On single node , 2 hours like usual.On RAC 12c using DNFS file system 10 hours.On RAC 12c using DNFS but single node of RAC took 10 hours.On RAC 12c using local file system and single node 10 hours.Install oracle 11gR2 RAC and try it again took 4 hours using ASM on DNFS. Using SLOB didn't see anything related to storage issue.

After investigation and a lot of working without tuning on 12c it's took 1 Hour and 37 min.

The problem with two different way :-

Heartbeat not configured correctly.SIEBEL Installation should not run with Index parallel option.
Thanks Osama.

Create new swap file to Linux

to add new swap file to Linux just follow the below steps , in my case i will add 32GB and i am not using LVM :-
just create file by the below command :-touch /new.swapWrite on the file :- dd if=/dev/zero of=/new.swap bs=1024 count=33554432Format the file :-mkswap /new.swapAdd the file to the system as a swap file.swapon /new.swapfinally add it to fstab :-/new.swap none swap sw 0 0 Thanks Osama

Direct NFS: please check that oradism is setuid

The above error appeared in Database Alertlog  and it's related to permission, i am using DNFS as file system for Database :-

 ls -ltr  $ORACLE_HOME/bin/oradism

-rwxrwxr-x 1 sorabill oinstall 109247 Jul  7  2014 /u01/app/oracle/product/12.1.0/dbhome_1//bin/oradism
as you see from the above the permission for this file is wrong 
Change to root userRun the following command :-cd /u01/app/oracle/product/12.1.0/dbhome_1//binchmod 750 oradismchmod u+s oradismRestart DB.
Check again.
Cheers Osama

Change SCAN Listener from etc/host to DNS

Changing SCAN LISTENER from etc/hosts on Linux to use DNS which mean the from one IP to 3 IPs

The SCAN listener will remain the same without any change therefore like i mentioned before the these steps only provide changing for SCAN to use DNS.

"I Will not post any output"

the configuration for the IP should be added to DNS and to check this on OS level you should nslookup command :-

On node #1 run the below command to check the Listener status and see the current configuration:-
srvctl status scan
srvctl status scan_listener
srvctl config scan
srvctl config scan_listener

On node #2 run the below command to check the Listener status and see the current configuration:-
srvctl status scan
srvctl status scan_listener
srvctl config scan
srvctl config scan_listener
The output should be the same for both.

Stop all the listeners on your RAC as root :-

srvctl stop scan_listener
srvctl stop scan
srvctl status scan
srvctl status scan_listener
Remove or comment any entire in /etc/hosts after don…

OTN Appreciation Day : Oracle WebLogic 12c #ThanksOTN

OTN Appreciation Day The idea came from Our Oracle ACE Director ( the Mind ) Tim Hall Here 

 OTN : Oracle Technology network  or let me say OTN gather all of us no matter where you live in this world ? only one thing gather us our love to OTN.

OTN done so much things to all of us, one of things i love and most of the people in the community know that is Fusion middleware and i will write about Oracle Weblogic 12cR2 the documentation available here 

Oracle Weblogic 12cR2 comes with different features such as the following:-

Multitenancy SupportContinuous AvailabilityJava EE 7 SupportJDK 8 CertificationDocker CertificationRuntime ImprovementsManageability ImprovementsDocumentation Update History for Release 12.2.1Standards Support, Supported Configurations, and WebLogic Server CompatibilityDeprecated Functionality (WebLogic Server 12.2.1)Removed Functionality and Components
If will talk about them all it will be documentation not blog post therefore i will choose 2 or 3 topics.

Docker Ce…

Install Oracle EBS R12.2 StartCD 51 on RAC

this post is questionnaire more than a technical, EBS startCD 51 released before 1 month and it's comes with different features such as DB 12c will be installed and it's support RAC installation Features immediately which mean you don't have to install EBS on Single node then convert to RAC.

Like the above pic, well everything done successfully for DB installation without any problem same as below :-

The installation is multi - node which mean Apps on different server, when trying to connect APPS to RAC DB each time the same error appered with no sense which is 
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Be noted that the DB is reigster with SCAN and tnsping is working , and i can access DB using TOAD thru SCAN or Local Listener
Therefore after multi try of the installation and fix the error, i choose the old way which is Single node and covert to RAC and the funny thing it's working without any issue.
If there is any id…

Result: Clock synchronization check using Network Time Protocol(NTP) failed RAC

When trying to Run the Runcluvfy command to check RAC pre requsiites the NTP failed , but at the same time it's gives you the solution to solve it  :-

in the following file :- /etc/sysconfig/ntpd open it and edit it, add the following :-

[root@prddb2 .ssh]# cat /etc/sysconfig/ntpd
# Drop root to id 'ntp:ntp' by default.
OPTIONS="-x -u ntp:ntp -p /var/run/ -g"
Add the above letter in RED color only.


Skip DNS reslov.conf check during RAC configuration

Before start reading this post you should know that Oracle is highly recommended using DNS while configure Oracle RAC include to this it will make your life easier in case any one wants to change the IP's.

However today i was working on EBS installation using startCD51 and this is allow me to install EBS directly on RAC but the customer database RAC not configured to use DNS so everytime i was trying to install EBS

The following Error shown up in my face :-

INFO: Verification Result for Node:RAC1,RAC2WARNING: Result values are not available for this verification taskINFO: *********************************************INFO: Task resolv.conf Integrity: This task checks consistency of file /etc/resolv.conf file across nodesINFO: Severity:CRITICALINFO: OverallStatus:OPERATION_FAILEDINFO: -----------------------------------------------
and there is nothing i can do to skip this error,

i choose to do the following ;-

Rename resolv.conf to resolv.conf.old for example

and re run the instal…

Maximum locked memory check Oracle

INFO: Maximum locked memory check: Check maximum locked memory setting on the system
To solve this issue just add the following to /etc/security/limits.conf

*                soft   memlock         unlimited
*               hard    memlock         unlimited

Thank you
Osama mustafa

ORA-12154: TNS:could not resolve the connect identifier specified” error during DBCA

While trying to install Oracle Database 11gR2 on Windows 2012R2 I faced the following error :-

ORA-12154: TNS:could not resolve the connect identifier specified” error during DBCA
After checking the logs and investigate about the issue  :-

The password was containing "@" after removed it from the password everything works perfectly.


Unable to retreive config file from Database

The above error shown up when trying to install APPS and connect it to the RAC/single database to fix this issue Just copy the configuration file after the installation is done successfully under the path :- /ebs1stag/oracle/SEBSDB/12.1.0/appsutil for example  the file name usually conf_SEBSDB.txt and load the file, try again.
Thank you Osama

CRS-5013 RAC 12c

When starting Oracle RAC 12c the following error appears :-

[root@------ bin]# ./crsctl check cluster
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
CRS-4534: Cannot communicate with Event Manager

CRS-5013: Agent "ORAROOTAGENT" failed to start process "/grid/app/" for action "start": details at "(:CLSN00008:)" in "/grid/app/oracle/diag/crs/....../crs/trace/ohasd_orarootagent_root.trc"

The cause :- DB Node was reboot.

To solve this issue :-

CRS-2672: Attempting to start 'ora.crf' on CRS-2674: Start of 'ora.crf' on failed CRS-2679: Attempting to clean 'ora.crf' on (Doc ID 1902447.1)

Osama' Class not Found

Aug 24, 2016 2:23:57 PM weblogic.nodemanager.server.AbstractServerManager log
INFO: Server output log file is '/u01/Oracle/Middleware/domains/mserver/STAGEDQ/servers/EDQ_INS1_SIPEDQ1/logs/EDQ_INS1_SIPEDQ1.out' Server failed to start up. See server output log for more details.
        at weblogic.nodemanager.server.AbstractServerManager.start(
        at weblogic.nodemanager.server.ServerManager.start(
        at weblogic.nodemanager.server.Handler.handleStart(
        at weblogic.nodemanager.server.Handler.handleCommand(
Aug 24, 2016 2:26:00 PM weblogic.nodemanager.server.Handler handleStart
WARNING: Exception while starting server 'EDQ_INS1_SIPEDQ1' Server failed to start up. See server output log for more details.

Apply Weblogic Patch Offline mode

Shutdown all the services for weblogic.unzip the patch under $MW_HOME/utils/bsu/cache_dirrun the following command :- ./ -prod_dir=$weblogic_home  -patch_download_dir=Patch_location -patchlist=patch_id -verbose -install

The final Result 

Or you can apply the weblogic patch using smart update

Osama Mustafa


Thank you for Oracle ACE Program  & OTN To join this Tour 2016 it's was my pleasure  to be a part of it

This is was my first time visiting this side of the world & presenting in Latin America, the tour covered south and north Latin America with different countries starting from Brazil and ending with Colombia, my part was to visit the following country : Brazil , Uruguay , Argentina and finally Mexico city.

Well it was very hard to find flights from Jordan - Amman to Brazil and most of the flight fully booked so i put my name on waiting list like any other else i was expecting that i will cancel any time but Qatar Airlines called me at 9 pm before the flights with 5 hours informing me that there is seat if i want to take it, so my answer was YES.
Went home finish packing and heading to the airport,  3 hours to QATAR and after that 13 hours to Brazil and it's was my first stop for OTN TOUR , the event started with amazing attendee, the keynote was in Portuguese  which i…

Oracle Database 12c Security Cookbook

If you want to learn about security as  beginners or professional it's very nice to add this book to your Library.

I was one of the technical reviewer for this book and the topics and table of contents covered everything you will need as DBA or as someone who wants to learn something.

The Book is available online via publisher website, or via amazon  Special Thanks for my friend Gokhan Atil.
Thanks  Osama Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong.

trying to startup EBS R12.2. with the following error :- Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong.
to solve this do the following :-

[oracle@tiperp tsterp]$ cd $APPL_TOP
[oracle@tiperp appl]$ pwd

after souring the environment try to startup the EBS again. 
Thank you  Osama

EBS Clone R12.2.4 Guide

In This document i will show how to clone EBS R12.2.4 Step by step Link Here 


OBIA Installation

The following link describe how to install OBIA on Linux 6.7 Here

Thank you
Osama Mustafa

Latest Video Upload Part #1

Recently i was working on some installation and configuration for Fusion and as you see the video uploaded to my channel :-

1- ODI Installation here
2- Oracle Enterprise manager 13c installation here
3- Oracle BI Installation On Linux here
4- Install Oracle BI Apps On Linux here


EBS R12.2. not able to clone due

The EBS R12.2 failed due to the below error :- INSTE8_APPLY 255
AutoConfig is exiting with status 1
RC-50013: Fatal: Instantiate driver did not complete successfully.
The Solution :-

The error happened to perl version while trying to execute this, if you check the following :-

which perl
/usr/bin/perl  to solve this issue :-

export PATH=$ORACLE_HOME/perl/bin:$PATH

Now, run again

Osama mustafa

Difference between OIM , OAM And OID ?

OAM :- Oracle Access manager 

Regarding to Oracle Documentation

Oracle Access Management is a Java, Enterprise Edition (Java EE)-based enterprise-level security application that provides a full range of Web-perimeter security functions and Web single sign-on services including identity context, authentication and authorization; policy administration; testing; logging; auditing; and more. It leverages shared platform services including session management, Identity Context, risk analytic, and auditing, and provides restricted access to confidential information.

From the above picture as you see OAM provides single point to control all resource grants in an enterprise where multiple applications exist on different platform.

You can refer to oracle Doc here.

OAM provides:

Single Sign On (SSO)AuthenticationAuthorizationAccess AuditingPolicy Administration
There is more but you can refer to the above documentation.
OIM : Oracle Identity manager 

enables enterprises to manage the entire user l…