Thursday, October 24, 2013

Some issues faced during upgrade to R12 (12.1.3) from 12.1.x and their Solutions



2  Run       AutoPatch R120     mth_pre_upgrade.sql         FAILED

"adwork002.log" 234201L, 8356714C

sqlplus -s MTH/***** @/u01/app/oracle/EBS/apps/apps_st/appl/mth/12.0.0/patch/115/sql/mth_pre_upgrade.sql
Connected.
DECLARE
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
ORA-06512: at line 59

Time when worker failed: Mon Apr 09 2012 00:28:06
"adwork002.log" 234201L, 8356714C               


Cause:  You're trying to create the same table (MTH_RESOURCES_D_TEMP) over and over again in your loop.
It will succeed the first time (provided the table does not yet exist), but will fail after that.

Solution:

SQL> conn mth/mth
Connected.
SQL> rename MTH_RESOURCES_D_TEMP to MTH_RESOURCES_D_TEMP_OLD;

Table renamed.

SQL> exit


Restart respective 2nd worker.

=========================================================================

ATTENTION: All workers either have failed or are waiting:

           FAILED: file POXOTCPO.sql on worker  1.
           FAILED: file arhzbobj.sql on worker  2.

        Control
Worker  Code      Context            Filename                    Status
------  --------  -----------------  --------------------------  --------------
     1  Run       AutoPatch R120     POXOTCPO.sql                FAILED
     2  Run       AutoPatch R120     arhzbobj.sql                FAILED


sqlplus -s APPS/***** @/u01/app/oracle/EBS/apps/apps_st/appl/po/12.0.0/patch/115/sql/POXOTCPO.sql
Connected.

Type body created.

O/S Message: Invalid argument


sqlplus -s APPS/***** @/u01/app/oracle/EBS/apps/apps_st/appl/ar/12.0.0/patch/115/sql/arhzbobj.sql
Connected.
drop type hz_person_cust_v2_bo_tbl
*


SQL> select OWNER,OBJECT_NAME,STATUS,OBJECT_TYPE from dba_objects where object_name like '%PO%_TYPE' and status='INVALID';

OWNER                          OBJECT_NAME                                                  STATUS  OBJECT_TYPE
------------------------------ ------------------------------------------------------------ ------- -------------------
APPS                           PO_EVENT_PARAMS_TYPE                                         INVALID TYPE BODY
APPS                           PO_VALIDATION_RESULTS_TYPE                                   INVALID TYPE BODY
APPS                           PO_AP_DIST_REC_TYPE                                          INVALID TYPE BODY
APPS                           PO_AP_LINE_LOC_REC_TYPE                                      INVALID TYPE BODY
APPS                           PO_DISTRIBUTIONS_REC_TYPE                                    INVALID TYPE BODY


===============================================================================================


ATTENTION: All workers either have failed or are waiting:

           FAILED: file xlajelns.pkh on worker  1.
           FAILED: file csdvints.pls on worker  6.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

[applmgr@ebs2 log]$ vi adwork001.log

sqlplus -s APPS/***** @/u01/app/oracle/EBS/apps/apps_st/appl/admin/EBS/out/p001invok.sql
Connected.
O/S Message: Invalid argument

[applmgr@ebs2 log]$ vi adwork006.log

sqlplus -s APPS/***** @/u01/app/oracle/EBS/apps/apps_st/appl/csd/12.0.0/patch/115/sql/csdvints.pls
Connected.
O/S Message: Invalid argument


Running Script Apreconb.pls Fails With Error 'O/S Message: Invalid argument' On OCFS2 File System (Doc ID 1264418.1)


I had entry of /dev/sdb1 like,

/dev/sdb1 /u01 ocfs2 rw,_netdev,datavolume,nointr  

My /etc/fstab entry look like after modification,

[root@ebs1 ~]# cat /etc/fstab
LABEL=/                 /                       ext3    defaults        1 1
LABEL=/boot             /boot                   ext3    defaults        1 2
tmpfs                   /dev/shm                tmpfs   defaults        0 0
devpts                  /dev/pts                devpts  gid=5,mode=620  0 0
sysfs                   /sys                    sysfs   defaults        0 0
proc                    /proc                   proc    defaults        0 0
LABEL=SWAP-sda2         swap                    swap    defaults        0 0
/dev/sdb1               /u01                    ocfs2   rw,_netdev,nointr     0 0
172.18.0.195:/software  /software               nfs     defaults        0 0



restarted patch, after which patch application was successful.
=====================================================================================

At the time of Upgrade from R12.1.1 to R12.1.3, while applying main patch 9239090


[applmgr@db1 log]$ tail u9239090.log

Relinking executables...


[applmgr@db1 log]$ tail -f adrelink.log

make: *** [/u01/app/oracle/EBS/apps/apps_st/appl/fem/12.0.0/bin/FEMCCE] Error
1
Done with link of fem executable 'FEMCCE' on Sun Apr 15 05:26:30 IST 2012

Relink of module "FEMCCE" failed.
See error messages above (also recorded in log file) for possible
reasons for the failure.  Also, please check that the Unix userid
running adrelink has read, write, and execute permissions
on the directory /u01/app/oracle/EBS/apps/apps_st/appl/fem/12.0.0/bin,
and that there is sufficient space remaining on the disk partition
containing your Oracle Applications installation.

Done with link of product 'fem' on Sun Apr 15 05:26:30 IST 2012

.
.
.
.
.
copying /u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bin/adshell.pl to
/u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bintmp/adshell.pl
copying /u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bin/aducsifm.pm to
/u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bintmp/aducsifm.pm
copying /u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bin/aducssp.pl to
/u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bintmp/aducssp.pl
copying /u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bin/adutils.pl to
/u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bintmp/adutils.pl
copying /u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bin/adpchnew to
/u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bintmp/adpatchnew
copying /u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bin/adadminnew to
/u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bintmp/adadminnew
copying /u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bin/adwrknew to
/u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bintmp/adworker
copying /u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bin/adctrlnew to
/u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bintmp/adctrlnew

Swapping bintmp and binstage.
Stage preparation complete.

adrelink is exiting with status 1

End of adrelink session
Date/time is  Sun Apr 15 05:27:47 IST 2012
**********************************************************

Solution:

1.  To fix this problem, users are required to replace the following line under the Linux section of the $AD_TOP/bin/adrelinknew.sh:

CPP_LDFLAGS=' -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/lib/stubs -lclntsh'

with

CPP_LDFLAGS=' -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/lib/stubs -lclntsh -Wl,--noinhibit-exec'

2. After making this change, users are then required to run the adadmin utility and relink application executables.

Output after relinking FEM_TOP with adadmin utility
**********************************************************

Done with link of fem executable 'FEMCCE' on Sun Apr 15 06:42:27 IST 2012

Done relinking module FEMCCE in product fem
Done with link of product 'fem' on Sun Apr 15 06:42:27 IST 2012


adrelink is exiting with status 0

End of adrelink session
Date/time is  Sun Apr 15 06:42:27 IST 2012
**********************************************************

Continue patch where it stuck on "An error occurred while relinking application programs.

Continue as if it were successful [No] : Yes

Continue with patch application...



Thank you,
Manish Nashikkar

No comments:

Post a Comment