Category Archives: ERP - Page 9

Running AutoConfig on the Application Tier

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>

Running AutoConfig on the Database Tier

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>

oracle.forms.net.ConnectionException: Forms session failed during startup: no response from runtime process

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.

Upgrading 11i EBS 9i Database to 10g

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)

  • Advanced installation
  • Choose Enterprise Edition installation type
  • Do not upgrade existing database
  • Install database software only

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)

  • Oracle Database 10g Products 10.2.0.1.0 (not Oracle HTML DB or Oracle Database 10g Companion Products)
  • Choose the 10g Home

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)

  • Oracle Database 10g Products 10.2.0.1.0 (not Oracle HTML DB or Oracle Database 10g Companion Products)
  • Choose the 10g Home

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

You do not have a current session, please log in before visiting this URL

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.

adalnctl.sh: exiting with status 127

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

AutoConfig is exiting with status 4 installing 11.5.9

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

jre was not found in oracle.swd.jre/bin/i386/native_threads/jre

Problem: After installing Oracle 9.2.0.4, netca and dbca fail with error:

jre was not found in:

/u01/app/oracle/oracle.swd.jre/bin/i386/native_threads/jre

Solution: Change directory to:

/u01/app/oracle/oracle.swd.jre/bin/i386/native_threads

Then create symbolic link to jre:

ln -s java jre

netca can now be launched.

Insufficient privileges to write to the specified path in component Database Configuration Assistant 9.2.0.1

Problem: While installing Oracle 9.2.0.4 for Linux, the following error appears in RunInstaller:

Error: You do not have sufficient privileges to write to the specified path. In component Database Configuration Assistant 9.2.0.1.0. Installation cannot continue for this component.

Solution: Export ORACLE_BASE:

export ORACLE_BASE=/u01/app/oracle

Exporting ORACLE_BASE resolved the issue.

Subject: Linux 9.2.0.4 Installation – Error: You do not have sufficient privileges to write to the specified path in Database Configuration Assistant Component (Doc ID: 267171.1)

GLIBC_2.0 not defined in file libc.so.6

Problem: While installing Oracle 9.2.0.4 on Oracle Enterprise Linux 4 Update 4, the following error appears:

Error occurred during initialization of VM

Unable to load native library: /tmp/OraInstall2009-08-31_01-27-21PM/jre/lib/i386/libjava.so:

symbol __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference

Solution: Apply patch 3006854.

Metalink Reference:

Subject: RUNINSTALLER FAILS ON RED HAT 3 TRYING TO INSTALL ORACLE9I

Doc ID: 264178.1