Upgrading JDK to 1.5 and configuring Jconsole.

In my earlier post i had talked about JVMs in Oracle Applications. Also i had mentioned about the jconsole tool that could be used for real time monitoring of your middle tier JVM usage.

The latest certified version of JDK supported with Oracle Applications is JDK 1.5. The version of JDK that is shipped with 11.5.10.2 is JDK 1.4.

Oracle recommends you to upgrade your JDK to 1.5 and one of the advantages of going for this upgrade is the ability to use Jconsole.

In my current i am detailing out step by step instructions for upgrading your middle tier JDK from 1.4 to 1.5 and the configuring jconsole for a real time monitoring of your JVM.


Upgrading JDK to 1.5

Downloading JDK 1.5

At the start you would require to get the J2SE1.5 software from the sun site

http://java.sun.com/j2se/1.5.0/download.jsp

Choose the J2SE 1.5 update 8 rpm file for Linux the file would be in the form of *.rpm.bin

Installing JDK 1.5

You must install the J2SE1.5 software on all the application middle tier nodes.

After you have FTPed the file to you application server change the permissions and execute the .bin file as the root user

# chmod 755 jdk-1_5_0_08-linux-i586-rpm.bin
# ./jdk-1_5_0_08-linux-i586-rpm.bin

This will present you with a binary license agreement agreeing to which will do the rpm installation for you.

Do you agree to the above license terms? [yes or no]
yes
Unpacking...
Checksumming...
0
0
Extracting...
UnZipSFX 5.42 of 14 January 2001, by Info-ZIP (Zip-Bugs@lists.wku.edu).
inflating: jdk-1_5_0_08-linux-i586.rpm
Preparing... ########################################### [100%]
1:jdk ########################################### [100%]

Done.

Make a note of the J2SE installation directory which i refer as JDK50_TOP, in my case it was /usr/java/jdk1.5.0_08.

Verify the java version

Verify the version of java installed

# ./java -version
java version "1.5.0_08"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_08-b03)
Java HotSpot(TM) Server VM (build 1.5.0_08-b03, mixed mode)

The following steps are to be performed as the applications user.

Apply Inter operability patches

Apply the following Oracle Applications 11.5.10.2 J2SE1.5 inter operability patches using adpatch.

Patch 4372996
Patch 5372210

I did a shutdown of my application tier process before applying these.

$ adstpall.sh apps/apps
$ cd 4372996
$ adpatch options=hotpatch

Note: In case you have not applied the CU2 that is you are not on 11.5.10.2 you must apply TXK AutoConfig Template Rollup
patch 4367673.


Execute the J2SE 5.0 Upgrade Script to Update Configuration Files

$ txkrun.pl -script=SetJDKCfg -contextfile=$CONTEXT_FILE -runautoconfig=Yes -appspass=apps -jdktop=/usr/java/jdk1.5.0_08

This will update you configuration files and run autoconfig at the end.

Verifying java on the application tiers

Execute the applications environment script again and check the JAVA in path

$ . ./APPSORA.env
$ which java
/usr/java/jdk1.5.0_08/bin/java

Testing Applications

Navigate to the following page

http://[yourhost.domain]:[port]/OA_HTML/jsp/fnd/aoljtest.jsp

this will prompt you for your apps user, password, hostname and port. After the test is complete verify the following files are in the new JDK1.5 home.

/usr/java/jdk1.5.0_08/lib/dt.jar
/usr/java/jdk1.5.0_08/lib/tools.jar
/usr/java/jdk1.5.0_08/jre/lib/rt.jar
/usr/java/jdk1.5.0_08/jre/lib/charsets.jar

Verify adovars.env file on your application tier.

$APPL_TOP/admin/adovars.env

Check the new JDK1.5 home has been updated.

OA_JRE_TOP="/usr/java/jdk1.5.0_08"
export OA_JRE_TOP

AF_JRE_TOP="/usr/java/jdk1.5.0_08"
export AF_JRE_TOP

