Tag Archives: Patching - Page 4

Installing Oracle Applications Release 11.5.9 on Linux

Posted by on September 28, 2007 No comments

Red Hat Enterprise Linux AS 3

Installation

(Red Hat Enterprise Linux AS release 3 under a Vmware virtual machine)

Refer to Metalink Doc ID:  Note: 234783.1 (Subject:  Oracle Applications 11.5.9 – Installation Update Notes for Linux x86 – B10849-01)

Step 1:        For a single-user install, create user applmgr (UID 500, GID 500) and assign it to the dba group (GID 501). Make the primary group of user applmgr ‘dba’.

Step 2:        Ensure that at least 2GB RAM is allocated and a 4GB swapfile exists. If possible, set the number of CPUs to 2.

Step 3:        Necessary packages must exist on the system (current ones shown in brackets):

  1. binutils-2.14.90.0.4-35 [binutils-2.14.90.0.4-26]
  2. compat-db-4.0.14-5 [ok]
  3. compat-gcc-7.3-2.96.122 [ok]
  4. compat-gcc-c++-7.3-2.96.122 [ok]
  5. compat-libstdc++-7.3-2.96.122 [ok]
  6. gcc-3.2.3-42 [gcc-3.2.3-20]
  7. gcc-c++-3.2.3-42 gcc-c++-3.2.3-20]
  8. glibc-2.3.2-95.27 [glibc-2.3.2-95.3]
  9. glibc-common-2.3.2-95.27 glibc-common-2.3.2-95.3]
  10. gnome-libs-1.4.1.2.90-34.1 [x]
  11. libaio-0.3.96-5 [libaio-0.3.96-3]
  12. libaio-devel-0.3.96-5 [libaio-devel-0.3.96-3]
  13. libgcc-3.2.3-42 [libgcc-3.2.3-20]
  14. libstdc++-3.2.3-42 [libstdc++-3.2.3-20]
  15. libstdc++-devel-3.2.3-42 [libstdc++-devel-3.2.3-20]
  16. make-3.79.1-17 [ok]
  17. openmotif21-2.1.30-8 [ok]
  18. pdksh-5.2.14-21 [ok]
  19. setarch-1.3-1 [ok]
  20. sysstat-4.0.7-4.EL3.3 [x]

sysstat-4.0.7-4.EL3.3 – RHEL AS 3 CD 2

gnome-libs-1.4.1.2.90-34.1 – RHEL AS 3 CD 3

Or load Add/Remove Programs and include:

  1. GNOME Software Development
  2. System Tools [sysstat]
  3. Legacy Development Tools

From Metalink Doc ID: 234783.1, the following are required RPMs:

  • compat-db-4.0.14.5 [Red Hat CD 3]
  • compat-gcc-7.3-2.96.122
  • compat-gcc-c++-7.3.2.96.122
  • compat-libstdc++-devel-7.3-2.96.122
  • openmotif21-2.1.30-8.i386.rpm [Red Hat CD 3 – MUST be installed manually]
  • setarch-1.3-1

Step 4:        Ensure that the following utilities are present by issuing it as a parameter to the ‘which’ command.

  • which ar
  • which cc
  • which ld
  • which make

Step 5:        Ensure that the JRE JDK 1.3.1_11 is installed. Download the RPM bin file from http://java.sun.com/products /archive/. Execute the .bin file to extract the RPM file (Legacy Development Tools must be installed from Add/Remove Programs). When run, the RPM creates the /usr/java/jdk1.3.1_11 directory. Create a softlink in /usr/local/bin to the /usr/java/jdk1.3.1_11/bin/java file. Verify that java works by running java –version from the terminal.

Step 6:         Insert the first CD (Start Here) and copy the CD to the staging area:

mkdir /u4/stage1159

mkdir startCD

mkdir Disk1

cd /u4/stage1159/startCD/Disk1

