11I INSTALLATION(11.5.10.2 on Redhat Linux AS 4.0 (Multi Node ))
Installation Instructions for Oracle Application Server 11.5.10.2 on Redhat Linux AS 4.0 (Multi Node )
Environment Name: REDHAT AS4 Machine:
Configuration of machines and OS
Configuration of Machines :-
2 GB RAM
150 GB HDD
Pantium IV 3 GHZ
DVD Rom
Operation Systems :-
Machine 1 :- apps01
Windows 2000 professional (50 GB, Primary Partition FAT32 *)
REDHAT Linx AS 4 (100 GB)
Machine 2 :- apps02
REDHAT Linx AS 4 (150 GB)
Installation of OS
Machine 1 :- apps01
Windows 2000 professional
- Install windows 2000 professional and create primary partition FAT32 so that you can mount on linux.
- Apply service pack 4.0
Redhat Linux AS 4.0
- Create Mount points as follows
Mount File system Size
/ Ext3 1GB
/boot Ext3 122MB
/ebis Ext3 79GB
/home Ext3 1GB
/opt Ext3 1GB
/var Ext3 1GB
/tmp Ext3 2G
/swap Ext3 4GB
/usr Ext3 10GB
- Select everything in custom selection of packages.
Machine 2 :- apps02
- Create Mount points as follows
Mount File system Size
/ Ext3 5GB
/boot Ext3 122MB
/ebis Ext3 114GB
/home Ext3 6GB
/opt Ext3 1GB
/var Ext3 2GB
/tmp Ext3 4G
/swap Ext3 4GB
/usr Ext3 10GB
- Select everything in custom selection of packages during linux installations
Prerequisite
Staging on Windows 2000 professional – Machine 01
1. Prerequisite
- Install and configure IIS 5.0 or above. It is prerequisite to run perl
- Download perl 5.8.8.8.7 from www.perl.com and install it. This is prerequisite for staging.
- Check the following DVD’s
? Oracle Application 11i Start Here Disk 1
? Oracle Application Rapid Install RDBMS Disk1
? Oracle Application Rapid Install Database Disk1 to Disk4
? Oracle Application Rapid Install Tools Disk1
? Oracle Application Rapid Install Appl_Top Disk 1 & Disk2
2. Insert Oracle Application 11i Start Here Disk 1 in DVD ROM drive
3. execute perl < DVDdrive>\mnt\cdrom\disk1\rapidwiz\adautostg.pl
4. Setup the stage Area Direcoty
At the prompt for the stage directory, enter the name of the system top-level
directory. The Rapid wizard stage11i directory will be created in this path.
5. When the script prompts select 1 (Oracle Applications) .
6. Insert the correct DVD’s as prompted by script
7. Staging will take approximately 25GB
Staging on Redhat Linux 4.0 AS– Machine 02
1. Check the following DVD’s
• Oracle Application 11i Start Here Disk 1
• Oracle Application Rapid Install RDBMS Disk1
• Oracle Application Rapid Install Database Disk1 to Disk4
• Oracle Application Rapid Install Tools Disk1
• Oracle Application Rapid Install Appl_Top Disk 1 & Disk2
2. Log in as Root and Check the current version of the perl installed
perl –v
it should be 5.8.5 or later
3. Mount the dvd rom
mount /dev/dvd /mnt/dvdrom
4. execute perl < DVDdrive>/dev/dvd/mnt/cdrom/disk1/rapidwiz/adautostg.pl
Setup the stage area At the prompt for the stage directory, enter the name of the system top-level directory. The Rapid wizard stage11i directory will be created in this path.
5. When the scripts prompts select 1 (Oracle Applications)
6. Insert the CD’s as prompted by the script
(Note : even Automount enabled DVD has to be unmounted from and remounted
umount /mnt/dvdrom
umount /dev/dvd
mount /dev/dvd /mnt/dvdrom and press enter
Pre-Installation Steps
Preparing the Operating systems for Oracle 11.5.10.2
Check the following packages
Required RPMS Installed RPMS
• compat-db-4.1.25-9
• compat-gcc-32-3.2.3-47.3
• compat-gcc-32-c++-3.2.3-47.3
• compat-oracle-rhel4-1.0-5
• compat-libcwait-2.0-2
• compat-libgcc-296-2.96-132.7.2
• compat-libstdc++-296-2.96-132.7.2
• compat-libstdc++-33-3.2.3-47.3
• xorg-x11-deprecated-libs-devel-6.8.1-23.EL
• xorg-x11-deprecated-libs-6.8.1-23.EL
• openmotif21-2.1.30-11.RHEL4.4
• libaio-0.3.102-1
• libaio-devel-0.3.102-1 • compat-db-4.1.25-9
• compat-gcc-32-3.2.3-47.3
• compat-gcc-32-c++-3.2.3-47.3
• compat-oracle-rhel4-1.0-5
• compat-libcwait-2.0-2
• compat-libgcc-296-2.96-132.7.2
• compat-libstdc++-296-2.96-132.7.2
• compat-libstdc++-33-3.2.3-47.3
• xorg-x11-deprecated-libs-devel-6.8.1-23.EL
• xorg-x11-deprecated-libs-6.8.1-23.EL
• openmotif-2.2.3-6.RHEL4.2
• libaio-0.3.102-1
• libaio-devel-0.3.102-1
The libaio components are available on Disk 3 of the RHEL4.0 media. For information on downloading the openmotif component, see the instructions at the following URL:
https://rhn.redhat.com/errata/RHSA-2005-412.html
1.1. After installing these patches, run ldconfig -v.
(Note : ldconfig creates the necessary links and cache to the most recent shared libraries found in the directories specified on the command line, in the file /etc/ld.so.conf, and in the trusted directories (/lib and /usr/lib). The cache is used by the run-time linker, ld.so or ld-linux.so. ldconfig checks the header and file names of the libraries it encounters when determining which versions should have their links updated )
1.2. Verify minimum Kernel Requirements with uname and rpm command,
[root@vision ~]# uname -r
2.6.9-5.ELsmp
[root@vision ~]# rpm -q glibc
glibc-2.3.4-2
1.3. Domain Name System (DNS) Resolver Parameters
Edit the following file /etc/resolv.conf and set the following parameters as below,
options attempts:5
options timeout:15
(Note : The resolv.conf file resides in the /etc directory and contains the IPs of domain name servers that you will probably need if you are going to do anything on the internet.
options :Allows certain internal resolver variables to be modified. The syntax is where option is one of the following
timeout: n (IN SECONDS)
sets the amount of time the resolver will wait for a response from a remote name server before retrying the query via a different name server.
attempts: n
sets the number of times the resolver will send a query to its name servers before giving up and returning an error to the calling application).
1.4. Host names
1.4.1. The format of hosts /etc/hosts file must be formatted as follows :
127.0.0.1 localhost.localdomain
.
(In apps01 hosts file make this entry and there should be entry for the other nodes which hosts the servers)
192.9.200.11 apps01.apps.com local_host
192.9.200.12 apps02.apps.com
(In apps02 the following entries to the /etc/hosts file has to be added )
192.9.200.146 apps02.apps.com local_host
192.9.200.149 apps01.apps.com
Ping the remote machine with and hostname and check
Comment the first line in the /etc/hosts file
1.4.2. Verify that the /etc/sysconfig/network file is formatted as follows :
HOSTNAME=.
Exi : HOSTNAME=apps01.apps.com
( Note : Make sure that your machines has static ip address)
1.5. If the /etc/sysconfig/networking/profiles/default/network file exists, remove it.
Note: If you changed any files in the previous steps, reboot the system.
1.6. Modify number of open descriptors: in file /etc/security/limits.conf add the following lines:
hard nofile 65535
soft nofile 4096
(.You can protect against certain types of denial of service attacks by modifying /etc/security/limits.conf. This file sets limits on system resources for each user.. The above setting limits the maximum number of files open)
1.7. Change port range value : /etc/sysctl.config add the following line,
net.ipv4.ip_local_port_range = 1024 65000
1.8. Set LD_ASSUME_KERNEL in file /etc/profile
LD_ASSUME_KERNEL=2.4.19
export LD_ASSUME_KERNEL
1.9. Apply one of these OS library patches: 4198954 (for Red Hat 4.0), you can download it from metalink.
? The above patch contains compat_libcwait-2.0-2.i386.rpm, compat-oracle-rhel4-1.0.-5.i386.rpm
? After applying the compat-libcwait-2.0-2.i386.rpm move the libcwait.so - library from /usr/lib to /lib and modify the path in /etc/ld.so.preload
2.0 Create a goup and two users one owner of database and other owner of oracle application
groupadd dba
useradd –g dba –G dba oracle
useradd –g dba –G dba applmgr
passwd oracle
passwd applmgr
Installation Steps
Installation of database server
Machine :- apps01
? Go to the following directory in your staging
/ebis/Stage11i/startCD/Disk1/rapidwiz
./rapidwiz
Press next for welcome screen
Select Installation option
Install Oracle Applications E-Business 11i
Load Configuration
No
Install Type
Multinode
Node Information
Database :- apps01
Administration :- apps01
Concurrent Manager :- apps01
Application :- apps02
Web:- apps02
Define Database type
Fresh Database ( PROD)
Database install information( Folder or Mount point)
/ebis
Database install information
Oracle OS User :- oracle
Oracle OS Group :- dba
Base Install Directory :- /ebis
Select Licensing Type
E-business Suite Licensing
Select Language
American English
Character Set
Default
Port Pool
Default
Configuration File path.
/tmp/config.txt
Follow the installation step upto completion of installation.
Application Server Installation.
Machine :- apps02
? Copy the configuration file from apps01.
ssh apps01.oneapps.com cat /tmp/config.txt > /tmp /config.txt
? Go to the following directory in your staging
/ebis/Stage11i/startCD/Disk1/rapidwiz
./rapidwiz
Press next for welcome screen
Select Installation option
Install Oracle Applications E-Business 11i
Load Configuration
Yes
Install Type
Multinode
Node Information
Database :- apps01
Administration :- apps01
Concurrent Manager :- apps01
Application :- apps02
Web:- apps02
Define Database type
Fresh Database ( PROD)
Database install information( Folder or Mount point)
/ebis
Database install information
Oracle OS User :- oracle
Oracle OS Group :- dba
Base Install Directory :- /ebis
Select Licensing Type
E-business Suite Licensing
Select Language
American English
Character Set
Default
Port Pool
Default
Configuration File path.
/tmp/config.txt
Follow the installation step upto completion of installation.
Include a subset of test steps that will confirm that the customization has been installed properly.
Post- Installation Steps
Apply patch 4632932 to all the application tiers, then re-source the applications environment file to refresh the environment variables. This patch is required for setting the values for LD_ASSUME_KERNEL and LD_PRELOAD.
Steps to Apply this patch
1. Connect as user applmgr on Application server
2. download patch 4632932 from metalink
3. Create a directory called patch in /ebis and unzip downloaded patch in this directory
4. Run adadmin utility and put the database into maintenance mode (type adadmin at shell prompt and it will guide you to put the application in maintenance mode .
5. Apply the patch using adpatch utility
6. After applying the patch disable the maintenance mode
7. Repeat the same on the host where the Database server installed
Friday, July 18, 2008
11I INSTALLATION(11.5.10.2 on Redhat Linux AS 4.0 (Multi Node ))
Posted by V.R.Kishore Reddy at 07:50
Tuesday, July 15, 2008
Configure Oracle HTTP Server To Run For Port 80
Configure Oracle HTTP Server To Run For Port 80
1.Stop Oracle HTTP Server using Application Server Control, or with the following opmn command, as the oracle user (not root):
# opmnctl stopall
2.Issue the following command as root: Log in as root.
3. Run the following commands in the middle-tier Oracle home:
# cd ORACLE_HOME/Apache/Apache/bin
# chown root .apachectl
# chmod 6750 .apachectl
(Be sure to now leave the root login)
3. Update the Application Server Control Console with the new port number:
Edit the following file : as the oracle user (not root)
ORACLE_HOME/Apache/Apache/conf/httpd.conf
Take a backup of httpd.config
cp httpd.conf httpd.conf_old_chg80
vi httpd.config
replace 7777 with 80
Save and close the file.
4. Restart the HTTP Server, as the oracle user (not root)
# opmnctl startall
5. Ensure that Oracle HTTP Server starts and uses the desired port 80.
Posted by V.R.Kishore Reddy at 06:57
Replacing Jinitiator with JRE for Oracle Apps 11i
Applies to:
Oracle Applications 11i
Goal:
PLATFORM : Red Hat Linux AS4
DB : 9.2.0.8
APPS : 11.5.10.2
JINITIATOR : 1.3.1.21
UPGRADING TO : JRE 1.6_05
Solution:
Download Interoperability patch 6863618
Download the Java Runtime Environment (JRE) 6 plug-in at, http://java.sun.com/javase/downloads/index.jsp
Downloaded JRE Native plug-in file from jre-6_uX-windows-i586-p.exe and rename to j2se160x.exe
(Where X = the version number. Using jre-6u5 as an example this would be j2se16005.exe)
Move the j2se1600X.exe file to the web application tier and place it in
[COMMON_TOP]/util/jinitiator
Apply Developer 6i Patchset 18 ( 4948577 )
unzip patch to $ORACLE_HOME
cd $ORACLE_HOME/developer6i_patch18
./patch_install.sh 2>&1 | tee patch_install_p18.log
cd $ORACLE_HOME/procbuilder60/lib; make -f ins_procbuilder.mk install
cd $ORACLE_HOME/forms60/lib; make -f ins_forms60w.mk install
cd $ORACLE_HOME/graphics60/lib; make -f ins_graphics60w.mk install
cd $ORACLE_HOME/reports60/lib; make -f ins_reports60w.mk install
cp developer6i_patch18/bin/genshlib $ORACLE_HOME/bin
Additional Patches:
5713544
sh patch.sh
adrelink.sh force=y "fnd f60webmx"
4261542
cd $ORACLE_HOME
unzip p4261542_600_GENERIC.zip
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class
$ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class.PRE_BUG4261542
cp -r $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class
$ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class.PRE_BUG4261542
cd $ORACLE_HOME/4261542/oracle/forms/engine
cp Main.class $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class
cd $ORACLE_HOME/4261542/oracle/forms/handler
cp AlertDialog.class
$ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class
Generate Product JAR Files ( adadmin )
5216496
sh patch.sh
5753922
sh patch.sh
adrelink.sh force=y "fnd f60webmx"
6195758
cd $ORACLE_HOME
unzip p6195758_600_GENERIC.zip
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class
$ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class.PRE_BUG6195758
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/ComponentItem.class
$ORACLE_HOME/forms60/java/oracle/forms/handler/ComponentItem.class.PRE_BUG6195758
cd $ORACLE_HOME/6195758/oracle/forms/handler
cp UICommon.class $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class
cp ComponentItem.class $ORACLE_HOME/forms60/java/oracle/forms/handler/ComponentItem.class
Generate Product JAR Files ( adadmin )
5938515
sh patch.sh
adrelink.sh force=y "fnd f60webmx"
3830807
sh patch.sh
4586086
cd $ORACLE_HOME
unzip
cd $ORACLE_HOME/forms60/lib
mv env_forms60.mk env_forms60.mk.PRE_BUG4586086
cp $ORACLE_HOME/bug4586086/env_forms60.mk $ORACLE_HOME/forms60/lib
cd $ORACLE_HOME/forms60/lib
make -f cus_forms60w.mk libso_install
adrelink.sh force=y "fnd f60webmx"
relink – adadmin
select 'Maintain Applications Files Menu' and then select 'Relink Applications Program'
Enter list of products to link ('all' for all products)[all] : fnd
Generate specific executables for each selected product [No] ? Y
Relink with debug information [No] ? N
Enter executables to relink, or enter 'all' [all] : f60webmx ar60run ar60runb ar60rund *
4888294 (adpatch )
5884875
cd $ORACLE_HOME
unzip p5884875_600_GENERIC.zip
cp -r $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class
$ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class.PRE_BUG5884875
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class
$ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class.PRE_BUG5884875
cd $ORACLE_HOME/5884875/oracle/forms/engine
cp Main.class $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class
cd $ORACLE_HOME/5884875/oracle/forms/handler
cp AlertDialog.class
$ORACLE_HOME/forms60/java/oracle/forms/engine/AlertDialog.class
Run adadmin "Generate JAR Files"
(6863618)
-------------
Apply the Patch Driver using adpatch
Run the txkSetPlugin.sh script from the
txkSetPlugin.sh 16005
Start Oracle Applicatons 11.5.10.2 and start using Java instead of Jinititor for Applets
Posted by V.R.Kishore Reddy at 04:59
Checking Product Versions & Locations in Oracle Applications
One of the things that you come across quite frequently when you work with oracle support is to need to tell them the product versions or the platform versions which run your oracle applications.
The version information which are commonly asked by during a service request.
I am categorizing this post into three sections
1)Oracle Applications Components
2)Oracle Database Components
3)Operating System and Utilities
1)Oracle Applications Components
a)Oracle Applications version:
You may never need this but in case you are looking at a new environment then the simplest way to figure out your application version is by navigating to
Help-> About Oracle Applications from any of the forms sessions.
b)Version of a Oracle Applications Form (fmx) or report:
To find the version of any oracle applications files
strings -a ICQTYED.fmx | grep Header
alternatively you can also use the adident command
c)Version of a Java class File:
To find the version of a java class file
$ strings
d)JDBC version:
In your middle tier, edit the jserv.properties file located in the IAS_ ORACLE_HOME/Apache/Jserv/etc directory
Locate the wrapper.classpath that is pointing to the jdbc zip file
/u01/applsam/samcomn/java/jdbc14.zip
e)How to find the Apache version?
Go to the $iAS/Apache/Apache/bin directory and enter the following command:
$ httpd -version
f)Version Of The OA Framework:
To find out the version of your Oracle appplication Framework
http://[host].[domain]:[portnumber]/OA_HTML/OAInfo.jsp
OA Framework Version Information
OA Framework Version 11.5.10.2CU.
MDS Version 9.0.5.4.81 (build 481)
UIX Version 2.2.18
BC4J Version 9.0.3.13.51
g)Oracle Application Product Version or Patch Set Level:
One of the most common things you will asked by your support engineer is the version or commonly known as the patch set level of your Oracle Applications product, while or after raising your service request. You can query this by logging on to your application database as the apps user.
select patch_level from fnd_product_installations where patch_level like '%AD%';
h)OJSP Version:
Log in to the application server as the applmgr user
cd $OA_HTML
edit the jtflogin.jsp file to add the following line
OJSP Version: <%= application.getAttribute("oracle.jsp.versionNumber") %>
clear your cache and bounce your apache server
source the jtflogin.jsp from your browser
http://hcslnx03.satyam.com:8002/OA_HTML/jtflogin.jsp
OJSP Version: 1.1.3.5.2
i)XML Parser Version:
You can find out the version of your XML Parser using the following query
SQL> select WF_EVENT_XML.XMLVersion() XML_VERSION
2 from sys.dual;
XML_VERSION
--------------------------------------------------------------------------------
Oracle XDK Java 9.0.4.0.0 Production
j)XML Publisher Version:
To check weather XML publisher is installed or not you can query the FND_PRODUCT_INSTALLATIONS table or you can lookup the
reports in Oracle Applications Manager. You can find out the version for your XML publisher from the output of your report or from MetaInfo.class file.
$OA_JAVA/oracle/apps/xdo/common/MetaInfo.class.
k)Workflow Version:
You can find out the version of your workflow using the following query
SQL> select TEXT Version from WF_RESOURCES
2 where TYPE = 'WFTKN' and NAME = 'WF_VERSION';
VERSION
--------------------------------------------------------------------------------
2.6.0
2)Oracle Database Components
a)Oracle RDBMS Version:
You can query the version of your database user the dynamic view V$VERSION
SQL> SELECT * FROM V$VERSION;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
PL/SQL Release 9.2.0.6.0 - Production
CORE 9.2.0.6.0 Production
TNS for Solaris: Version 9.2.0.6.0 - Production
NLSRTL Version 9.2.0.6.0 – Production
b)Version of OPATCH:
$ perl $ORACLE_HOME/OPatch/opatch.pl version
/oracle/product/v9.2.0.6_doeb10s/OPatch/opatch.pl version: 1.0.0.0.51
c)Listener Version:
$ lsnrctl version
LSNRCTL for Solaris: Version 9.2.0.6.0 - Production on 06-JUL-2007 09:34:53
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=samsolx)(PORT=1527))
TNSLSNR for Solaris: Version 9.2.0.6.0 - Production
TNS for Solaris: Version 9.2.0.6.0 - Production
Unix Domain Socket IPC NT Protocol Adaptor for Solaris: Version 9.2.0.6.0 - Production
Oracle Bequeath NT Protocol Adapter for Solaris: Version 9.2.0.6.0 - Production
TCP/IP NT Protocol Adapter for Solaris: Version 9.2.0.6.0 - Production,,
The command completed successfully
3)Operating Systems and Utilities
a)Sun Solaris Version:
To check the version of you Solaris you can use the following file.
$ cat /etc/release
Solaris 8 2/02 Fujitsu_3 s28s_u7fjsv3wos_04 SPARC
Copyright 2002 Sun Microsystems, Inc. All Rights Reserved.
Assembled 08 December 2002
b)RedHat Linux Version:
You can check the version and release of Linux from the following file
view /etc/redhat-release
Red Hat Enterprise Linux AS release 4 (Nahant Update 2)
c)Perl Version:
You can use the perl -v or the perl - version command to find out the version of perl on your environment.
$ perl -version
This is perl, version 5.005_03 built for sun4-solaris
Copyright 1987-1999, Larry Wall
d)Java Version:
To fine the version of Java used
$ java -version
java version "1.4.2_04"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_04-b05)
Java HotSpot(TM) Client VM (build 1.4.2_04-b05, mixed mode)
e)Version of Installed packages on Solaris
To find the version of the packages on Solaris
$ pkginfo -i|grep perl
application MCperl584 PERL 5.8.4 with Modules 64bit with Threads
optional VRTSperl Perl 5.8.6 for VERITAS
f)Version of Installed packages on Linux:
To find the version of the packages on linux
rpm -qa|grep
g)Kernel Version of Unix:
You can find the version of your kernel on UNIX by the following command
uname -a
h)Bit of Operating System:
You can check the bit size of your OS by using the following command
$ isainfo -b
64
Bit of your Oracle Software
To check if your Oracle Binary is 32 bit or 64 bit you can use the file command on any of the oracle executables like
$ file $ORACLE_HOME/bin/oracle
/oracle/product/v9.2.0.6_doeb10s/bin/oracle: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, not stripped
Files where kernel settings and security limits are stored
/etc/sysctl.conf /etc/security/limits.conf
Posted by V.R.Kishore Reddy at 04:42
Apply INDIA LOCALIZATION Patch
India Localization Patch Application Tool ( Discrete and OPM )
Required Patches:
6491231 ( REF : 6059025 - MULTINODE : PATCH TOOL ENHANCED TO HADLE, OA FRAMEWORK AND XMLP )
5498551 ( REF : 5219225 - CUMULATIVE PATCHSET - IN60107 )
6167056 ( ENH : HANDLING SECONDARY AND HIGHER EDUCATION CESS)
Installation(Installing patch tool):
1.Download patch 6059025.
2.mv 6059025.zip $JA_TOP/.
3.unzip 6059025.zip
4 Cd inpatch
5 run command :
perl install.pl appspwd=apps japwd=ja
INDIA LOCALIZATION CUMULATIVE PATCHSET IN60107
Download patch 5498551
Mv 5498551.zip $JA_TOP
Unzip 5498551.zip
Cd 5498551
1.check the pre-requisites:
find the patchset level using: (FND patchset C or above)
select patch_level, application_name from fnd_product_installations fpi, fnd_application_tl fat where patch_level is not null and fpi.application_id = fat.application_id and patch_level like '%FND%' ;
( FND – G )
2.Take a backup of database.
Download patch 5498551 ( REF : 5219225 - CUMULATIVE PATCHSET - IN60107 )
This localization patchset files: 70 MB disk space
Check df –h
Check the datafile has atleast 100M free space
First find related tablespace using
Cd erpp/erppappl/admin/scripts/ERPP1_erpp1/
Sh adstpall apps/apps
Run adadmin
Put in maintenance mode.
Check invalid objects
Sqlplus “/ as sysdba”
Exec UTL_RECOMP.RECOMP_PARALLEL(8);
(note the invalid objects).
select USERNAME,DEFAULT_TABLESPACE,TEMPORARY_TABLESPACE from dba_users where USERNAME='JA';
Tablespace – ja
The datafile for ja tablespace should have 100MB free space.
select TABLESPACE_NAME from dba_indexes where owner='JA';
Tablespace – jx
The datafile for should have 50MB free space.
Rollback segment should have 30MB free space.
Get the undo tablespace name using:
Show parameter undo_tablespace;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_tablespace string APPS_UNDOTS1
Check the free space
SELECT Total.name "Tablespace Name", nvl(Free_space, 0) Free_space, nvl(total_space-Free_space, 0) Used_space, total_space FROM (select tablespace_name, sum(bytes/1024/1024) Free_Space from sys.dba_free_space group by tablespace_name) Free, (select b.name, sum(bytes/1024/1024) TOTAL_SPACE from sys.v_$datafile a, sys.v_$tablespace B where a.ts# = b.ts# group by b.name) Total WHERE Free.Tablespace_name(+) = Total.name ORDER BY Total.name
ALTER DATABASE DATAFILE '/erpp/erppdata/jad01.dbf' RESIZE 100M;
Check if DBMS_SUPPORT package is present in your APPS schema by using the below query in APPS schema :
select object_name, object_type from all_objects where object_name = 'DBMS_SUPPORT' and object_type like 'PACKAGE%' ;
---------------------
DBMS_SUPPORT
PACKAGE
DBMS_SUPPORT
PACKAGE BODY
Run sqlplus apps/apps@ja_chk_stat.sql
Continue if only no issues in prechecks_5498551.log
Check 'JA_IN_INSTALL_CHECK_INFO_D does not exist in apps schema
select owner, table_name from all_tables where table_name = 'JA_IN_INSTALL_CHECK_INFO_D' and owner = 'APPS' ;
object does not exist.
Run….check for errors
select descriptive_flexfield_name, application_column_name, descriptive_flex_context_code from fnd_descr_flex_column_usages where descriptive_flexfield_name in ('AP_INVOICES') ;
Patching:
perl /erpp/erppappl/ja/11.5.0/inpatch/indpatch.pl drvr_file=5498551.drv fnd_patchset=G logfile=first.log test=y appspwd=apps japwd=ja mode=FCD systempwd=manager
perl /erpp/erppappl/ja/11.5.0/inpatch/indpatch.pl drvr_file=5498551.drv fnd_patchset=G logfile=org.log test=n appspwd=apps japwd=ja mode=FCD systempwd=manager
open another session and check log file
cd $JA_TOP/5498551
tail –f org.log
And also check the patching status running
select * from jai_applied_patches where patch_number = '5498551’;
Error:
Cannot copy---------to /erpp/erppappl/ar/11.5.0/JAINBOER.rdf permission denied
Cannot copy---------to /erpp/erppappl/ar/11.5.0/JAINARE1.rdf permission denied
chmod 775 /erpp/erppappl/ar/11.5.0/reports/US
cp /erpp/erppappl/ja/5498551/reports/US/ JAINBOER.rdf /erpp/erppappl/ar/11.5.0/JAINBOER.rdf
cp /erpp/erppappl/ja/5498551/reports/US/ JAINBOER.rdf /erpp/erppappl/ar/11.5.0/JAINARE1.rdf
Rerun
perl /erpp/erppappl/ja/11.5.0/inpatch/indpatch.pl drvr_file=5498551.drv fnd_patchset=G logfile=org.log test=n appspwd=apps japwd=ja mode=FCD systempwd=manager
And check log file for errors.
Run adadmin
Disable maintenance mode.
Go to
Cd erpp/erppappl/admin/scripts/ERPP1_erpp1/
Sh adstrtal.sh apps/apps
Login through front page and select Application
DeveloperFlexfielddescriptiveSegments
Press f11 and search “Oracle Payables” in Application and press ctrl+f11 and Title should be “Invoices”
Then uncheck the Freeze flexfield definition. Press “ok”
Click codeGlobal data elements then clickSegments
Just click last column
Note down the information of the segments attached to Attributes 1-5,14 and 15 and delete them.Then re-create them with the same information but with free attributes not in (1-5, 14, 15). And rename the window promt name to previous values.
Save and make “tick” in Freeze flexfield Definition. Then press “compile” and click “ok”.
POST-PATCH APPLICATION STEPS
(Migration should be done with the help of FUNCTIONAL user)
Run this script
sqlplus apps/apps @jai_rcv_chk_pending_delivery.sql
1.View the old Threshold Data:
SELECT DISTINCT a.vendor_id, a.vendor_site_id, b.vendor_name,
DECODE(a.vendor_site_id, 0 , 'Null Site', c.vendor_site_code) "Vendor Site Code", a.tds_section, a.tds_amount, decode(a.invoice_tds_flag, 'P', 'Per Invoice', 'A', 'All Invoices') FROM ja.ja_in_vendor_tds_info_dtl a, po_vendors b, po_vendor_sites_all c
WHERE a.vendor_id = b.vendor_id AND b.vendor_id = c.vendor_id
AND (a.vendor_site_id = c.vendor_site_id OR a.vendor_site_id = 0)
Cd /erpp/erppl/ja/5498551/misc/
sqlplus apps/apps@jai_ap_3841637_migrate_pkg_t.sql
2.PAN Number validation:
SELECT DISTINCT a.vendor_id, a.vendor_site_id, b.vendor_name,
DECODE(a.vendor_site_id, 0 , 'Null Site', c.vendor_site_code) "Vendor Site Code", a.pan_no, jai_ap_3841637_migrate_pkg_t.check_valid(a.pan_no, 10) PAN_NO_STATUS,
DECODE(a.vendor_site_id, 0, a.confirm_pan_flag, NULL) PAN_CONFIRM_FLAG
FROM ja_in_vendor_tds_info_hdr a, po_vendors b, po_vendor_sites_all c WHERE a.vendor_id = b.vendor_id
AND b.vendor_id = c.vendor_id AND (a.vendor_site_id = c.vendor_site_id OR a.vendor_site_id = 0)
4.Execute in apps schema:
DROP PACKAGE JAI_AP_3841637_MIGRATE_PKG_T ;
Do steps 5,6 only if any discrepancies in PAN No and PAN Confirm Flag as a result of output of step 3
5. UPDATE ja_in_vendor_tds_info_hdr
SET pan_no = '&New_PAN_NO'
WHERE vendor_id = &vendor_id
AND vendor_site_id = NVL(&vendor_Site_ID, vendor_site_id);
6. UPDATE ja_in_vendor_tds_info_hdr
SET confirm_pan_flag = '&Confirm_PAN_FLAG_Y_N'
WHERE vendor_id = NVL(&vendor_id_NULL_for_all_vendors, vendor_id);
1.Migration script for generating ETDS flat file:
Take "TDS 2.244% Sec. 194(C)" tax and assume that the total tds rate given is : 2.244% which includes 10% surcharge and 2% cess. And if the user had already entered the value: 2.244 in the field 'Percentage' and no value in the field 'Surcharge %age',Then he should query that particular tax code and give the value 0.244 in the
'Surcharge %age' field.
2.Run scripts present in the "misc" folder:
a. sqlplus apps/
b. SELECT tax_id , tax_name , tax_Rate , surcharge_rate
FROM JA_IN_TAX_CODE_APP;
Based on the above data, you might want to delete some taxes (as discussed with functional user) which do not contain cess in the tax rate.
DELETE JA_IN_TAX_CODE_APP
WHERE tax_id = &relevant_tax_id_from_query_above
c. sqlplus apps/
RG1 - Source Migration for Shipment / Manual AR Invoice Records :
Sqlplus apps/apps@ jai_mig_4346220.sql
output has 40>0
output iv has some value >
select * from ja_in_localization_errors where application_id = '4346220'
Select * from ja_in_rg_i where register_id = < register_id from above>
shipment transaction,
UPDATE ja_in_rg_i SET cess_amount = ( SELECT sum(func_tax_amount) FROM
ja_in_so_picking_lines jspl , ja_in_so_picking_tax_lines jsptl ,
ja_in_tax_codes jtc WHERE jspl.delivery_detail_id = jsptl.delivery_detail_id AND jspl.delivery_detail_id = <&reference_no from RG1 balance screen> AND jspl.organization_id = &organization_id AND jspl.location_id= &location_id AND jspl.inventory_item_id = &inventory_item_id AND jspl.quantity = &rg1_qty AND jtc.tax_id = jsptl.tax_id AND upper(jtc.tax_type) IN ('EXCISE_EDUCATION_CESS','CVD_EDUCATION_CESS')), source = 'WSH',
last_update_date = sysdate, last_updated_by = -4346220
WHERE register_id = ®ister_id;
commit;
AR Receivable transaction:
UPDATE ja_in_rg_i SET cess_amount = ( SELECT sum(func_tax_amount)
FROM ja_in_ra_customer_trx jrct, ja_in_ra_customer_trx_lines jrctl,
ja_in_ra_cust_trx_tax_lines jrcttl , ja_in_tax_codes jtc WHERE
jrct.customer_trx_id = jrctl.customer_trx_id AND jrct.customer_trx_id = <&reference_no from RG1 balance screen>
AND jrctl.customer_trx_line_id = jrcttl.link_to_cust_trx_line_id
AND jrct.organization_id = &organization_id AND jrct.location_id = &location_id AND jrctl.inventory_item_id = inventory_item_id AND jtc.tax_id = jrcttl.tax_id AND upper(jtc.tax_type) IN ('EXCISE_EDUCATION_CESS','CVD_EDUCATION_CESS')
source = 'AR', last_update_date = sysdate ,
last_updated_by = -4346220 WHERE register_id = ®ister_id;
commit;
perl compile_il_apps_obj.pl appspwd=apps
Go to "Application Developer" Responsibility
- Open View -> Requests
- Click on "Submit New Request"
- Click on "Single Request"
- Enter "Generate Messages" in Name field
- Enter the following parameters
Language : US
Application : Asia/Pacific Localizations
Mode : DB_TO_RUNTIME
- Click Ok and then Submit the request, ensure that request completes successfully
Logout and Relogin
Conn po/po
create index ja_in_rcv_shipment_headers_n1 on
rcv_shipment_headers(receipt_num);
create index ja_in_rcv_transactions_n1 on rcv_transactions (rma_reference);
Conn ar/ar
create index ja_in_ra_customer_trx_all_n1 on
ra_customer_trx_all(interface_header_attribute1, interface_header_attribute6);
conn inv/inv
create index ja_in_mtl_transactions_n1 on
mtl_material_transactions(rcv_transaction_id);
CUSTOM.pll on $AU_TOP/resource.
Cp /erpp/erppappl/ja/5498551/patch/backup/resource/CUSTOM.pll /erpp/erppappl/au/11.5.0/resource/CUSTOM.pll
f60gen module=CUSTOM userid=apps/apps module_type=LIBRARY
----------------------------------------------------------------
6167056 ( ENH : HANDLING SECONDARY AND HIGHER EDUCATION CESS)
1.Download patch 6167056
2.mv 6167056.zip $JA_TOP
3.unzip 6167056.zip
4.cd 6167056
5.
adadminchange maintenance mode enable maintenance mode.
perl /erpp/erppappl/ja/11.5.0/inpatch/indpatch.pl drvr_file= 6167056.drv fnd_patchset=G logfile=first.log test=y appspwd=apps japwd=ja mode=FCD systempwd=manager
perl /erpp/erppappl/ja/11.5.0/inpatch/indpatch.pl drvr_file=6167056.drv fnd_patchset=G logfile=org.log test=n appspwd=apps japwd=ja mode=FCD systempwd=manager
tail –f org.log
check logfile for any issues.
And also check patching status
select * from jai_applied_patches where patch_number = '6167056’;
1.View the old Threshold Data:
SELECT DISTINCT a.vendor_id, a.vendor_site_id, b.vendor_name,
DECODE(a.vendor_site_id, 0 , 'Null Site', c.vendor_site_code) "Vendor Site Code", a.tds_section, a.tds_amount, decode(a.invoice_tds_flag, 'P', 'Per Invoice', 'A', 'All Invoices') FROM ja.ja_in_vendor_tds_info_dtl a, po_vendors b, po_vendor_sites_all c
WHERE a.vendor_id = b.vendor_id AND b.vendor_id = c.vendor_id
AND (a.vendor_site_id = c.vendor_site_id OR a.vendor_site_id = 0)
Cd /erpp/erppl/ja/5498551/misc/
sqlplus apps/apps@jai_ap_3841637_migrate_pkg_t.sql
2.PAN Number validation:
SELECT DISTINCT a.vendor_id, a.vendor_site_id, b.vendor_name,
DECODE(a.vendor_site_id, 0 , 'Null Site', c.vendor_site_code) "Vendor Site Code", a.pan_no, jai_ap_3841637_migrate_pkg_t.check_valid(a.pan_no, 10) PAN_NO_STATUS,
DECODE(a.vendor_site_id, 0, a.confirm_pan_flag, NULL) PAN_CONFIRM_FLAG
FROM ja_in_vendor_tds_info_hdr a, po_vendors b, po_vendor_sites_all c WHERE a.vendor_id = b.vendor_id
AND b.vendor_id = c.vendor_id AND (a.vendor_site_id = c.vendor_site_id OR a.vendor_site_id = 0)
4.Execute in apps schema:
DROP PACKAGE JAI_AP_3841637_MIGRATE_PKG_T ;
Do steps 5,6 only if any discrepancies in PAN No and PAN Confirm Flag as a result of output of step 3
5. UPDATE ja_in_vendor_tds_info_hdr
SET pan_no = '&New_PAN_NO'
WHERE vendor_id = &vendor_id
AND vendor_site_id = NVL(&vendor_Site_ID, vendor_site_id);
6. UPDATE ja_in_vendor_tds_info_hdr
SET confirm_pan_flag = '&Confirm_PAN_FLAG_Y_N'
WHERE vendor_id = NVL(&vendor_id_NULL_for_all_vendors, vendor_id);
1.Migration script for generating ETDS flat file:
Take "TDS 2.244% Sec. 194(C)" tax and assume that the total tds rate given is : 2.244% which includes 10% surcharge and 2% cess. And if the user had already entered the value: 2.244 in the field 'Percentage' and no value in the field 'Surcharge %age',Then he should query that particular tax code and give the value 0.244 in the
'Surcharge %age' field.
2.Run scripts present in the "misc" folder:
a. sqlplus apps/
b. SELECT tax_id , tax_name , tax_Rate , surcharge_rate
FROM JA_IN_TAX_CODE_APP;
Based on the above data, you might want to delete some taxes (as discussed with functional user) which do not contain cess in the tax rate.
DELETE JA_IN_TAX_CODE_APP
WHERE tax_id = &relevant_tax_id_from_query_above
c.sqlplus apps/
ci.
RG1 - Source Migration for Shipment / Manual AR Invoice Records :
Sqlplus apps/apps@ jai_mig_4346220.sql
output has 40>0
output iv has some value >
select * from ja_in_localization_errors where application_id = '4346220'
Select * from ja_in_rg_i where register_id = < register_id from above>
shipment transaction,
UPDATE ja_in_rg_i SET cess_amount = ( SELECT sum(func_tax_amount) FROM
ja_in_so_picking_lines jspl , ja_in_so_picking_tax_lines jsptl ,
ja_in_tax_codes jtc WHERE jspl.delivery_detail_id = jsptl.delivery_detail_id AND jspl.delivery_detail_id = <&reference_no from RG1 balance screen> AND jspl.organization_id = &organization_id AND jspl.location_id= &location_id AND jspl.inventory_item_id = &inventory_item_id AND jspl.quantity = &rg1_qty AND jtc.tax_id = jsptl.tax_id AND upper(jtc.tax_type) IN ('EXCISE_EDUCATION_CESS','CVD_EDUCATION_CESS')), source = 'WSH',
last_update_date = sysdate, last_updated_by = -4346220
WHERE register_id = ®ister_id;
commit;
AR Receivable transaction:
UPDATE ja_in_rg_i SET cess_amount = ( SELECT sum(func_tax_amount)
FROM ja_in_ra_customer_trx jrct, ja_in_ra_customer_trx_lines jrctl,
ja_in_ra_cust_trx_tax_lines jrcttl , ja_in_tax_codes jtc WHERE
jrct.customer_trx_id = jrctl.customer_trx_id AND jrct.customer_trx_id = <&reference_no from RG1 balance screen>
AND jrctl.customer_trx_line_id = jrcttl.link_to_cust_trx_line_id
AND jrct.organization_id = &organization_id AND jrct.location_id = &location_id AND jrctl.inventory_item_id = inventory_item_id AND jtc.tax_id = jrcttl.tax_id AND upper(jtc.tax_type) IN ('EXCISE_EDUCATION_CESS','CVD_EDUCATION_CESS')
source = 'AR', last_update_date = sysdate ,
last_updated_by = -4346220 WHERE register_id = ®ister_id;
commit;
perl compile_il_apps_obj.pl appspwd=apps
Go to "Application Developer" Responsibility
- Open View -> Requests
- Click on "Submit New Request"
- Click on "Single Request"
- Enter "Generate Messages" in Name field
- Enter the following parameters
Language : US
Application : Asia/Pacific Localizations
Mode : DB_TO_RUNTIME
- Click Ok and then Submit the request, ensure that request completes successfully
- Logout and Relogin
CUSTOM.pll on $AU_TOP/resource.
Cp /erpp/erppappl/ja/5498551/patch/backup/resource/CUSTOM.pll /erpp/erppappl/au/11.5.0/resource/CUSTOM.pll
f60gen module=CUSTOM userid=apps/apps module_type=LIBRARY
adadminchange maintenance mode Disable maintenance mode
sqlplus apps/apps
EXEC SYS.UTL_RECOMP.RECOMP_PARALLEL(8);
Start the application server.
Posted by V.R.Kishore Reddy at 03:55
How To Apply 11i.ATG_PF.H.RUP6
5903765--> 11i.ATG_PF.H.RUP6
DOC-ID--> 444524.1
PREREQUISTE:
Step 1 Upgrade the RDBMS to Oracle 9iR2/10g or higher (Required)
Step 2 Apply the AD minipack. (Conditionally Required)
PATCH 6502082=Patch 11i.AD.I.6
Step 3 Run the Technology Stack Validation Utility. (Required)
# From the location where this patch was unzipped, change directory to fnd/patch/115/bin.
cd 5903765
# Run the utility as follows:
./txkprepatchcheck.pl -script=ValidateRollup -outfile=$APPLTMP/txkValidateRollup.html -appspass=apps
enable maintainance mode
adpatch driver=u5903765.drv logfile=5903765.log
check the invalid objects=36524
(wheather patch hanged check tablespace fnd_install_processes)
workers failed 1and4,
bneint.ldt
bneparamlist.ldt
preinstallation patch=3218526(before this apply 4252319)
docid=287080.1
PATCH=4252319
adpatch driver=u4252319.drv
compile apps schema
Compile flexfield data in AOL tables
Restart Oracle Webserver Middle Tier environments
5903765 (adpatch driver=u5903765.drv logfile=5903765.log)
FAILED:
file ademusr.sql on worker 1 for product ad username APPLSYS.
Completed:
file aftcm049.sql on worker 3 for product
fnd username APPLSYS.
ATTENTION: All workers either have failed or are waiting:
FAILED: file ademusr.sql
on worker 1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
429498.1(Fails on ademusr.sql )
patch=5989593---(REVOKE ALL FROM PUBLIC" From adgrants.sql as pre-requisite.)
Run the adgrants.sql script as a user that can connect as SYSDBA to grant
privileges to selected SYS objects
and create PL/SQL profiler objects.
1.Create $ORACLE_HOME/appsutil/admin on the database server.
2. Copy adgrants.sql
(UNIX) from the patchtop(5989593)/admin directory to
$ORACLE_HOME/appsutil/admin. Or, copy adgrants_nt.sql (Windows) from
patchtop(5989593)\admin to %ORACLE_HOME%\appsutil\admin.
3.Set the environment to point to ORACLE_HOME on the database server.
4.
Use SQL*Plus to run the script:
UNIX:
$ sqlplus /nolog
SQL> connect / as sysdba
SQL>
PATCH 3865683=RELEASE 11.5.10 PRODUCTS NAME PATCH
Posted by V.R.Kishore Reddy at 03:35
How To Apply ADI-6 Patch
APPLY ADI-6 PATCH:
Download patch 6502082
Open read me 233044.1
Check for pre requisites:
Before apply patch down the apps server and enable maintenance mode
----To check weather maintenance mode enabled
select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual;
Before apply patch check for system requirements:
Perl executable
You must have the Perl executable (5.004 minimum; 5.005 perferred) in your PATH
before you apply this minipack. You should have already installed Perl as part of
your iAS ORACLE_HOME. See http://www.cpan.org for information on obtaining Perl.
FNDLOAD executable
Ensure all application tier server nodes contain the FNDLOAD executable in the
$FND_TOP/bin directory
Unzip apps.zip under $JAVA_TOP on all application tier nodes, if you have not done so already.
Convert to Multiple Organizations
Oracle Applications strongly recommends that you convert to Multi-Org as soon as
possible so that you will be prepared for improvements to performance across the
E-Business Suite as well as support for Multi-Org Access Control.
see Release 11i Use of Multiple Organizations in Oracle Applications (OracleMetaLink Document 210193.1). related doc284046 and 2451368
Apply the Minipack:
Adpatch driver=
Check for invalid objects before applying patch and check after apply patch by using following command
--To check the Invalid Objects
SELECT count(1) FROM dba_objects WHERE status='INVALID';
$FND_TOP /patch/115/sql/afoppool.sql (for compile queue objects)
--To Recompile Invalid Objects
EXEC SYS.UTL_RECOMP.RECOMP_PARALLEL(8);
Post-minipack Steps:
Step 1: Grant privileges and create PL/SQL profiler objects
Run the adgrants.sql script as a user that can connect as SYSDBA to grant privileges to selected SYS objects and create PL/SQL profiler objects.
1.Create $ORACLE_HOME/appsutil/admin on the database server.
2.Copy adgrants.sql (UNIX) from $APPL_TOP/admin to $ORACLE_HOME/appsutil/admin.
Or, copy adgrants_nt.sql (Windows) from %APPL_TOP%\admin to
%ORACLE_HOME%\appsutil\admin.
3.Set the environment to point to ORACLE_HOME on the database server.
4.Use SQL*Plus to run the script:
UNIX:
$ sqlplus /nolog
SQL> connect / as sysdba
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql
Windows:
C:\> sqlplus /nolog
SQL> connect / as sysdba
SQL> @%ORACLE_HOME%\appsutil\admin\adgrants_nt.sql
Step 2: Unzip apps.zip under $JAVA_TOP (conditionally required)
If you have already unzipped apps.zip, go on to Step 3.
Verify whether apps.zip has been unzipped. If the file exists in your $JAVA_TOP directory, it has not been unzipped. If it doesn't exist in $JAVA_TOP, it has already been unzipped.
Step 3: Run AutoConfig
Posted by V.R.Kishore Reddy at 03:21
