Apps DBA Workshop

Developer 6i Patch Set 19 upgrade with EBS 11i . *** All patches must be installed on all Application tier nodes Stop all application processes by adstpall.sh Apply the latest certified Developer 6i patch set 19 ( 6194129 ) - Source applications environment (e.g source .../testappl/APPSORA.env) - Verify that $ORACLE_HOME is the 806_ORACLE_HOME - Execute with applmgr user $ unzip p6194129_60828_LINUX.zip $ cd developer6i_patch19 $ ./patch_install.sh 2>&1 | tee patch_install_p19.log - Check patch_install_p19.log for any errors - Execute the following to relink Procedure Builder, Forms, Graphics and Reports $ cd $ORACLE_HOME/procbuilder60/lib; make -f ins_procbuilder.mk install $ cd $ORACLE_HOME/forms60/lib; make -f ins_forms60w.mk install $ cd $ORACLE_HOME/graphics60/lib; make -f

10g agent Installation ********************* *Note :412424.1 Oracle Enterprise Manager Grid Control Release Notes for Solaris (SPARC) 10g Release 3 (10.2.0.3.0) *Note :393246.1 install & config of the Agent 1.2 for EM Grid Plug-In 10gR2 for Oracle Applications *Note :308320.1 Install & config of the Agent 1.2 for EM Grid Plug-In 10gR2 for Oracle Applications 11i perfomance ************** *Note :216205.1 Database Initialization Parameters for Oracle Applications Release 11i *Note :244040.1 Oracle E-Business Suite Recommended Performance Patches DIAGNOSTIC TOOLS ********************* *Note :438452.1 Performance Tools Quick Reference Guide *Note :301137.1 OS Watcher User's Guide - Diagonostic tools *Note :352363.1 LTOM - The On-Board Monitor User Guide *Note :359395.1 Remote Diagnostic Agent (RDA) 4 - RAC Cluster Guide *Note :161474.1 Oracle Applications Remote Diagnostics Agent (APPS_RDA) Jinitiator and web browser for 11i *************************

perform system pre-requisite: Download the software from the following link http://www.oracle.com/technology/software/products/database/oracle11g/111060_linuxsoft.html Unzip the files: #unzip linux_11gR1_database.zip Verify Hosts File The /etc/hosts file must contain a fully qualified name for the server: Install the following redhat packages packages present in Linux 4 Disk1 rpm -Uvh binutils-2.* rpm -Uvh elfutils-libelf-0.* rpm -Uvh glibc-2.* rpm -Uvh glibc-common-2.* rpm -Uvh libgcc-3.* rpm -Uvh libstdc++-3.* rpm -Uvh compat-libstdc++-33* rpm -Uvh make-3.* rpm -Uvh unixODBC-2.* packages present in Linux 4 Disk2 rpm -Uvh glibc-devel-2.* rpm -Uvh gcc-3.* rpm -Uvh gcc-c++-3.* rpm -Uvh libstdc++-devel-3.* packages present in Linux 4 Disk3 rpm -Uvh libaio-0.* rpm -Uvh libaio-devel-0.* rpm -Uvh sysstat-5.* packages present in Linux 4 Disk4 rpm -Uvh elfutils-libelf-devel-0.* rpm -Uvh unixODBC-devel-2.* Set Kernel Parameters Oracle recommend the following minimum parameter settings: kerne