tag:blogger.com,1999:blog-317931332024-03-07T11:28:01.180-08:00Sam's WebLog On Oracle Applications TechnologyA weblog on the latest trends, news and events on Oracle Applications TechnologySamhttp://www.blogger.com/profile/02503978840124498130noreply@blogger.comBlogger24125tag:blogger.com,1999:blog-31793133.post-85085952387088099272006-10-01T22:37:00.000-07:002006-10-01T22:48:14.264-07:00<p class="MsoNormal">Finally the blog is <span> </span>back again and this is the new address</p> <p class="MsoNormal"><a mce_real_href="http://www.appsdbablog.com/" href="http://www.appsdbablog.com/">www.appsdbablog.com</a></p> <p class="MsoNormal">RSS feed URL</p> <p class="MsoNormal">http://appsdbablog.com/atom.xml</p> <p class="MsoNormal">There are still some tweaks that i doing on this blog, like the email subscriptions are yet to be made up.</p> <p class="MsoNormal"><span>In case you find some changes that are missing or don’t like just drop in a comment, I will surly work on that.</span></p> <p class="MsoNormal">Thanks for patience.</p>Note i will not be posting on this site(appstech-sam.blogspot.com) again.Samhttp://www.blogger.com/profile/02503978840124498130noreply@blogger.com324tag:blogger.com,1999:blog-31793133.post-689557602577653672006-09-28T04:19:00.000-07:002006-09-28T04:22:08.912-07:00Update<br /><br />Last few days I have been busy trying to get a new location for my blog, The feedback and the response to this blog has been overwhelming and I thank you , the readers for that.<br /><br />The good news is I have a new fresh, cleaner and a sleek looking blog coming up. Now I am in the process of transferring the old entries to their new home. I am working hard to get it released this weekend so please bear with me for a little while more.<br /><br />Also my sincere apologies to Yury Atul Fadi among others who have left their feedback but I was unable to respond to. I promise to be back soon.<br /><br />SamSamhttp://www.blogger.com/profile/02503978840124498130noreply@blogger.com6tag:blogger.com,1999:blog-31793133.post-32560081765610860432006-09-25T04:00:00.000-07:002006-09-25T04:22:56.489-07:00<div><strong>Upgrading JDK to 1.5 and configuring Jconsole.</strong><br /><br />In my earlier post i had talked about JVMs in Oracle Applications. Also i had mentioned about the <strong><em>jconsole</em></strong> tool that could be used for real time monitoring of your middle tier JVM usage.<br /><br />The latest certified version of JDK supported with Oracle Applications is <strong><em>JDK 1.5.</em></strong> The version of JDK that is shipped with 11.5.10.2 is JDK 1.4.<br /><br />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.<br /><br />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.<br /><br /><br /><strong>Upgrading JDK to 1.5<br /></strong><br /><strong>Downloading JDK 1.5<br /></strong><br />At the start you would require to get the J2SE1.5 software from the sun site<br /><br /><em>http://java.sun.com/j2se/1.5.0/download.jsp<br /></em><br />Choose the J2SE 1.5 update 8 rpm file for Linux the file would be in the form of <em>*.rpm.bin</em><br /><br /><strong>Installing JDK 1.5</strong><br /><br />You must install the J2SE1.5 software on all the application middle tier nodes.<br /><br />After you have FTPed the file to you application server change the permissions and execute the .bin file as the root user<br /><br /><em># chmod 755 jdk-1_5_0_08-linux-i586-rpm.bin<br /># ./jdk-1_5_0_08-linux-i586-rpm.bin<br /></em><br />This will present you with a binary license agreement agreeing to which will do the rpm installation for you.<br /><br /><em>Do you agree to the above license terms? [yes or no]<br />yes<br />Unpacking...<br />Checksumming...<br />0<br />0<br />Extracting...<br />UnZipSFX 5.42 of 14 January 2001, by Info-ZIP (Zip-Bugs@lists.wku.edu).<br />inflating: jdk-1_5_0_08-linux-i586.rpm<br />Preparing... ########################################### [100%]<br />1:jdk ########################################### [100%]<br /></em><br /><em>Done.<br /></em><br />Make a note of the J2SE installation directory which i refer as JDK50_TOP, in my case it was <em>/usr/java/jdk1.5.0_08.<br /></em><br /><strong>Verify the java version</strong><br /><br />Verify the version of java installed<br /><br /><em># ./java -version<br />java version "1.5.0_08"<br />Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_08-b03)<br />Java HotSpot(TM) Server VM (build 1.5.0_08-b03, mixed mode)<br /></em><br />The following steps are to be performed as the applications user.<br /><br /><strong>Apply Inter operability patches<br /></strong><br />Apply the following Oracle Applications 11.5.10.2 J2SE1.5 inter operability patches using adpatch.<br /><br />Patch 4372996<br />Patch 5372210<br /><br />I did a shutdown of my application tier process before applying these.<br /><br /><em>$ adstpall.sh apps/apps<br />$ cd 4372996<br />$ adpatch options=hotpatch<br /></em><br />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<br />patch 4367673.<br /><br /><br /><strong>Execute the J2SE 5.0 Upgrade Script to Update Configuration Files<br /></strong><br /><em>$ txkrun.pl -script=SetJDKCfg -contextfile=$CONTEXT_FILE -runautoconfig=Yes -appspass=apps -jdktop=/usr/java/jdk1.5.0_08<br /></em><br />This will update you configuration files and run autoconfig at the end.<br /><br /><strong>Verifying java on the application tiers<br /></strong><br />Execute the applications environment script again and check the JAVA in path<br /><br /><em>$ . ./APPSORA.env </em><br /><em>$ which java<br />/usr/java/jdk1.5.0_08/bin/java<br /></em><br /><strong>Testing Applications<br /></strong><br />Navigate to the following page </div><div><br /><em>http://[yourhost.domain]:[port]/OA_HTML/jsp/fnd/aoljtest.jsp </em></div><div><em><br /></div></em><img style="DISPLAY: block; MARGIN: 0px auto 10px; CURSOR: hand; TEXT-ALIGN: center" alt="" src="http://photos1.blogger.com/blogger2/8173/3880/320/jsptest.png" border="0" /><br />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.<br /><br /><em>/usr/java/jdk1.5.0_08/lib/dt.jar<br />/usr/java/jdk1.5.0_08/lib/tools.jar<br />/usr/java/jdk1.5.0_08/jre/lib/rt.jar<br />/usr/java/jdk1.5.0_08/jre/lib/charsets.jar<br /></em><br /><strong>Verify adovars.env file on your application tier.<br /></strong><br /><em>$APPL_TOP/admin/adovars.env<br /></em><br />Check the new JDK1.5 home has been updated.<br /><br /><div><em>OA_JRE_TOP="/usr/java/jdk1.5.0_08"<br />export OA_JRE_TOP<br /><br />AF_JRE_TOP="/usr/java/jdk1.5.0_08"<br />export AF_JRE_TOP<br /><br />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<br />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<br />5/sam/applsam/samcomn/java"<br />export CLASSPATH<br /><br />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/<br />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:<br />/u05/sam/applsam/samcomn/java"<br />export AF_CLASSPATH<br /></em><br /><strong>Additional Check.<br /></strong><br />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.<br /><br /><br /><strong>Configuring JCONSOLE </strong><br /></div><div> </div><div>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.</div><div><br />You would need to have the following two parameters in your jserv.properties file<br /><br /><em>wrapper.bin.parameters=-Dcom.sun.management.jmxremote<br />wrapper.bin.parameters=-Dcom.sun.management.jmxremote.ssl=false<br /></em></div><div><strong>Adding Parameters To The Custom Template File</strong><br /></div><div> </div><div>Since the seeded autoconfig template files do not have these parameters you have to create a custom template file to intoduce these additional parameters<br /><br />First you have to find out the template file corresponding to the jserv.properties file.<br />You could do this by running the adtmplreport.sh script at $AD_TOP/bin<br /><br /><em>$AD_TOP/bin/adtmplreport.sh contextfile=$CONTEXT_FILE target=/u05/sam/applsam/samora/iAS/Apache/Jserv/etc/jserv.properties<br /></em><br /><em>TEMPLATE FILE : /u05/sam/applsam/samappl/fnd/11.5.0/admin/template/jserv_ux_ias1022.properties<br />TARGET FILE : /u05/sam/applsam/samora/iAS/Apache/Jserv/etc/jserv.properties<br /></em><br /><strong>Create a directory for your template file.<br /></strong><br />mkdir $FND_TOP/admin/template/custom<br /><br />Copy the existing template file here<br /><br /><em>cd $FND_TOP/admin/template/custom<br />cp - i /u05/sam/applsam/samappl/fnd/11.5.0/admin/template/jserv_ux_ias1022.properties </em><br /><em>.<br /></em><br />edit this template file and introduce the following line here<br /><br /><em>wrapper.bin.parameters=-Dcom.sun.management.jmxremote<br />wrapper.bin.parameters=-Dcom.sun.management.jmxremote.ssl=false<br /></em><br /><strong>Check the custom template file</strong><br /></div><div>Check that the custom template file is OK by running the<br /><em></em></div><div> </div><div><em>$AD_TOP/bin<br />adchkcfg.sh contextfile=<context> appspass=<appspwd><br />adchkcfg.sh contextfile=$CONTEXT_FILE appspass=apps<br /></em><br />Run autoconfig and verify in the values have been written into the jserv.properties.<br /><br /><strong>Restart you Oracle application tier services</strong><br /><br />$ cd $COMMON_TOP/admin/scripts/[context_name]/adstpall.sh apps/apps<br />$ cd $COMMON_TOP/admin/scripts/[context_name]/adstrtal.sh apps/apps<br /><br />You can now launch jconsole from JDK50_TOP/bin<br /><br /><em>$ ./jconsole</em></div><br /><br /><div>As you see the configuration take place automatically when you launch jconsole from the application server itself.You just need to click on connect.<br /></div><br /><div><em></em></div><p></p><br /><p><img style="DISPLAY: block; MARGIN: 0px auto 10px; CURSOR: hand; TEXT-ALIGN: center" alt="" src="http://photos1.blogger.com/blogger2/8173/3880/320/Jcon1.png" border="0" /></p><br /><p>The first screen shows you a sumary of the JVM usage and garbage collection.<br /><br /></p><br /><p></p><br /><p><img style="DISPLAY: block; MARGIN: 0px auto 10px; CURSOR: hand; TEXT-ALIGN: center" alt="" src="http://photos1.blogger.com/blogger2/8173/3880/320/Jcon2.png" border="0" /></p><br /><p></p><br /><br /><p>The next screen is more fun, this show you the real time JVM usage in a graphical format.</p><br /><p><img style="DISPLAY: block; MARGIN: 0px auto 10px; CURSOR: hand; TEXT-ALIGN: center" alt="" src="http://photos1.blogger.com/blogger2/8173/3880/320/Jcon3.png" border="0" /><br /></p><br /><br /><strong>References</strong><br />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<br /><a href="http://blogs.oracle.com/schan/2006/08/14#a565">Using Jconsole with Apps 11i by Steven Chan<br /></a><br /><div><strong>Version Information</strong></div><div>Oracle Applications:11.5.10.2</div><div>JDK:1.5</div><div>OS: Redhat Linux AS 4</div><div> </div>Samhttp://www.blogger.com/profile/02503978840124498130noreply@blogger.com44tag:blogger.com,1999:blog-31793133.post-53322026333523559182006-09-21T03:38:00.000-07:002006-09-21T03:44:30.989-07:00<strong>Installing Oracle Applications 11.5.10.2 on Linux AS 4<br /></strong><br />In today’s post i will describe the steps to install oracle Application on linux. This is a simple single node installation.<br /><br /><strong>Conventions<br /></strong><em>#</em> prompt refers to my root prompt.<br /><em>$</em> prompt refer to my user account prompts.<br />All OS commands are in <em>italics</em> as usual.<br /><br /><strong><em>Verify OS version</em></strong><br /><br />The fist step would be however to verify your Linux installation. You could check the version of the Linux installed by the<br />command<br /><br /><em># cat /etc/redhat-release<br />Red Hat Enterprise Linux AS release 4 (Nahant Update 2)<br /></em><br /><strong><em>Operating System utilities Check<br /></em></strong><br /><em><strong>Perl Software</strong><br /></em><br />You must have <strong><em>perl 5.0053</em></strong> or higher installed to be able to create the staging area using the perl script <strong><em>adautostg.pl</em></strong><br /><br /><strong><em>Java Requirement<br /></em></strong><br />On 11.5.10, Rapidwiz, installs the J2SE 1.4.2 automatically for systems running on Sun Solaris, Linux, or Windows Operating Systems.<br /><br /><strong><em>Additional Patches</em></strong><br /><br />For Redhat linux 4 you must apply patch 4198954<br /><br />This will installt the OS packages<br /><br /><em>compat-oracle-rhel4-1.0-5.i386.rpm<br />compat-libcwait-2.1-1.i386.rpm<br /></em><br />Create directories to hold your Oracle Applications<br /><br /><em># mkdir sam<br /># ls -l<br />total 24<br />drwx------ 2 root root 16384 Aug 30 14:41 lost+found<br />drwxr-xr-x 2 root root 4096 Sep 21 11:55 sam<br /># chmod -R 777 sam<br /></em><br />I am following a <strong><em>unix multi user installation</em></strong> so you need to create two OS user accounts,<strong><em>orasam for the database and applsam for the applications</em></strong>.<br /><br /><em># useradd -g dba -d /u05/sam/orasam orasam<br /># useradd -g dba -d /u05/sam/applsam applsam<br /></em><br /><strong><em>Xhost client settings</em></strong><br /><strong><em><br /></em></strong>If you are installing using a Remote XServer you may need execute the following command<br /><br /><em># xhost +<br />access control disabled,clients can connect from any host<br /></em><br /><strong><em>Set umask 022 for both the user accounts<br /></em></strong><br />Setting umask to 022 ensures that group and others have read and execute permissions,<br />but not write permission.<br /><br /><em># su - orasam<br />$ vi .bash_profile<br />add the line at the end<br />umask 002<br /><br /># su - applsam<br />$ vi .bash_profile<br />add the line at the end<br />umask 002<br /></em><br /><strong><em>Modify the orainventory for your new installation<br /></em></strong><br /><em># vi /etc/oraInst.loc<br /><br />inventory_loc=/u05/sam/oraInventory<br />inst_group=dba<br /></em><br /><strong><em>Set the LD_ASSUME_KERNEL parameter for both the user accounts orasam </em></strong><br /><strong><em>and applsam</em></strong><br /><strong><em></em></strong><br /><em># su - orasam<br />$ vi .bash_profile<br />add the lines at the end<br />LD_ASSUME_KERNEL=2.4.19<br />export LD_ASSUME_KERNEL<br /><br /># su - applsam<br />$ vi .bash_profile<br />add the lines at the end<br />LD_ASSUME_KERNEL=2.4.19<br />export LD_ASSUME_KERNEL<br /></em><br /><strong><em>Starting the installation</em></strong><br /><br />You start the installation as the root user by running the rapidwiz executable from<br /><br /><em># cd /u02/stage11i102/startCD/Disk1/rapidwiz<br /># ./rapidwiz<br /></em><br /><br /><a href="http://photos1.blogger.com/blogger2/8173/3880/1600/Ins1.2.gif"><img style="FLOAT: left; MARGIN: 0px 10px 10px 0px; WIDTH: 204px; CURSOR: hand; HEIGHT: 132px" height="132" alt="" src="http://photos1.blogger.com/blogger2/8173/3880/200/Ins1.png" width="221" border="0" /></a>The first which you see screen is the rapid install welcome screen.<br /><br /><br /><br /><br /><br /><br /><br /><a href="http://photos1.blogger.com/blogger2/8173/3880/1600/Ins2.gif"><img style="FLOAT: left; MARGIN: 0px 10px 10px 0px; CURSOR: hand" alt="" src="http://photos1.blogger.com/blogger2/8173/3880/200/Ins2.png" border="0" /></a><br />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.<br /><br /><br /><br /><br /><br /><a href="http://photos1.blogger.com/blogger2/8173/3880/1600/Ins3.gif"><img style="FLOAT: left; MARGIN: 0px 10px 10px 0px; CURSOR: hand" alt="" src="http://photos1.blogger.com/blogger2/8173/3880/200/Ins3.png" border="0" /></a>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.<br /><br /><br /><p></p><p> </p><p> </p><p><a href="http://photos1.blogger.com/blogger2/8173/3880/1600/Ins4.gif"><img style="FLOAT: left; MARGIN: 0px 10px 10px 0px; CURSOR: hand" alt="" src="http://photos1.blogger.com/blogger2/8173/3880/200/Ins4.png" border="0" /></a>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.<br /><br /><br /><a href="http://photos1.blogger.com/blogger2/8173/3880/1600/Ins2.gif"></a><br /><br /><br /><br /><br /><a href="http://photos1.blogger.com/blogger2/8173/3880/1600/Ins5.gif"><img style="FLOAT: left; MARGIN: 0px 10px 10px 0px; CURSOR: hand" alt="" src="http://photos1.blogger.com/blogger2/8173/3880/200/Ins5.png" border="0" /></a> In this screen you sepcify your database OS user account and its base directory.<br /><br /><br /><br /><br /><br /><br /><br /><a href="http://photos1.blogger.com/blogger2/8173/3880/1600/Ins6.gif"><img style="FLOAT: left; MARGIN: 0px 10px 10px 0px; CURSOR: hand" alt="" src="http://photos1.blogger.com/blogger2/8173/3880/200/Ins6.png" border="0" /></a>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)<br /><br /><br /><br /><br /><br /><br /><a href="http://photos1.blogger.com/blogger2/8173/3880/1600/Ins7.gif"><img style="FLOAT: left; MARGIN: 0px 10px 10px 0px; CURSOR: hand" alt="" src="http://photos1.blogger.com/blogger2/8173/3880/200/Ins7.png" border="0" /></a> This screen is used to choose the country specific functionalities or localizations which might be required.<br /><br /><br /><br /><br /><br /><br /><br /><a href="http://photos1.blogger.com/blogger2/8173/3880/1600/Ins8.gif"><img style="FLOAT: left; MARGIN: 0px 10px 10px 0px; CURSOR: hand" alt="" src="http://photos1.blogger.com/blogger2/8173/3880/200/Ins8.png" border="0" /></a> 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.<br /><br /><br /><br /><br /><br /><br /><a href="http://photos1.blogger.com/blogger2/8173/3880/1600/Ins9.gif"><img style="FLOAT: left; MARGIN: 0px 10px 10px 0px; CURSOR: hand" alt="" src="http://photos1.blogger.com/blogger2/8173/3880/200/Ins9.png" border="0" /></a> 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.<br /><br /><br /><br /><br /><br /><br /><a href="http://photos1.blogger.com/blogger2/8173/3880/1600/Ins10.gif"><img style="FLOAT: left; MARGIN: 0px 10px 10px 0px; CURSOR: hand" alt="" src="http://photos1.blogger.com/blogger2/8173/3880/200/Ins10.png" border="0" /></a> 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.<br /><br /><br /><br /><br /><br /><br /><a href="http://photos1.blogger.com/blogger2/8173/3880/1600/Ins11.gif"><img style="FLOAT: left; MARGIN: 0px 10px 10px 0px; CURSOR: hand" alt="" src="http://photos1.blogger.com/blogger2/8173/3880/200/Ins11.png" border="0" /></a> 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<br /><br /><br /><br /><br /><br /><br /><a href="http://photos1.blogger.com/blogger2/8173/3880/1600/Ins12.gif"><img style="FLOAT: left; MARGIN: 0px 10px 10px 0px; CURSOR: hand" alt="" src="http://photos1.blogger.com/blogger2/8173/3880/200/Ins12.png" border="0" /></a> 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.<br /><br /><br /><br /><br /><br /><br /><a href="http://photos1.blogger.com/blogger2/8173/3880/1600/Ins13.gif"><img style="FLOAT: left; MARGIN: 0px 10px 10px 0px; CURSOR: hand" alt="" src="http://photos1.blogger.com/blogger2/8173/3880/200/Ins13.png" border="0" /></a> The installer will now perform a check for all the OS utilities disk space permissions port availability and display the results.<br /><br /><br /><br /><br /><br /><br /><br /><a href="http://photos1.blogger.com/blogger2/8173/3880/1600/Ins14.gif"><img style="FLOAT: left; MARGIN: 0px 10px 10px 0px; CURSOR: hand" alt="" src="http://photos1.blogger.com/blogger2/8173/3880/200/Ins14.png" border="0" /></a> You will be prompted to start the installation of oracle applications in the next screen.<br /><br /><br /><br /><br /><br /><br /><br /><a href="http://photos1.blogger.com/blogger2/8173/3880/1600/Ins16.gif"><img style="FLOAT: left; MARGIN: 0px 10px 10px 0px; CURSOR: hand" alt="" src="http://photos1.blogger.com/blogger2/8173/3880/200/Ins16.png" border="0" /></a></p><p>After the installation is completed a post installation sheck will be done to ensure that all the services are working as desired.</p><p> </p><p> </p><p> </p><p>The installtion described above was single node installation of PROD instance of Oracle Applications on a Linux environment.</p>Samhttp://www.blogger.com/profile/02503978840124498130noreply@blogger.com60tag:blogger.com,1999:blog-31793133.post-90125905896935752402006-09-20T04:39:00.000-07:002006-09-20T04:54:21.005-07:00<strong>Multi Node to Single Node Cloning</strong><br /><br />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.<br /><br />This is accomplished by the <strong><em>Shared APPL_TOP</em></strong> and <strong><em>Merging APPL_TOP</em></strong> features.<br /><br />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)<br /><br /><em>Source System</em> here refers to the multi node system to be cloned<br /><em>Target System</em> refers to the newly to be created single node system<br /><em>Applications Version</em> 11.5.10<br /><em>Operating System</em> Linux ES 4<br /><br />The following Steps are required to be performed on the source system<br /><br /><strong>1. Apply application tier patches using adpatch </strong><br /><br />Apply patch 4038964<br />Apply patch 4175764<br /><br />Both the above patches are include in the <em>consolidated update 2 or CU2</em> so in case you are on 11.5.10.2 or later you can ignore this step.<br /><br /><strong>2. Maintain snapshot information<br /></strong><br />Log in as the applications user on each application tier node and run '<strong><em>Maintain Snapshot Information</em></strong>' by using adadmin.<br /><br /><strong>3. Merge existing APPL_TOPs</strong><br /><strong><br /></strong>Log in to the primary node of your application tier as the application user user and run:<br /><br /><em>$ cd [COMMON_TOP]/admin/scripts/[CONTEXT_NAME]</em><br /><em>$ perl adpreclone.pl appsTier merge</em><br /><br />This will prompt you with option to merge secondary nodes<br /><br />Now log in as the applications user to each of the secondary application tier nodes being merged and run:<br /><br /><em>$ cd [COMMON_TOP]/admin/scripts/[CONTEXT_NAME]</em><br /><em>$ perl adpreclone.pl appltop merge</em><br /><br /><strong>4. Prepare the source system database tier.</strong><br /><br />Log on to the database tier of the source system as the oracle user and run the following commands:<br /><br /><em>$ cd [RDBMS ORACLE_HOME]/appsutil/scripts/[CONTEXT_NAME]</em><br /><em>$ perl adpreclone.pl dbTier</em><br /><br />With this all the pre clone tasks on the source system have been completed.<br /><br />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.<br /><br /><strong>1. Create OS user accounts<br /></strong><br />Create a OS user account for your applications<br /><br /><em>$ useradd -g dba -d [home_directory] -p password username<br /></em><br />Similarly create a OS user account for your database<br /><br /><strong>2. Modify the orainventory to reflect the new location</strong><br /><br /><em>$ vi /etc/oraInst.loc<br /></em><br /><strong>3.</strong> <strong>Copy the following application tier directories</strong><br /><br />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:<br /><br /><em>– [APPL_TOP]<br />– [OA_HTML]<br />– [OA_JAVA]<br />– [COMMON_TOP/util]<br />– [COMMON_TOP/clone><br />– [806 ORACLE_HOME]<br />– [iAS ORACLE_HOME]</em><br /><em></em><br /><strong>4. Copy the required files for merging</strong><br /><strong><br /></strong>Log in as the applications user to each of the secondary source nodes and recursively copy:<br /><br /><em>directory [COMMON_TOP]/clone/appl</em><br /><em>- to -<br />directory [COMMMON_TOP]/clone/appl on the target system node<br /></em><br />Before proceeding with the next steps you must shutdown your oracle applications services and the database on the source system<br /><br /><strong>5. Copy the database tier file system</strong><br /><br />Log on to the source system as the database user<br /><br />Copy the database (DBF) files from the source to the target system<br />Copy the source database ORACLE_HOME to the target system<br /><br />After this you can now startup the database and applications services on your source system and release it for use.<br /><br /><strong>6. Configure the target system database server</strong><br /><br /><br /><br /><p>Log on to the target system as the database user and type the following commands to configure and start the database:<br /><br /><em>$ <rdbms>cd [RDBMS ORACLE_HOME]/appsutil/clone/bin<br />$ perl adcfgclone.pl dbTier<br /></em><br />This will prompt for new ORACLE_SID,ORACLE_HOME,Port Pool,JAVA_TOP and DATA_TOP give the appropriate values matching your target system<br /><br />Once successful this should start your database and listener<br /><br /><strong>7. Configure the application tier server nodes<br /></strong><br />The database and its listener should remain up before executing the next set of commands.<br />Log in to the merged APPL_TOP node as the applications user and execute the following commands:<br /><br /><em>$ cd [COMMON_TOP]/clone/bin<br />$ perl adcfgclone.pl appsTier<br /></em><br />This will prompt you new port pool for applictaion tier services as well as new APPLTOP,COMMON_TOP,ORACLE_HOME and IAS_TOP<br /><br />Successful completion of this task will bring up your application tier services on the target or the cloned node.<br /><br /><strong>8. Post Clone Tasks<br /></strong><br />Log in to the target system application tier node as the APPLMGR user.<br />Run the following tasks in adadmin for all products:<br />o generate JAR files<br />o generate message files<br />o relink executables<br />o copy files to destination<br /><br /><br /><strong>9. Clean up of the target system</strong><br /></p>Remove the temporary directory [COMMON_TOP]/clone/appl to reduce disk space usage.<br /><br /><em>Note: The version of Oracle Applications used is 11.5.10 and the operating system is Linux ES 4</em>Samhttp://www.blogger.com/profile/02503978840124498130noreply@blogger.com10tag:blogger.com,1999:blog-31793133.post-20797116009018999732006-09-14T06:45:00.000-07:002006-09-14T06:50:18.896-07:00<strong>JVM</strong><br /><br />JVM or the <strong><em>Java Virtual Machine</em></strong> in Oracle Applications is the core where all java requests are handled. These request can be generated either from the self service web application page, from the Oracle Applications manager console or through a java based concurrent request.<br /><br />The default version of JDK that comes with the latest release of Applications 11.5.10.2 is <strong><em>JDK 1.4.2,</em></strong> although <strong><em>JDK 1.5 has also been certified with 11.5.10 now.</em></strong><br /><br />The <strong><em>mod_jserv</em></strong> component of the Oracle Applications Server is responsible for processing all java requests.<br /><br />The mod_jserv automatically creates a JVM during the startup of Oracle HTTP server (OHS),this JVM will handle all the servlets coming from within a browser.This is done using <em>$IAS_ORACLE_HOME/Apache/Apache/bin/java.sh file.<br /></em><br />mod_jserv uses the <strong><em>Apache JServ Protocol (AJP) </em></strong>to communicate between the HTTPD process and the JVM for processing the Java requests.<br /><br />The <strong><em>jserv.conf</em></strong> file and the <strong><em>jserv.properties</em></strong> file control the behavior of the mod_jserv process and the JVM.<br /><br />Some of the significant parameters which influence jservr performance are<br /><br />The <strong><em>ApJServManual</em></strong> parameter in the jserv.conf file is used here to specify if the JVM will be allocated automatically at the startup of the OHS.<br /><br />The <strong><em>wrapper.bin.parameters</em></strong>=-verbose:gc –Xmx2048M -Xms128M -XX:MaxPermSize=128M -XX:NewRatio=2 -XX:+PrintGCTimeStamps -XX:+UseTLAB in the jserv.properties<br /><br /><em>Verbose:gc</em> means JVM is configured to print output when garbage collector runs<br /><em>–Xmx2048M </em>specifies the maximum memory heap size<br /><em>-Xms128M</em> specifies the minimum amount of memory required<br /><br />According to Oracle, we can increase the maximum heap memory to over 4GB based on the available RAM.<br /><br />The <strong><em>ApJServVMTimeout</em></strong> in jserv.conf is used to specify the amount of time allocated for the JVM to startup or shutdown ,this value should be sufficient to ensure thata garbage collector finishs its job.<br /><br />An improper of an insufficient JVM allocation often results in java errors like the <strong><em>java.lang.OutOfMemoryError and java.lang.NoClassDefFoundError<br /></em></strong><br />In autoconfig enabled Oracle Applications systems the configuration and behavior of JVM can be maintained thought the context file. These can be changed though the Oracle Applications Manager or by using the context editor.<br /><br />You can also get a summary of the Jserv usage from OAM by using the <strong><em>Jserv Usage Summary</em></strong> screen from OAM.<br /><br />You can also use <strong><em>JConsole</em></strong> a utility provided by Sun Microsystems to have a graphical real time monitoring of your JVM usage.<br /><br />The following article provides details on using jconsole.<br /><br />http://java.sun.com/developer/technicalArticles/J2SE/jconsole.html<br /><br />Additionally in oracle applications the jVM usage is catorgorised in the following groups<br /><br /><strong><em>OACoreGroup</em></strong> This is the core group for handeling Java requests<br /><strong><em>DiscoGroup</em></strong> Ths is the JVM groups reserverd for your Discoverer requests<br /><strong><em>FormsGroup</em></strong> This is the JVM that is used in case you have configured your forms server to run in servlet mode<br /><strong><em>XmlSvcsGroup</em></strong> This is the JVM that is used for your XML services like XML gateway.<br /><br />You can increase the number of JVMs for each of these groups through OAM. Each of these JVM will listen on a TCP port from the port range specified in the java.sh file.<br /><br />You can check the status of your jvm though<br /><br /><em>http://[host][domain]:[port]/servlets/IsItWorking or by using Oracle Diagnostics<br /></em>Samhttp://www.blogger.com/profile/02503978840124498130noreply@blogger.com4tag:blogger.com,1999:blog-31793133.post-48690085197556445262006-09-13T05:08:00.000-07:002006-09-13T05:19:32.929-07:00<strong>AD Admin</strong><br /><p><br />Continuing our discussions on ad utilities today i will discuss about the most commonly used ad utility adadmin. <strong><em>Adadmin</em></strong> is a utility that performs a number of tasks required from maintaing and administering an Oracle Applications instance.<br /><br />On a broad level the tasks performed by adadmin can be categorized into <strong><em>database activities</em></strong> and <strong><em>Applications filesystem management tasks</em></strong>.<br /><br />In addition to these, adadmin in 11.5.10 onwards you can use adadmin to put the system in <strong><em>Maintenance Mode</em></strong> also. Maintenance mode is special mode introducted to facilitate maintenance tasks like patch application.<br /><br />Before you run adadmin you must ensure the following.<br /><br />Set your applications environment<br />Ensure that you have sufficient space in tmp disk.<br />For certain adadmin task you may require to shutdown your concurrent managers<br /><br />You can run adadmin by typing adadmin at the command pront afdter seeting the environment.<br /><br /><em>$adadmin</em><br /><br />At the time of execution adadmin prompts you to verify and enter several information pertaining to your applications installation like APPL_TOP location ,ORACLE_HOME.adadmin log file name,batch size etc.<br /><br />Adadmin can also be run in a non interactive mode. This is accomplished by creating a <strong><em>defaults file.</em></strong>The defaults file must be place at the location $APPL_TOP/admin/[sid]/<br /><br />You can create the defaults file with the following syntax<br /><br /><em>$adadmin deafultsfile=$APPL_TOP/admin/[sid]/samtask.txt<br /></em><br />Next time you can run adadmin for the same task by specifying the <em>interactive=no option</em>.<br /><br /><em>adadmin \<br />defaultsfile=APPL_TOP/admin/vis/samtask.txt \<br />logfile=adadmin_091306.log workers=9 \<br />interactive=no<br /></em><br />If your previous session of adadmin had encountred with problems adadmin promts you to either continue with your old session or start with a frest session as show below<br /><br /><em>Your previous AD Administration session did not run to completion.<br />Do you wish to continue with your previous AD Administration session [Yes] ?<br /></em><br /><br />The main menu of adadmin presents you with the following six choices<br /><br /> AD Administration Main Menu<br /> --------------------------------------------------<br /><br /> 1. Generate Applications Files menu<br /><br /> 2. Maintain Applications Files menu<br /><br /> 3. Compile/Reload Applications Database Entities menu<br /><br /> 4. Maintain Applications Database Entities menu<br /><br /> 5. Change Maintenance Mode<br /><br /> 6. Exit AD Administration<br /><br />First two options are related to maintaining applicvations file system the second twop options relate to database activities ,the fifth option here is used to put the system in maintenance mode and bring it back from maintenance mode.</p><p><br />Under the Generate Applications Files Menu you can perform the following tasks<br /><br /> Generate Applications Files<br /> ----------------------------------------<br /><br /> 1. Generate message files<br /><br /> 2. Generate form files<br /><br /> 3. Generate report files<br /><br /> 4. Generate graphics files<br /><br /> 5. Generate product JAR files<br /><br /> 6. Return to Main Menu<br /><br /><br />Under the Maintain Applications Files menu you can perform the following tasks<br /><br /> Maintain Applications Files<br /> ----------------------------------------<br /><br /> 1. Relink Applications programs<br /><br /> 2. Create Applications environment file<br /><br /> 3. Copy files to destinations<br /><br /> 4. Convert character set<br /><br /> 5. Maintain snapshot information<br /><br /> 6. Check for missing files<br /><br /> 7. Return to Main Menu<br /><br /><br />Under the Compile/Reload Applications Database Entities menu you can perform the following tasks<br /><br /> Compile/Reload Applications Database Entities<br /> ---------------------------------------------------<br /><br /> 1. Compile APPS schema<br /><br /> 2. Compile menu information<br /><br /> 3. Compile flexfields<br /><br /> 4. Reload JAR files to database<br /><br /> 5. Return to Main Menu<br /><br /><br />Under the Maintain Applications Database Entities menu you can perform the following tasks<br /><br /> Maintain Applications Database Entities<br /> ---------------------------------------------------<br /><br /> 1. Validate APPS schema<br /><br /> 2. Re-create grants and synonyms for APPS schema<br /><br /> 3. Maintain multi-lingual tables<br /><br /> 4. Check DUAL table<br /><br /> 5. Maintain Multiple Reporting Currencies schema<br /><br /> 6. Return to Main Menu<br /><br />Under the Change Maintenance Mode you can do the following<br /><br /> Change Maintenance Mode<br /> ----------------------------------------<br /><br />Maintenance Mode is currently: [Disabled].<br /><br /><br />Maintenance mode should normally be enabled when patching<br />Oracle Applications and disabled when users are logged on<br />to the system. See the Oracle Applications Maintenance<br />Utilities manual for more information about maintenance mode.<br /><br /><br />Please select an option:<br /><br /> 1. Enable Maintenance Mode<br /><br /> 2. Disable Maintenance Mode<br /><br /> 3. Return to Main Menu<br /><br /></p><p>If you noitice the message this menu selection also shows the maintenance status (disabled in our case) of the system.<br /><br />You can also forcefully exit adadmin at any point of time by typing <strong><em>'abort'</em></strong>,This will however result in a unclean exit of adadmin and the next time when you run adadmin you will be prompted with the option to start fresh or continue with the previous session as described earlier<br /><br />To know more about the individual tasks performed by admin refer to the <em>'Maintaining Oracle Applications Documentation Set' </em><a href="http://download-uk.oracle.com/docs/cd/B25516_08/current/html/docset.html">at the applications documentation library</a><em>.</em><br /> </p>Samhttp://www.blogger.com/profile/02503978840124498130noreply@blogger.com47tag:blogger.com,1999:blog-31793133.post-82703987501412127402006-09-12T06:55:00.000-07:002006-09-12T07:09:32.775-07:00<span style="font-weight: bold;">Autoconfig</span><o:p> </o:p> <p class="MsoNormal">An Oracle Applications instance has its configuration details that are stored and used in multiple files. Managing these configurations manually would have been a night mare without autoconfig. My friends who have worked with 11.0.3 and earlier versions would understand the pain better than anyone else. Though in 11.0.3 the number of configuration files were numbered and could be tracked with a little effort.<o:p></o:p></p> <p class="MsoNormal">But not so in the case of 11i.Thankfully we have autoconfig to do up the messy job for us now.<o:p> </o:p></p> <p class="MsoNormal"><span style="font-weight: bold; font-style: italic;">Autoconfig</span> is a utility which is shipped with the latest releases of Oracle Applications that manages all the configuration files in oracle Applications.</p><p class="MsoNormal">Autoconfig has been defined by oracle '<span style="font-style: italic;">as a tool which that simplifies and standardizes configuration management tasks in an Oracle Applications environment</span>'.<o:p></o:p></p> <p class="MsoNormal">But where does autoconfig get the configuration information from? For this autoconfig relies on a file called the <span style="font-weight: bold; font-style: italic;">context file</span>.<o:p></o:p></p> <p class="MsoNormal">The context file is an XML file in the format <span style="font-style: italic;">[sid]_[hostname].</span>xml.This xml file stores all the configuration details of your oracle applications system like the web port number, database names etc.<o:p></o:p></p> <p class="MsoNormal">There are separate context files for the database tier and the applications tier. <o:p></o:p></p> <p class="MsoNormal">The <span style="font-style: italic;">[context_name]</span> variable used here is an equivalent of <span style="font-style: italic;">[sid]_[hostname]</span><o:p></o:p></p> <p class="MsoNormal">The location of the context file on the application tier is <o:p> </o:p></p> <p class="MsoNormal"><span style="font-style: italic;">$APPL_TOP/admin/[context_name].xml</span><o:p></o:p></p> <p class="MsoNormal">The location of the context file for the databse tier is <o:p> </o:p></p> <p class="MsoNormal"><span style="font-style: italic;">$ORACLE_HOME/appsutil/[context_name].xml</span><o:p></o:p></p> <p class="MsoNormal">Additionally if the applications is spread across multiple nodes each node will have its separate context file.<o:p></o:p></p> <p class="MsoNormal">Autoconfig reads the information that is present in theses context files and updates the corresponding configuration files like appsweb.cfg, jserv.conf to name a couple.<o:p></o:p></p> <p class="MsoNormal">But how do these context files get the information from? in previous versions of Oracle Applications we had a utility called the <span style="font-weight: bold; font-style: italic;">context editor</span> which was used to update the context files. This has now been replaced by the <span style="font-weight: bold; font-style: italic;">Oracle Applications Manager</span>.<o:p></o:p></p> <p class="MsoNormal">Context files should now be edited only through OAM and never manually.<o:p></o:p></p> <p class="MsoNormal">In case the context file is lost, you can regenerate your context file using the <span style="font-weight: bold; font-style: italic;">adbldxml.pl</span> script<o:p></o:p></p> <p class="MsoNormal">Once a particular context value is updated in OAM and saved, the changes are not propagated across the configuration files till you run autoconfig.<o:p></o:p></p> <p class="MsoNormal">Apart form the context file autoconfig also makes use of the <span style="font-weight: bold; font-style: italic;">template files</span>. Each configuration files that is going to be updated by autoconfig had a corresponding template file. Autoconfig compares the value from the context file with the template file before writing into the corresponding configuration file.</p> <p class="MsoNormal"><span style="font-weight: bold; font-style: italic;">Driver files</span> are also used by autoconfig, the driver files contain specific commands that may be required to be executed to update certain values at the database level.</p> <p class="MsoNormal">Autoconfig is run by executing the shell script <span style="font-weight: bold; font-style: italic;">adautocfg.sh </span>which in turn calls for the <span style="font-weight: bold; font-style: italic;">adconfig.sh</span> which calls the perl script <span style="font-weight: bold; font-style: italic;">adconfig.pl</span>.<o:p></o:p></p> <p class="MsoNormal">The applications environment must be set before executing autoconfig, also since autoconfig will require a connection to your database you must ensure that the database and listener is up before running autoconfig.<o:p><br /></o:p></p> <p class="MsoNormal">Autoconfig is enabled in all latest releases of 11i,in case you want to implement autoconfig to an earlier 11i instance you can follow the instructions given in metalink note <a href="https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=165195.1">165195.1</a><o:p></o:p></p>Samhttp://www.blogger.com/profile/02503978840124498130noreply@blogger.com3tag:blogger.com,1999:blog-31793133.post-56885367778784969652006-09-11T06:05:00.000-07:002006-09-11T06:16:55.132-07:00<p class="MsoNormal"><span style="font-weight: bold;">Oracle Applications File System.</span><o:p></o:p></p> <p class="MsoNormal">A proper understanding of the file system that Oracle Applications implements is critical for efficiently working with and managing Oracle Applications.<o:p></o:p></p> <p class="MsoNormal">The below discussion only a brief overview of the Applications file system and directory structures<span style=""> </span>and does not include shared application tier file system.<o:p></o:p></p> <p class="MsoNormal">The final structure your application file system takes depends upon the input parameters that you give while executing <span style="font-style: italic;">rapidinstall</span>, it is carried across multiple nodes with the help of the <span style="font-style: italic;">config.txt</span> which stores these parameters.<o:p></o:p></p> <p class="MsoNormal">The <span style="font-style: italic;">[dbname]</span> in this blog refer to your database name and generally the SID of your database which is also specified at the time of executing rapidinstall for installing oracle applications.<o:p></o:p></p> <p class="MsoNormal">Since the installation start with the DB node first we will first talk about the DB Tier.<o:p> </o:p></p> <p class="MsoNormal">On the DB tier there two main top level directories which are <span style="font-weight: bold; font-style: italic;">[dbname]DATA and [dbname]DB</span>.<o:p></o:p></p> <p class="MsoNormal">The <span style="font-style: italic; font-weight: bold;">[dbname]DATA</span> is also reffred as the <span style="font-weight: bold; font-style: italic;">DATA_TOP</span> contains all the datafiles (<span style="font-style: italic;">.dbf</span>) for the various tablespaces of your database. These include your System tablespace, Applications Tablespace, Temporary table Space etc. All the<span style=""> </span>datafiles must reside within the DATA_TOP.It is however possible to have multiple DATA_TOPs within a Oracle Applications Instance, this is<br />particularly useful for spreading across your datafiles across multiple mount points or disks.<o:p></o:p></p> <p class="MsoNormal">The second important top level directory of the database tier is <span style="font-style: italic; font-weight: bold;">[dbname]DB</span>. This contains your 9i ORACLE_HOME (as in the case of 11.5.10).That is under this directory all the files need to run and maintain you database reside.any database upgrade like upgrading your applications database to 10g would involve upgrading this ORACLE_HOME.<o:p></o:p></p> <p class="MsoNormal">Coming to the Applications Tier there are three important top level directories.<o:p></o:p></p> <p class="MsoNormal"><span style="font-weight: bold; font-style: italic;">[dbname]APPL,[dbname]COMN and [dbname]ORA</span><o:p></o:p></p> <p class="MsoNormal">The <span style="font-style: italic; font-weight: bold;">[dbname]APPL</span> is also know as your <span style="font-weight: bold; font-style: italic;">APPL_TOP</span>. The APPL_TOP contains the core technology files required for Oracle Applications it also contains individual subdirectories for all oracle applications products. For eg under the [dbname]APPL or the APPL_TOP you would find directories for <span style="font-style: italic;">AD,FND,GL</span> etc. These product directories are also know as PRODUCT_TOPs like AD_TOP,GL_TOP etc. Each of the product directories have the sub directories like admin, driver, import, odf, sql, bin, forms,reports etc.<o:p></o:p></p> <p class="MsoNormal">The second TOP level directory under the applications tier is the <span style="font-weight: bold; font-style: italic;">[dbname]COMN</span>. This is also referred to as your COMMON_TOP.The <o:p></o:p></p> <p class="MsoNormal"><o:p></o:p></p> <p class="MsoNormal"><span style="font-weight: bold; font-style: italic;">COMMON_TOP</span> contains files that are commonly used by different Oracle applications products as well as any third party applications that may have been integrated with Oracle applications.<o:p></o:p></p> The COMMON_TOP contains sub following sub directories.<o:p></o:p><ul><li><span style="font-style: italic;">admin</span> which holds the place for concurrent manager log and out files in the log and out sub directories respectively. Also it contains a scripts subdirectory.<o:p></o:p></li><li><span style="font-style: italic;">html</span> which is also referred by the environment variable OA_HTML contains the HTML files, JSP,CSS and Java scripts that are used by Oracle Applications.<o:p></o:p></li><li><span style="font-style: italic;">java</span> subdirectory which holds the jar files, this is also referred to as the JAVA_TOP.<o:p> </o:p></li><li>scripts subdirectory that contains the machine admin scripts like the adstpall.sh<o:p></o:p></li><li><span style="font-style: italic;">util</span> subdirectory contains third party utilities that are used in oracle applications like JRE from sun microsystems<o:p> </o:p></li><li><span style="font-style: italic;">Temp</span> subdirectory used for caching<o:p></o:p></li><li><span style="font-style: italic;">Portal</span> subdirectory used to delivery rapid install portal pages.<o:p> </o:p></li></ul> <p class="MsoNormal">The third top level directory under application tier is the <span style="font-weight: bold; font-style: italic;">[dbname]ORA</span> directory.This contains the <span style="font-weight: bold; font-style: italic;">IAS ORACLE HOME and the 8.0.6 ORACLE HOME</span>.<o:p></o:p></p> <p class="MsoNormal">Apart from the Database ORACLE_HOME 11i uses two other ORACLE_HOMES.The first is the <span style="font-weight: bold; font-style: italic;">8.0.6 ORACLE HOME</span>.This is used for developer 6i products which are forms reports and graphics. The applications executables also link with the 8.0.6 libraries.<o:p></o:p></p> <p class="MsoNormal"><span style="font-weight: bold; font-style: italic;">IAS ORACLE HOME</span> is the ORACLE HOME used by the 9iAS application server which is the primary web server for Oracle Applications.<o:p><br /><br /></o:p></p>Samhttp://www.blogger.com/profile/02503978840124498130noreply@blogger.com3tag:blogger.com,1999:blog-31793133.post-84837165193168000442006-09-08T00:23:00.000-07:002006-09-08T00:29:04.995-07:00<p class="MsoNormal"><span style="font-weight: bold;">Oracle Diagnostics.</span><o:p></o:p></p> <p class="MsoNormal">Oracle diagnostics is one of the tools that aim at achieving enhanced supportability for your Oracle Applications instance.<o:p></o:p></p> <p class="MsoNormal">Oracle diagnostics provides a series of predefined test that can be run against your ebusiness suite to determine any performance or configuration bottlenecks. The diagnostics tests are divided into various categories ranging form technical and functional areas. Separate test groups are created for each application with oracle applications like General Ledger, Applications DBA etc. For each product the tests are further categorized into problem areas like installation issues, data issues customizations etc.<o:p></o:p></p> <p class="MsoNormal">A periodic execution of these test is recommended by oracle to check the sanity of your Oracle Applications instance over a period of time.<o:p></o:p></p> <p class="MsoNormal">Oracle diagnostics test are mostly written in <span style="font-weight: bold; font-style: italic;">JSP,JAVA or PLS/SQL </span>with the user interface mostly being web based in the form of <span style="font-weight: bold; font-style: italic;">HTML or JSP</span>.(Though there is also a command line interface available).<o:p></o:p></p> <p class="MsoNormal">The web based interface for Oracle diagnostics can either be launched from <span style="font-weight: bold; font-style: italic;">Oracle Applications Manager or via the CRM administrators console</span> (<span style="font-style: italic;">http://<domain_name>/OA_HTML/jtflogin.jsp</domain_name></span>).<o:p></o:p></p> <p class="MsoNormal">The web base interface can be launched either as standalone HTML user via the URL <span style="font-style: italic;">http://<host>:<port>/OA_HTML/jtfqalgn.htm</port></host></span> or as an administrative -level user through the CRM administrators console or Oracle Applications Manager Console.<o:p></o:p></p> <p class="MsoNormal">The command line interface can be used by the following command <o:p> </o:p></p> <p class="MsoNormal">java -DJTFDBCFILE=<dbc> -Dframework.Logging.system.filename=<frameworklogfile><br />-Dservice.Logging.common.filename=<service> oracle.apps.jtf.regress.qatool.QAConsole<o:p> </o:p></service></frameworklogfile></dbc></p> <p class="MsoNormal">Apart from the predefined test Oracle diagnostics also allows for creating custom test and unit test cases. You can also create most of these test using user Interface also that is without any coding involved.<o:p></o:p></p> <p class="MsoNormal">Oracle diagnostics tools are come as a product within Oracle Applications with the product name IZU. In case your Oracle Applications instances does not have this product, you must first install this product using AD Splicer.<o:p></o:p></p> <p class="MsoNormal">The results of the diagnostics test can be viewed as a report in a web based user interface for a particular diagnostics test <span style=""></span>session. This output can be saved to the local PC and uploaded to metalink for further support. The diagnostics test results and the associated statistics are also available at the database level in the following tables <span style="font-weight: bold; font-style: italic;">JTF_DIAGNOSTIC_LOG and JTF_DIAGNOSTIC_STATS.</span><o:p></o:p></p> <p class="MsoNormal">Further you can also use Oracle Applications Manager to schedule automatic execution of diagnostics tests.<o:p> </o:p></p> <p class="MsoNormal">Since the results of the diagnostics test might contain potentially sensitive data segregated diagnostic roles are available to restrict the type of test available to a particular user. Diagnostic roles include <span style="font-style: italic;">Super User, Application User, End User and Anonymous user.</span><o:p></o:p></p> <p class="MsoNormal">The latest release of Oracle diagnostics is 2.4,once you have installed/available IZU in Oracle Applications you can apply the latest Oracle diagnostics 2.4 test using adpatch. However its important to note that Oracle Diagnostics can be installed only on <span style="font-weight: bold; font-style: italic;">systems 11.5.4 and higher</span>. Also <span style="font-weight: bold; font-style: italic;">JDK 1.3.1 or higher</span> is recommend to use oracle diagnostics.<o:p></o:p></p> <p class="MsoNormal">This current version of Oracle diagnostics tools are launched directly within Oracle applications. Once you have completed the installation of Oracle diagnostics you can assign the seeded responsibility '<span style="font-style: italic;">Oracle Diagnostics Tool</span>' to any valid ebusiness suite user.<o:p></o:p></p> <p class="MsoNormal">You can refer to metalink note <a href="http://metalink.oracle.com/metalink/plsql/ml2_documents.showNot?p_id=358831.1">358831.1</a> for details instructions on doing this.<o:p><br /></o:p></p> <p class="MsoNormal">Complete reference on Oracle Diagnostics is also available in the Oracle Applications Supportability Guide in the <a href="http://www.oracle.com/technology/documentation/applications.html">applications documentation CD</a>.<o:p></o:p></p>Samhttp://www.blogger.com/profile/02503978840124498130noreply@blogger.com28tag:blogger.com,1999:blog-31793133.post-1157460857099552142006-09-05T05:44:00.000-07:002006-09-05T05:54:17.156-07:00<p class="MsoNormal"><span style="font-weight: bold;">XML Gateway</span><o:p></o:p></p> <p class="MsoNormal">It feels good to be back in business that is back to blogging. A huge backlog of mails kept me occupied yesterday, today i will talk briefly about <span style="font-weight: bold; font-style: italic;">Oracle XML Gateway</span> as component of Oracle Applications. This is only indented to be a conceptual introduction and for the complete details you must refer to the user guide or appropriate metalink note.</p><p class="MsoNormal">XML Gateway is a tool that facilitates the communication between the Oracle E business suite and third party applications or trading partners in the form of well formatted XML messages.</p> <p class="MsoNormal">XML Gateway ensures that both <span style="font-weight: bold; font-style: italic;">business to business (B2B) and Application to Application(A2A) requirements</span> are met. Further XML<span style=""> </span>Gateway ensures that the messages that are generated or consumed are compliant with the standards set by the <span style="font-weight: bold; font-style: italic;">Open</span><br /><span style="font-weight: bold; font-style: italic;">Applications Group</span>. You can find more information on these standards at <a href="http://www.openapplications.org/">http://www.openapplications.org</a><o:p></o:p></p> <p class="MsoNormal">Oracle XML Gateway works with Oracle Workflow to consume events raised and generate XML messages. These messages are further propagated using <span style="font-weight: bold; font-style: italic;">Oracle Advanced queuing technology and Oracle Transport agent(OTA)</span>.<o:p></o:p></p> <p class="MsoNormal">Inbound and outbound messages are managed in queue table using Oracle Advanced Queuing.<o:p> </o:p></p> <p class="MsoNormal">The OTA is used to deliver messages to a trading partner over HTTP or HTTPs. An OTA servlet running with Oracle Applications is also responsible for receiving inbound documents sent by the trading partner.<o:p></o:p></p> <p class="MsoNormal">Oracle XML gateway can be considered as a form of EDI, whereas in a normal EDI transaction the operation happens in a batch in case of XML gateway the message are more real time as they are based of events.<o:p></o:p></p> <p class="MsoNormal">Oracle XML gateway makes use of the uses <span style="font-weight: bold; font-style: italic;">Web Services Description Language (WSDL)</span> to facilitate trading partners to communicate with Oracle Applications. Trading partners can use third party web service tools to call the web services publish by your Oracle Applications.<o:p></o:p></p> <p class="MsoNormal">It also uses the <span style="font-weight: bold; font-style: italic;">Java Messaging Service(JMS) </span>to send messages between Oracle Applications and trading partners.<o:p></o:p></p> <p class="MsoNormal">At the core of Oracle XML Gateway lies the execution engine, this is responsible for interacting with other oracle technologies like Oracle Workflow etc to consume and generate messages between trading partners as in the case of a B2B communication.<o:p></o:p></p> <p class="MsoNormal">Oracle XML Gateway supports the SMTP, HTTP, HTTPS, JMS transport protocols for message delivery and consumption.<o:p></o:p></p> <p class="MsoNormal">Oracle XML Gateway uses the Message Designer to define message maps, message maps are required to specify the data source and data target for the document. You can also use Map creation wizards that are provided for this purpose.<o:p></o:p></p> <p class="MsoNormal">The message designer and wizard is a client software which is required to be installed separately on the client PCs.<br /></p> <p class="MsoNormal">Message map files have a <span style="font-style: italic;">.xgm</span> extension. Message maps that are created on the loacle /client system have to be loaded to the middle tier APPL_TOP.<o:p></o:p></p> <p class="MsoNormal">The <span style="font-style: italic;">java LoadMap</span> and <span style="font-style: italic;">java DeleteMap</span> are used to load and delet message maps on the middle tier server.<o:p> </o:p></p> <p class="MsoNormal">Its important to note that before you crate your message maps for your document you must ensure that the document conforms to the<span style=""> </span><span style="font-weight: bold; font-style: italic;">Document Type Definition(DTD)</span>.Pre defined DTD are installed and loaded in the $APPLTOP of the middle Tier. You can however load custom DTD that you can define using the Oracle Message Designer to the middle tier as well as modify existing DTD and delete existing DTD.<o:p></o:p></p> <p class="MsoNormal">The DTD files are created with the <span style="font-style: italic;">.dtd</span> extension.<o:p></o:p></p> <p class="MsoNormal">The <span style="font-style: italic;">java DeleteDTDFromClob</span> and <span style="font-style: italic;">java LoadDTDToClob</span> are used for deleting and loading DTDs respectively.For complete syntax and example to load and delet DTDs refer to the Oracle XML Gateway users guide.<o:p></o:p></p> <p class="MsoNormal">You can use the Oracle Applications responsibility '<span style="font-style: italic;">XML Gateway Responsibility</span>' to define trading partners and transactions.<o:p></o:p></p> <p class="MsoNormal">In releases 11.5.7 onwards XML gateway is distributed as a part of AOL and does not require to be licensed or installed separately. For prior releases XML Gateway can be installed by applying patch 2440710.<o:p></o:p></p> <p class="MsoNormal">The metalink note <a href="https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=152775.1">152775.1</a> contains full instructions for installing and configuring Oracle XML Gateway.<o:p></o:p></p> <p class="MsoNormal">You can verify your XML gateway installation byu executing the following sql script <o:p></o:p></p> <p class="MsoNormal"><span style="font-style: italic;">SQL> $ECX_TOP/patch/115/sql/ECXTEST.sql</span><o:p></o:p></p> <p class="MsoNormal">this will create a OUTnnn.xml if the installation and configuration of XML Gateway is successful.</p>Samhttp://www.blogger.com/profile/02503978840124498130noreply@blogger.com39tag:blogger.com,1999:blog-31793133.post-1156514638530485122006-08-25T07:03:00.000-07:002006-08-25T07:05:20.356-07:00<span style="font-weight: bold; font-style: italic;">Notice:</span><br /><br />I am travelling to europe on business so i wont be blogging next week,will resume once back.<br /><br />SamSamhttp://www.blogger.com/profile/02503978840124498130noreply@blogger.com13tag:blogger.com,1999:blog-31793133.post-1156514120997869872006-08-25T06:51:00.000-07:002006-08-25T06:55:21.013-07:00<p class="MsoNormal"><span style="font-weight: bold;">Ad Relink</span><o:p></o:p></p> <p class="MsoNormal">Continuing my series on the AD Utilities in todays post i will blog about <span style="font-weight: bold; font-style: italic;">AD Relink</span>.</p><p class="MsoNormal">AD Relink is a utility that is used to Oracle Applications Executables the Oracle8 Server product libraries contained within the Oracle Applications Technology Stack ORACLE_HOME.<o:p></o:p></p> <p class="MsoNormal">In other words AD Relink is used to regenerate an Oracle Applications executable using the Oracle Applications Tech Stack libriries.<o:p></o:p></p> <p class="MsoNormal">A unique feature of AD relink is that it is not a executable like other Ad utilities it is in fact a shell script that uses the <span style="font-weight: bold; font-style: italic;">UNIX 'make' command</span>. In windows environment therefore its important to have <span style="font-weight: bold; font-style: italic;">MKS Toolkit or CYGWIN</span> in the path before using AD Relink.It does this by reading the product definition from the <span style="font-weight: bold; font-style: italic;">{prod}.mk</span> file. This file is located at PROD_TOP/lib location. AD Relink will fail in case the files are missing, courupted or a newer version of the file is required.<o:p></o:p></p> <p class="MsoNormal">Relinking may be required under various scenarios like an executable getting corrupt or lost. Relinking is also recommended after cloning upgrades and patching. But mostly Auto Patch will take care of the relinking process at the end of the patching.<o:p></o:p></p> <p class="MsoNormal">The following is the syntax for AD Relink<o:p> </o:p></p> <p class="MsoNormal"><span style="font-style: italic;">adrelink.sh force={y | n} [optionalargs] <targets></targets></span><o:p></o:p></p> <p class="MsoNormal">Force here is used to specify wether to relink regardless of the status of the library or object files.<o:p></o:p></p> <p class="MsoNormal">Optional Args include back_mode used to specify to backup the executable before relinking.<br />The values for this are 'all','file'(backs up the executables metioned in the adrelinkbk.txt,this is also the default value) and 'none'.<o:p></o:p></p> <p class="MsoNormal"><span style="font-style: italic;">Eg: adrelink.sh force=y “ad adpatch”</span><o:p></o:p></p> <p class="MsoNormal">AD Relink is run after logging into the system as the 'applmgr' user and setting the environment.<br />The following environment variables must be set properly before using AD Relink<br /><span style="font-style: italic;">PATH, ORACLE_HOME,APPL_TOP, ORACLE_SID or TWO_TASK, LD_LIBRARY_PATH, and SHLIB_PATH (HP specific)</span><o:p> </o:p></p> <p class="MsoNormal">Also you must use <span style="font-weight: bold; font-style: italic;">AD Relink to relink only AD executables</span> to relink other executables it is recommended to used ADADMIN instead. Eg if you wish to Relink your <span style="font-style: italic;">FNDLIBR</span> (Your concurrent Manager executable) you should use adadmin and choose the '<span style="font-style: italic;">Maintain Applications Files</span>' option, though you could do the same with AD Relink also.<o:p></o:p></p> <p class="MsoNormal">By default AD Relink creates a log file of the actions performed and the errors encounterd in the linking process at the location from where the AD Relink command was run.<o:p><br /></o:p></p> <p class="MsoNormal">It is recommended that you shutdown services of the tier for whose executables you are relinking.<o:p></o:p></p> <p class="MsoNormal">You cannot relink non Oracle Applications executable using AD Relink for that you must use the make command manually.<br /><span style="font-style: italic;">eg: make -f ins_rdbms.mk install.</span><o:p></o:p></p>Samhttp://www.blogger.com/profile/02503978840124498130noreply@blogger.com1tag:blogger.com,1999:blog-31793133.post-1156420175353464102006-08-24T04:42:00.000-07:002006-08-24T05:11:30.570-07:00<p class="MsoNormal"><span style="font-weight: bold;">AD Splicer</span><o:p></o:p></p> <p class="MsoNormal">Oracle Applications provides quite a few utilities which are aimed at effective maintenance and monitoring an Oracle Applications instance. In my next posts i will talk about these UNIX utilities which are also referred to as <span style="font-weight: bold; font-style: italic;">AD utilities</span>.<o:p></o:p></p> <p class="MsoNormal">Today i used AD Splicer so i will start with this one.</p><p class="MsoNormal">AD Splicer is a utility used to add an <span style="font-weight: bold; font-style: italic;">off-cycle</span> product into Oracle Applications.<o:p></o:p></p> <p class="MsoNormal">Products which have been released between the base releases of 11i are referred to an off-cycle product. Once AD Splicer is used to splice these off-cycle products into Oracle Applications they are recognized by other AD utilities like AD Patch as a valid Oracle Applications product for a given release.<o:p></o:p></p> <p class="MsoNormal">In a multi node environment adsplicer should be used on all the APPL_TOPs.It is recommended to run AD Splice on the <span style="font-weight: bold; font-style: italic;">Admin node first</span>.<o:p></o:p></p> <p class="MsoNormal">Before using AD Splice you are required to add the new tablespace for the new products that are going to be added. In case you have migrated to the Oracle Applications new tablespace model you would require to create a new tablespace <span style="font-weight: bold; font-style: italic;">APPS_TS_TOOL</span>s manually before using AD Splicer.<o:p></o:p></p> <p class="MsoNormal">Ad Splicer makes use of the following <span style="font-weight: bold; font-style: italic;">control files</span> to add the new off-cycle product into oracle applications.<o:p></o:p></p> <p class="MsoNormal"><span style="font-weight: bold; font-style: italic;"><prod>[prod]prod.txt</prod></span> : This is a product definition file which contains the language independent information about the product. <o:p></o:p></p> <p class="MsoNormal"><span style="font-weight: bold; font-style: italic;"><prod>[prod]terr.txt</prod></span> : This is also a product definition file containing language-specific information about the new product.<o:p></o:p></p> <p class="MsoNormal">Both these product definition files should not be edited manually.<o:p></o:p></p> <p class="MsoNormal">For example the product definition files for the off-cycle product Web ADI are <span style="font-style: italic;">bneterr.txt and bneprod.txt </span><o:p><br /></o:p></p> <p class="MsoNormal"><span style="font-weight: bold; font-style: italic;">newprods.txt</span> : This file is also know as the product configuration file. You can edit this file optionally. This file acts as a template for configuring the new product that would be added. It comprises of a list of parameters which include<o:p></o:p></p> <p class="MsoNormal"><span style="font-style: italic;">product</span>- The product being added eg.bne .This must not be changed.<o:p></o:p></p> <p class="MsoNormal"><span style="font-style: italic;">base_product_top</span> - This is the base path where the files for the new product will be places using the Oracle applications filesystem architecture. the default value for this is APPL_TOP.<o:p></o:p></p> <p class="MsoNormal"><span style="font-style: italic;">oracle_schema</span> -<span style=""> </span>This parameter refer to the oracle schema which is the owner of the new product to be added.<o:p></o:p></p> <p class="MsoNormal"><span style="font-style: italic;">sizing_factor</span> -<span style=""> </span>The sizing factor which is to be followed for table and index creation.<o:p style="font-style: italic;"></o:p></p> <p class="MsoNormal"><span style="font-style: italic;">main_tspace</span> - The tablespace for product tables<o:p style="font-style: italic;"></o:p></p> <p class="MsoNormal"><span style="font-style: italic;">index_tspace</span> - The tablespace for product indexes<o:p></o:p></p> <p class="MsoNormal">temp_tspace - The tablespace for Oracle schema’s temporary segments<o:p></o:p></p> <p class="MsoNormal"><span style="font-style: italic;">default_tspace</span> - This refers to the default table space for the of the Oracle Schema owning the product.<o:p></o:p></p> <p class="MsoNormal">All the above mentioned control files namely the <span style="font-style: italic;"><prod>prod.txt,<prod>terr.txt and newprods.txt</prod></prod></span> must be placed in <span style="font-style: italic;">$APPL_TOP/admin</span> so that adsplce is able to read them.<o:p></o:p></p> <p class="MsoNormal">Like other Ad utilities AD Splice will also require to make a connection to your database instance using SYSTEM and APPLSYS accounts as a result your <span style="font-weight: bold; font-style: italic;">database and listener must be running</span> while using AD Splice.<o:p></o:p></p> <p class="MsoNormal">An important fact to note is that products that are added through AD Splice are visible to other AD Utilites except autoupgrade.</p>The metalink Note <a href="https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=76708.1"><small>76708.1</small></a> contains further details and instructions on using AD Splice.Samhttp://www.blogger.com/profile/02503978840124498130noreply@blogger.com3tag:blogger.com,1999:blog-31793133.post-1156167995111503752006-08-21T06:46:00.000-07:002006-08-21T06:50:37.373-07:00<p class="MsoNormal"><span style="font-weight: bold;">Oracle Jinitiator</span><o:p></o:p></p> <p class="MsoNormal">Oracle Applications is based upon a thin client architecture. On the desktop Tier you need almost nothing.. Well almost, it does require a certified web browser and the Oracle Jinitiator.<o:p></o:p></p> <p class="MsoNormal">Oracle Jinitiator is a software that provides the <span style="font-weight: bold;">JVM</span> to run oracle form based products which run in the form of a form client applet.The oracle Jinitiator uses its own JVM instead of the browsers JVM.It is isntalled as a plugin ( as in the case of mozilla, Netscape or firefox) or as an Active X component (in case of Internet Explorer).<o:p><br /></o:p></p> <p class="MsoNormal">When Oracle Applications is accessed for the first time from a client PC the Jinitiator is downloaded and installed on the client PC.It is not used for Self Service Web Applications, The JInitiator is invoked only upon clicking a form based application.<o:p></o:p></p> <p class="MsoNormal">After Jinitiator is installed it downloads the form client applet along with the <span style="font-style: italic;">commonly used JAR files</span>, this is done to reduce the network traffic to download JAR files form the server every time.<o:p></o:p></p> <p class="MsoNormal">Jinitiator also performs <span style="font-weight: bold; font-style: italic;">JAR caching, applet caching and incremental JAR loading</span> to improve applications performance.<br />These JAR files are commonly stored under the users profile directory with a folder named <span style="font-weight: bold; font-style: italic;">Oracle Jar Cache.</span><o:p></o:p></p> <p class="MsoNormal"><o:p></o:p>The Oracle Jinitiator executable is stored on the location<span style="font-style: italic;"> $OA_HTML/oajinit.exe</span><o:p></o:p></p> <p class="MsoNormal">Oracle Jinitiator allows only trusted JAR files to run within its JVM. This trust is established by using <span style="font-weight: bold; font-style: italic;">digital signatures</span>. In the current version of Oracle Applications the JAR files are automatically signed with the digital signatures during the install of Oracle Applications using rapidwiz. However you can still change your digital signature and repackageyour <span style="font-weight: bold; font-style: italic;">oajinit.exe</span> for security reasons.<o:p></o:p></p> <p class="MsoNormal">During the installation process rapidwiz automatically creates a file in the applmgr user $HOME directory called <span style="font-weight: bold; font-style: italic;">identitydb.obj</span>, this file has a reference to the SID of the database instance.<o:p></o:p></p> <p class="MsoNormal">If there is a mismatch between this file on the server and that on the clinet PC it often results in the yellow bar problem.<o:p></o:p></p><p class="MsoNormal"><o:p></o:p>The folowing files are created automatically by rapidwiz in the current version of Oracle Applications<o:p></o:p></p> <p class="MsoNormal"><o:p> </o:p></p> <p style="font-style: italic;" class="MsoNormal">$APPL_TOP/admin/appltop.cer<o:p></o:p></p> <p style="font-style: italic;" class="MsoNormal">$APPL_TOP/admin/adsign.txt<o:p></o:p></p> <p class="MsoNormal"><span style="font-style: italic;">$HOME(applmgr)/identitydb.obj</span><o:p></o:p></p> <p class="MsoNormal"><o:p> </o:p></p> <p class="MsoNormal">To create a new digital certificate you can use the <span style="font-weight: bold; font-style: italic;">adjkey</span> command, while the <span style="font-weight: bold; font-style: italic;">adjbuild.sh</span> is used to repackage your jinitiator exe.You can also regenerate your JAR files using <span style="font-weight: bold; font-style: italic;">ADADMIN</span>.<o:p></o:p></p> <p class="MsoNormal"><o:p> </o:p></p> <p class="MsoNormal">A Jinitiator package should typically contain the certificate and the obj file along with the executable.<o:p></o:p></p> <p class="MsoNormal"><o:p> </o:p></p> <p class="MsoNormal">In previous versions of Oracle Applications (earlier to 11.5.9) an unsigned JAR file would result in a <span style="font-style: italic;">yellow bar problem</span>, but in the current release of Oracle Application attempting to load a forms with an unsigned JAR file would fail with an <span style="font-weight: bold; font-style: italic;">a java security exception</span> error.<o:p></o:p></p> <p class="MsoNormal"><o:p> </o:p></p> <p class="MsoNormal">The latest certified versions of Oracle Jinitiator is 1.3.1.26 to run with Oracle E-business Suite 11.5.10, the least certified version is 1.1.8.16 which is used with release 11, though you can use version 1.1.8.X to access your 11i applications it is recommended that you upgrade your Jinitiator to the latest supported version 1.3.1.X.<o:p></o:p></p> <p class="MsoNormal"><o:p> </o:p></p> <p class="MsoNormal">You can follow the metalink note id <a href="http://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=124606.1">124606.1</a> to upgrade your Jinitiator.<o:p></o:p></p> <p class="MsoNormal"><o:p> </o:p></p> <p class="MsoNormal"><o:p> </o:p></p> <p class="MsoNormal">An important fact to remember is that any patch applied through adpatch which contains JAR files, these new JAR files are not signed with the digital signature, after the patch is applied adpatch will <span style="font-style: italic;">regenerate</span> all the JAR files and these new JAR files will be signed and trusted to run within the Jinitiator.<o:p></o:p></p> <p class="MsoNormal">To see a list of supported browsers that are certified to access E-Business Suite reffer to metalink Note id <a href="http://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=285218.1">285218.1</a>.<o:p></o:p></p> <p class="MsoNormal"><br /></p>Samhttp://www.blogger.com/profile/02503978840124498130noreply@blogger.com6tag:blogger.com,1999:blog-31793133.post-1155805399237775552006-08-17T01:56:00.000-07:002006-08-17T02:31:46.876-07:00<p class="MsoNormal"><span style="font-weight: bold;">11i.ATG_PF.H Rollup 4</span><o:p></o:p></p> <p class="MsoNormal">A ATG Rollup Patch (RUP) is released approximately twice every year. It includes the fixes that have been successfully tested and included in the ATG RUP, till it is frozen for release.<o:p> </o:p></p> <p class="MsoNormal">Oracle Applications Technology 11i.ATG_PF.H Rollup 4 has now been released.<o:p></o:p></p> <p class="MsoNormal">ATG_PF.H Rollup 4 is cumulative and contains all the fixes included in 11i.ATG_PF.H Rollup 3 and 11i.ATG_PF.H Rollup 3 contained all the fixes that were included in CU2,which included all fixes of CU1.<br />So in case you have missed out of any of the consolidated updates (CU1 & CU2) or the ATG_PF.H Rollup 3 here is your chance to catch up.<o:p> </o:p></p> <p class="MsoNormal">11i.ATG_PF.H Rollup 4 can be applied only to a 11i instance with 11i.ATG_PF.H. 11i.ATG_PF.H comes with the base installation of 11.5.10, so in case you want to apply this rollup to any instance of Oracle Applications 11.5.9 or earlier you must first upgrade to 11i.ATG_PF.H and then apply 11i.ATG_PF.H Rollup 4<o:p></o:p></p> <p class="MsoNormal">The following products are changed or affect by the current RUP<o:p></o:p></p> <ul><li>Oracle Alert<o:p></o:p></li><li>Oracle Applications Framework<o:p></o:p></li><li>Oracle Workflow<o:p></o:p></li><li>Oracle Application Object Library<o:p></o:p></li><li>Oracle XML Gateway<o:p> </o:p></li></ul> <p class="MsoNormal">The Oracle Applications Technology 11i.ATG_PF.H Rollup 4 also includes <span style="font-style: italic;">Patch 5107107 - TXK (FND & ADX) AUTOCONFIG ROLLUP PATCH N released AUGUST this year.</span><o:p></o:p></p> <p class="MsoNormal">Its important that in case you have implemented Single Sign On using 10g As and OID you must not apply this path but wait for the <span style="font-weight: bold; font-style: italic;">ATG 11.5.10 RUP4 SSO 10g Integration Patch </span>(4775907) due for release late august.<o:p> </o:p></p> <p class="MsoNormal">For SSL configurations you must run the script <span style="font-style: italic;">txkrun.pl -script=InstSSLFix</span> also included within this patch.<o:p> </o:p></p> <p class="MsoNormal">Other post installation tasks include upgrading your <span style="font-weight: bold; font-style: italic;">Oracle XML Parser</span> for Java to v9.0.4 and creating additional tablespace <span style="font-weight: bold; font-style: italic;">APPS_TS_TOOLS</span> before you can use adsplicer to add any additional products, this is not required in case you have not migrated to Oracle Applications Tablespace model.</p> <p class="MsoNormal">Metalink note <a href="https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=365228.1">365228.1</a> contains details about the 11i.ATG_PF.H Rollup 4 and instructions to apply the same.</p>Samhttp://www.blogger.com/profile/02503978840124498130noreply@blogger.com2tag:blogger.com,1999:blog-31793133.post-1155739562768739442006-08-16T07:45:00.000-07:002006-08-16T07:46:03.090-07:00<p class="MsoNormal"><span style="font-weight: bold;">XML Publisher</span><o:p></o:p></p> <p class="MsoNormal">One of the good things that were introduced in 11.5.10 was XML publisher (<span style="font-weight: bold; font-style: italic;">XDO</span>).Though you can install XML publisher with any version of 11i after applying the require pre requisite patches, it comes bundled with 11.5.10 version of Oracle Applications onwards.<o:p><br /></o:p><br />XML publisher is a java based tool which uses data definitions and templates to generate a output of a report in a desired format such as in PDF. It is based on the <span style="font-weight: bold; font-style: italic;">W3C Extensible Style sheet Language (XSL) and uses XSLFO</span> to convert data into a formatting object. A strong feature of the XML publisher is that it allows extensive customization of Oracle Applications reports by making use of templates without requiring high level of technical skills.<o:p></o:p></p> <p class="MsoNormal">You can install XML publisher during the Oracle Applications (11.5.10) installation or register the product later on using license manager through Oracle Applications Manager (OAM).<o:p></o:p></p> <p class="MsoNormal">In case your oracle Applications release is 11.5.9 or earlier you must follow the steps stated in metalink note id <a href="https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=278727.1">278727.1</a> to install XML Publisher.<o:p><br /></o:p></p> <p class="MsoNormal">The XML publisher also comes with a <span style="font-weight: bold; font-style: italic;">desktop component</span>. Two main components of the XML publisher desktop component are <span style="font-weight: bold; font-style: italic;">template builder and template viewer</span>.<o:p></o:p></p> <p class="MsoNormal">The template builder can be integrated with desktop tools like word. Once installed, you get additional features to automate the process of template creation like generation of SQL etc.<o:p><br /></o:p></p> <p class="MsoNormal">The XML publisher essentially comprises of the following modules<o:p></o:p></p><p class="MsoNormal"><o:p></o:p><span style="font-weight: bold;">Data Definition</span>-The XML engine acts as a single point to fulfill all reporting needs for an organization.<o:p></o:p></p> <p class="MsoNormal"><span style="font-weight: bold;">Data Layout/Templates</span>-Templates and the final layout are managed within the XML publisher using a Template Manager, these can be customized using desktop tools like MS Word, excel or Adobe Acrobat. The template manager is also responsible for registering your new templates before they can be used with XML publisher.<o:p></o:p></p> <p class="MsoNormal"><span style="font-weight: bold;">Translation</span> - The XML publisher uses the translation handler to do the required translation at runtime. It can also convert the output into a XLIFF format which can be used by 3rd party translation companies.<o:p></o:p></p> <p class="MsoNormal"><span style="font-weight: bold;">Delivery</span> - The delivery manager is responsible to deliver the output to different destinations like printers,EDI,email etc. The delivery manager also provides flexibility by delivering the same output to different destinations like HTML format can be sent to email while a PDF format sent to the printer.<o:p><br /></o:p></p> <p class="MsoNormal">XML publisher allows <span style="font-weight: bold; font-style: italic;">conditional formatting</span> of the output by using <span style="font-weight: bold; font-style: italic;">XSL or XSL:FO code</span>. Additionally XML publisher can also be used to perform b2b communication by using the <span style="font-weight: bold; font-style: italic;">XML Data Engine</span>.<o:p></o:p></p><p class="MsoNormal">As i stated before the XML publisher can also be used to generate output that can be used for <span style="font-weight: bold; font-style: italic;">EDI or EFT (Electronic Funds Transfer)</span>.To use this feature you must use a <span style="font-weight: bold; font-style: italic;">eText template</span>. These templates are comprised of a series of tables which contain commands and data field definitions.<o:p></o:p></p> <p class="MsoNormal">If you have applied the consolidated update 1 or above you can generate the output using XML publisher through the concurrent request directly by selecting the appropriate template in the concurrent program definition. Incase you have not applied the CU 1 you must first run the concurrent request to generate the XML report and then run a concurrent request to publish the request.<o:p></o:p></p> <p class="MsoNormal">The behavior of XML publisher can be controlled through a set f properties, these properties can be set through the XML publisher administrator interface or you can use the XML publisher properties file <span style="font-weight: bold; font-style: italic;">xdo.cfg</span>. This file can be located at <span style="font-style: italic;"><xdo_top>/resource or alternately at JRE_TOP>/jre/lib.</xdo_top></span><o:p></o:p></p> <p class="MsoNormal">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.<o:p></o:p></p> <p class="MsoNormal"><span style="font-style: italic;">$OA_JAVA/oracle/apps/xdo/common/MetaInfo.class.</span><o:p></o:p></p> <p class="MsoNormal"><o:p> </o:p></p>Samhttp://www.blogger.com/profile/02503978840124498130noreply@blogger.com2tag:blogger.com,1999:blog-31793133.post-1155304980160015702006-08-11T06:49:00.000-07:002006-08-11T07:03:01.016-07:00<p style="font-weight: bold;" class="MsoNormal">Oracle Applications Manager.<o:p></o:p></p> <p class="MsoNormal">The Oracle Applications Manager(<span style="font-weight: bold; font-style: italic;">OAM</span>) provides a console to effectively manage, monitor, configure and troubleshoot an Oracle Applications environment.<br />The console is HTML based and as such does not require any additional software excpet the browser.<br />One of the key features of OAM is the <span style="font-weight: bold; font-style: italic;">Applications Dashboard</span> which provides information on E-Business Suite installation,including summaries of current status, performance, critical activities, diagnostics, business flows, and security.<o:p></o:p></p> <p class="MsoNormal">In Oracle Applications Manager 2.1.1, there are three System Administrator type responsibilities to use when accessing Oracle Applications Manager.<br />These Oracle Applications responsibilities are:<br /><span style="font-weight: bold; font-style: italic;">System Administrator</span> - this responsibility has access to all functionality in OAM.<br /><span style="font-weight: bold; font-style: italic;">OAM Read Only Mode</span> - this responsibility provides administrators with view-only access to most of the data in OAM. This responsibility does not provide access to critical actions such as Stop Services and Edit Configuration Parameters.<br /><span style="font-weight: bold; font-style: italic;">OAM Patch History</span> - administrators with this responsibility can view the Applications Dashboard and Patch History pages.<o:p><br /></o:p></p> <p class="MsoNormal">The OAM is also used in conjunction with <span style="font-weight: bold; font-style: italic;">autoconfig</span> for making changes to the application and DB tier context files.<o:p></o:p></p> <p class="MsoNormal"><o:p></o:p>OAM also provides advanced configuration wizards that allow you to perform advanced configurations to your E-Business Suite like SSL /SSL Accelerator conversion, Forms Listener servlet configuration and Apache Jserv load balancing<span style="">.</span><o:p></o:p></p> <p class="MsoNormal">OAM provides for a in depth monitoring of your Oracle Applications environment.OAM can also be used to monitor your <span style="font-weight: bold; font-style: italic;">forms listener servlet</span> if you have configured your forms listener to run as a servlet.<o:p></o:p></p> <p class="MsoNormal">You can also get detailed view of the <span style="font-weight: bold; font-style: italic;">Oracle Applications technology stack components</span> like jserv memory usage, database connection pool details etc.<o:p></o:p></p> <p class="MsoNormal">Additionally OAM can also be used to monitor your concurrent manager and concurrent requests.<o:p><br /></o:p></p> <p class="MsoNormal">In my first post i had talked about <span style="font-weight: bold; font-style: italic;">Generic Service Management(GSM)</span>, in case you have implemented generic service management you can monitor and control your different Oracle Applications services through OAM.<o:p></o:p></p> <p class="MsoNormal">OAM also provides various features that aid in <span style="font-weight: bold; font-style: italic;">patch management process</span>. There are various patch reports like applied patches which give details of the patches applied along with the timing reports and the changes they have made to the file system. This is a feature that i am sure DBAs who have worked on releases prior to 11i would surely appreciate.<o:p></o:p></p> <p class="MsoNormal">Also included in the latest version of OAM after features like <span style="font-weight: bold; font-style: italic;">patch wizard and support cart </span>which can be used with metalink services and aid in resolving service requests.<o:p></o:p></p> <p class="MsoNormal">Cloning is also supported from OAM, currently though you cannot perform <span style="font-weight: bold; font-style: italic;">merging APPL_TOPS</span>(Multi Node to single node cloning) from OAM.<o:p></o:p></p> <p class="MsoNormal"><span style="font-weight: bold; font-style: italic;">Oracle Diagnostics</span> can also be run from OAM. Oracle Diagnostics enables testing, identifying and reporting functional problems through a web-interface. This tool allows invoking test cases interactively using custom input values or through batch modeusing pre-registered input values.<o:p></o:p></p> <p class="MsoNormal">For more details on Oracle Diagnostics, please see Metalink Note: <a href="http://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=262006.1">262006.1</a><br /><o:p></o:p></p> <p class="MsoNormal">You can also extend the functionality of OAM by using your custom SQL scripts to run with Oracle Applications Manager.<o:p></o:p></p> <p class="MsoNormal">You can use OAM with any version of Oracle Applications 11i starting form 11.5.1. The latest version of OAM is <span style="font-weight: bold; font-style: italic;">2.1.1</span> whichcan be obtained by applying Oracle Applications Manager Mini-pack 11i.OAM.H.However if you have already applied 11i.ATG_PF.H,11i.FND.H or on Oracle Applications 11.5.10 or higher you do not need to explicitly apply the 11i.OAM.H mini pack.<o:p></o:p></p> <p class="MsoNormal">The metalink note <a href="http://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=258330.1">258330.1</a> contains details on this pack.<o:p><br /></o:p></p> <p class="MsoNormal">If you are installing OAM from the patch you can either configure it manually by editing the zone.properties and jserv.properties or by using autoconfig.</p><o:p></o:p>The metalink note <a href="http://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=201703.1">201703.1</a> contains details on installing and configuring OAM<o:p></o:p>. <p class="MsoNormal">After you have configured OAM it is important that you set your <span style="font-weight: bold; font-style: italic;">DISPLAY</span> environment variable correctly in your jserv.properties file to enable all the graphs within OAM to be displayed correctly.<o:p></o:p></p> <p class="MsoNormal"><span style="font-style: italic;">Example: wrapper.env=DISPLAY=myacme:0.0</span><o:p></o:p></p> <p class="MsoNormal">Once OAM has been installed you can acees it from either the Oracle Applications sign on page, from any user with the system administration responsibility or from the following URL <span style="font-style: italic;">http://host:port/servlets/weboam/oam/oamLogin</span><o:p><br /><br /></o:p> </p>Samhttp://www.blogger.com/profile/02503978840124498130noreply@blogger.com7tag:blogger.com,1999:blog-31793133.post-1155132219532068452006-08-09T06:57:00.000-07:002006-08-09T07:03:39.576-07:00<span style="font-weight: bold;">OracleAS Web Cache</span><br /><br />Delevring a content rich site always involves a tradeoff with performace.Oracle AS Web Cache aims to significantlly reduce this tradeoff.<br /><br />The aim of my current post is give a brief introduction into the faetaures and capabalities of OracleAS Web Cache.<br /><br />OracleAS Web Cache improves performance of complex applications. Web caching moves frequently used content closer to the user, reducing page building tasks from the application server therby decreasing page load times.<br /><br />Another feature of OracleAS Web Cache is that it provieds for caching of both <span style="font-weight: bold; font-style: italic;">static and dynamic web pages</span> allowing scaling of applictions that are planned to be deployed.The dynamic content caching is achived as OracleAS Web Cache employes an advanced validation machanisam to maintain consistency with origin data sources like file systems,content management tools,content feeds and databases.This is further achived as Oracle As Web Cache supports <span style="font-weight: bold; font-style: italic;">ESI standards</span>. ESI stands for Eege Side Includes which is an open specification for a simple markup language that enables dynamic page fragmentation, caching, and assembly. It improves the performance and reduces the cost of dynamic content creation.<br />More information on ESI can be found at <a href="http://www.esi.org/">http://www.esi.org/</a><br /><br />Additionally OracleAS Web Cache allows <span style="font-weight: bold; font-style: italic;">HTTP and HTTPS content</span> caching.Also Oracle As Webcache allows session related caching rules (which is maintatining session tracking without compromiosing on the caching) and Multi version cahing rules(Caching multiple versions for the same URL)<br /><br />To make use of Oracle AS Web Cacheing you must upgarde your Oracle Applications to use Oracle Appliction Applications Server 9.0.2, the latest certified version however is 10gAS.<br /><br />OracleAs Web Cache acn also be used to implment a <span style="font-weight: bold; font-style: italic;">reverse proxy</span> in typical DMZ configurations.Wehn a user sends a request to the Web Cache via the load balanceer or DNS server the web cacahe sneds the request to the application server if it cannot find a chached page for the request,however if it does find a cached page the web cache will deliver the same directly to the browser.<br /><br />You can also implemet <span style="font-weight: bold; font-style: italic;">Web Cache Clustering</span> by configuring multiple instances of OracleAS Web Cache.These provide for a failover in case one of the Web Cache cluster member fails.The cache cluster members poll the failed Web cache server for its current status until it is reachable again.Apart from failover cache clustering also aloow to cache extra content by disturbuting the cache load across multiple Web Caches.OracleAS Web Cache uses the relative capacity of each cache to automatically distribute ownership of objects among the cache cluster members.<br /><br />OracleAS Web Cache can also be used to do load balancing for Oracle Applications. It provides for <span style="font-weight: bold; font-style: italic;">Stateless Load Balancing and Stateful (Session Binding) Load balancing.</span><br /><br />You can specify the Web Cache to <span style="font-weight: bold; font-style: italic;">compress both cachable and non cachable objects</span>,in such a scenerio the web cache will compress the opbeject based on the object type and the browser type.It uses the <span style="font-weight: bold; font-style: italic;">GZIP algorithm</span> for this purpose.<br /><br />You can also go through the <a href="https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=270154.1">OracleAS 10g Web Cache FAQ</a> available through metalink.<br /><br />Due to the extensive deployment of OracleAS Web Cache it is essential for us to secure our Web Cache. Currently OracleAs web Cache security can be implemented using Restricted Adfministration,SSL and SSL Accleration.<br />Reffer to <a href="http://download-west.oracle.com/docs/cd/B14099_02/caching.1012/b14046/security.htm#g1011855">Securing OracleAS Web Cache</a> for more information.Samhttp://www.blogger.com/profile/02503978840124498130noreply@blogger.com3tag:blogger.com,1999:blog-31793133.post-1154941819378125942006-08-07T02:03:00.000-07:002006-08-07T02:10:19.393-07:00<p class="MsoNormal"><span style="font-weight: bold;">NLS/MLS in Oracle Applications.</span><o:p></o:p></p> <p class="MsoNormal">With the globalization of business the NLS/MLS feature in Oracle Applications has come into use quite extensively.<o:p></o:p></p> <p class="MsoNormal"><span style="font-weight: bold; font-style: italic;">NLS (National Language Support)</span> refers to the ability to run an Oracle Applications instance in any one of the supported languages other than American English.<o:p></o:p></p> <p class="MsoNormal">This includes the user Interface that is the customer facing forms reports etc.<o:p></o:p></p> <p class="MsoNormal">The base langue (that’s is the underlying logic for the instance)continues to remain American English, though this can also be changed.<o:p></o:p></p> <p class="MsoNormal"><span style="font-weight: bold; font-style: italic;">MLS</span> <span style="font-weight: bold; font-style: italic;">(Multi Language Support)</span>should not be confused to be different from NLS it is infact an extension of NLS. MLS refers to the ability to run a single instance of Oracle Applications in more than one supported language apart for the American English.<o:p></o:p></p> <p class="MsoNormal">MLS enabled applications store the seeded data in both the base language and the translated language.<o:p></o:p></p> <p class="MsoNormal">Also most applications with Oracle Applications are MLS supported.<o:p></o:p></p> <p class="MsoNormal"><o:p></o:p>You can check the base and installed languages of your oracle Applications by querying the table FND_LANGUAGES.<o:p></o:p></p> <p class="MsoNormal">Your base language will be represented with the 'B' flag and other installed language with 'I' Flag.<o:p></o:p></p> <p style="font-style: italic;" class="MsoNormal">>SELECT LANGUAGE_SHORT_NAME, INSTALLED_FLAG<br />FROM FND_LANGUAGES <o:p> </o:p></p> <p class="MsoNormal">Before implementing NLS/MLS it is important to make sure that your database character set will support your additional language.<o:p></o:p></p> <p class="MsoNormal"><o:p></o:p><br />The metalink note <a href="https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=333785.1">333785.1</a> contains a table of all the supported languages and the langues that are planned to be supported along with their supported database character sets.<br /><o:p> </o:p></p> <p class="MsoNormal">If you are implementing multiple languages or planning to install additional languages you can choose <span style="font-weight: bold; font-style: italic;">UTF8</span> as your database character set.<o:p></o:p></p> <p class="MsoNormal">You can install the additional language during the installation of Oracle Applications (in this case you would have to stage the NLS software along with the Oracle Applications Software) or you can add an additional language after you have setup and installed Oracle Applications. You should must however apply translations for any paths that you may have applied after the installation of Oracle Applications and before the implementation of the additional language.<o:p><br /></o:p></p> <p class="MsoNormal">If you are installing the language after the installation of Oracle Applications it includes a series of steps starting from Licensing your language, updating your multilingual tables and using auto patch to install the NLS patch.<o:p></o:p></p> <p class="MsoNormal">NLS release notes for 11.5.10.2(<a href="https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=215868.1&blackframe=1">215868.1</a>) contains the details steps of installing additional languages<o:p></o:p></p> <p class="MsoNormal">At the database level once NLS/MLS is implemented Oracle Applications stores language specific attributes in a separate table know as the translation table, where as the language independent attributes are stored in the base table. As a result it is important to consider additional space requirements as far as the database sizing is considered before implementing NLS/MLS<o:p></o:p></p> <p class="MsoNormal">Oracle Applications currently does not support the uninstalling of the languages once they are installed. You can manually update the <span style="font-weight: bold; font-style: italic;">FND_LANGUAGES</span> table, though this method is also not supported by Oracle.<o:p> </o:p></p> <p class="MsoNormal">To print from Oracle Applications while using UTF8 to support NLS/MLS you must use PASTA (<span style="font-weight: bold; font-style: italic;">FNDPSTAX</span>) utility which is shipped with Oracle Applications. This uses the pasta.cfg file for various print options.The file is located at $FND_TOP/resource.<o:p></o:p></p> <p class="MsoNormal">There are various seed printer drivers that can used with PSATA printing like PASTA_LANDSCAPE, PASTA_PORTRAIT, PASTA_LANDWIDE and PASTA_DYNAMIC.<o:p></o:p></p> <p class="MsoNormal"><o:p></o:p>When applying patches on an NLS/MLS environment you must first apply the base language patch immediately followed by the translation patches of the other installed languages.<o:p><br /><br /></o:p></p>Samhttp://www.blogger.com/profile/02503978840124498130noreply@blogger.com2tag:blogger.com,1999:blog-31793133.post-1154607602483800922006-08-03T05:14:00.000-07:002006-08-07T02:10:51.713-07:00<span style="font-weight: bold;">Shared APPL_TOP</span><span style="font-weight: bold;"> and Application Tier Filesystem</span><br /><p class="MsoNormal">In the <span style="font-weight: bold; font-style: italic;">Shared APPL_TOP</span> feature introduced by Oracle in E-Business 11i, Oracle allows multiple nodes to share a single APPL_TOP .In a shared APPL_TOP configuration, the <span style="font-weight: bold; font-style: italic;">APPL_TOP</span> and <span style="font-weight: bold; font-style: italic;">COMN_TOP</span> file systems can be installed on a single shared disk. The shared disk resource can then be shared via various network file protocols across multiple nodes to provide standard application tier services such as forms, web and concurrent processing. A shared APPL_TOP also significantly simplifies the patching or upgrade process since it has to be performed only once and changes made are immediately visible to all the nodes.<o:p></o:p></p> <p class="MsoNormal">Here it is important to note that there is a difference between a Shared APPL_TOP and a <span style="font-weight: bold; font-style: italic;">Shared Application Tier File system</span>. In a Shared APPL_TOP though the APPL_TOP(APPL_TOP and the COMMON_TOP ) is shared across different nodes, each nodes still have their individual ORACLE_HOME. In a Shared Application Tier FileSystem both the APPL_TOP and the ORACLE_HOME (ORA_TOP) reside on the shared disk.<o:p></o:p></p> <p class="MsoNormal">The Shared APPL_TOP architecture was introduced in 2003 however with the release of 11.5.10 Oracle has extended this feature to share the entire application tier filesystem thereby further reducing disk space and bring down maintenance tasks.This is what is referred to now as the <span style="font-weight: bold; font-style: italic;">Shared Application Tier File System</span>.<o:p> </o:p></p> <p class="MsoNormal">This feature i found to be particularly useful if your oracle applications environment uses multiple languages. Using the Shares APPL_TOP feature i do not now have to apply the translation on all the application Tier nodes but just to the Shared APPL_TOP.<o:p></o:p></p> <p class="MsoNormal"><o:p></o:p></p> <p class="MsoNormal">In both the cases any changes on the shared TOPs like for example patch application is immediately visible to all the nodes of the application tier. <o:p> </o:p></p> <p class="MsoNormal">Another important factor to be kept in mind is that SHARED APPL_TOPS will not work if different nodes are on different Operating systems. So its mandatory that the different nodes of the application tier run on a same operating system or in other words the different nodes must be <span style="font-weight: bold; font-style: italic;">binary compatible</span>.<o:p></o:p></p> <p class="MsoNormal">Also as of now the SHARED APPL_TOP feature is not available for the windows version of Oracle Applications.<o:p> </o:p></p> <p class="MsoNormal">Apart from reducing maintenance tasks a shared APPL_TOP/Shared Application Tier Filesystem also improves scalability of the system as it less complex to bring in an additional node to improve performance.<o:p></o:p></p> <p class="MsoNormal">There are various methods by with you can implement shared APPL_TOP like using Rapid Install or by merging existing APPL_TOPs<o:p></o:p></p> <p class="MsoNormal">It is mandatory for you to have implemented <span style="font-weight: bold; font-style: italic;">autoconfig </span>before you can proceed with the implementation of a Shared APPL_TOP<o:p></o:p></p> <p class="MsoNormal">The metalink note Sharing the Application Tier File System in Oracle Applications 11i <a href="http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=233428.1">233428.1</a> talks about implementing shared APPL_TOP under different Scenarios <o:p></o:p></p> <p class="MsoNormal">While patching a shared APP_TOP you can just apply the path to any of the nodes and it will become visible to all the nodes, in case of applying a patch to 8.0.6 home or IAS_HOME you need to apply the patch only once but to a primary node.<o:p> </o:p></p> <p class="MsoNormal">Shared APPL_TOP and Shared Application Files system concepts are different from a <span style="font-weight: bold; font-style: italic;">Staged APPL_TOP</span>. A Staged APPL_TOP is implemented to reduce your patching related downtimes by creating a exact clone of your production system, patching that system and synchronizing your cloned at database and application level to the production system.</p> <p class="MsoNormal">This approach significantly reduced your patching downtime.</p> <p class="MsoNormal">To knopw more about a Staged APPL_TOP refer to metalink note <a href="http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=242480.1">242480.1</a></p> <p class="MsoNormal"><o:p> </o:p></p> <p class="MsoNormal"><br /><o:p></o:p></p>Samhttp://www.blogger.com/profile/02503978840124498130noreply@blogger.com4tag:blogger.com,1999:blog-31793133.post-1154434635139227392006-08-01T05:09:00.000-07:002006-08-01T05:23:34.426-07:00<span style="font-weight: bold;">Oracle Applications Framework<br /></span><p class="MsoNormal">The Oracle Applications Framework 11.5.10 was one of the exciting features that i found in the latest release of Oracle Applications 11.5.10<o:p></o:p></p> <p class="MsoNormal">Oracle Applications Framework is also referred as <span style="font-weight: bold; font-style: italic;">OA Framework</span>. OA Framework is a Java framework that excels at creating 3-tier web-based applications that link to an 11i Oracle Applications instance while maintaining all the security features of that 11i instance.</p><br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://photos1.blogger.com/blogger/4140/173/1600/Picture1.0.png"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer;" src="http://photos1.blogger.com/blogger/4140/173/320/Picture1.0.png" alt="" border="0" /></a><br /><br /><p class="MsoNormal">OA Framework makes a connection to the database using <span style="font-weight: bold; font-style: italic;">JDBC drivers</span>.<o:p></o:p></p> <p class="MsoNormal">An important significance of the OA framework model is that it facilitates the customization of existing out of box i modules as well as it allows development of new Self Service Web Application modules.<o:p></o:p></p> <p class="MsoNormal">As a result the OA Framework provides with benefits of Productivity, Scalability, and Customizability etc.<o:p></o:p></p> <p class="MsoNormal">Though the OA Framework is J2EE based, it also used various industry standards like <span style="font-weight: bold; font-style: italic;">HTML, XML, Java, JSP, SQL and Web Services.</span><o:p style="font-weight: bold; font-style: italic;"> </o:p></p> <p class="MsoNormal">The OA Framework Architecture is based on the <span style="font-weight: bold; font-style: italic;">J2EE MVC design pattern</span>.<span style=""> </span>The MVC architecture is a component-based design pattern with clean interfaces between the Model, View, and Controller. The Model is where the application implements its business logic. The View is where the application implements its user interface and the Controller is where the application handles user interaction and directs business flow.<o:p></o:p></p> <p class="MsoNormal">Additionally OA framework also contain extensions to Oracle 9I JDeveloper called <span style="font-weight: bold; font-style: italic;">Oracle Applications Extension</span> or the <span style="font-weight: bold; font-style: italic;">OA Extension</span>. The Jdeveloper is a IDE client which allows you to do customizations and additions to the OA Framework.<o:p></o:p></p> <p class="MsoNormal">The metalink note <a href="https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=275878.1">275878.1</a> contains FAQ to use JDeveloper with the OA Framework<o:p></o:p></p><o:p></o:p>There are a number of profile options which are used to configure the OA Framework behaviour.<o:p></o:p> <p class="MsoNormal">To know maore about OAF profile options reffer to note <a href="https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=275876.1">275876.1</a><o:p> </o:p></p> <p class="MsoNormal">You can test your OAF by go through a series of tests which are accessible from the following URL<o:p></o:p></p> <p style="font-style: italic;" class="MsoNormal">http://<host_name>:<port_number>/OA_HTML/jsp/fnd/aoljtest.jsp<o:p> </o:p></port_number></host_name></p> <p class="MsoNormal">Note: use your hostname and port identifier<o:p></o:p></p> <p class="MsoNormal">The latest release of OA Framework is 11.5.10, if you are on 11.5.9 or any prior release you can user matalink note <a href="https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=275874.1">275874.1</a> to upgrade and configure your OA Framework to 11.5.10.<o:p><br /></o:p></p> <p class="MsoNormal">You must also upgrade your JDK to 1.3 before proceeding with this, The metalink note <a href="https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=130091.1">130091.1</a> will be helpful for upgrading JDK to 1.3<o:p></o:p></p> <p class="MsoNormal">Another good note which might be useful is Oracle Application Framework Troubleshooting Note:<a href="https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=275875.1">275875.1</a> </p> <p class="MsoNormal">Extensive literature regarding OA framework has been published in the OA Framework Developers Guide</p>Samhttp://www.blogger.com/profile/02503978840124498130noreply@blogger.com7tag:blogger.com,1999:blog-31793133.post-1154345247200468382006-07-31T04:20:00.000-07:002006-08-01T05:25:21.300-07:00<strong>Oracle Open World</strong><br /><br />Registration to the Oracle Open world is currently open at<br /><br /><a href="http://www.oracle.com/openworld/attendees/register/index.html">http://www.oracle.com/openworld/attendees/register/index.html</a><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://photos1.blogger.com/blogger/4140/173/1600/oow_clr.gif"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer;" src="http://photos1.blogger.com/blogger/4140/173/320/oow_clr.1.gif" alt="" border="0" /></a><br /><strong></strong><a href="http://www.oracle.com/openworld/attendees/register/index.html"></a><br />Actually it would have been there a couple of months back notice it today so thought of putting up a mention to it.<br /><br />And if you are planning to attend it you can register now and grab those early bird discounts that are being offered.<br />Its going to be a exciting event to look forward to with more than 1400 session planned between October 22-26<br /><br />If you want to browse through at what’s being offered go through the content catalog at<br /><a href="http://www28.cplan.com/cc139/catalog.jsp"><br />http://www28.cplan.com/cc139/catalog.jsp</a><br /><br />Going through could not help notice that Sir Elton John would be performing live during the OOW, that’s nice.. if you enjoy that kind of music that is...<br /><br />There are also some special programs and partner activities on the menu<br /><br />Don’t miss it.. :)Samhttp://www.blogger.com/profile/02503978840124498130noreply@blogger.com1tag:blogger.com,1999:blog-31793133.post-1154330876403396772006-07-31T00:25:00.000-07:002006-07-31T00:33:48.356-07:00<strong>Generic Service Management</strong><br /><br />This will be my first post.. I thought of talking about some kind of 11i architecture of basics but decided to blog about GSM. GSM stands for <strong><em>Generic Service Management</em></strong> a new feature introduced from version 11.5.7 onwards..<br /><br />The basic idea behind GSM is provide a framework to centrally manage various Oracle Application process spread across different nodes.<br /><br />Oracle describes the GSM as an extension of concurrent processing.<br />So how does it work ? With invent of GSM , the <em><strong>Internal Concurrent Manager</strong></em> (ICM) which traditionally was responsible to manage the concurrent mangers now extents itself to the role of managing and monitoring various applications services across various nodes. These services include Oracle Forms Listener, Oracle Reports Server, Apache Web listener, Oracle Workflow Mailer etc.<br /><br />Apart from managing and monitoring the services GSM provides a fault tolerance by attempting to start any services that have exited unexpectedly<br />GSM Setup<br />Manual setup of GSM is required only if you are using Oracle Applications prior to 11.5.7, in the later releases GSM is already setup though you can choose to disable it.<br /><br />Information about the nodes is started at the database level in a table FND_NODES.<br />GSM uses the ping command to check the availability of the nodes so its essential to have the Oracle applications user like applmgr to be able ping to the various application nodes for GSM to function.<br /><br />The Metalink Note <strong><em>210062.1</em></strong> talks about GSM configuring and trouble shooting in an Oracle Applications environment.Samhttp://www.blogger.com/profile/02503978840124498130noreply@blogger.com1