CLASSPATH="/usr/java/jdk1.5.0_08/jre/lib/rt.jar:/usr/java/jdk1.5.0_08/lib/dt.jar:/usr/java/jdk1.5.0_08/lib/tools.jar:/usr/jav
a/jdk1.5.0_08/jre/lib/charsets.jar:/u05/sam/applsam/samcomn/java/appsborg2.zip:/u05/sam/applsam/samora/8.0.6/forms60/java:/u0
5/sam/applsam/samcomn/java"
export CLASSPATH

AF_CLASSPATH="/usr/java/jdk1.5.0_08/jre/lib/rt.jar:/usr/java/jdk1.5.0_08/lib/dt.jar:/usr/java/jdk1.5.0_08/lib/tools.jar:/usr/
java/jdk1.5.0_08/jre/lib/charsets.jar:/u05/sam/applsam/samcomn/java/appsborg2.zip:/u05/sam/applsam/samora/8.0.6/forms60/java:
/u05/sam/applsam/samcomn/java"
export AF_CLASSPATH

Additional Check.

You can log into Oracle Applications as the sysadmin user and run a concurrent request and view the output to check the working of applications.


Configuring JCONSOLE

The jconsole executable comes within your jdk 1.5 software.You can either run it from the application middle tier server itself or connect remotely. In our case we will configure jconsole to run from the application tier server itself.

You would need to have the following two parameters in your jserv.properties file

wrapper.bin.parameters=-Dcom.sun.management.jmxremote
wrapper.bin.parameters=-Dcom.sun.management.jmxremote.ssl=false

Adding Parameters To The Custom Template File

Since the seeded autoconfig template files do not have these parameters you have to create a custom template file to intoduce these additional parameters

First you have to find out the template file corresponding to the jserv.properties file.
You could do this by running the adtmplreport.sh script at $AD_TOP/bin

$AD_TOP/bin/adtmplreport.sh contextfile=$CONTEXT_FILE target=/u05/sam/applsam/samora/iAS/Apache/Jserv/etc/jserv.properties

TEMPLATE FILE : /u05/sam/applsam/samappl/fnd/11.5.0/admin/template/jserv_ux_ias1022.properties
TARGET FILE : /u05/sam/applsam/samora/iAS/Apache/Jserv/etc/jserv.properties

Create a directory for your template file.

mkdir $FND_TOP/admin/template/custom

Copy the existing template file here

cd $FND_TOP/admin/template/custom
cp - i /u05/sam/applsam/samappl/fnd/11.5.0/admin/template/jserv_ux_ias1022.properties
.

edit this template file and introduce the following line here

wrapper.bin.parameters=-Dcom.sun.management.jmxremote
wrapper.bin.parameters=-Dcom.sun.management.jmxremote.ssl=false

Check the custom template file

Check that the custom template file is OK by running the

$AD_TOP/bin
adchkcfg.sh contextfile= appspass=
adchkcfg.sh contextfile=$CONTEXT_FILE appspass=apps

Run autoconfig and verify in the values have been written into the jserv.properties.

Restart you Oracle application tier services

$ cd $COMMON_TOP/admin/scripts/[context_name]/adstpall.sh apps/apps
$ cd $COMMON_TOP/admin/scripts/[context_name]/adstrtal.sh apps/apps

You can now launch jconsole from JDK50_TOP/bin

$ ./jconsole

As you see the configuration take place automatically when you launch jconsole from the application server itself.You just need to click on connect.

The first screen shows you a sumary of the JVM usage and garbage collection.

The next screen is more fun, this show you the real time JVM usage in a graphical format.

References
Using J2SE Version 5.0 with Oracle E-Business Suite 11i Note:304099.1Using AutoConfig to Manage System Configurations with Oracle Applications 11i Note:165195.1
Using Jconsole with Apps 11i by Steven Chan

Version Information

Oracle Applications:11.5.10.2

JDK:1.5

OS: Redhat Linux AS 4

Installing Oracle Applications 11.5.10.2 on Linux AS 4

In today’s post i will describe the steps to install oracle Application on linux. This is a simple single node installation.

Conventions
# prompt refers to my root prompt.
$ prompt refer to my user account prompts.
All OS commands are in italics as usual.

