Issues faced while upgrading Oracle Applications (E-Business Suite) from 11i to R12.2

 Issue# 11:

When trying to enable maintenance mode it failed to change the profile option value:

Please select an option:

 

   1.    Enable Maintenance Mode

 

   2.    Disable Maintenance Mode

 

   3.    Return to Main Menu

 

 

 

Enter your choice [3] : 1

 

sqlplus -s &un_apps/***** @/u03/dproappl/ad/11.5.0/patch/115/sql/adsetmmd.sql ENABLE

 

An error occurred while running adsetmmd.sql.

Continue as if it were successful [No] :

 

Solution:

SQL> create table fnd_profile_option_values_bak as select * from fnd_profile_option_values ;

 

Table created.

 

SQL>

 

SQL> select profile_option_id from FND_PROFILE_OPTIONS where PROFILE_OPTION_NAME ='APPS_MAINTENANCE_MODE';

 

PROFILE_OPTION_ID

-----------------

                     5791

 

SQL>

 

SQL> col PROFILE_OPTION_VALUE for a25

select APPLICATION_ID,PROFILE_OPTION_ID,PROFILE_OPTION_VALUE from fnd_profile_option_values where profile_option_id='5791';

 

APPLICATION_ID PROFILE_OPTION_ID PROFILE_OPTION_VALUE

-------------- ----------------- -------------------------

                     0                             5791 NORMAL

 

SQL> update fnd_profile_option_values set profile_option_value ='MAINT' where profile_option_id='5791';

 

1 row updated.

 

SQL> commit;

 

Commit complete.

 

SQL> select APPLICATION_ID,PROFILE_OPTION_ID,PROFILE_OPTION_VALUE from fnd_profile_option_values where profile_option_id='5791';

 

APPLICATION_ID PROFILE_OPTION_ID PROFILE_OPTION_VALUE

-------------- ----------------- -------------------------

                     0                             5791 MAINT

 

SQL>

Issues faced while upgrading Oracle Applications (E-Business Suite) from 11i to R12.2

 Issue# 10:

Relinking MT executables failed.

 

Solution:

To determine which gcc executable is used by the application run the following:

As the user who is facing the issue run:

[apdpro@dbmig bin]$ which gcc

/u03/dproora/8.0.6/bin/gcc

[apdpro@dbmig bin]$

 

To check for gcc version used:

[apdpro@dbmig ~]$ gcc -v

Reading specs from /usr/lib/gcc/i386-redhat-linux/3.4.6/specs

Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --with-system-zlib --enable-__cxa_atexit --disable-libunwind-exceptions --enable-languages=c,c++,f77 --disable-libgcj --host=i386-redhat-linux

Thread model: posix

gcc version 3.4.6 20060404 (Red Hat 3.4.6-4.1)

[apdpro@dbmig ~]$

 

From root check the version of gcc under /usr/bin:

[root@dbmig oracle]# cd /usr/bin

[root@dbmig bin]# ls -l gcc* g++*

lrwxrwxrwx 1 root root    14 Apr 21 02:17 g++ -> /usr/bin/g++32

-rwxr-xr-x 3 root root 85016 Apr 28  2005 g++32

-rwxr-xr-x 3 root root 93140 Nov 12  2010 g++34

lrwxrwxrwx 1 root root     5 Apr 12 23:38 g++344 -> g++34

-rwxr-xr-x 1 root root   914 May 22  2008 g++344_2

lrwxrwxrwx 1 root root    14 Apr 21 02:16 gcc -> /usr/bin/gcc32

-rwxr-xr-x 2 root root 84760 Apr 28  2005 gcc32

-rwxr-xr-x 2 root root 89792 Nov 12  2010 gcc34

lrwxrwxrwx 1 root root     5 Apr 12 23:38 gcc344 -> gcc34

-rwxr-xr-x 1 root root  2018 Jun  6  2007 gccmakedep

-rwxr-xr-x 1 root root   914 May 22  2008 gcc_old

lrwxrwxrwx 1 root root    14 Apr 20 19:12 gcc.orig -> /usr/bin/gcc32

lrwxrwxrwx 1 root root    32 Apr 12 23:56 gcc.orig2 -> /usr/bin/i386-redhat-linux-gcc32

-rwxr-xr-x 1 root root   914 May 22  2008 g++_old

lrwxrwxrwx 1 root root     5 Apr 18 22:53 g++.orig -> g++32

lrwxrwxrwx 1 root root    32 Apr 12 23:56 g++.orig2 -> /usr/bin/i386-redhat-linux-g++32

[root@dbmig bin]#

 

[root@dbmig bin]# which gcc

/usr/bin/gcc

[root@dbmig bin]#

 

[root@dbmig bin]# gcc -v

Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2.3/specs

Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --with-system-zlib --enable-__cxa_atexit --enable-languages=c,c++ --disable-libgcj --host=i386-redhat-linux

Thread model: posix

gcc version 3.2.3 20030502 (Red Hat Linux 3.2.3-47.3)

[root@dbmig bin]#

 

-          From the above it seems that the gcc version running from ORALE_HOME is higher than the required version as per    How to Deal with Relink, make Failed on Linux ? ERRORS : bin/sh: /usr/bin/cc: cannot execute binary file. or undefined reference to `dl_iterate_phdr@GLIBC_x.x.y'....make: *** [f60run] Error 126" (Doc ID 833732.1)

 

-          Remove the higher gcc reference and create a softlink to /usr/bin gcc

[apdpro@dbmig ~]$ cd /u03/dproora/8.0.6/bin/

[apdpro@dbmig bin]$

[apdpro@dbmig bin]$ mv gcc gcc_3.4.6

[apdpro@dbmig bin]$ ln -s /usr/bin/gcc /u03/dproora/8.0.6/bin/gcc

[apdpro@dbmig bin]$ which gcc

/u03/dproora/8.0.6/bin/gcc

[apdpro@dbmig bin]$ gcc -v

Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2.3/specs

Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --with-system-zlib --enable-__cxa_atexit --enable-languages=c,c++ --disable-libgcj --host=i386-redhat-linux

Thread model: posix

gcc version 3.2.3 20030502 (Red Hat Linux 3.2.3-47.3)

[apdpro@dbmig bin]$

 

-          Run adadmin or adrelink.sh .

Issues faced while upgrading Oracle Applications (E-Business Suite) from 11i to R12.2

 Issue# 9:

While installing 11.2.0.1 DB home relinking failed.

Log file contains the following error:

INFO: /lib/libgcc_s.so.1: undefined reference to `__stack_chk_fail@GLIBC_2.4'
collect2: ld returned 1 exit status

 

Solution:

11.2 Install on Linux Fails with makefile Error:"__stack_chk_fail@GLIBC_2.4" (Doc ID 1220843.1)

login as root user:

% cd /usr/bin (as root)

% mv gcc gcc.old

% mv g++ g++.old

% ln -s gcc34 gcc

% ln -s g++34 g++