Category Archives: Solaris - Page 3

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

Upgrading 8.1.7 to 9.2.0

Posted by on May 28, 2007 No comments

This documentation shows how to upgrade Oracle Applications RDBMS version 8.1.7 to 9.2.0.

Step 1:        Go to Metalink and order or download the three CDs for 9.2.0.1, for the correct platform

Step 2:        Shutdown the application tier services and the database and listener services.

Step 3:        The current RDBMS top is proddb/8.1.7. Create a new RDBMS top directory:

mkdir /raid01/oratest/oracle/proddb/9.2.0

Step 4:        Set the following environment variables:

ORACLE_HOME=/raid01/oratest/oracle/proddb/9.2.0

ORACLE_SID=TEST

Step 5:        Ensure that any TNSLSNR variables are unset.

Step 6:        If the installation was previously cancelled half-way, deinstall the installed products and/or delete the files in 9.2.0:

cd /raid01/oratest/oracle/proddb/9.2.0

rm –rf *

Step 7:        When installing, use the following values:

Destination Name: TEST_920

Destination Path: /raid01/oratest/oracle/proddb/9.2.0

Begin installation.

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