Verify OS version

The fist step would be however to verify your Linux installation. You could check the version of the Linux installed by the
command

# cat /etc/redhat-release
Red Hat Enterprise Linux AS release 4 (Nahant Update 2)

Operating System utilities Check

Perl Software

You must have perl 5.0053 or higher installed to be able to create the staging area using the perl script adautostg.pl

Java Requirement

On 11.5.10, Rapidwiz, installs the J2SE 1.4.2 automatically for systems running on Sun Solaris, Linux, or Windows Operating Systems.

Additional Patches

For Redhat linux 4 you must apply patch 4198954

This will installt the OS packages

compat-oracle-rhel4-1.0-5.i386.rpm
compat-libcwait-2.1-1.i386.rpm

Create directories to hold your Oracle Applications

# mkdir sam
# ls -l
total 24
drwx------ 2 root root 16384 Aug 30 14:41 lost+found
drwxr-xr-x 2 root root 4096 Sep 21 11:55 sam
# chmod -R 777 sam

I am following a unix multi user installation so you need to create two OS user accounts,orasam for the database and applsam for the applications.

# useradd -g dba -d /u05/sam/orasam orasam
# useradd -g dba -d /u05/sam/applsam applsam

Xhost client settings

If you are installing using a Remote XServer you may need execute the following command

# xhost +
access control disabled,clients can connect from any host

Set umask 022 for both the user accounts

Setting umask to 022 ensures that group and others have read and execute permissions,
but not write permission.

# su - orasam
$ vi .bash_profile
add the line at the end
umask 002

# su - applsam
$ vi .bash_profile
add the line at the end
umask 002

Modify the orainventory for your new installation

# vi /etc/oraInst.loc

inventory_loc=/u05/sam/oraInventory
inst_group=dba

Set the LD_ASSUME_KERNEL parameter for both the user accounts orasam
and applsam

# su - orasam
$ vi .bash_profile
add the lines at the end
LD_ASSUME_KERNEL=2.4.19
export LD_ASSUME_KERNEL

# su - applsam
$ vi .bash_profile
add the lines at the end
LD_ASSUME_KERNEL=2.4.19
export LD_ASSUME_KERNEL

Starting the installation

You start the installation as the root user by running the rapidwiz executable from

# cd /u02/stage11i102/startCD/Disk1/rapidwiz
# ./rapidwiz


The first which you see screen is the rapid install welcome screen.








In the next screen you see,It presents you with choices either to do a fresh installation or perform an upgrade of an existing instance, I choose the first oiption.





In case you have a configuration file you can browse and choose the file here. This option is useful while doing multi node installation. Since this is a fresh install I choose NO.

The next screen is used to decide if you wish to do a single node or a multi node installation, we chose a single node installation here.







In this screen you sepcify your database OS user account and its base directory.







The following screen prompts to choose the kind of licensing we wish to have for our e business suite (in case of Vision installations you will not see this screen)






This screen is used to choose the country specific functionalities or localizations which might be required.







The next screen is used to select any additional language which we might want to install with ebusiness suite. You must have staged the appropriate language CD before selecting the language.






You must now select the character set for your database and applications, I used UTF8 to allow me to add additional languages in the future.






In this screen you specify your OS application user account and the base directory for it. You can click on advanced to further edit the directory structure.






Now you specify your domain name, and port pool. Your port pool is used to assign the ports for your various oracle application process without causing a conflict






You can specify a location to save the configuration information you have entered so far. In case of a multi node installation this config file is used to do the installation on the other nodes.






The installer will now perform a check for all the OS utilities disk space permissions port availability and display the results.







You will be prompted to start the installation of oracle applications in the next screen.

After the installation is completed a post installation sheck will be done to ensure that all the services are working as desired.

The installtion described above was single node installation of PROD instance of Oracle Applications on a Linux environment.

Multi Node to Single Node Cloning

With Oracle Applications 11.5.10 the ability to clone from a multi node to a single node system using rapid clone has now been certified.

This is accomplished by the Shared APPL_TOP and Merging APPL_TOP features.

