Problem: After laying down R12 file system, unable to relink applications while applying patches.
Solution: Set environment variable MSVCPP to location of Visual C++ 2008:
set MSVCPP=D:/MSVS2008/VC
Note that forward slashes (‘/’) should be used in the path for this environment variable.
Problem: After laying down R12 filesystem and starting up the database, the following error occurs:
SQL> startup ORACLE instance started. Total System Global Area 1071333376 bytes Fixed Size 1352100 bytes Variable Size 427822684 bytes Database Buffers 629145600 bytes Redo Buffers 13012992 bytes ORA-00205: error in identifying control file, check alert log for more info SQL> startup pfile=D:\ORACLE\MFGP\mfgpdb\11.2.0\database\initMFGP.ora ORA-00401: the value for parameter compatible is not supported by this release
Solution: Oracle Database 11.1.0 comes bundled with R12 and the Oracle Service was created using the 11.1.0 Oracle Home. However, the database was upgraded to 11.2.0. Delete the Oracle service (OracleServiceMFGP) using oradim, and recreate using the oradim in the 11.2.0 Oracle home.
Problem: While running patch 9491976 during R12 upgrade, the following error occurs:
AutoPatch error: adprdf(): At line 3 in file G:\patches\9491976\u9491976.drv: This patch cannot be applied to your current release. Patch's intended release is "12.0.0" Your current release is "11.5.10.2"
Solution: Apply patch 9491976 with option ‘preinstall=y’.
Problem: When running “Recreate grants and synonyms”, the following error occurs:
ERROR Enter the password for your 'SYSTEM' ORACLE schema: Connecting to SYSTEM......Unable to connect. AD Administration error: The following ORACLE error: ORA-01017: invalid username/password; logon denied
Solution: If you are able to connect to the database as the SYSTEM user, then set sec_case_sensitive_logon initialization parameter to false.
Problem: When running AutoConfig on the database tier, the following error occurs:
Starting context file generation for db tier.. Using JVM from D:\ORACLE\MFGP\mfgpdb\11.2.0\jdk\bin\java to execute java programs.. AC-20001: Error: LOCAL not defined in the Environment. This value must be set to complete Context file generation.
Solution: Set the LOCAL environment variable to the Oracle SID e.g. SET LOCAL=PROD. Then rerun AutoConfig.
Problem: While running patch 6241631, the following error occurs:
FAILED: file icxwtab.odf on worker 1.
Attempted to run ICXDLTMP.SQL, but it gave an error:
SELECT TRANSACTION_ID, count(*) FROM ICX.ICX_TRANSACTIONS GROUP BY TRANSACTION_ID HAVING count(*)>1; TRANSACTION_ID COUNT(*) -------------- ---------- 2119244000 2 select rowid, creation_date, transaction_id, session_id from icx_transactions where transaction_id='2119244000'; delete from icx_transactions where rowid = 'AAA74DAAjAAAe7dAAq';
Solution: There is a duplicate transaction_id in the icx.icx_transactions.
SELECT TRANSACTION_ID, count(*) FROM ICX.ICX_TRANSACTIONS GROUP BY TRANSACTION_ID HAVING count(*)>1; TRANSACTION_ID COUNT(*) -------------- ---------- 2119244000 2 select rowid, creation_date, transaction_id, session_id from icx_transactions where transaction_id='2119244000'; delete from icx_transactions where rowid = 'AAA74DAAjAAAe7dAAq';
Problem: When applying patch 6241631 on E-Business Suite 11i, the relink of OAMKSVC.exe fails.
Solution: Install Microsoft XML Parser SDK (xmlsdk.msi). Then copy C:\Program Files\Microsoft XML Parser SDK\lib\msxml2.lib to C:\VC98\Lib.
Reference: Relink of Module OAMKSVC.exe failed (Doc ID 330231)
Problem: When running catpatch.sql as part of Oracle Database 9.2.0.8 upgrade, the following errors occur:
ORA-29832: cannot drop or replace an indextype with dependent indexes ORA-29844: duplicate operator name specified
Solution: These errors can be ignored.
Reference: Ora-29832 And Ora-29844 Errors Running Catpatch.sql [ID 781203.1]
Problem: I built a new Windows 2003 environment and restored a backup of E-Business Suite 11i. However, instead of going through the post-clone process, I attempted to change the hostname using the MOS document “How to change hostname for E-Business Suite Release 12 on single node” (Doc ID 1277556.1). However, when running AutoConfig on the apps tier, the following error occurred:
D:\ORACLE\MFGP\mfgpappl\admin>ECHO OFF Cannot find HOME_COUNTER under SOFTWARE\ORACLE\ALL_HOMES. Error when running adgenhomenum.exe d:\oracle\MFGP\mfgpora\8.0.6 ERROR: Running d:\oracle\MFGP\mfgpappl\ad\11.5.0\bin\adgethnum.cmd failed D:\ORACLE\MFGP\mfgpappl\admin>ECHO OFF
Solution:
Create HOME_COUNTER string key in registry under SOFTWARE\ORACLE\ALL_HOMES and set to 1.
Error Encountered
When AutoConfig was rerun, it completed with errors.
Solution:
Run the AutoConfig/adconfig.cmd command twice on apps tier! (Verified!)
Problem:
When running OUI, it states that patches IZ41855, IZ51456, and IZ52319 are missing.
# instfix -i -k IZ41855 There was no data for IZ41855 in the fix database. # instfix -i -k IZ51456 There was no data for IZ51456 in the fix database. # instfix -i -k IZ52319 There was no data for IZ52319 in the fix database. # oslevel -s 6100-08-01-1245 #
Solution:
These patches can be ignored because AIX 6.1 is patched to the latest level.
Recent Comments