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: 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: 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: 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 connect to an 11i E-Business Suite database using SQL Developer, the following error appears:
An error was encountered performing the requested operation: IO Error: Connection reset Vendor code 17002
Sometimes, the error reads:
An error was encountered performing the requested operation: IO Error: Got minus one from a read call Vendor code 17002
Issuing the tnsping command against the instance returns the following:
C:>tnsping vis3 TNS Ping Utility for 32-bit Windows: Version 9.0.1.4.1 - Production on 02-MAY-2012 10:21:29 Copyright (c) 1997 Oracle Corporation. All rights reserved. Used parameter files: C:OracleDevSuiteHomenetworkadminsqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=oel5vis3.localdomain) (PORT=1524)) (CONNECT_DATA= (SID=VIS3))) TNS-12537: TNS:connection closed
Pinging the instance on the database node completed successfully.
The problem started occurring after applying ATG RUP7.
Solution:
AutConfig was run as part of applying ATG RUP 7 patches. This regenerated the sqlnet.ora, which included the following two lines:
tcp.validnode_checking = yes tcp.invited_nodes=(OEL5VIS3.localdomain)
This blocked all SQL connections to the server. Since this instance is a test environment, the above lines in sqlnet.ora were commented off and the listener bounced.
[amazon asin=1847196268&template=iframe image&chan=default] [amazon asin=0071484744&template=iframe image&chan=default] [amazon asin=0137142838&template=iframe image&chan=default]
Problem:
While attempting to remove a file on Linux, the message ‘rm: cannot lstat file: Input/output error’ appears:
[applmgr@oel5vis3 applmgr]$ cd /u01/VIS3/oracle/vis3db/9.2.0/oem_webstage/oracle/sysman/vbo/vbos [applmgr@oel5vis3 vbos]$ ls -ltr total 16 ?--------- ? ? ? ? ? VbosLobStorage.class ?--------- ? ? ? ? ? VbosLobSQLList.class ?--------- ? ? ? ? ? VbosLobOperations.class -rw-r--r-- 1 applmgr dba 0 Apr 26 2002 VbosDimensionOperations.class -rw-r--r-- 1 applmgr dba 0 Apr 26 2002 VbosArrayTypeOperations.class -rw-r--r-- 1 applmgr dba 0 Apr 26 2002 VbosClusterOperations.class -rw-r--r-- 1 applmgr dba 0 Apr 26 2002 VbosDBLinkOperations.class -rw-r--r-- 1 applmgr dba 0 Apr 26 2002 VbosIndexOperations.class -rw-r--r-- 1 applmgr dba 0 Apr 26 2002 VbosJavaObjectHelper.class -rw-r--r-- 1 applmgr dba 0 Apr 26 2002 VbosJavaObjectOperations.class -rw-r--r-- 1 applmgr dba 0 Apr 26 2002 VbosJavaSourceOperations.class -rw-r--r-- 1 applmgr dba 0 Apr 26 2002 VbosJavaClassOperations.class -rw-r--r-- 1 applmgr dba 0 Apr 26 2002 VbosLob.class . . . [applmgr@oel5vis3 vbos]$ rm VbosLobOperations.class rm: cannot remove `VbosLobOperations.class': Input/output error [applmgr@oel5vis3 vbos]$ rm -f VbosLobOperations.class rm: cannot remove `VbosLobOperations.class': Input/output error [applmgr@oel5vis3 vbos]$ touch VbosLobOperations.class touch: cannot touch `VbosLobOperations.class': Input/output error
Solution:
Unmount partition with bad file and run fsck on partition (may need to exit Terminal window and open new Terminal window).
Problem:
While installing a Vision instance of 11.5.10.2, the following errors appears:
RW-20003: Error: Unzip failed: unknown reason. Check log file for details.
General solution:
Verify file owner and group settings for EBS staging area.
Redownload, restage installation media from DVD or E-Delivery.
Verify MD5 checksums for files downloaded from E-Delivery.
Solution (in this case):
/u00/Stage11i/oraApps/Disk4/appl/stage/fnd_WEB3.zip corrupt. Restage.
Problem:
While following online instructions for installing E-Business Suite, it is advised to add the following code to /etc/profile:
if [ $USER = "oracle" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi fi
However, when a user logs on, the following message appears:
-bash: ulimit: open files: cannot modify limit: Operation not permitted
Solution:
Set the limits in /etc/security/limits.conf, not /etc/profile. Follow E-Business Suite installation documentation on My Oracle Support, not online!
Recent Comments