cp –r /media/cdrom/* .

About 33GB of disk space is required to set up the staging area.

Step 7:        Download and apply patch 3006854.

Step 8:        On the console of appslinux (not VNC), start Rapid Install by running rapidwiz (located in script /home/applmgr/setup1159.env):

unset LANG (this is EXTREMELY important!)

setarch i386

export DISPLAY=:0.0

echo $DISPLAY

cd /u0/stage1159/startCD/Disk1/rapidwiz

./rapidwiz

Follow the wizard to completion. See Metalink Doc IDs: 466544.996, 640827.995 and 234783.1.

Refer to the “Installing Oracle Applications: A Guide to Using Rapid Install Release 11i (11.5.10)” (r11510ins.pdf) for more information.

Patch List – Production Upgrade

Posted by on August 12, 2007 No comments
Sno Patch Number Description Remarks
1 4238286 Tums
2 4712852 AD.i.4 Patch Got An issue while applying on
Apps Node while Relinking Refer
Log Notes
3 5107107 AutoConfig Update
Patch
4 4318672 Technology Stack
Utility Patch
5 9iAS Installation This Patch will Install This Step includes set of
iAS and Developer Patches which is same in Main
Project Plan
6 9i Upgrade Database Upgrade This steps includes set of
Patches which is same in Main
Project Plan
Note : After Database Upgrade Process
Got an issue while Starting up the Instance
Refer log Notes
7 3180164 New Product and New TBS
8 3480000 Maintenance Patch Got an Issue while applying on Admin Node
refer to Log Notes and also it took 3 days on
admin node
9 3275245 Online Help Patch This Patch Will be Applied after Go-Live
10 5117525 Jinitiator Upgrade Patch This patch should apply as a Part of Jinitiator
11 JDK Upgrade
12 5759055 TXK and ADX patch This Patch is should be applied as part of 10g
Upgrade as Pre-Reqs
13 4653225 10g Upgrade This Patch should as 10g pre-req Upgrade
14 10g Upgrade Actual 10g upgrade process
15 5753621 Receivables Patch
16 3636980 Diagnostic Patch
17 5529008 Diag Support Patch

Pre-Upgrade Checks On Production

Posted by on August 12, 2007 No comments

1. Check the Invalid Objects in the existing Production Instance and Spool the output

2. Check the Size of existing SGA in Production

3. Check the Number of Tablespaces along with free space

4. Check the Number of Datafiles/Log/Control files in Production

5. Run Autoconfig on both Both Nodes just to make sure that autoconfig run successful on both nodes…Note: This must be done when users logout from application

6. Relink any Executable eg.FNDLIBR using adadmin or adrelink command on both nodes just to make sure that there is no relink issue for any module

7. Check the Installed or Shared Modules on existing Production Instance along with it Patch Level

8. Turn Off Archive Log mode

Note: Except step 5,6,8 spool the output and store it for further reference

Additional steps:

a. Obtain URL, port of instance

b. Obtain username and password of essential Oracle users (apps, system, sys) and OS users (applmgr, root)

c. Obtain username, password for user with System Administrator responsibility, to test concurrent programs (e.g. Active Users)

d. Determine and note location of database files, log files, control files, archive log files

e. Note location of top directories (APPL_TOP, COMMON_TOP, ORA_TOP, DB_TOP, DATA_TOP)

f. Determine status of archivelog mode (and turn off if necessary)

g. Record PERL location and version

h. Rerun AutoConfig on database, application tiers to ensure it is working

I. Run adrelink on database, application to ensure it is working

j. Source environment and ensure environment variables correct (e.g. APPLCSF)

k. Ensure UNIX commands available (cc, ld, make/gnumake, ar)

ojspcompile.pl Errors With ‘Xml File Not Found’

Posted by on August 5, 2007 No comments

After running patch 4712852,

error! could not find autoconfigure’s XMLFILE

Solution: Metalink Doc ID: 374676.1 (Subject: Ojspcompile.pl Errors With ‘Xml File Not Found’ During Patching In a RAC Environment)

had the following solution:

To implement the solution, please execute the following steps:

1. Apply 4709948, ‘TXK (FND) AUTOCONFIG TEMPLATE ROLLUP PATCH M (APRIL 2006)’
2. Retest.

This patch is included in patch 5759055, which will be applied next.

SOLUTION:

Rreran patch 4712852, perl -x /emca/PROD/prodappl/jtf/11.5.0/admin/scripts/ojspCompile.pl –compile –quiet
ran successfully.

11i Upgrade on Test Instance

Posted by on July 28, 2007 No comments
Step No. Patch Number Type of Patch Patch Name Date Applied Start
Time		 End
Time		 Time Taken
(One Tier)		 Comment Node Applied
Patches Applied June-July, 2007
15/06/2007 10:58 03/07/2007 2:24 17 days 15:25 hours Total time taken: 17 days 15 hours
Enable Maintenance Mode
Shut down Oracle services on application and database nodes
1 4238286 ONE-OFF PATCH TUMS-MP 11.5.10: TUMS UTILITY FOR THE 11.5.10 MAINTENANCE PACK Fri 15-Jun-07 10:58:53 11:03:13 0 days 0:04 hours
2 4712852 MINI PACK Minipack 11i.AD.I.4 Fri 15-Jun-07 12:25:18 12:50:59 0 days 0:25 hours GHL1TESTDATA
3 5107107 ROLLUP PATCH TXK (FND & ADX) AUTOCONFIG ROLLUP PATCH N (AUGUST 2006) Fri 15-Jun-07 15:32:19 15:49:50 0 days 0:17 hours GHL1TESTDATA
4 4318672 ONE-OFF PATCH 11.5.10.2 Technology Stack Validation Patch (Revision 1 July, 2005) Fri 15-Jun-07 17:02:39 17:06:37 0 days 0:03 hours
5 4139957 INTEROP PATCH Interop Patch For 11.5.10 TechStack Component Only Install Sat 16-Jun-07 17:43:42 21:06:43 0 days 3:23 hours
6 4888294 INTEROP PATCH APPLICATIONS INTEROPERABILITY PATCH FOR DEVELOPER 6I PATCH 18* Sun -Jun-07 16:42:33 16:47:43 0 days 0:05 hours
7 5529008 SUPPORT PACK DIAGNOSTICS SUPPORT PACK NOVEMBER 2006 with Oracle Diagnostics 2.4 RUP A Sat 23-Jun-07 8:23:58 8:39:17 0 days 0:15 hours
8 3480000 MAINTENANCE PACK ORACLE APPLICATIONS RELEASE 11.5.10.2 MAINTENANCE PACK Sat 30-Jun-07 15:25:16 2:24:34 2 days 10:59 hours Started: Sat Jun 30 2007 15:25:16
Completed: Tue Jul 03 2007 02:24:34
9 3275245 ONE-OFF PATCH 11.5.10 ONLINE HELP CONSOLIDATED PATCH Thu 05-Jul-07 12:19:33 1:18:37 0 days 12:59 hours
10 5117525 INTEROP PATCH APPLICATIONS INTEROPERABILITY PATCH FOR JINITIATOR 1.3.1.x Sat 07-Jul-07 19:57:17 20:06:05 0 days 0:08 hours
11 5759055 ROLLUP PATCH TXK (FND & ADX) AUTOCONFIG ROLLUP PATCH P (MAR/APR 2007) Sun 08-Jul-07 19:22:20 19:38:08 0 days 0:15 hours
12 4653225 INTEROP PATCH 11.5.10 INTEROP PATCH FOR 10GR2 Sun 08-Jul-07 20:18:57 20:41:48 0 days 0:22 hours
13 5753621 ONE-OFF PATCH ONE-OFF REQUEST ON TOP OF 11.5.9 CU2 FOR BUG 5525015 Fri 13-Jul-07 17:04:06 17:11:36 0 days 0:07 hours
14 3636980 NEW PRODUCT Support Diagnostics (IZU) patch for AD Splice Mon 23-Jul-07 8:15:44 8:19:28 0 days 0:03 hours
15 2838093 ONE-OFF PATCH ONE-OFF FIXES FOR XSU 1.2.1 & XML PARSER FOR PL/SQL 1.0.2 FOR APPLICATIONS Sat 28-Jul-07 11:36:10 11:38:47 0 days 0:02 hours C driver
16 2838093 ONE-OFF PATCH ONE-OFF FIXES FOR XSU 1.2.1 & XML PARSER FOR PL/SQL 1.0.2 FOR APPLICATIONS Sat 28-Jul-07 11:43:01 11:45:18 0 days 0:02 hours D driver
17 4464099 ROLLUP PATCH FUNDS CHECKER ROLLUP PATCH : STANDALONE FOR BASE11i OR ANY MAINTENANCE PACK Sat 28-Jul-07 12:01:07 12:07:34 0 days 0:06 hours
18 3180164 UPDATE APPLPROD.TXT TO ADD NEW PRODUCTS FOR 11.5.10 MAINTENANCE PACK Sat 28-Jul-07 16:46:28 17:03:32 0 days 0:17 hours

Patch List for Cloning 11i

Posted by on July 11, 2007 No comments
Step No. Patch Number Type of Patch Patch Name Date Applied Comment Node Applied
Patches Applied to PROD on July 5, 2007
Refer to Metalink Doc ID: 230672.1 (Cloning Oracle Applications Release 11i with Rapid Clone)
Enable Maintenance Mode
Shut down Oracle application tier services
1 5035661 Minipack UPGRADE OUI TO VERSION 2.2 5-Jul-07 Apply to iAS and RDBMS homes linux-blade
2 4712852 Minipack MINIPACK 11I.AD.I.4 5-Jul-07 See Metalink Doc ID: 233044.1 linux-blade
3 5759055 Rollup Patch TXK (FND & ADX) AUTOCONFIG ROLLUP PATCH P (MAR/APR 2007) 5-Jul-07 See Metalink Doc ID: 165195.1 linux-blade
Update RDBMS ORACLE_HOME with AutoConfig files from Application Tier
4 5225940 Family Pack POST ADX-F FIXES 5-Jul-07 linux-blade
Disable Maintenance Mode before copying files
Continue cloning process
Restart Oracle application tier services
Note:
Patches 3453499 and 4709948 were applied by 5759055; there is no need to apply these patches.
linux-blade: Database tier, concurrent processing server, administration server, reports server, forms server, web server
Source directory: /emca/PROD/
Target Directory: /u0/oracle

 

Failed to generate product JAR files in JAVA_TOP

Posted by on June 28, 2007 No comments

Problem: While applying patch 3218526, the following error occurs:

Failed to generate product JAR files in JAVA_TOP -
   /u02/bravo/bravocomn/java.

adogjf() Unable to generate jar files under JAVA_TOP

AutoPatch error:
Failed to generate the product JAR files

You should check the file
/u02/bravo/bravoappl/admin/bravo/log/adpatch_3218526_20070628a.log

for errors.

Solution:

Issue encountered while running this patch on BRAVO.

To resolve this issue, on the AP node (web tier):

1. Source the environment
2. Run:
adjkey -initialize
3. Run:
adjbuild.sh /u0/bravo/bravocomn/util/jinitiator /u0/bravo/bravocomn/util/jinitiator/jinit11816.exe
4. Run adadmin on both nodes and generate product jars

ORA-06502 Saving Work Order

Posted by on June 4, 2007 No comments

Problem: The following error is occurring:

The following errors occur when trying to update operations of Firm work orders:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

ORA-06512: at “APPS.FND_MESSAGE”, line 418

ORA-06512: at “APPS.FND_MESSAGE”, line 461

ORA-06512: at “APPS.FND_MESSAGE”, line 585

ORA-06512: at “APPS.FND_MESSAGE”, line 537

ORA-06512: at “APPS.APP_EXCEPTION”, line 42

ORA-06512: at “APPS.EAM_WORKORDER_UTIL_PKG”, line 1165

ORA-06512: at “APPS.EAM_OPERATIONS_PKG”, line 347

Steps to Reproduce Issue:

  1. Log on as user operations
  2. Enterprise Asset Management
  3. Work Orders > Work Order
  4. Seattle Maintenance
  5. WO90203
  6. Click Operations
  7. When the start and end time is changed, error occurs.

Solution: Apply Patch 4432063.

Refer to Metalink Doc ID: 357568.1 (Error ‘ORA-06502’ Occurs When Saving Changes To Work Order Operation)

Relink of module “WFRESGEN” failed

Posted by on May 18, 2007 No comments

While applying the patch AD.I.4 patch 4712852 on a multi node instance, the following error encountered during the relinking process on Apps server, which was successfully run on the Admin Node.

Relinking module 'WFRESGEN' in product fnd ...
make -f /disk1/oratest/oracle/prodappl/admin/TEST/out/link_fnd_26515.mk
/disk1/oratest/oracle/prodappl/fnd/11.5.0/bin/WFRESGEN
Starting link of fnd executable 'WFRESGEN' on Fri May 18 11:57:46 GMT 2007
make: Fatal error: Don't know how to make target
`/disk1/oratest/oracle/prodappl/fnd/11.5.0/lib/wfresgcp.o'
Done with link of fnd executable 'WFRESGEN' on Fri May 18 11:57:46 GMT 2007
Relink of module "WFRESGEN" failed.
See error messages above (also recorded in log file) for possible
reasons for the failure. Also, please check that the Unix userid
/
/disk1/oratest/oracle/prodappl/fnd/11.5.0/bin/WFRESGEN
Starting link of fnd executable 'WFRESGEN' on Fri May 18 11:57:46 GMT 2007
make: Fatal error: Don't know how to make target
`/disk1/oratest/oracle/prodappl/fnd/11.5.0/lib/wfresgcp.o'
Done with link of fnd executable 'WFRESGEN' on Fri May 18 11:57:46 GMT 2007
Relink of module "WFRESGEN" 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 /disk1/oratest/oracle/prodappl/fnd/11.5.0/bin,
and that there is sufficient space remaining on the disk partition
containing your Oracle Applications installation.

Solution:-

a) Aborted the patch

b) Copied the missing file wfresgcp.o from the Admin Node to Apps node

c) Relinked all the modules (this process took 1 hr on each node)

d) Re-run the patch and successfully completed

Project Rollup Patches Not Completing On DB Tier

Posted by on April 20, 2007 No comments

Problem: When applying Project Costing rollup patches to DB tier, the following errors are returned:

adlibout: error: cannot get table of contents in library file for product pa

File name is f:/oracle/prodappl/pa/11.5.0/lib/past.lib

Solution: mspdb60.dll not in the path.

Another issue was encountered on the system, which the application modules were relinked. While relinking, the message ‘gnumake: Error 128’ appeared. Metalink Doc ID 123595.1 and 142390.1 indicated that the mspdb60.dll file was not in the path (on the DB tier). After modifying the path, the relink completed successfully.

The Project Costing rollup patches were then reapplied, on both tiers, and all patches went through successfully. Relinking appears to be part of the patching process for the Project Costing rollup patches.