BLOG

adop exiting with status = 255 (Fail)

Posted on by Osama Mustafa in Application
[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
[STATEMENT] [END   2016/11/22 17:15:50] Acquiring lock on sessions table
[STATEMENT] [START 2016/11/22 17:15:50] Checking for any pending sessions
[STATEMENT] There is already a hotpatch session which is incomplete. Details are:
[STATEMENT]     Session Id: 2
[STATEMENT]     Prepare phase status: X
[STATEMENT]     Apply phase status: P
[STATEMENT]     Cutover  phase status: R
[STATEMENT]     Abort phase status: X
[STATEMENT]     Session status: F
[STATEMENT] [Note: Y denotes that the phase is done
[STATEMENT]        N denotes that the phase has not been completed
[STATEMENT]        X denotes that the phase is not applicable
[STATEMENT]        R denotes that the phase is running (in progress) or ran
[STATEMENT]        F denotes that the phase has failed
[STATEMENT]        P (is applicable only to APPLY phase) denotes atleast
[STATEMENT]           one patch is already applied for the session id
[STATEMENT] Online patching tool cannot proceed when a previous patching session is incomplete
[STATEMENT] Please ensure no pending patching sessions exist before trying a new patch
[ERROR]     Unrecoverable error occured. Exiting the current session.
[STATEMENT] [START 2016/11/22 17:16:08] Unlocking sessions table
[STATEMENT] [END   2016/11/22 17:16:09] Unlocking sessions table
[STATEMENT] Log file: /adop_20161122_171500.log
[STATEMENT] [START 2016/11/22 17:16:11] Unlocking sessions table
[STATEMENT] [END   2016/11/22 17:16:12] Unlocking sessions table
Can’t call method “close” on an undefined value at /u01/oracle/EBSTST/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/Phase.pm line 239.

adop exiting with status = 255 (Fail)

I tried different thing but we run the abort again it’s working , and do the following as well.

Run Autoconfig
run adop phase=fs_clone

Thanks.

Remove Conflict Patch From Weblogic

Posted on by Osama Mustafa in Fusion Middleware
When trying to apply new patch to the weblogic the following error shown up :-

[oracle@ebsnew bsu]$ ./bsu.sh -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]$ ./bsu.sh -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

Installing SIEBEL 15 on RAC took a lot of time

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

Posted on by Osama Mustafa in Operating system
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.swap
  • Write on the file :-
    •  dd if=/dev/zero of=/new.swap bs=1024 count=33554432
  • Format the file :-
    • mkswap /new.swap
  • Add the file to the system as a swap file.
    • swapon /new.swap
  • finally add it to fstab :-
    • /new.swap none swap sw 0 0
Thanks
Osama

Direct NFS: please check that oradism is setuid

Posted on by Osama Mustafa in Operating system
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 user
  • Run the following command :-
    • cd /u01/app/oracle/product/12.1.0/dbhome_1//bin
    • chmod 750 oradism
    • chmod u+s oradism
  • Restart DB.
Check again.
Cheers
Osama

Change SCAN Listener from etc/host to DNS

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

Let’s modify the scan :-

srvctl modify scan -n
srvctl modify scan_listener –u

Start listener :-

srvctl start scan
srvctl start scan_listener
srvctl status scan
srvctl status scan_listener

Thanks
Osama

OTN Appreciation Day : Oracle WebLogic 12c #ThanksOTN

Posted on by Osama Mustafa in News
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 Support
  • Continuous Availability
  • Java EE 7 Support
  • JDK 8 Certification
  • Docker Certification
  • Runtime Improvements
  • Manageability Improvements
  • Documentation Update History for Release 12.2.1
  • Standards Support, Supported Configurations, and WebLogic Server Compatibility
  • Deprecated 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 Certification

Oracle WebLogic Server 12.2.1 is certified to run inside a Docker container. Docker is a Linux-based container technology that enables you to quickly create lightweight clustered and non-clustered WebLogic Server domain configurations on a single host OS or virtual machines, for either development or production environments.

you can have access to github here and how to Run Weblogic on Docker check here 

  • Multitenancy Support

Multitenancy in WebLogic Server provides a sharable infrastructure for use by multiple organizations. These organizations are a conceptual grouping of your own choosing, which you can think of as tenants. By allowing one domain to support multiple tenants, Weblogic Server Multitenant improves density and achieves a more efficient use of resources while eliminating the hurdles typically present when trying to share multiple applications: runtime cross-application impact, security differences, data co-mingling, and administrative challenges.

 WebLogic Server MT enables an end to end multitenant infrastructure, including multitenancy from the load balancer to the middle tier and cache tier, and to the database tier. WebLogic Server MT extends the Oracle WebLogic Server Enterprise Edition and Oracle WebLogic Suite products

Alot of different features.

Thanks
Osama

Install Oracle EBS R12.2 StartCD 51 on RAC

Posted on by Osama Mustafa in Application
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 idea about this error please comment below maybe i missed something 
Thanks
Osama

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

Posted on by Osama Mustafa in Operating system
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/ntpd.pid -g”

Add the above letter in RED color only.

Thanks
Osama