This post is part 4 of the “11i to R12.1.3 upgrade” series. For other parts click on below links.

1) Install Fresh EBS 11i on Linux 5 32 Bit (PART 1 in “11i to R12.1.3 upgrade” series)
2) Upgrade database 9.2.0.6 to 11.2.0.4 in 11i (PART 2 in “11i to R12.1.3 upgrade” series)
3) 11i Split configuration- Move 11g Database to Linux 6 64Bit (PART 3 in “11i to R12.1.3 upgrade” series)
4) Upgrade 11i TO R12.1.1 (PART 4 in “11i to R12.1.3 upgrade” series)
5) Upgrade R12.1.1 To R12.1.3 (PART 5 in “11i to R12.1.3 upgrade” series)

The objective of the document is to provide all the required setup steps to upgrade EBS 11i to R12.1.1 version
We have already upgraded our EBS database to 11.2.0.4 version as the database version which came with 11i installation (9.2.0.6) is not certified with EBS R12.1.1.

The technology stack installed on the R12.1 application tier includes, among other components:

• Oracle 10g Application Server (AS) 10.1.2
• Oracle 10g Application Server (AS) 10.1.3
• Oracle Developer 10g (includes Oracle Forms)
• Java (J2SE) native plug-in 1.6.0_10
• Java Developer Kit (JDK) 6.0

This post has been divided into below steps:

1. Increase server cpus and ram
2. Clean up 11i
3. Convert from jinitiator to native sun(oracle) jre
4. Convert tablespace to oatm model
5. Increase tablespace size
6. Database upgrade requirements
7. Modify initialization parameters
8. Apply 11i.ad.i.6 (conditional)
9. Verify temporary tablespace
10. Prepare an upgrade plan for customizations (conditional)
11. Convert to multiple organizations architecture (required)
12. Drop event alert triggers in custom schemas
13. Convert oracle alert e-mail processing to the workflow notification mailer
14. Apply interoperability patches for oracle apps 11i and database 11gr2
15. Complete all functional steps
16. Execute the upgrade manual script (tums)
17. Run ad preparation scripts
18. Gather schema statistics for cbo
19. Back up database, applications, and customizations (recommended)
20. Stage r12.1 (linux x86-64) software
21. Run rapid install (required)
22. Ensure that Maintenance Mode is enabled
23. Apply AD 12.1.1 upgrade driver R12.AD.B.1 (7461070)
24. Apply additional patches in pre-install mode
25. Apply solution from 12.1.1 UPGRADE FROM 11.5.10.2 VERY SLOW XDOLOADER TASK HANGS (Doc ID 1065393.1)
26. Run the American English upgrade patch driver
27. Revoke solution from 12.1.1 UPGRADE FROM 11.5.10.2 VERY SLOW XDOLOADER TASK HANGS (Doc ID 1065393.1)
28. Disable Maintenance Mode
29. Reset init.ora parameters
30. Back up Oracle E-Business Suite
31. Configure and start server processes
32. Change Default Passwords
33. Re-apply customizations
34. Re-enable custom triggers, constraints, and indexes
35. Other System Administration Tasks
36. Install online help (recommended)
37. Review Other Post Upgrade Tasks

38. ISSUES FACED

1. Increase server cpus and ram

On the EBS R12.1.1 Server it is good idea to increase RAM/CPU so that upgrade process will go smooth.
For fresh database with EBS, we used 4 CPUs and 10GB RAM (for both database and application on same server)

2. Clean up 11i

Clean up 11i – Archive old data if possible

Purge 11i-Run the oracle concurrent request/workflow purge program

Use “Purge Portal” introduced in EBS 11.5.10.2 to configure, deploy and monitor archive/purge programs from a single console. From System Administrator Responsibility go to OAM and then to “Purging/Critical Activities”

3. Convert from jinitiator to native sun(oracle) jre

JInitiator is not certified or supported in R12.

Already upgraded to JRE 1.7 in previous post of this series

4. Convert tablespace to OATM model

If not already done, Convert Tablespace to OATM model. OATM uses 12 locally managed tablespaces for all products, including the temporary tablespace, system tablespace, and system-managed undo (SMU) tablespace.
We already have OATM model.

 SQL> select TABLESPACE_NAME,STATUS,CONTENTS from dba_tablespaces
 TABLESPACE_NAME STATUS CONTENTS
 ------------------------------ --------- ---------
 SYSTEM ONLINE PERMANENT
 CTXD ONLINE PERMANENT
 OWAPUB ONLINE PERMANENT
 TEMP ONLINE TEMPORARY
 ODM ONLINE PERMANENT
 PORTAL ONLINE PERMANENT
 APPS_UNDOTS1 ONLINE UNDO
 APPS_TS_TX_DATA ONLINE PERMANENT
 APPS_TS_TX_IDX ONLINE PERMANENT
 APPS_TS_SEED ONLINE PERMANENT
 APPS_TS_INTERFACE ONLINE PERMANENT
 APPS_TS_SUMMARY ONLINE PERMANENT
 APPS_TS_NOLOGGING ONLINE PERMANENT
 APPS_TS_ARCHIVE ONLINE PERMANENT
 APPS_TS_QUEUES ONLINE PERMANENT
 APPS_TS_MEDIA ONLINE PERMANENT
 OLAP ONLINE PERMANENT
 APPS_TS_TOOLS ONLINE PERMANENT
 SYSAUX ONLINE PERMANENT

19 rows selected.

5. Increase tablespace size

Expect database size to grow by 20%.

We increased tablespace size for some of the tablespaces which were low on disk space.
Also you can make datafiles auto extend ON :

Run

