BLOG

Skip DNS reslov.conf check during RAC configuration

Posted on by Osama Mustafa in Operating system
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 installation again .

perfect worked for me

Thanks
Osama

Maximum locked memory check Oracle

Posted on by Osama Mustafa in Operating system

INFO: Maximum locked memory check: Check maximum locked memory setting on the system
INFO: Severity:IGNORABLE
INFO: OverallStatus:VERIFICATION_FAILED

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

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

Thanks
Osama 

Unable to retrieve config file from Database

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

Posted on by Osama Mustafa in Database
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/12.1.0.2/bin/osysmond” 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)

Thanks
Osama

oracle.security.jps.wls.listeners.JpsApplicationLifecycleListener’ Class not Found

Posted on by Osama Mustafa in Application

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’

java.io.IOException: Server failed to start up. See server output log for more details.
        at weblogic.nodemanager.server.AbstractServerManager.start(AbstractServerManager.java:196)
        at weblogic.nodemanager.server.ServerManager.start(ServerManager.java:23)
        at weblogic.nodemanager.server.Handler.handleStart(Handler.java:609)
        at weblogic.nodemanager.server.Handler.handleCommand(Handler.java:121)
        at weblogic.nodemanager.server.Handler.run(Handler.java:71)
        at java.lang.Thread.run(Thread.java:745)
Aug 24, 2016 2:26:00 PM weblogic.nodemanager.server.Handler handleStart
WARNING: Exception while starting server ‘EDQ_INS1_SIPEDQ1’
java.io.IOException: Server failed to start up. See server output log for more details.
        at weblogic.nodemanager.server.AbstractServerManager.start(AbstractServerManager.java:196)
        at weblogic.nodemanager.server.ServerManager.start(ServerManager.java:23)
        at weblogic.nodemanager.server.Handler.handleStart(Handler.java:609)
        at weblogic.nodemanager.server.Handler.handleCommand(Handler.java:121)
        at weblogic.nodemanager.server.Handler.run(Handler.java:71)
        at java.lang.Thread.run(Thread.java:745)

The above is EDQ Cluster Error, Fresh installation after searching inside the logs i found the following :-

‘oracle.security.jps.wls.listeners.JpsApplicationLifecycleListener’ Class not Found

This is simply happened because StartScriptEnabled property in nodemanager.properties file was set to ‘false’. therefore must set to true

Apply Weblogic Patch Offline mode

Posted on by Osama Mustafa in Fusion Middleware

  1. Shutdown all the services for weblogic.
  2. unzip the patch under $MW_HOME/utils/bsu/cache_dir
  3. run the following command :-

./bsu.sh -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

Thanks
Osama Mustafa

OTN TOUR : LATIN AMERICA 2016

Posted on by Osama Mustafa in News
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 can’t understand 🙂 , i had two session about fusion middleware on in the morning and the other one afternoon, it’s was amazing meeting new people and the old friends during the event, after the conference we had Speaker dinner.

Next day i had to move to the airport next stop was Uruguay i reach the hotel at midnight tired because of this i slept immediately i woke up at 7 am for the conference, met Deiby and Carlos in the Lobby and we walk together to the university, i had two session as well after the conference we had perfect dinner with all our friends.

I spent one day in Uruguay and did some city tour i have to say it was cold and rainy but nice city, the last stop was Mexico which is very amazing city i love it the conference was amazing, the people everything.

It’s very short description about the tour but better than not mentioning anything.

Thank
Osama

Oracle Database 12c Security Cookbook

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

adstpall.sh: Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong.

Posted on by Osama Mustafa in Application
trying to startup EBS R12.2. with the following error :-

adstpall.sh: 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
/u01/app/product/tsterp/fs1/EBSapps/appl

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