Wednesday, April 23, 2014

adop hangs in 12.2 upgrade

In the process of  Oracle E-Business suite 12.2.3 upgrade i have noticed the issue.

Issue: adop hangs at grep process.

[appldev@ORA6DEVAPPAST ~]$ ps -fx
Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.8/FAQ
PID TTY STAT TIME COMMAND
20277 ? S 0:00 sshd: appldev@pts/1
20278 pts/1 Ss 0:00 \_ -bash
21072 pts/1 R+ 0:00 \_ ps -fx
19802 pts/0 S 0:00 -bash
19964 pts/0 S 0:00 \_ ksh
20188 pts/0 S 0:00 \_ bash
20255 pts/0 S+ 0:00 \_ strace adop
20256 pts/0 S+ 0:00 \_ /bin/sh /u01/dev/fs_ne/EBSapps/appl/ad/bin/adop
20267 pts/0 S+ 0:00 \_ /bin/sh /u01/dev/fs_ne/EBSapps/appl/ad/bin/adop
20268 pts/0 S+ 0:00 \_ grep s_base"
20269 pts/0 S+ 0:00 \_ sed s/^.*s_base[^>.]*>[ ]*\([^<]*\)<.*/\1/g; s/ *$//g
18040 ? S 0:00 sshd: appldev@notty
18043 ? Ss 0:00 \_ /usr/libexec/openssh/sftp-server

Debug :

[appldev@ORA6DEVAPPAST appl]$ sh -x adop
+ header_string=': adop_ux.sh 120.5.12020000.6 2012/11/30 09:16:44 sbandla ship $'
++ basename adop
+ program=adop
++ echo ': adop_ux.sh 120.5.12020000.6 2012/11/30 09:16:44 sbandla ship $'
++ awk '{print $3}'
+ prog_version=120.5.12020000.6
+ node_info_file=/u01/dev/fs2/FMW_Home/Oracle_EBS-app1/applications/oacore/APP-INF/node_info.txt
+ '[' '!' -f /u01/dev/fs2/FMW_Home/Oracle_EBS-app1/applications/oacore/APP-INF/node_info.txt ']'
++ hostname
++ sed 's/\..*//g'
+ host_name=ORA6DEVAPPAST
++ grep ORA6DEVAPPAST:CONTEXTFILE /u01/dev/fs2/FMW_Home/Oracle_EBS-app1/applications/oacore/APP-INF/node_info.txt
++ sed 's/^.*[^=]=//g; s/ *$//g'
+ context_file=
+ '[' '!' -f ']'
++ grep 's_base"'
++ sed 's/^.*s_base[^>.]*>[ ]*\([^<]*\)<.*/\1/g; s/ *$//g'

#######################node_info.txt file content#######################
ora6devappast:CONTEXTFILE=/u01/dev/fs2/inst/apps/devast_ora6devappast/appl/admin/devast_ora6devappast.xml
ora6devappast:INSTANCETOP=/u01/dev/fs2/inst/apps/devast_ora6devappast
ora6devappast:ORACLEHOME=/u01/dev/fs2/EBSapps/10.1.2
ora6devappast:FNDSECURE=/u01/dev/fs2/inst/apps/devast_ora6devappast/appl/fnd/12.0.0/secure
ora6devappast:DBCFILENAME=devast.dbc
ora6devappast:TNSADMIN=/u01/dev/fs2/inst/apps/devast_ora6devappast/ora/10.1.2/network/admin
ora6devappast:TWOTASK=devast
ora6devappast:LDLIBRARYPATH=/u01/dev/fs2/EBSapps/10.1.2/lib32:/u01/dev/fs2/EBSapps/10.1.2/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/dev/fs2/EBSapps/10.1.2/jdk/jre/lib/i386:/u01/dev/fs2/EBSapps/10.1.2/jdk/jre/lib/i386/server:/u01/dev/fs2/EBSapps/10.1.2/jdk/jre/lib/i386/native_threads:/u01/dev/fs2/EBSapps/appl/sht/12.0.0/lib
ora6devappast:FNDTOP=/u01/dev/fs2/EBSapps/appl/fnd/12.0.0
ora6devappast:LIBPATH=
ora6devappast:SHLIBPATH=
ora6devappast:OAHTML=/u01/dev/fs2/FMW_Home/Oracle_EBS-app1/applications/oacore/html
ora6devappast:APPLTMP=/u01/dev/fs2/inst/apps/devast_ora6devappast/appltmp
ora6devappast:AUTOP=/u01/dev/fs2/EBSapps/appl/au/12.0.0
ora6devappast:PLATFORM=LINUX_X86-64
ora6devappast:WLSPROPERTYFILE=/u01/dev/fs2/inst/apps/devast_ora6devappast/appl/admin/oacore_wls.properties
#########################Issue Resolution##########################
Modify hostname in /etc/sysconf/network from ORA6DEVAPPAST to ora6devappast
 Restart the server to udpate the changes.
 ##########################Thank you####################
With the help of  VasuBalla i am able to identify and fix the issue.