Problem:
After applying patch 9239090 (ORACLE E-BUSINESS SUITE 12.1.3 RELEASE UPDATE PACK), DataInstall must be run. However, after sourcing the environment and running the DataInstall command, the following error appears:
java.lang.ClassNotFoundException: oracle.apps.per.DataInstall
Solution:
Source the application tier environment (not the database tier environment) and then run DataInstall.
Problem:
While running patch 9239090, the following error appears:
ATTENTION: All workers either have failed or are waiting: FAILED: file OKLTXRBKUG.sql on worker 1. FAILED: file OKLTXRBKUG.sql on worker 2. FAILED: file OKLTXRBKUG.sql on worker 3. FAILED: file OKLTXRBKUG.sql on worker 4. FAILED: file OKLTXRBKUG.sql on worker 5. FAILED: file OKLTXRBKUG.sql on worker 6. FAILED: file OKLTXRBKUG.sql on worker 7. FAILED: file OKLTXRBKUG.sql on worker 8. FAILED: file OKLTXRBKUG.sql on worker 9. FAILED: file OKLTXRBKUG.sql on worker 10. FAILED: file OKLTXRBKUG.sql on worker 11. FAILED: file OKLTXRBKUG.sql on worker 12. ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Solution:
The OKL_TRANSACTION_PVT package was invalid. When this was compiled, the OKL_SECURITIZATION_PVT was invalid. In this way, a number of OKL packages were invalid and the error was cascading. In order to resolve the issue, I logged on to SQL*Plus as sysdba and ran the following commands:
alter package APPS.OKL_TXL_ASSETS_PVT compile; alter package APPS.OKL_TXL_ASSETS_PVT compile body; alter package APPS.OKL_TXL_ASSETS_PUB compile; alter package APPS.OKL_TXL_ASSETS_PUB compile body; alter package APPS.OKL_SPLIT_ASSET_PVT compile; alter package APPS.OKL_SPLIT_ASSET_PVT compile body; alter package APPS.OKL_SECURITIZATION_PVT compile; alter package APPS.OKL_SECURITIZATION_PVT compile body; alter package APPS.OKL_TRANSACTION_PVT compile; alter package APPS.OKL_TRANSACTION_PVT compile body;
OKL_TRANSACTION_PVT now compiles without issue.
To resolve this in future, use adadmin to compile APPS schema. Afterwards, issue the following SQL statement in SQL*Plus to get the number of invalid objects:
select count(*) from dba_objects where status = ‘INVALID’;
Continue compiling APPS schema with adadmin and checking the number of invalid objects until that number no longer decreases.
Problem:
While running patch 9239090, the following error appears:
ATTENTION: All workers either have failed or are waiting: FAILED: file OKLTXRBKUG.sql on worker 1. FAILED: file OKLTXRBKUG.sql on worker 2. FAILED: file OKLTXRBKUG.sql on worker 3. FAILED: file OKLTXRBKUG.sql on worker 4. FAILED: file OKLTXRBKUG.sql on worker 5. FAILED: file OKLTXRBKUG.sql on worker 6. FAILED: file OKLTXRBKUG.sql on worker 7. FAILED: file OKLTXRBKUG.sql on worker 8. FAILED: file OKLTXRBKUG.sql on worker 9. FAILED: file OKLTXRBKUG.sql on worker 10. FAILED: file OKLTXRBKUG.sql on worker 11. FAILED: file OKLTXRBKUG.sql on worker 12. ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Solution:
The OKL_TRANSACTION_PVT package was invalid. When this was compiled, the OKL_SECURITIZATION_PVT was invalid. In this way, a number of OKL packages were invalid and the error was cascading. In order to resolve the issue, I logged on to SQL*Plus and ran the following commands:
alter package APPS.OKL_TXL_ASSETS_PVT compile;
alter package APPS.OKL_TXL_ASSETS_PVT compile body;
alter package APPS.OKL_TXL_ASSETS_PUB compile;
alter package APPS.OKL_TXL_ASSETS_PUB compile body;
alter package APPS.OKL_SPLIT_ASSET_PVT compile;
alter package APPS.OKL_SPLIT_ASSET_PVT compile body;
alter package APPS.OKL_SECURITIZATION_PVT compile;
alter package APPS.OKL_SECURITIZATION_PVT compile body;
alter package APPS.OKL_TRANSACTION_PVT compile;
alter package APPS.OKL_TRANSACTION_PVT compile body;
OKL_TRANSACTION_PVT now compiles without issue.
To resolve this in future, use adadmin to compile APPS schema. Afterwards, issue the following SQL statement in SQL*Plus to get the number of invalid objects:
select count(*) from dba_objects where status = ‘INVALID’;
Continue compiling APPS schema with adadmin and checking the number of invalid objects until that number no longer decreases.
Problem:
When rerunning patch 9239090, the following error appears:
ATTENTION: All workers either have failed or are waiting: FAILED: file mth_pre_upgrade.sql on worker 1. ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Checked worker log file:
C:oracleTEST1appsapps_stappladminTEST1logadwork001.log
The following errors appeared:
Time when worker started job: Mon Jan 30 2012 09:42:06 Start time for file is: Mon Jan 30 2012 09:42:06 sqlplus -s MTH/***** @C:oracleTEST1appsapps_stapplmth12.0.0patch115sqlmth_pre_upgrade.sql Error: Program exited with status 1 Cause: The program terminated, returning status code 1. Action: Check your installation manual for the meaning of this code on this operating system.DECLARE * ERROR at line 1: ORA-00955: name is already used by an existing object ORA-06512: at line 59 Time when worker failed: Mon Jan 30 2012 09:42:06 Time when worker started job: Mon Jan 30 2012 09:42:06 Start time for file is: Mon Jan 30 2012 09:42:06 sqlplus -s MTH/***** @C:oracleTEST1appsapps_stapplmth12.0.0patch115sqlmth_pre_upgrade.sql Error: Program exited with status 1 Cause: The program terminated, returning status code 1. Action: Check your installation manual for the meaning of this code on this operating system.DECLARE * ERROR at line 1: ORA-00955: name is already used by an existing object ORA-06512: at line 59 Time when worker failed: Mon Jan 30 2012 09:42:06
Solution:
1. Edit C:oracleTEST1appsapps_stapplmth12.0.0patch115sqlmth_pre_upgrade.sql and uncomment SQL code for Exception. Then restart worker (did not try this solution).
2. Use adctrl (option 8) to skip and restart this step (tried this solution).
Reference:
https://forums.oracle.com/forums/thread.jspa?messageID=9224027
[amazon asin=0070077290&template=iframe image&chan=default] [amazon asin=1453742735&template=iframe image&chan=default] [amazon asin=0615238440&template=iframe image&chan=default]
Problem:
When running Rapid Install, the following error appears:
RW-50004: Error code received when running external process. Check log file for details. Running Database Install Driver for TEST1 instance
In the ‘Rapid Install base window – do not close’ window, the following appears:
Configuration file written to: C:oracleTEST1instappsTEST1_ittl-hrmstestconf_TEST1.txt Configuration file written to: C:oracleTEST1dbtech_st11.1.0appsutilconf_TEST1.txt Database logfile - C:oracleTEST1dbtech_st11.1.0appsutillogTEST1_ittl-hrmstest1260950.log uploadConfig() : Exception : TDU
Rapid Wizard completes with the following error:
RW-10001: Rapidinstall wizard has detected that your configuration has errors. You must resolve these issues before continuing.
The log file C:oracleTEST1dbtech_st11.1.0appsutillogTEST1_ittl-hrmstest1260950.log showed the following:
RW-50010: Error: - script has returned an error: 1 RW-50004: Error code received when running external process
Solution:
Change the NUMBER_OF_PROCESSORS environment variable from 16 to 12 and restart installation.
Problem:
When launching Application Designer on the PeopleSoft server, the following error appears:
Error: Could not resolve environment variable(s) in %PS_SERVDIR%logsPeopleTools.trc.
Note that PeopleTools 8.50 is running on this machine.
Solution:
Set the PS_SERVDIR environment variable to point to the process scheduler location.
Recent Comments