Monthly Archives: May 2007

Upgrading 8.1.7 to 9.2.0

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

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

Troubleshooting APP-FND-00500 Error

Problem:

The APP-FND-00500 error was encountered when printing TD4 slips.

Solution:

Set printer output to RAW.

Reference:

Metalink Doc ID: 200359.1 (Oracle Application Object Library Printer Setup Test), which will assist in validating the printer configuration/setup in Oracle Applications.