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: 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:
After sharing folders on Windows 2003, unable to access them from Windows XP. XP does not prompt for the Windows 2003 login. The following message appears:
\APPSWINDOWS11gR2 is not accessible. You might not have permission to use this network resource. Contact the administrator of this server to find out if you have access permissions. Access denied
Solution:
Manually map network drives to the Windows 2003 shared folders from XP machine using the NET USE command, adding the /USER switch to include the user name.
Problem:
After applying latest OS updates (October 9, 2012) on Windows XP SP3, Internet Explorer 7 (IE7) can no longer connect to Oracle Enterprise Manager (11g) via SSL (https). Firefox is able to connect to OEM.
Solution:
Update for Windows XP (KB2661254-V2) affecting certificates. Quick fix: from Add/Remove Programs, check ‘Show updates’, remove Update for Windows XP (KB2661254-V2) and reboot.
Note that removing Windows updates may affect your computer’s security. Proceed at your own risk.
*** UPDATE: Oracle has fixed the issue in MOS ID: 1489557.1 (EM Grid Control 11g Console Not Accessible Via Internet Explorer After Applying Microsoft Security Patches On Client PC)
Reference:
Microsoft Security Advisory (2661254): Update For Minimum Certificate Key Length
http://technet.microsoft.com/en-us/security/advisory/2661254
Microsoft Security Advisory (2749655): Compatibility Issues Affecting Signed Microsoft Binaries
http://technet.microsoft.com/en-us/security/advisory/2749655
Read more »
Problem:
When trying to convert the char column (attribute9) to date using the to_date function in SQL Developer, the following error is displayed:
ORA-01843: not a valid month 01843. 00000 - "not a valid month" *Cause: *Action:
Solution:
Dates were stored in two different formats (mm/dd/yyyy) and (dd-mon-yyyy) in the attribute9 column. Convert all dates to one format (dd-mon-yyyy).
‘ap7001are.us.oracle.com’ Target Host in R12 Database Control
Problem:
After enabling and launching Database Control on an R12.1 instance, the instance ‘ap7001are.us.oracle.com’ is seen as a target host and ‘PROD_ap7001are.us.oracle.com’ as the listener.
Solution:
Drop and recreate the Enterprise Manager repository on the R12 instance.
Problem:
While configuring Enterprise Manager Database Control for an R12.1 instance on Windows 2008, the following error is encountered:
tzOffset for America/Caracas is -270(min), but agent is runnning with tzOffset -240(min)
Solution:
Change time zone in emd.properties and operating system.
Problem:
After creating an spfile on an 11g instance (11.1.0.7) on R12.1.3 on Windows 2008, it does not automatically appear when the ‘show parameter spfile’ command is issued in SQL*Plus.
Solution:
When the database is started via the Windows Services panel, it seems that the pfile is used by default, even though the spfile may have been created. Stop and start the database via SQL*Plus to see the spfile.
Recent Comments