Issue# 15:
Solution:
Reinstall OLAP manually after DBUA.
This blog contains part of my knowledge that I would like to share, I hope it can help others at sometime. IMPORTANT NOTE: Please make sure to test any solution mentioned here on a test environment first, it is not recommended applying them on your Production environment directly, the solution that worked in my environment is not guaranteed to work for yours.
Tuesday, November 10, 2020
Issues faced while upgrading Oracle Applications (E-Business Suite) from 11i to R12.2
Issue# 14:
During DB upgrade to 11.2.0.4 the following error appear:
update SYSTEM_PRIVILEGE_MAP set name = 'GRANT ANY OBJECT PRIVILEGE'
2 where privilege=-244;
update SYSTEM_PRIVILEGE_MAP set name = 'GRANT ANY OBJECT PRIVILEGE'
*
ERROR at line 1:
ORA-00001: unique constraint (SYS.I_SYSTEM_PRIVILEGE_MAP) violated
Solution:
As per ORA-00001: UNIQUE CONSTRAINT VIOLATED WHEN RUNNING THE POST UPGRADE STEP TO 11G (Doc ID 1240775.1)
The error can be ignored.
Issues faced while upgrading Oracle Applications (E-Business Suite) from 11i to R12.2
Issue# 13:
Relinking failed:
[apdpro@dbmig ~]$ adrelink.sh force=y "AD adadmin"
…
…
…
Starting link of ad executable 'adadmin' on Wed Apr 12 22:58:23 AST 2017
gcc -s -L/u03/dproora/8.0.6/lib -L/u03/dproora/8.0.6/lib/stubs -ldl -o /u03/dproappl/ad/11.5.0/bin/adadmin.new \
/u03/dproappl/ad/11.5.0/lib/adadmin.o \
/u03/dproappl/ad/11.5.0/lib/libad.a /u03/dproappl/fnd/11.5.0/lib/libfnd.a -lsql /u03/dproora/8.0.6/lib/nautab.o /u03/dproora/8.0.6/lib/naeet.o /u03/dproora/8.0.6/lib/naect.o /u03/dproora/8.0.6/lib/naedhs.o `cat /u03/dproora/8.0.6/lib/naldflgs` -lnetv2 -lnttcp -lnetwork -lncr -lclient -lvsn -lcommon -lgeneric -lmm -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -lnetv2 -lnttcp -lnetwork -lncr -lclient -lvsn -lcommon -lgeneric -lepc -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -lclient -lvsn -lcommon -lgeneric -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 `cat /u03/dproora/8.0.6/lib/sysliblist` -ldl -lpthread -lm /u03/dproora/8.0.6/rdbms/lib/defopt.o /u03/dproora/8.0.6/rdbms/lib/ssbbded.o
/usr/lib/gcc/i386-redhat-linux/3.4.6/libgcc_s.so: undefined reference to `dl_iterate_phdr@GLIBC_2.2.4'
/usr/lib/gcc/i386-redhat-linux/3.4.6/libgcc_s.so: undefined reference to `__stack_chk_fail@GLIBC_2.4'
collect2: ld returned 1 exit status
make: *** [/u03/dproappl/ad/11.5.0/bin/adadminnew] Error 1
Done with link of ad executable 'adadmin' on Wed Apr 12 22:58:23 AST 2017
Relink of module "adadmin" 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 /u03/dproappl/ad/11.5.0/bin,
and that there is sufficient space remaining on the disk partition
containing your Oracle Applications installation.
Done with link of product 'ad' on Wed Apr 12 22:58:23 AST 2017
adrelink is exiting with status 1
End of adrelink session
Date/time is Wed Apr 12 22:58:23 AST 2017
**********************************************************
Line-wrapping log file for readability ...
Done line-wrapping log file.
Original copy is /u03/dproappl/admin/log/adrelink.lsv
New copy is /u03/dproappl/admin/log/adrelink.log
[apdpro@dbmig ~]$
Solution:
Relink fails for Oracle 9.2 patchset with undefined reference to dl_iterate_phdr@GLIBC_2.2.4 (Doc ID 335515.1)
[root@dbmig bin]# cd /tmp
[root@dbmig tmp]# rpm -Uvh --force compat-oracle-el5-1.0-5.i386.rpm
Preparing... ########################################### [100%]
1:compat-oracle-el5 ########################################### [100%]
[root@dbmig tmp]#
[root@dbmig bin]# mv gcc gcc344
[root@dbmig bin]# mv g++ g++344
[root@dbmig bin]# ln -s gcc32 gcc
[root@dbmig bin]# ln -s g++32 g++
[root@dbmig bin]#
Issues faced while upgrading Oracle Applications (E-Business Suite) from 11i to R12.2
Issue# 12:
While applying patch# 7429271
ATTENTION: All workers either have failed or are waiting:
FAILED: file admorgb.pls on worker 1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Worker log:
create or replace package body ad_morg as
/* $Header: admorgb.pls 115. ...
AD Worker error:
ORA-04031: unable to allocate 42100 bytes of shared memory ("shared pool","unknown object","PL/SQL MPCODE","BAMIMA: Bam Buffer")
Unable to process file in PACKAGE mode.
Not converting file for Invoker's Rights because it appears to
be a package body creation script (based on the filename).
File is: /u03/dproappl/ad/11.5.0/patch/115/sql/admorgb.pls
sqlplus -s APPS/***** @/u03/dproappl/ad/11.5.0/patch/115/sql/admorgb.pls
create or replace package body ad_morg as
*
ERROR at line 1:
ORA-04031: unable to allocate 42100 bytes of shared memory ("shared
pool","unknown object","PL/SQL MPCODE","BAMIMA: Bam Buffer")
Time when worker failed: Wed Apr 12 2017 21:56:35
Solution:
- Stopped all workers > 3 > all
- Stopped pending workers > 5 > remaining workers
- Restart the database
- Restart the patch
- Restart failed worker
Subscribe to:
Posts (Atom)