Concurrent Manager Log: %APPLCSF%%APPLLOG%
G:oracleVIS12instappsVIS12_appswindows3logsapplconclog
%APPLCSF%%APPLLOG%
%APPLCSF%%APPLOUT%
Application TNS Listener executable:
G:oracleVIS12appstech_st10.1.2BINTNSLSNR
Application TNS Listener config file:
G:oracleVIS12instappsVIS12_appswindows3ora10.1.2networkadminlistener.ora
Location of dbc file (VIS12.dbc):
G:oracleVIS12instappsVIS12_appswindows3applfnd12.0.0secure
Apache Root:
G:oracleVIS12appstech_st10.1.2ApacheApache
Step 1: Stop all Oracle processes and the Distributed Transaction Coordinator service.
Step 2: Run regedit and delete the following entries:
HKEY_LOCAL_MACHINESOFTWAREORACLE HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesOracle* HKEY_LOCAL_MACHINESYSTEMControlSet001ServicesOracle* HKEY_LOCAL_MACHINESYSTEMControlSet003ServicesOracle*
Exit regedit, and then reboot.
Step 3:Delete the Oracle directory (x:oracleVIS12) and C:Program Filesoracle.
Empty the recycle bin, and then reboot the computer once more.
Step 4:Clean up the Program Menu for Oracle entries
Step 5:Run Rapid Wizard to restart the R12 installation.
Metalink Reference:
Doc ID: 567507.1 (How to Remove an Oracle E-Business Suite Release 12.x Windows Environment)
Microsoft Windows [Version 5.2.3790] (C) Copyright 1985-2003 Microsoft Corp. C:Documents and SettingsAdministrator>g: G:>cd oracleVIS12appsapps_stappl G:oracleVIS12appsapps_stappl>appsinf.cmd ECHO is off. ECHO is off. Tue 11/03/2009 12:35 PM appsinf.cmd exiting with status 0 ERRORCODE = 0 ERRORCODE_END G:oracleVIS12appsapps_stappl>APPSVIS12_appswindows3.cmd ECHO is off. ECHO is off. Tue 11/03/2009 12:35 PM ECHO is off. ECHO is off. Setting environment for using Microsoft Visual Studio 2005 x86 tools. APPSORA.cmd exiting with status 0 G:oracleVIS12appsapps_stappl>cd .. G:oracleVIS12apps>cd oracleVIS12instappsVIS12_appswindows3adminscripts G:oracleVIS12instappsVIS12_appswindows3adminscripts>dir Volume in drive G is ORAAPPSR12 Volume Serial Number is 381E-5906 Directory of G:oracleVIS12instappsVIS12_appswindows3adminscripts 10/30/2009 05:06 PM <DIR> . 10/30/2009 05:06 PM <DIR> .. 10/30/2009 05:06 PM 4,504 adalnctl.cmd 10/30/2009 05:06 PM 4,759 adapcctl.cmd 10/30/2009 05:06 PM 2,704 adautocfg.cmd 10/30/2009 05:06 PM 4,831 adcmctl.cmd 10/30/2009 05:06 PM 7,086 adexecsql.pl 10/30/2009 05:06 PM 4,901 adformsctl.cmd 10/30/2009 05:06 PM 4,767 adoacorectl.cmd 10/30/2009 05:06 PM 4,758 adoafmctl.cmd 10/30/2009 05:06 PM 4,467 adopmnctl.cmd 10/30/2009 05:06 PM 15,084 adpreclone.pl 10/30/2009 05:06 PM 5,399 adstpall.cmd 10/30/2009 05:06 PM 5,520 adstrtal.cmd 10/30/2009 05:06 PM 1,695 gsmstart.cmd 10/30/2009 02:20 PM <DIR> ieo 10/30/2009 05:06 PM 1,656 java.cmd 10/30/2009 05:07 PM 1,426 jtffmctl.cmd 10/30/2009 05:07 PM 6,535 mwactl.cmd 10/30/2009 05:07 PM 2,415 mwactlwrpr.cmd 17 File(s) 82,507 bytes 3 Dir(s) 1,052,397,568 bytes free G:oracleVIS12instappsVIS12_appswindows3adminscripts>adautocfg.cmd . Starting up AutoConfig engine... . Tue 11/03/2009 12:41 PM Enter the APPS user password:apps The log file for this session is located at: G:oracleVIS12instappsVIS12_app swindows3adminlog11031241adconfig.log AutoConfig is configuring the Applications environment... AutoConfig will consider the custom templates if present. Using CONFIG_HOME location : G:oracleVIS12instappsVIS12_appswin dows3 Classpath : G:oracleVIS12appsapps_stcomnjavalib appsborg2.zip;G:oracleVIS12appsapps_stcomnjavaclasses Using Context file : G:oracleVIS12instappsVIS12_appswindow s3appladminVIS12_appswindows3.xml Context Value Management will now update the Context file Updating Context file...COMPLETED Attempting upload of Context file and templates to database...COMPLETED Context Value Management Complete. Check Logs for details ECHO is off. ECHO is off. Tue 11/03/2009 12:41 PM 1 file(s) copied. Script Success, Applications Context update complete. Configuring templates from all of the product tops... Configuring AD_TOP........COMPLETED Configuring FND_TOP.......COMPLETED Configuring ICX_TOP.......COMPLETED Configuring IEO_TOP.......COMPLETED Configuring BIS_TOP.......COMPLETED Configuring AMS_TOP.......COMPLETED Configuring CCT_TOP.......COMPLETED Configuring WSH_TOP.......COMPLETED Configuring CLN_TOP.......COMPLETED Configuring OKE_TOP.......COMPLETED Configuring OKL_TOP.......COMPLETED Configuring OKS_TOP.......COMPLETED Configuring CSF_TOP.......COMPLETED Configuring IGS_TOP.......COMPLETED Configuring IBY_TOP.......COMPLETED Configuring JTF_TOP.......COMPLETED Configuring MWA_TOP.......COMPLETED Configuring CN_TOP........COMPLETED Configuring CSI_TOP.......COMPLETED Configuring WIP_TOP.......COMPLETED Configuring CSE_TOP.......COMPLETED Configuring EAM_TOP.......COMPLETED Configuring FTE_TOP.......COMPLETED Configuring ONT_TOP.......COMPLETED Configuring AR_TOP........COMPLETED Configuring AHL_TOP.......COMPLETED Configuring OZF_TOP.......COMPLETED Configuring IES_TOP.......COMPLETED Configuring CSD_TOP.......COMPLETED Configuring IGC_TOP.......COMPLETED AutoConfig completed with errors. Completed execution of AutoConfig G:oracleVIS12instappsVIS12_appswindows3adminscripts>
Microsoft Windows [Version 5.2.3790] (C) Copyright 1985-2003 Microsoft Corp. C:Documents and SettingsAdministrator>g: G:>cd oracleVIS12dbtech_st10.2.0 G:oracleVIS12dbtech_st10.2.0>VIS12_appswindows3.cmd ECHO is off. ECHO is off. Tue 11/03/2009 12:32 PM VIS12_appswindows3.cmd exiting with status 0 G:oracleVIS12dbtech_st10.2.0>cd appsutilscriptsVIS12_appswindows3 G:oracleVIS12dbtech_st10.2.0appsutilscriptsVIS12_appswindows3> dir Volume in drive G is ORAAPPSR12 Volume Serial Number is 381E-5906 Directory of G:oracleVIS12dbtech_st10.2.0appsutilscriptsVIS12_appswindows3 10/30/2009 03:08 PM <DIR> . 10/30/2009 03:08 PM <DIR> .. 10/30/2009 03:08 PM 2,690 adautocfg.cmd 10/30/2009 03:08 PM 5,262 adchknls.pl 10/30/2009 03:08 PM 3,420 addbctl.cmd 10/30/2009 03:08 PM 3,932 addlnctl.cmd 10/30/2009 03:08 PM 7,089 adexecsql.pl 10/30/2009 03:08 PM 3,441 adlsnodes.cmd 10/30/2009 03:08 PM 14,953 adpreclone.pl 10/30/2009 03:08 PM 837 adstopdb.sql 10/30/2009 03:08 PM 1,251 adstrtdb.sql 9 File(s) 42,875 bytes 2 Dir(s) 1,052,569,600 bytes free G:oracleVIS12dbtech_st10.2.0appsutilscriptsVIS12_appswindows3> adautocfg.cmd . Starting up AutoConfig engine... . Tue 11/03/2009 12:34 PM Enter the APPS user password:apps The log file for this session is located at: G:oracleVIS12dbtech_st10.2.0a ppsutillogVIS12_appswindows311031234adconfig.log AutoConfig is configuring the Database environment... AutoConfig will consider the custom templates if present. Using ORACLE_HOME location : G:oracleVIS12dbtech_st10.2.0 Classpath : ;G:oracleVIS12dbtech_st10.2.0jdbclibojdbc14.jar;G:oracleVIS12dbtech_st10.2.0appsutiljavaxmlparserv2.jar;G:oracleVIS12dbtech_st10.2.0appsutiljava;G:oracleVIS12dbtech_st10.2.0jlibnetcfg.jar;G:oracleVIS12dbtech_st10.2.0jlibldapjclnt10.jar Using Context file : G:oracleVIS12dbtech_st10.2.0appsutilVIS12_appswindows3.xml Context Value Management will now update the Context file Updating Context file...COMPLETED Attempting upload of Context file and templates to database...COMPLETED Context Value Management Complete. Check Logs for details Updating rdbms version in Context file to db102 Updating rdbms type in Context file to 32 bits Configuring templates from ORACLE_HOME ... AutoConfig completed successfully. Completed execution of AutoConfig G:oracleVIS12dbtech_st10.2.0appsutilscriptsVIS12_appswindows3>
Problem: oracle.forms.net.ConnectionException: Forms session <1> failed during startup: no response from runtime process
Solution: Applications were not linked properly during install. Manually relink applications using adadmin.
Problem: When configuring Workflow Mailer, and no password is entered for the Inbound Mailer Server (IMAP), the instance pauses for a few seconds, then returns:
Unable to make a network connection
Solution:
If a valid mail server is entered into the Inbound Server Name under Inbound Email Account, but invalid username and password is entered, the following message appears:
Unable to connect to the mail account. Check the host, user name and password.
If a valid mail server is entered into the Inbound Server Name under Inbound Email Account, and a valid username and password is entered, the following message appears:
Validation
Need to put a valid username and password into the Inbound Server Name.
Ensure that the Test Email Address and Reply-To email addresses are different.
This document shows how to upgrade the 9i database in 11i E-Business Suite to 10g on Linux.
Metalink Reference:
Doc ID: 362203.1 (Subject: Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0))
Section 1: Upgrading an 11i Database to Oracle Database 10g Release 2 (10.2.0)
Ignore steps 1 – 5 in the Metalink document.
Begin at Step 6.
Step 6: Prepare to create the 10.2.0 Oracle home
Download Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86
10201_database_linux32.zip (668,734,007 bytes) (cksum – 2737423041)
http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201linuxsoft.html
http://www.oracle.com/technology/documentation/database10gr2.html
http://www.oracle.com/technology/support/metalink/index.html
Step 7: Install the base 10.2.0 software
Install Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86
Refer to chapter 3, Oracle Database Installation Guide 10g Release 2 (10.2)
Unzip 10201_database_linux32.zip
Create directory: /u01/oracle/visdb/10.2.0
Ensure OS meets requirements for 10g
Set ORACLE_HOME=/u01/oracle/visdb/10.2.0
Set ORACLE_SID=VIS
Begin installation (./runInstaller)
Note: You may need to increase the swap file to 4GB before installing 10g.
Step 8: Install Oracle Database 10g Products from the 10g Companion CD
Refer to section 3.5, “Installing Oracle Database 10g Products” in the Oracle Database Companion CD Installation Guide
Unzip 10201_companion_linux32.zip
Ensure OS meets requirements for 10g (should be in place)
Set ORACLE_HOME=/u01/oracle/visdb/10.2.0
Set ORACLE_SID=VIS
Begin installation (./runInstaller)
Step 9: Perform 10.2.0.4 patch set pre-installation tasks
Oracle® Database Patch Set Notes
10g Release 2 (10.2.0.4) Patch Set 3 for Linux x86
Metalink Doc ID: 316900.1
Download patch 6810189 (p6810189_10204_Linux-x86.zip)
Unzip p6810189_10204_Linux-x86.zip
Ensure OS meets requirements for 10g (should be in place)
Set ORACLE_HOME=/u01/oracle/visdb/10.2.0
Set ORACLE_SID=VIS
Stop all processes (dbconsole, iSQL*Plus, database listener)
Backup Oracle Inventory, Oracle database, Oracle Home
Begin installation (./runInstaller)
Perform 10.2.0.4 patch set pre-installation tasks
On the database server node, as the owner of the Oracle 10g file system and database instance, unzip and extract the 10.2.0.4 patch set file for your platform. Read the patch set notes (usually README.html). Make sure you thoroughly understand the upgrade and patch set installation process before you begin. Check OracleMetaLink or contact Oracle Support Services to determine any known issues with the patch set and its interoperability with Oracle E-Business Suite.
Perform the tasks in the “Preinstallation Tasks” section of the patch set notes (if they apply to your system).
Step 10: Perform 10.2.0.4 patch set installation tasks
On the database server node, as the owner of the Oracle RDBMS file system and database instance, perform the tasks in the “Installing the Oracle Database 10g Patch Set Interactively” section of the patch set notes. Make sure that:
The ORACLE_HOME environment variable points to the new 10.2.0 Oracle home.
The PATH environment variable includes $ORACLE_HOME/bin and the directory where the new perl executable is located (usually $ORACLE_HOME/perl/bin).
The LD_LIBRARY_PATH environment variable includes $ORACLE_HOME/lib.
The PERL5LIB environment variable points to the directories where the new perl libraries are located (usually $ORACLE_HOME/perl/lib/<perl version> and $ORACLE_HOME/perl/lib/site_perl/<perl version>)
You use the runInstaller (UNIX/Linux) or the setup.exe executable (Windows) provided in the patch set to run OUI.
Step 11: Create nls/data/9idata directory
Run: perl $ORACLE_HOME/nls/data/old/cr9idata.pl script
Modify set10g.env:
export ORA_NLS10= ORACLE_HOME/nls/data/9idata
Step 12: Apply additional 10.2.0.4 RDBMS patches
Download from Metalink and apply:
6880880 or the latest OPatch version.
6521934
6600051
7496636
7497678
cd $ORACLE_HOME
unzip /u01/patches/p6880880_102000_LINUX.zip
Problem: After installing 11.5.9 Vision instance, the E-Business Suite logon appears, and the user is able to log on as SYSADMIN/SYSADMIN. However, after logging on, the following message appears:
You do not have a current session, please log in before visiting this URL
When trying to troubleshoot the issue with aoljtest.jsp, the user is able to login, but when trying to access all the tests, the following message appears:
"This page can only be accessed through aoljtest.jsp"
Solution:
The domain name of the machine had only one component (localdomain). This was changed to cia.org.tt (at least two components) and the instance wiped and reinstalled.
Problem: After installing 11.5.9 Vision instance, the apps listener exits with status 127.
Solution: Apply operating system patch 3830807
Metalink Reference:
Subject: Attempt To Start Listener Exits With Status 127
Doc ID: 299810.1
Problem:
[AutoConfig Error Report] The following report lists errors AutoConfig encountered during each phase of its execution. Errors are grouped by directory and phase. The report format is: <filename> <phase> <return code where appropriate> [INSTANTIATE PHASE] AutoConfig could not successfully instantiate the following files: Directory: /u0/oracle/TEST3/test3db/9.2.0/md/demo/orascv/doc OraSCV.asc INSTE8 Directory: /u0/oracle/TEST3/test3db/9.2.0/oem_webstage/readme emreadme.txt INSTE8 Directory: /u0/oracle/TEST3/test3db/9.2.0/relnotes/em README_EM.txt INSTE8 Directory: /u0/oracle/TEST3/test3db/9.2.0/sysman/doc/readme README_em.txt INSTE8 AutoConfig is exiting with status 4
Solution: Unset the LANG environment variable.
Metalink Reference:
Subject: Sun.io.MalformedInputException For OraSCV.asc,emreadme.txt, README_EM.txt And README_em.txt While 11.5.9 Install
Doc ID: 262125.1
Recent Comments