In this post i am listing out the steps to perform a multi note to a single node cloning from scratch. The information mentioned here is the steps which i have used and found them to be successful for a more elaborate explanation you might want to refer to the metalink note Sharing the Application Tier File System in Oracle E-Business Suite 11i (233428.1)

Source System here refers to the multi node system to be cloned
Target System refers to the newly to be created single node system
Applications Version 11.5.10
Operating System Linux ES 4

The following Steps are required to be performed on the source system

1. Apply application tier patches using adpatch

Apply patch 4038964
Apply patch 4175764

Both the above patches are include in the consolidated update 2 or CU2 so in case you are on 11.5.10.2 or later you can ignore this step.

2. Maintain snapshot information

Log in as the applications user on each application tier node and run 'Maintain Snapshot Information' by using adadmin.

3. Merge existing APPL_TOPs

Log in to the primary node of your application tier as the application user user and run:

$ cd [COMMON_TOP]/admin/scripts/[CONTEXT_NAME]
$ perl adpreclone.pl appsTier merge

This will prompt you with option to merge secondary nodes

Now log in as the applications user to each of the secondary application tier nodes being merged and run:

$ cd [COMMON_TOP]/admin/scripts/[CONTEXT_NAME]
$ perl adpreclone.pl appltop merge

4. Prepare the source system database tier.

Log on to the database tier of the source system as the oracle user and run the following commands:

$ cd [RDBMS ORACLE_HOME]/appsutil/scripts/[CONTEXT_NAME]
$ perl adpreclone.pl dbTier

With this all the pre clone tasks on the source system have been completed.

The next set of tasks are required to be carried out on the target system that is the system on which you wish to place the merged single node instance.

1. Create OS user accounts

Create a OS user account for your applications

$ useradd -g dba -d [home_directory] -p password username

Similarly create a OS user account for your database

2. Modify the orainventory to reflect the new location

$ vi /etc/oraInst.loc

3. Copy the following application tier directories

Copy the following application tier directories from the primary node of your source system to the target application tier node, retaining the original directory structure:

– [APPL_TOP]
– [OA_HTML]
– [OA_JAVA]
– [COMMON_TOP/util]
– [COMMON_TOP/clone>
– [806 ORACLE_HOME]
– [iAS ORACLE_HOME]

4. Copy the required files for merging

Log in as the applications user to each of the secondary source nodes and recursively copy:

directory [COMMON_TOP]/clone/appl
- to -
directory [COMMMON_TOP]/clone/appl on the target system node

Before proceeding with the next steps you must shutdown your oracle applications services and the database on the source system

5. Copy the database tier file system

Log on to the source system as the database user

Copy the database (DBF) files from the source to the target system
Copy the source database ORACLE_HOME to the target system

After this you can now startup the database and applications services on your source system and release it for use.

6. Configure the target system database server

Log on to the target system as the database user and type the following commands to configure and start the database:

$ cd [RDBMS ORACLE_HOME]/appsutil/clone/bin
$ perl adcfgclone.pl dbTier

This will prompt for new ORACLE_SID,ORACLE_HOME,Port Pool,JAVA_TOP and DATA_TOP give the appropriate values matching your target system

Once successful this should start your database and listener

7. Configure the application tier server nodes

The database and its listener should remain up before executing the next set of commands.
Log in to the merged APPL_TOP node as the applications user and execute the following commands:

$ cd [COMMON_TOP]/clone/bin
$ perl adcfgclone.pl appsTier

This will prompt you new port pool for applictaion tier services as well as new APPLTOP,COMMON_TOP,ORACLE_HOME and IAS_TOP

Successful completion of this task will bring up your application tier services on the target or the cloned node.

8. Post Clone Tasks

Log in to the target system application tier node as the APPLMGR user.
Run the following tasks in adadmin for all products:
o generate JAR files
o generate message files
o relink executables
o copy files to destination


9. Clean up of the target system

Remove the temporary directory [COMMON_TOP]/clone/appl to reduce disk space usage.

Note: The version of Oracle Applications used is 11.5.10 and the operating system is Linux ES 4