Tuesday, July 22, 2014

Error in 12.2.3 Cloning

On the target server you may get below error message when running perl adcfgclone.pl appsTier

error: db3 error(13) from dbenv->open: Permission denied
error: cannot open Packages index using db3 - Permission denied (13)
error: cannot open Packages database in /var/lib/rpm
error: db3 error(13) from dbenv->open: Permission denied
error: cannot open Packages database in /var/lib/rpm
error: db3 error(13) from dbenv->open: Permission denied
error: cannot open Packages index using db3 - Permission denied (13)
error: cannot open Packages database in /var/lib/rpm
error: db3 error(13) from dbenv->open: Permission denied
error: cannot open Packages database in /var/lib/rpm

###############################################################################
The issue is related to permissions for application user account on  /var/lib/rpm/

[root@ora6crpappast ~]# ls -l /var/lib/rpm/
total 86228
-rwxrwxrwx. 1 root root  5550080 Jun 11 10:31 Basenames
-rwxrwxrwx. 1 root root    12288 Apr 23 18:47 Conflictname
-rw-r--r--. 1 root root    24576 Jul 22 10:17 __db.001
-rw-r--r--. 1 root root   237568 Jul 22 10:17 __db.002
-rw-r--r--. 1 root root  1318912 Jul 22 10:17 __db.003
-rw-r--r--. 1 root root   761856 Jul 22 10:17 __db.004

as a root user login to cd /var/lib/rpm/ 

grant 777 permissions. 

chmod 777 *db*

-rwxrwxrwx. 1 root root    24576 Jul 22 10:17 __db.001
-rwxrwxrwx. 1 root root   761856 Jul 22 10:17 __db.004
-rwxrwxrwx. 1 root root  1318912 Jul 22 10:17 __db.003
-rwxrwxrwx. 1 root root   237568 Jul 22 10:17 __db.002

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.