SELECT 'alter database datafile '''||file_name||''' autoextend on;' from dba_data_files;

6. Database upgrade requirements

WE ALREADY UPGRADED TO 11.2.0.4 in previous article of this series.

7. Modify initialization parameters

• Remove _db_file_multiblock_read_count parameter. DO NOT RESTORE THIS PARAMETER AFTER THE UPGRADE.
• Keep _db_file_optimizer_read_count . The default setting is 8. Do not change this parameter.

• Keep job_queue_processes = Number of CPUs

• Keep parallel_max_servers = 2* Number of CPUs

• Keep recyclebin=OFF

Database needs to be restarted for making recyclebin=OFF.

Also run below command to purge

SQL> select owner, count(*) from dba_recyclebin group by owner;
SQL> purge recyclebin;

8. Apply 11i.ad.i.6 (conditional)

ALREADY APPLIED 11I.AD.I.7 in previous post of this series.

9. Verify temporary tablespace

TEMP tablespace should be a locally managed tablespace with a uniform allocation size. If the temporary tablespace is not defined in this way, drop the temporary tablespace and recreate it using the following example as a template:

Verify:

SQL> select CONTENTS,EXTENT_MANAGEMENT,ALLOCATION_TYPE from dba_tablespaces where tablespace_name='TEMP';

 The query output should be:
 Contents EXTENT_MANAGEMENT ALLOCATION_TYPE
-------------------------------------------------------
 TEMPORARY LOCAL UNIFORM

If not:

 SQL> drop tablespace TEMP;
 SQL> create TEMPORARY tablespace TEMP tempfile 'ts_p_temp1.dbf' size 2048M EXTENT MANAGEMENT LOCAL
 UNIFORM SIZE 1M;

To verify that the temporary tablespace has been created, run the following:

SQL> select CONTENTS,EXTENT_MANAGEMENT,ALLOCATION_TYPE from dba_tablespaces where tablespace_name='TEMP';

After the upgrade, restore the previous storage parameters for the temporary tablespace
and lower the extent size for the temporary tablespace to a value that is less than 1 MB
(for example, 128 K).

IN OUR CASE WE ALREADY HAVE THE CORRECT TEMP TABLESPACE.

10. Prepare an upgrade plan for customizations (conditional)

Developer team should look into this step and prepare a plan.

11. Convert to multiple organizations architecture (required)

Converting to Multiple Organizations does not require you to use multiple operating units or sets of books, but it does enable you to use these features if you desire.

Converting to Multiple Organizations does not produce any noticeable change in behavior – if you do not define multiple operating units and/or sets of books, the conversion is transparent to users.

Below is how we enabled Multi Org just for testing in our 11i system:

STEP A) Define at least one Operating Unit

Define at least one Operating Unit, and set the profile option, “MO: Operating Unit” (ORG_ID) at Site level, to that Operating Unit’s value

We only have one seeded organization defined.

SQL> Select ORGANIZATION_ID from HR_ALL_ORGANIZATION_UNITS;

ORGANIZATION_ID
 ---------------
 0

1) Verify

ORG_ID profile is blank as of now.

SQL> select fnd_profile.value_specific('ORG_ID') from dual;

No rows selected or NULL value

2) Enable the profile to be updatable

SQL> update fnd_profile_options
 set site_enabled_flag = 'Y' , resp_enabled_flag = 'Y' , user_enabled_flag = 'Y' where profile_option_name = 'ORG_ID' and start_date_active <= sysdate and nvl(end_date_active, sysdate) >= sysdate ;

3) Set the profile option

 DECLARE stat boolean;
 BEGIN dbms_output.disable;
 dbms_output.enable(100000);
 stat := FND_PROFILE.SAVE('ORG_ID', 0, 'SITE');
 IF stat THEN dbms_output.put_line( 'Stat = TRUE - profile updated' );
 ELSE dbms_output.put_line( 'Stat = FALSE - profile NOT updated' );
 END IF;
 commit;
 END;

4) Verify again

SQL> select fnd_profile.value_specific('ORG_ID') from dual;

FND_PROFILE.VALUE_SPECIFIC('ORG_ID')
 ------------------------------------
 0

Now it shows value as 0.

STEP B) Run Convert to Multi-Org process

Go to Adadmin> Maintain Applications Database Entities menu > Convert to Multi-Org

This step can take some time.

The Convert to Multi-Org program does the following:

• Populates the ORG_ID column in the Multi-Org tables with the new operating unit value you defined at the site level profile option: MO: Operating Unit
• Sets the MULTI_ORG_FLAG in the FND_PRODUCT_GROUPS table to “Y”
• Runs the “Replicate Seed Data” program
If you define more than one Operating Unit, the replicate seed data process is run for all Operating Units.

STEP C) Apply Patch 2451368: Migrate data from Customers to Site Uses

Apply using adpatch
Copy driver first and then database driver.
Verify now:

SQL> SELECT MULTI_ORG_FLAG FROM FND_PRODUCT_GROUPS;

M
-
Y

12. Drop event alert triggers in custom schemas

To drop all event alert database triggers in custom schemas, run the alrdtrig.sql script, located in $ALR_TOP/admin/sql (in your Release 11i system). Re-create the triggers after the upgrade is complete.
**We don’t have custom schemas yet so skipped this step.

13. Convert oracle alert e-mail processing to the workflow notification mailer

Oracle Alert leverages the Workflow Notification Mailer to send alert e-mail messages and process responses, obsoleting the previous e-mail implementation. All incoming responses to alerts sent by the previous Oracle Alert E-mail implementation must be completed before the upgrade.
11i.ATG_PF.H Rollup 6 roll up patch causes Oracle Alert to use the Workflow Notification Mailer for new alerts, but allows you to continue to run the Alert Response Processor for incoming responses sent before the conversion.

**RUP7 Already Applied

14. Apply interoperability patches for oracle apps 11i and database 11gr2

Already Applied in earlier post in this series.

15. Complete all functional steps

There will be many functional setups/configuration which Functional team needs to take care before we plan to upgrade our 11i system to R12 system.

16. Execute the upgrade manual script (tums)

The Upgrade Manual Script (TUMS) examines your current configuration and creates a report that lists upgrade tasks that do not apply to your system. Omitting the steps listed in the TUMS report can significantly reduce upgrade downtime.

a) Download and apply TUMS patch.

Download patch 7705743 and apply it to the administration server node on your Release 11i APPL_TOP. It supplies you with the script (adtums.sql) you need to generate the TUMS report (tumsr12.html).

b) Generate the TUMS report.

$ cd $AD_TOP/patch/115/sql
$ sqlplus apps/apps@adtums.sql /usr/tmp

c) Review the report.

The tumsr12.htm report lists the steps (identified by the TUMS step key in this book) that do not apply to your installation. You may safely ignore any steps listed in this report.

17. Run ad preparation scripts

Download patch 7197489 and unzip.
1) Run adgncons.sql that is included in this zip file.

sqlplus apps/apps @adgncons.sql apps apps

2) Run adcrtbsp.sql, which is generated by adgncons.sql.
Modify adcrtbsp.sql to reflect your current tablespace information.

sqlplus system/manager @adcrtbsp.sql

Put directory path in place of ? in this script > “ DATAFILE ‘?/dbf/interim.dbf’”

3) Run the adgrants.sql script as a user that can connect as SYSDBA
to grant privileges to selected SYS objects and create
PL/SQL profiler objects.
1. Create $ORACLE_HOME/appsutil/admin on the database server.
2. Copy adgrants.sql (UNIX) from this patch directory to $ORACLE_HOME/appsutil/admin.

 $ sqlplus /nolog
 SQL> connect / as sysdba
 SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql apps

18. Gather schema statistics for CBO

Log in to Oracle Applications with the System Administrator responsibility.
Navigate to the Submit Request window (Request > Run).
Submit the Gather Schema Statistics program.
Set the schema name to ALL to gather statistics for all Oracle Applications schemas
recommended that you use Auto for the Gather option

19. Back up database, applications, and customization (recommended)

Make a cold backup of the Oracle E-Business Suite database. You can use it to restore the database should you encounter problems during the upgrade process.

Note: The upgrade process does not save customizations. You should copy all your customized files and put them in a safe place so you can reapply the customizations after the upgrade.

20. Stage r12.1 (linux x86-64) software

a) Download all files from delivery.oracle.com and upload to Linux server.
b) Unzip all files.
c) Create StageR12 directory and copy all unzipped files under it.

$ mkdir StageR12

IF REQUIRED, you may need to manually create below directories under StageR12.

For Start Here DVD create below:
$ mkdir startCD

For APPL_TOP DVD create below:
$ mkdir oraApps

For RDBMS DVD create below:
$ mkdir oraDB

For Tools DVD create below:
$ mkdir oraiAS

For Databases DVD create below:
$ mkdir oraAppDB

21. Run rapid install (required)

Use the Rapid Install wizard to lay down the file system and install the new technology stack for your Release 12.1.1 Oracle E-Business Suite system.
**On the Wizard Operation screen, remember to select Upgrade to Oracle E-Business Suite Release 12.1.1**

cd /StageR12/startCD/Disk1/rapidwiz

./rapidwiz

22. Ensure that Maintenance Mode is enabled

$sqlplus apps/xxx @$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE

23. Apply AD 12.1.1 upgrade driver R12.AD.B.1 (7461070)

Merge the patch (9179588:R12.AD.B) with 9477107:R12.AD.B and R12.AD.B.1 (patch 7461070).
Note: This merge should be a full merge using -admode. Do not use -preinstall or – driveronly mode.

$ adpatch

24. Apply additional patches in pre-install mode

Applying pre-install patches will save you a lot of headache later on and will help in smooth upgrade.

— Go to Oracle Note ID: R12.1 and 12.2 Oracle E-Business Suite Preinstall Patches Report [Video] (Doc ID 1448102.2)
— Download “EBS_R12.1_Preinstall_2014_Nov_19.zip” for R121
— Unzip the file and click on index.html
— Download all relevant patches as mentioned and apply with adpatch as preinstall=y

25. Apply solution for slow XDOLOADER task

From 12.1.1 UPGRADE FROM 11.5.10.2 VERY SLOW XDOLOADER TASK HANGS (Doc ID 1065393.1)

Open a second shell as root and execute:

# mv /dev/random /dev/random_org
# ln -s /dev/urandom /dev/random

Its purpose is sym link is user to feed random numbers from urandom to random during the upgrade.
Close the secondary root shell

26. Run the American English upgrade patch driver

$ cd $AU_TOP/patch/115/driver
 $ adpatch options=nocopyportion,nogenerateportion

27. Revoke solution for slow XDOLOADER task

From 12.1.1 UPGRADE FROM 11.5.10.2 VERY SLOW XDOLOADER TASK HANGS (Doc ID 1065393.1)

Open a second shell as root and execute:

# rm /dev/random
# mv /dev/random_org /dev/random

This should only be used temporary during the upgrade and needs to backed out after completion.

Close the secondary root shell

28. Disable Maintenance Mode

SQL> @$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE
 PL/SQL procedure successfully completed.
 Commit complete.

29. Reset init.ora parameters

Follow the instructions in Database Initialization Parameters for Oracle Applications
Release 12 (Doc ID: 396009.1) and reset the init.ora parameters as needed.

30. Back up Oracle E-Business Suite

Back up both database and application at this stage.

31. Configure and start server processes

Point Rapid Install to the Applications context file.
Rapid Install creates the appropriate server process control scripts and starts all server processes, including the concurrent managers.

 $ cd /media/sf_VM/StageR12/startCD/Disk1/rapidwiz
 $ ./ rapidwiz

Go to http://r12server.localdomain:8001/

32. Change Default Passwords

To maintain database security and restrict access to important accounts, you should change the passwords without delay for sys, system users.
You should also change the default passwords for the Oracle E-Business Suite product accounts in your production and test databases.

33. Re-apply customization

If you customized Applications environment files (APPLSYS.env or devenv), then re-integrate them in devenv.env, or in the adovars.env file ($APPL_TOP/admin for UNIX or %APPL_TOP%\admin for Windows). Restart the application server processes so that the changes take affect.

34. Re-enable custom triggers, constraints, and indexes

During the upgrade, custom triggers or constraints may have been modified. If you disabled these triggers and constraints, identify any data updates that must be made before you re-enable them.
If you dropped any custom indexes, then review the new data model to determine if the index is necessary before you redefine it.

35. Other System Administration Tasks (conditional)

Some of the below steps may be required depending on the requirements:
Configure SSL for Web Services (conditional)
Complete Workflow Notification Mailer configuration (required)
Complete Transport Agent setup (conditional)
Complete setup for Oracle XML Gateway (required)
Enable PDF printing (required)
Specify a temporary directory for XML Publisher (required)

36. Install online help (recommended)

To install the American English online help, run the database portion of the online help patch (u6746000.drv). It is located in $AU_TOP/patch/115/driver directory. Set the
AutoPatch options=hotpatch,nocopyportion,nogenerateportion.
If you have languages other than American English registered in your system, then check if the NLS version of the Online Help is available. If it is available, then download and apply the NLS version of the online help patch for each active language.

37. Review Other Post Upgrade Tasks

Some other post upgrade steps are mentioned below:
Other details can be found in 11i>R12 upgrade document.
– Verify completion of concurrent programs (recommended)
– Update/verify custom responsibilities (conditional)
– Migrate custom development to new technologies (recommended)
– Migrate the CUSTOM library (conditional)
– Copy and re-customize modified scripts or reports (conditional)
– Copy existing custom start scripts (conditional)
– Review user responsibility assignments (recommended)
– Alerts related tasks
– Multiple Organizations related tasks
FEW OTHER FUNCTIONAL STEPS AS DOCUMENTED IN UPGRADE GUIDE.

38. ISSUES FACED

ERROR 1

while starting R12.1 rapidwiz:

[oracle@r12server rapidwiz]$ Exception in thread “main” java.lang.UnsatisfiedLinkError: /media/sf_VM/StageR12/startCD/Disk1/rapidwiz/jre/Linux_x64/1.6.0/lib/i386/xawt/libmawt.so: libXext.so.6: cannot open shared object file: No such file or directory
oracle@r12server rapidwiz]$ Exception in thread “main” java.lang.UnsatisfiedLinkError: /media/sf_VM/StageR12/startCD/Disk1/rapidwiz/jre/Linux_x64/1.6.0/lib/i386/xawt/libmawt.so: libXtst.so.6: cannot open shared object file: No such file or directory
[oracle@r12server rapidwiz]$ Exception in thread “main” java.lang.UnsatisfiedLinkError: /media/sf_VM/StageR12/startCD/Disk1/rapidwiz/jre/Linux_x64/1.6.0/lib/i386/xawt/libmawt.so: libXi.so.6: cannot open shared object file: No such file or directory

at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(Unknown Source)
at java.lang.ClassLoader.loadLibrary(Unknown Source)

SOLUTION 1

FEW RPMS ARE MISSING

“Exception java.lang.UnsatisfiedLinkError:… libXtst.so.6” while Installing 10gR2 on RHEL/OEL 5 [ID 551406.1]
DBConsole Failed to Start with the Error log4j:ERROR Please initialize the log4j system properly in the emdb.nohup File [ID 825753.1]
Problem: Installing Grid Control 10.2.0.5 on Oracle Enterprise Linux 5 x86_64 EMDeploy Fails with exitCode=7 [ID 958435.1]

[oracle@r12server rapidwiz]$ rpm –query –whatprovides ‘libXext.so.6’
no package provides libXext.so.6

1. Install rpm

libXi-1.0.1-3.1 (x86_64)
libXi-1.0.1-3.1 (i386)
2. Verify the rpm installation
$rpm -q –qf ‘%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n’ libXi

3. Start Rapidwiz

ERROR 2

R12.1 filesystem failed

Unzip Count:153

Processing Disk1….

RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.

Please make sure you have UnZip 5.X in your path and try again…

SOLUTION 2

[oracle@r12server bin]$ ./unzip -version
caution: both -n and -o specified; ignoring -o
UnZip 6.00 of 20 April 2009, by Info-ZIP. Maintained by C. Spieler. Send

We have startCD version 12.1.1.9

To implement the solution, please execute the following steps:

1 – Download Patch 8639046 – RAPID INSTALL STARTCD 12.1.1.11
2 – Install the patch using the instructions in the readme
3 – Install 12.1.1 again using rapidwiz.

UNIX:

$ cd /Stage12.1.1/startCD/Disk1/rapidwiz
$ ./RapidWizVersion

Uncompress the patch in the main staging area to overwrite the startCD
directory with the new files.

For example :

UNIX:

$ cd /Stage12.1.1
$ unzip -o p8639046_R12_GENERIC.zip

ERROR 3

[oracle@r12server admin]$ sqlplus
sqlplus: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory
SOLUTION 3

*Adcfgclone Fails With Error While Loading Shared Libraries: libclntsh.so.10.1 [ID 736410.1]*

download and apply 32 bit version glibc-devel-2.12-1.132.el6_5.4.i686

$ cd $ORACLE_HOME/bin
$ relink all

ERROR 4

New copy is /d01/r12/apps/apps_st/appl/admin/testdb/log/adrelink.log

An error occurred while relinking application programs.

Relinking module ‘adwrknew’ in product ad …

make -f /d01/r12/apps/apps_st/appl/admin/testdb/out/link_ad_11910.mk /d01/r12/apps/apps_st/appl/ad/12.0.0/bin/adwrknew

Starting link of ad executable ‘adwrknew’ on Thu Dec 11 10:53:41 CST 2014
gcc -m32 -s -L/d01/r12/apps/tech_st/10.1.2/lib/stubs -L/d01/r12/apps/tech_st/10.1.2/lib -ldl -o /d01/r12/apps/apps_st/appl/ad/12.0.0/bin/adwrknew /d01/r12/apps/apps_st/appl/ad/12.0.0/lib/aiworker.o /d01/r12/apps/apps_st/appl/fnd/12.0.0/lib/afldrbind.o /d01/r12/apps/apps_st/appl/fnd/12.0.0/lib/afldrdump.o /d01/r12/apps/apps_st/appl/fnd/12.0.0/lib/afldrutl.o /d01/r12/apps/apps_st/appl/fnd/12.0.0/lib/afldrcfd.o /d01/r12/apps/apps_st/appl/fnd/12.0.0/lib/afldrfs.o /d01/r12/apps/apps_st/appl/fnd/12.0.0/lib/afldrval.o /d01/r12/apps/apps_st/appl/fnd/12.0.0/lib/afldrad.o /d01/r12/apps/apps_st/appl/fnd/12.0.0/lib/afldrdl.o /d01/r12/apps/apps_st/appl/fnd/12.0.0/lib/afldrul.o \
/d01/r12/apps/apps_st/appl/ad/12.0.0/lib/libad.a /d01/r12/apps/apps_st/appl/fnd/12.0.0/lib/libfnd.a -lsql10 -lclntsh `cat /d01/r12/apps/tech_st/10.1.2/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lnro10 `cat /d01/r12/apps/tech_st/10.1.2/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lclient10 -lnnetd10 -lvsn10 -lcommon10 -lgeneric10 -lmm -lcore10 -lxml10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 `cat /d01/r12/apps/tech_st/10.1.2/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lnro10 `cat /d01/r12/apps/tech_st/10.1.2/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lclient10 -lnnetd10 -lvsn10 -lcommon10 -lgeneric10 -lcore10 -lxml10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 -lclient10 -lnnetd10 -lvsn10 -lcommon10 -lgeneric10 -lcore10 -lxml10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 `cat /d01/r12/apps/tech_st/10.1.2/lib/sysliblist` -ldl -lm -lpthread
/usr/lib/gcc/x86_64-redhat-linux/4.4.7/32/libgcc_s.so: undefined reference to `__stack_chk_fail@GLIBC_2.4′
collect2: ld returned 1 exit status
make: *** [/d01/r12/apps/apps_st/appl/ad/12.0.0/bin/adwrknew] Error 1

SOLUTION 4

Relink From Adadmin Giving Error: libgcc_s.so: undefined reference to `__stack_chk_fail@GLIBC_2.4′ (Doc ID 1525823.1)).

*********************************************************************
Note 761566.1 Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86-64

# unlink /usr/lib/libXtst.so.6
# ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6
Without this updated link, you may see the following errors during a relink of the 10.1.2 Oracle Home:

/usr/lib/libXtst.so.6: undefined reference to `__stack_chk_fail@GLIBC_2.4′
/usr/lib/libXtst.so.6: undefined reference to `__fprintf_chk@GLIBC_2.3.4′
/usr/lib/libXtst.so.6: undefined reference to `__sprintf_chk@GLIBC_2.3.4′
********************************************************************

AND

******************************************************************
After installation, users must update the stub libraries in the 10.1.2 and 10.1.3 Oracle Homes using the patch 12415211. In following the instructions below, please note that Opatch should not be used to install this patch.

Users must specifically copy the files in the patch to the specified directories as follows for the 10.1.2 Oracle Home:

$ cd /apps/tech_st/10.1.2/lib
$ cp -p -R stubs stubsORIG
$ cd stubs
$ cp $HOME/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so .
$ ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1
$ ln -s libgcc_s.so.1 libgcc_s.so
After this is done and sourcing the APPS<CONTEXT_NAME>.env file, users should relink all 10.1.2 executables by running the $ORACLE_HOME/appsutil/clone/adlnktools.sh script and ensuring that there are now no errors in the make log file output from the script.

The instructions for the 10.1.3 Oracle Home are:

$ cd /d01/r12/apps/tech_st/10.1.3/lib
$ cp -p -R stubs stubsORIG
$ cd stubs
$ cp $HOME/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so .
$ ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1
$ ln -s libgcc_s.so.1 libgcc_s.so
After this, users should relink sqlplus by running the /d01/r12/apps/tech_st/10.1.3/appsutil/clone/adlnkweboh.sh script and ensuring that there are now no errors in the make log file output from the script.
****************************************************************

1. Please follow next steps:
Note 761566.1 Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86-64
– After Installing or Upgrading
Patch AS 10g (10.1.2 and 10.1.3) Oracle Homes (Oracle Linux 6 and RHEL 6 only)

Note! The patch should be applied manually and not via opatch. Please follow the instruction as per Note 761566.1

Not related, but also a mandatory step is:
Note 761566.1 Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86-64
– Link to Motif library in Oracle Application Server 10.1.2 (on Oracle Linux 5, RHEL 5, Oracle Linux 6 and RHEL 6 only)

ERROR 5

/usr/bin/ld: cannot find -ljava

SOLUTION 5

‘/usr/bin/ld: cannot find -ljava’ occurs while applying one off patch (Doc ID 418557.1)
To implement the solution, execute the following steps:

Continue with the patch installation when you receive thie error and complete it.

Search for file libjava.so on the system
For example you find it under the following directory

$ORACLE_HOME/jdk/jre/lib/i386

Backup and edit $ORACLE_HOME/sysman/lib/env_sysman.mk

Change : JRE_LIB_DIR=%JRE_HOME%/bin
To : JRE_LIB_DIR=$(ORACLE_HOME)/jdk/jre/lib/i386

Issue the failed relink command:

% make -f ins_sysman.mk relink_sharedobj SHAREDOBJ=libnmemso

ERROR 6

FAILED: file pechktsk.sql on worker 5.
ORA-00979: not a GROUP BY expression

SOLUTION 6

Fix: Note ID 1083981.1.
Patch 8855023 for R12.

This issue is caused because the group by clause was not compatible with the columns selected in the select clause.

This issue is fixed in file $PER_TOP/patch/115/sql/pechktsk.sql.

For release 12.1, the fixed version is 120.0.12010000.2 or higher.
For release 11.5, the fixed version is 115.13 or higher.
For release 12.1 (i.e. if you are on 11.5.10 CU2 with Oracle RDBMS 11gR2 and “upgrading” to 12.1.1, then this patch is applicable to you.): Download and review the readme and pre-requisites for Patch 8855023: ‘PECHKTSK.SQL FAILS WITH ORA-00979 ERROR IN 11GR2 ENVIRONMENTS’
Note! This patch is applicable ONLY to those customers who are at 11.5.10 CU2 with Oracle RDBMS 11gR2 and upgrading to 12.1.1. This patch must be applied in pre-install mode (adpatch preinstall=y) after
applying R12.AD.B.1 (7461070) but before upgrading to 12.1.1

ERROR 7

patch hangs at

sqlplus -s APPS/***** @/u02/apps/CRPQA/apps/apps_st/appl/psa/12.0.0/patch/115/sql/psafirstrun.sql
Enter value for 1:
the following error occurs and the script does not complete:

SOLUTION 7

Patch 14563642 Stuck While Running Adpatch (Doc ID 1900759.1)

1. Change the file PSAFIRSTRUN.SQL, in the opening section edit the file as follows:

FROM
=========================
DECLARE
l_str VARCHAR2(200);
l_owner VARCHAR2(30):=’&&1′;
BEGIN
=========================
TO
=======================
DECLARE
l_str VARCHAR2(200);
l_owner VARCHAR2(30):=’APPS’;
BEGIN
========================

adctrl>>
then
4. Tell manager that a worker failed its job
give worker number
then
2. Tell worker to restart a failed job
give worker number

ERROR 8

hanged

4 Run AutoPatch R120 pl igwupgrade.sql Running

SOLUTION 8

Press enter so that worker fail.

The following error message found in your LOG File outlines the cause :ORA-01434: private synonym to be dropped does not exist

Your issue is due to igw product which has been included by error in the R12 installation
see details in the following Note Grants Proposal is not Available for Release 12 (Doc ID 452440.1)
So you can safely skip the failed job

To implement the solution, please execute the following steps:

1) skip the failed job via the hidden menu 8 of adctrl

2) continue your upgrade

ERROR 9

Assigned: file amviccd.sql on worker 2 for product amv username AMV.
FAILED: file igspintind.sql on worker 1 for product igs username IGS.
FAILED: file amviccd.sql on worker 2 for product amv username AMV.
FAILED: file amviccn.sql on worker 3 for product amv username AMV.

ATTENTION: All workers either have failed or are waiting:

FAILED: file igspintind.sql on worker 1.
FAILED: file amviccd.sql on worker 2.
FAILED: file amviccn.sql on worker 3.

SOLUTION 9

sqlplus -s APPS/***** @/d01/r12/apps/apps_st/appl/amv/12.0.0/patch/115/sql/amviccd.sql &un_amv &pw_amv
Connected.
DECLARE
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-11422: linguistic initialization failed
DRG-11446: supplied knowledge base file
/d02/app/oracle/product/11.2.0/dbhome_1/ctx/data/enlx/droldUS.dat not installed
ORA-06512: at “CTXSYS.DRUE”, line 160
ORA-06512: at “CTXSYS.TEXTINDEXMETHODS”, line 366
ORA-06512: at “SYS.DBMS_SQL”, line 1199
ORA-06512: at line 56

sqlplus -s IGS/***** @/d01/r12/apps/apps_st/appl/igs/12.0.0/patch/115/sql/igspintind.sql
DECLARE
*
ERROR at line 1:
ORA-20100: Error occured while creating intermedia indexes for table
IGP_US_PORTFOLIOS.ORA-29855: error occurred in the execution of ODCIINDEXCREATE
routine
ORA-20000: Oracle Text error:
DRG-11422: linguistic initialization failed
DRG-11446: supplied knowledge base file
/d02/app/oracle/product/11.2.0/dbhome_1/ctx/data/enlx/droldUS.dat not installed
ORA-06512: at line 97

Oracle Database 11g Examples (formerly Companion) was not installed and must be installed separately from the database.

installed 11g examples…restarted faild jobs.

ERROR 10

1 Run AutoPatch R120 pl igiefupg.sql Running

package /d01/r12/apps/apps_st/appl/igi/12.0.0/patch/115/sql/igiefupg.sql
Could not find any objects to create in package mode.

Unable to process file in PACKAGE mode.

Converting file for PL/SQL Load Without Compile.
Source file: /d01/r12/apps/apps_st/appl/igi/12.0.0/patch/115/sql/igiefupg.sql
Dest file: /d01/r12/apps/apps_st/appl/admin/testdb/out/p001ncpls.sql
sqlplus -s APPS/***** @/d01/r12/apps/apps_st/appl/admin/testdb/out/p001ncpls.sql

Session altered.

Enter value for 2: old 14: l_igi_schema := ‘&2’;
new 14: l_igi_schema := ”;
Enter value for 1:
Enter value for 2: old 14: l_igi_schema := ‘&2’;
new 14: l_igi_schema := ”;
Enter value for 1: old 15: l_apps_schema := ‘&1’;
new 15: l_apps_schema := ”;
DECLARE
*
ERROR at line 1:
ORA-00903: invalid table name
ORA-06512: at line 21

SOLUTION 10

edited below file and put value of ‘igi’ and ‘apps’ schema in below script
executed below script manually

/d01/r12/apps/apps_st/appl/admin/testdb/out/p001ncpls.sql

ERROR 11

Loading data using FNDLOAD function.
FNDLOAD APPS/***** 0 Y UPLOAD @FND:patch/115/import/afcpprog.lct @PAY:patch/115/import/US/payzzcncprg00514.ldt –
FNDLOAD APPS/***** 0 Y UPLOAD @FND:patch/115/import/afcpprog.lct @PQP:patch/115/import/US/loc_gb/pqpzzcncprg00025.ldt –
FNDLOAD APPS/***** 0 Y UPLOAD @FND:patch/115/import/afcpprog.lct @JG:patch/115/import/US/jg12acp.ldt –
FNDLOAD APPS/***** 0 Y UPLOAD @FND:patch/115/import/afcpprog.lct @BOM:patch/115/import/US/bomprg.ldt –

Connecting to APPS……Connected successfully.

Calling FNDLOAD function.

Returned from FNDLOAD function.

Log file: /d01/r12/apps/apps_st/appl/admin/testdb/log/US_bomprg_ldt.log
Log file: /d01/r12/apps/apps_st/appl/admin/testdb/log/US_jg12acp_ldt.log
Log file: /d01/r12/apps/apps_st/appl/admin/testdb/log/loc_gb_pqpzzcncprg00025_ldt.log

Error calling FNDLOAD function.

Uploading from the data file /d01/r12/apps/apps_st/appl/bom/12.0.0/patch/115/import/US/bomprg.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/d01/r12/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afcpprog.lct(120.2.12010000.2), /d01/r12/apps/apps_st/appl/bom/12.0.0/patch/115/import/US/bomprg.ldt) to staging tables
Dumping LCT file /d01/r12/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afcpprog.lct(120.2.12010000.2) into FND_SEED_STAGE_CONFIG
Dumping LDT file /d01/r12/apps/apps_st/appl/bom/12.0.0/patch/115/import/US/bomprg.ldt into FND_SEED_STAGE_ENTITY
A database error occurred:
ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column

The error occurred while executing the following statement:
INSERT INTO FND_SEED_STAGE_ENTITY (SEQ, CONFIG_ID, TOP_ENTITY_SEQ, LAST_DB_UPDATED_BY, LAST_DB_UPDATE_DATE, LAST_FILE_UPDATED_BY, LAST_FILE_UPDATE_DATE, ACTION, EXEC_STATUS, COMMIT_FLAG, BIND_VAR_METADATA, PARENT_PK_VALUE ,BIND_VALUE0 ,BIND_VALUE1 ,BIND_VALUE2 ,BIND_VALUE3 ,BIND_VALUE4 ,BIND_VALUE5 ,BIND_VALUE6 ,BIND_VALUE7 ,BIND_VALUE8 ,BIND_VALUE9 ,BIND_VALUE10 ,BIND_VALUE11 ,BIND_VALUE12 ,BIND_VALUE13 ,BIND_VALUE14 ,BIND_VALUE15 ,BIND_VALUE16 ,BIND_VALUE17 ,BIND_VALUE18 ,BIND_VALUE19 ,BIND_VALUE20 ,BIND_VALUE21 ,BIND_VALUE22 ,BIND_VALUE23 ,BIND_VALUE24 ,BIND_VALUE25 ,BIND_VALUE26 ,BIND_VALUE27 ,BIND_VALUE28 ,BIND_VALUE29 ,BIND_VALUE30 ,BIND_VALUE31 ,BIND_VALUE32 ,BIND_VALUE33 ,BIND_VALUE34 ,BIND_VALUE35 ,BIND_VALUE36 ,BIND_VALUE37 ,BIND_VALUE38 ,BIND_VALUE39 ,BIND_VALUE40 ,BIND_VALUE41 ,BIND_VALUE42 ,BIND_VALUE43 ,BIND_VALUE44 ,BIND_VALUE45 ,BIND_VALUE46 ,BIND_VALUE47 ,BIND_VALUE48 ,BIND_VALUE49 ,BIND_VALUE50 ,BIND_VALUE51 ,BIND_VALUE52 ,BIND_VALUE53 ,BIND_VALUE54 ,BIND_VALUE55 ,BIND_VALUE56 ,BIND_VALUE57 ,BIND_VALUE58 ,BIND_VALUE59 ,BIND_VALUE60 ,BIND_VALUE61 ,BIND_VALUE62 ,BIND_VALUE63 ,BIND_VALUE64 ,BIND_VALUE65 ,BIND_VALUE66 ,BIND_VALUE67 ,BIND_VALUE68) VALUES (:seq, :config_id, :top_entity_seq, NULL, NULL, NULL, NULL, ‘IGNORE’, ‘0’, NULL, :bvar_metadata, :parent_pk_value ,:bind_value0 ,:bind_value1 ,:bind_value2 ,:bind_value3 ,:bind_value4 ,:bind_value5 ,:bind_value6 ,:bind_value7 ,:bind_value8 ,:bind_value9 ,:bind_value10 ,:bind_value11 ,:bind_value12 ,:bind_value13 ,:bind_value14 ,:bind_value15 ,:bind_value16 ,:bind_value17 ,:bind_value18 ,:bind_value19 ,:bind_value20 ,:bind_value21 ,:bind_value22 ,:bind_value23 ,:bind_value24 ,:bind_value25 ,:bind_value26 ,:bind_value27 ,:bind_value28 ,:bind_value29 ,:bind_value30 ,:bind_value31 ,:bind_value32 ,:bind_value33 ,:bind_value34 ,:bind_value35 ,:bind_value36 ,:bind_value37 ,:bind_value38 ,:bind_value39 ,:bind_value40 ,:bind_value41 ,:bind_value42 ,:bind_value43 ,:bind_value44 ,:bind_value45 ,:bind_value46 ,:bind_value47 ,:bind_value48 ,:bind_value49 ,:bind_value50 ,:bind_value51 ,:bind_value52 ,:bind_value53 ,:bind_value54 ,:bind_value55 ,:bind_value56 ,:bind_value57 ,:bind_value58 ,:bind_value59 ,:bind_value60 ,:bind_value61 ,:bind_value62 ,:bind_value63 ,:bind_value64 ,:bind_value65 ,:bind_value66 ,:bind_value67 ,:bind_value68)
Concurrent request completed

SOLUTION 11

(ORA-24816: Expanded Non Long Bind Data Supplied After Actual Long Or Lob Column [ID 452095.1])

[oracle@r12server log]$ vi /d01/r12/apps/apps_st/appl/admin/testdb/log/US_jg12acp_ldt.log
[oracle@r12server log]$ echo $NLS_LANG
American_America.AL32UTF8
SQL> SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER = ‘NLS_CHARACTERSET’;

VALUE
——————————————————————————–
UTF8
If the database characterset is UTF8 set NLS_LANG to American_America.UTF8.

a. Execute ‘export’ as follows.

# export NLS_LANG=American_America.UTF8

b. Query value for NLS_LANG to verify it.

#echo $NLS_LANG (Unix)

===============================================================================================
If adpatch is still running but hanging due to failed workers:

1. Stop adpatch.

Please use adctrl utility to stop adpatch.

The best way to do this is to shut down the workers manually, which
also causes the AD utility to quit in an orderly fashion.

Action
a. Select AD Controller(adctrl) Option 3 and enter all for the worker number. Each worker
stops once it completes or fails its current job.

b. Verify that no worker processes are running. Use a command similar to the one
in the following example. The command arguments may vary on different
platforms.
UNIX:
$ ps -a | grep adworker
Windows:
Invoke the Task Manager (Ctrl-Alt-Delete) to view processes.

c. When all workers have shut down, the manager and the AD utility quits.

2. Change NLS_LANG setup.

Please refer to the example above.

3. Start adpatch again, continue previous session.

Check if AutoPatch is progressing, if not use adctrl utility, option 2 to restart failing worker.

4. How to avoid similar issue in the future.

Verify NLS_LANG setup in the Autoconfig Context file.

Edit the context file using Oracle Applications Manager(OAM) or Context Editor and find value for NLS_LANG:

If the database characterset is UTF8 it should be:

<NLS_LANG oa_var=”s_tools_nlslang”>American_America.UTF8</NLS_LANG>
<NLS_LANG oa_var=”s_weboh_nlslang”>American_America.UTF8</NLS_LANG>
<NLS_LANG oa_var=”s_nlslang”>American_America.UTF8</NLS_LANG>

If NLS_LANG parameters have different values than expected please apply corrections. Then execute Autoconfig and make sure it was successful.

5. Test if the changes to NLS_LANG were successful.

Source the env file and query:

#echo $NLS_LANG (Unix)

ERROR 12

Start time for file is: Sat Dec 13 2014 14:19:29

sqlplus -s APPS/***** @/d01/r12/apps/apps_st/appl/msd/12.0.0/patch/115/sql/MSDODPCODE.sql
begin
*
ERROR at line 1:
ORA-33292: Insufficient permissions to access analytic workspace APPS.ODPCODE
using the specified access mode.
ORA-06512: at “SYS.DBMS_AW”, line 67
ORA-06512: at “SYS.DBMS_AW”, line 131
ORA-06512: at “SYS.DBMS_AW”, line 977
ORA-06512: at “SYS.DBMS_AW”, line 930
ORA-33262: Analytic workspace APPS.ODPCODE does not exist.
ORA-06512: at “SYS.DBMS_AW”, line 901
ORA-06512: at “APPS.MSD_AW_LOADER”, line 10
ORA-06512: at line 3

SOLUTION 12

MSDODPCODE.SQL Fails Applying U6678700.Drv [ID 1151274.1]
sql> grant olap_dba to apps;

sqlplus>exec dbms_aw.AW_ATTACH(‘ODPCODE’,true,true,’wait’);

Restart the failed worker.

ERROR 13

Stuck on
/d01/r12/apps/apps_st/appl/psa/12.0.0/patch/115/sql/psab7693047.sql
asking for value &1 &2

SOLUTION 13

Edit above SQL script as follows

&1 = APPS
&2 = PSA

Fail worker, restart worker.

ERROR 14

FAILED: file igipayup.sql on worker 5.

Start time for file is: Sat Dec 13 2014 21:43:29

sqlplus -s APPS/***** @/d01/r12/apps/apps_st/appl/igi/12.0.0/patch/115/sql/igipayup.sql
INSERT INTO IGI_UPGRADE_LOG(SEQUENCE_ID, COMPONENT, MODULE, MESSAGE_TEXT,
*
ERROR at line 36:
ORA-06550: line 36, column 14:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 36, column 2:
PL/SQL: SQL Statement ignored

SOLUTION 14

To implement the solution, please execute the following steps:

1. The error message you are seeing indicates that the table IGI_UPGRADE_LOG does not exist. Verify this is true by running the following command:

SELECT COUNT(*) FROM IGI_UPGRADE_LOG;

2. Assuming that the table does not exist, look in %IGI_TOP%/patch/115/odf and see if you have a file called ‘igiupg.odf’ in there.
3. If the file exists, use the utility ‘adodfcmp’ to create the missing table.
4. If the file does not exist, download and unzip the patch:10074551:R12.IGI.B and copy ‘igiupg.odf’ into directory $IGI_TOP/patch/115/odf
5. To create the missing object(s) use the following commands:

adodfcmp userid=IGI/igi touser=APPS/apps priv_schema=SYSTEM/manager changedb=YES odffile=$IGI_TOP/patch/115/odf/igiupg.odf mode=sequences

adodfcmp userid=IGI/igi touser=APPS/apps priv_schema=SYSTEM/manager changedb=YES odffile=$IGI_TOP/patch/115/odf/igiupg.odf mode=tables

6. Use adctrl (option 2) to continue patch 6678700 from the point of failure and run the script IGIPAYUP.sql.

Reference: R12 Upgrade Patch 6678700 Failed In IGIPAYUP.sql With INSERT INTO IGI_UPGRADE_LOG ORA-00942 Table Or View Does Not Exist (Doc ID 1489757.1)

ERROR 15

FAILED: file zpbremcwm.sql on worker 1.

sqlplus -s APPS/***** @/d01/r12/apps/apps_st/appl/zpb/12.0.0/patch/115/sql/zpbremcwm.sql
from OLAPSYS.CWM2$DIMENSION
*
ERROR at line 45:
ORA-06550: line 45, column 19:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 44, column 6:
PL/SQL: SQL Statement ignored
ORA-06550: line 49, column 19:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 48, column 6:
PL/SQL: SQL Statement ignored
ORA-06550: line 53, column 19:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 52, column 6:
PL/SQL: SQL Statement ignored
ORA-06550: line 235, column 41:
PLS-00364: loop index variable ‘V_CUBE’ use is invalid
ORA-06550: line 235, column 6:
PL/SQL: Statement ignored
ORA-06550: line 239, column 51:
PLS-00364: loop index variable ‘V_DIMS’ use is invalid
ORA-06550: line 239, column 6:
PL/SQL: Statement ignored
ORA-06550: line 243, column 37:
PLS-00364: loop index variable ‘V_CATS’ use is invalid
ORA-06550: line 243, column 6:
PL/SQL: Statement ignored
SOLUTION 15

Zpbremcwm.sql Fails On Worker During 6678700 Patch (Doc ID 1469964.1)

If not using Enterprise Planning and Budgeting, then all failed workers relating to EPB or ZPB can be skipped, and the user can continue with the upgrade.

choose hidden option 8 and skip the worker.

ERROR 16
Control Worker Code Context Filename Status

—— ——– —————– ————————– ————–

1 Run AutoPatch R120 pl jaircvdff.sql FAILED
2 Run AutoPatch R120 pl jaircvdff.sql FAILED
3 Run AutoPatch R120 pl jaircvdff.sql FAILED
4 Run AutoPatch R120 pl jaircvdff.sql FAILED
5 Run AutoPatch R120 pl jaircvdff.sql FAILED
6 Run AutoPatch R120 pl jaircvdff.sql FAILED

sqlplus -s APPS/***** @/d01/r12/apps/apps_st/appl/ja/12.0.0/patch/115/sql/jaircvdff.sql &un_ja &batchsize 4 6
declare
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at “APPS.AD_PARALLEL_UPDATES_PKG”, line 872
ORA-06512: at “APPS.AD_PARALLEL_UPDATES_PKG”, line 917
ORA-06512: at “APPS.AD_PARALLEL_UPDATES_PKG”, line 891
ORA-06512: at line 107

SOLUTION 16

JAIRCVDFF.SQL FAILS ON 12.1.1 UPGRADE PATCH 6678700 (Doc ID 1473255.1)

The cause of the issue is wrong parameter passed to script. Please provide the following parameters while running the script manually:-
Enter value for 3: 1
Enter value for 4: 1
Enter value for 1: PO
Enter value for 2: 1000

Once the script completes successfully then skip the worker and continue with patching.

ERROR 17

Control
Worker Code Context Filename Status
—— ——– —————– ————————– ————–
1 Run AutoPatch R120 pl GMIG3MIB.sql Running

GMIG3MIB.sql Runs for a Long Time When Applying American English Upgrade Driver u6678700.drv
16382255 GMIG3MIB.sql Runs For Long Time When Applying American English Upgrade Driver U6678700.drv (Doc ID 1534951.1)

Upgrade Patch 6678700 to EBS 12.1.1 – script GMIG3MIB.sql runs for a very long time (Doc ID 1391010.1)

… which explains the pre-install driver steps. All pre-install drivers will be present in the directory : $APPL_TOP/admin/$TWO_TASK/preinstall

To verify that the merged driver file has the information for patch 13335019 you can check for this type of information.
SOLUTION 17

sqlplus -s APPS/***** @/d01/r12/apps/apps_st/appl/gmi/12.0.0/patch/115/sql/GMIG3MIB.sql
Enter value for 2: GMI

Enter value for 1: 1000

Enter value for 3: 1

Enter value for 4: 1

FAIL THE WORKER
SKIP THE WORKER

ERROR 18

2 Run AutoPatch R120 pl fem_bal_nacc_hier_l2_mv.xd FAILED

Start time for statement above is Sun Dec 14 01:41:40 CST 2014
Exception occured ORA-54015: Duplicate column expression was specified
ORA-06512: at “APPS.AD_MV”, line 131
ORA-06512: at “APPS.AD_MV”, line 289
ORA-06512: at line 1

java.sql.SQLException: ORA-54015: Duplicate column expression was specified
ORA-06512: at “APPS.AD_MV”, line 131
ORA-06512: at “APPS.AD_MV”, line 289
ORA-06512: at line 1
==========================================================
Done calling the utility function. Return Code = [1] TimeStamp = [Sun Dec 14 01:41:41 CST 2014]
Updating task with status 1

AD Worker error:
The utility FndXdfCmp returned error for the above task.

SOLUTION 18

Use adctrl hidden option ‘8’ to skip the failed worker and complete the upgrade. Then, apply patch 10406817 “ORA-54015 APPLYING FEM_BAL_NACC_HIER_L2_MV.XDF ON ORACLE 11GR2 DATABASE” after the upgrade.

Reference: Patch Fails on Fem_bal_nacc_hier_l2_mv.xdf After Upgrade to Oracle 11.2.0.2 Database (Doc ID 1284055.1)

ERROR 19

FAILED: file czhist.sql on worker 5.

sqlplus -s APPS/***** @/d01/r12/apps/apps_st/appl/cz/12.0.0/patch/115/sql/czhist.sql &un_cz

PL/SQL procedure successfully completed.

BEGIN FND_STATS.GATHER_COLUMN_STATS(‘CZ’,’CZ_DEVL_PROJECTS’,’DELETED_FLAG’); END;

*
ERROR at line 1:
ORA-20002: Version of statistics table “APPLSYS”.”FND_STATTAB” is too old.
Please try upgrading it with dbms_stats.upgrade_stat_table
ORA-06512: at “APPS.FND_STATS”, line 664
ORA-06512: at “APPS.FND_STATS”, line 2497
ORA-06512: at line 1
Time when worker failed: Sun Dec 14 2014 02:43:14
SOLUTION 19

As sys on DB node, EXECUTE DBMS_STATS.UPGRADE_STAT_TABLE(‘APPLSYS’,’FND_STATTAB’)

Restart failed worker

ERROR 20

1 Run AutoPatch R120 pl adsstats.sql FAILED

sqlplus -s APPS/***** @/d01/r12/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adsstats.sql
declare
*
ERROR at line 1:
ORA-20000: ORA-20001: invalid column name or duplicate columns/column
groups/expressions in method_opt Error while executing
FND_STATS.GATHER_SCHEMA_STATISTICS package.
ORA-06512: at line 91

SOLUTION 20

SQL> set lines 132

SQL> select table_name, column_name, count(*) from FND_HISTOGRAM_COLS group by table_name, column_name having count(*) > 1;
TABLE_NAME COLUMN_NAME COUNT(*)
——————————————— ———————————- ———-
HRI_DBI_WMV_COUNT_MV COUNT_TYPE 2
1. Make sure to have a valid backup for FND_HISTOGRAM_COLS table.

2. Run the following to delete column ‘PARENT_FLEX_VALUE’ from FND_HISTOGRAM_COLS.

delete from FND_HISTOGRAM_COLS
where table_name = ‘HRI_DBI_WMV_COUNT_MV’
and column_name = ‘COUNT_TYPE’
and rownum=1;

1 row deleted

and

delete from FND_HISTOGRAM_COLS
where (table_name, column_name) in
(
select hc.table_name, hc.column_name
from FND_HISTOGRAM_COLS hc , dba_tab_columns tc
where hc.table_name =’HRI_DBI_WMV_COUNT_MV’
and hc.table_name= tc.table_name (+)
and hc.column_name = tc.column_name (+)
and tc.column_name is null
);
3- Restart the failed worker.

ERROR 21
when starting HTTP services

——–
14/12/14 17:06:30 Start process
——–
/d01/r12/inst/apps/testdb_r12server/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/d01/r12/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory
~

SOLUTION 21
Attempting to Start Apache (adapcctl.sh) Throws an ‘Error While Loading Shared Libraries: libdb.so.2’ on RedHat Linux 5 [ID 879522.1]
Oracle HTTP Server Unable To Start During Installation Due To Missing Libraries libdb-3.3.so libgdbm.so.2 [ID 735605.1]

[root@r12server ~]# yum install gdbm-1.8.0-36.el6.i686

and

[root@r12server ~]# ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

ERROR 22
Login Page
checking URL = http://r12server.localdomain:8001/OA_HTML/AppsLogin
RW-50016: Error: – {0} was not created:
File = {1}
SOLUTION 22

Check: Note: 437152.1 – R12 Rapidwiz Fails on Post Installation Tasks : RW-50016, Timed Out( 100000 )

ERROR 23

FRM-92095: Oracle JInitiator version too low. Please install version 1.1.8.2 or higher
SOLUTION 23
https://blogs.oracle.com/ptian/entry/solution_for_error_frm_92095

Cause:

The JRE version is not incompatible.
Solution 1:

This is a workaround solution, For Window 7 user, Add a OS Parameter: JAVA_TOOL_OPTIONS, and parameter value is: -Djava.vendor=”Sun Microsystems Inc.”

(Not very sure this way works in windows XP or not, You can try it, And pls let me know the result)

Reference:http://www.ora600.be/FRM-92095%3A+Oracle+Jnitiator+version+too+low+-+please+install+version+1.1.8.2+or+higher
Solution 2:

This is a workaround solution as well, Uninstall your JRE 7, and re-install JRE 6

How uninstall JRE 7, Refer: http://www.java.com/en/download/uninstall.jsp

How to install JRE 6,Refer: http://www.java.com/en/download/manual_v6.jsp

Solution 3:

This is root solution, Enable EBS environments for JRE 7, refer: https://blogs.oracle.com/stevenChan/entry/java_jre_1_7_03

ERROR 24
When running opatch on application oracle_home:

LsInventory: OPatch Exception while accessing O2O

OPATCH_JAVA_ERROR : An exception of type “OPatchException” has occurred:
OPatch Exception:
OUI found no such ORACLE_HOME set in the environment
Can not get details for given Oracle Home
An exception occurs
null

There is no Interim Patch

OPATCH_JAVA_ERROR : An exception of type “OPatchException” has occurred:
Can not get a list of inventory on this home.

ERROR: OPatch failed because of Inventory problem.
SOLUTION 24
BOTH ORACLE 10.1.2. AND 10.1.3 WERE NOT REGISTERED IN THE INVENTORY.

$ cd $ORACLE_HOME/oui/bin
./runInstaller -silent -attachHome ORACLE_HOME=/d01/r12/apps/tech_st/10.1.2 ORACLE_HOME_NAME=”testdb_TOOLS”
./runInstaller -silent -attachHome ORACLE_HOME=/d01/r12/apps/tech_st/10.1.3 ORACLE_HOME_NAME=”testdb_WEBOH”

OR ADD BELOW ENTRY IN INVENTORY.XML

ERROR 25

Starting AutoConfig at Wed Dec 17 21:33:12 2014
Using adconfig.pl version 120.26.12010000.5

Classpath :

Version Conflicts among development maintained and customized templates encountered; aborting AutoConfig run.

The logfile for this session is located at: /d02/app/oracle/product/11.2.0/dbhome_1/appsutil/log/testdb_r12server/12172133/adconfig.log

SOLUTION 25

AutoConfig Fails With Error: Version Conflicts Among Development Maintained and Customized Templates Encountered; aborting AutoConfig run [ID 1100113.1]

Remove appsutil completely and then unzip again

ERROR 26

COPYRETRY : Retrying copy, due to exception :Error in writing to file ‘/d2/R12/ab/apps/R1211XB9/apps/tech_st/10.1.3/dsa/bin/dsaServer.sh’. [/d2/R12/ab/apps/R1211XB9/apps/tech_st/10.1.3/dsa/bin/dsaServer.sh (No such file or directory)]
COPRETRY Attempt :1
COPYRETRY new Jar File copied to temp:/tmp/OraInstall2014-12-18_09-39-09AM/temp12
COPYRETRY : Retrying copy, due to exception :Error in writing to file ‘/d2/R12/ab/apps/R1211XB9/apps/tech_st/10.1.3/dsa/bin/dsaServer.sh’. [/d2/R12/ab/apps/R1211XB9/apps/tech_st/10.1.3/dsa/bin/dsaServer.sh (No such file or directory)]
COPRETRY Attempt :2
COPYRETRY new Jar File copied to temp:/tmp/OraInstall2014-12-18_09-39-09AM/temp13
COPYRETRY : Retrying copy, due to exception :Error in writing to file ‘/d2/R12/ab/apps/R1211XB9/apps/tech_st/10.1.3/dsa/bin/dsaServer.sh’. [/d2/R12/ab/apps/R1211XB9/apps/tech_st/10.1.3/dsa/bin/dsaServer.sh (No such file or directory)]
COPRETRY Attempt :3
COPYRETRY new Jar File copied to temp:/tmp/OraInstall2014-12-18_09-39-09AM/temp14
Exception thrown from action: copyGroupFromJar
Exception Name: IOException2
Exception String: Error in writing to file ‘/d2/R12/ab/apps/R1211XB9/apps/tech_st/10.1.3/dsa/bin/dsaServer.sh’. [/d2/R12/ab/apps/R1211XB9/apps/tech_st/10.1.3/dsa/bin/dsaServer.sh (No such file or directory)]
SOLUTION 26

It was the comps.xml under $IAS_ORACLE_HOME/inventory/ContentsXML that had wrong entries.
After replacing the path with the correct one, the installation was successfully.

*********

opmn.xml
/d01/r12/apps/tech_st/10.1.3/opmn/conf
/d2/R12/ab/apps/R1211XB9/

correct > /d01/r12/apps/tech_st/10.1.3
wrong > /d2/R12/ab/apps/R1211XB9/apps/tech_st/10.1.3
%s/\/d2\/R12\/ab\/apps\/R1211XB9/\/d01\/r12/g

Author
Recent Posts

Brijesh Gogia

I’m an experienced Cloud/Oracle Applications/DBA Architect with more than 15 years of full-time DBA/Architect experience. I have gained wide knowledge on Oracle and Non-Oracle software stack running on-prem and on Cloud and have worked on several big projects for multi-national companies. I enjoy working with leading-edge technology and have a passion for Cloud architecture, automation, database performance, and stability. Thankfully my work allows me time for researching new technologies (and to write about them).

Upgrade 11i to R12.1.1 (PART 4 in “11i to R12.1.3 upgrade” series)

1. Increase server cpus and ram

2. Clean up 11i

3. Convert from jinitiator to native sun(oracle) jre

4. Convert tablespace to OATM model

5. Increase tablespace size

6. Database upgrade requirements

7. Modify initialization parameters

8. Apply 11i.ad.i.6 (conditional)

9. Verify temporary tablespace

10. Prepare an upgrade plan for customizations (conditional)

11. Convert to multiple organizations architecture (required)

12. Drop event alert triggers in custom schemas

13. Convert oracle alert e-mail processing to the workflow notification mailer

14. Apply interoperability patches for oracle apps 11i and database 11gr2

16. Execute the upgrade manual script (tums)

17. Run ad preparation scripts

18. Gather schema statistics for CBO

19. Back up database, applications, and customization (recommended)

21. Run rapid install (required)

22. Ensure that Maintenance Mode is enabled

23. Apply AD 12.1.1 upgrade driver R12.AD.B.1 (7461070)

24. Apply additional patches in pre-install mode

25. Apply solution for slow XDOLOADER task

26. Run the American English upgrade patch driver

27. Revoke solution for slow XDOLOADER task

28. Disable Maintenance Mode

29. Reset init.ora parameters

30. Back up Oracle E-Business Suite

31. Configure and start server processes

32. Change Default Passwords

33. Re-apply customization

34. Re-enable custom triggers, constraints, and indexes

35. Other System Administration Tasks (conditional)

36. Install online help (recommended)

37. Review Other Post Upgrade Tasks

38. ISSUES FACED

One Comment

Upgrade 11i to R12.1.1 (PART 4 in “11i to R12.1.3 upgrade” series)

1. Increase server cpus and ram

2. Clean up 11i

3. Convert from jinitiator to native sun(oracle) jre

4. Convert tablespace to OATM model

5. Increase tablespace size

6. Database upgrade requirements

7. Modify initialization parameters

8. Apply 11i.ad.i.6 (conditional)

9. Verify temporary tablespace

10. Prepare an upgrade plan for customizations (conditional)

11. Convert to multiple organizations architecture (required)

12. Drop event alert triggers in custom schemas

13. Convert oracle alert e-mail processing to the workflow notification mailer

14. Apply interoperability patches for oracle apps 11i and database 11gr2

16. Execute the upgrade manual script (tums)

17. Run ad preparation scripts

18. Gather schema statistics for CBO

19. Back up database, applications, and customization (recommended)

21. Run rapid install (required)

22. Ensure that Maintenance Mode is enabled

23. Apply AD 12.1.1 upgrade driver R12.AD.B.1 (7461070)

24. Apply additional patches in pre-install mode

25. Apply solution for slow XDOLOADER task

26. Run the American English upgrade patch driver

27. Revoke solution for slow XDOLOADER task

28. Disable Maintenance Mode

29. Reset init.ora parameters

30. Back up Oracle E-Business Suite

31. Configure and start server processes

32. Change Default Passwords

33. Re-apply customization

34. Re-enable custom triggers, constraints, and indexes

35. Other System Administration Tasks (conditional)

36. Install online help (recommended)

37. Review Other Post Upgrade Tasks

38. ISSUES FACED

Related posts:

One Comment