Apps DBA Workshop

The Installation of 11gR2 is not proceeding due to missing OS patch 124861-15 on Solaris 10. When we are trying to Install this patch it gives error: bash-3.00# patchadd 124861-15 Validating patches... Loading patches installed on the system... Done! Loading patches requested to install. Version of package SPROlang from directory SPROlang in patch 124861-15 differs from the package installed on the system. Version of package SPROlangx from directory SPROlangx in patch 124861-15 differs from the package installed on the system. Version of package SPROsunms from directory SPROsunms in patch 124861-15 differs from the package installed on the system. Version of package SPROmrcom from directory SPROmrcom in patch 124861-15 differs from the package installed on the system. Done! The following requested patches do not update any packages installed on the system No Packages from patch 124861-15 are installed on the system. No patches to dependency check. The packages included in this patch ar

This article will describe how to find out applications access URL in E-Business suite 11i and R12 In Applications 11i: bash-3.00$cd $APPL_TOP/admin bash-3.00$ pwd /appl/apps/prodnewappl/admin bash-3.00$ ls -l *.xml -rw-r--r-- 1 appltest dbatest 84223 Oct 2 12:54 PRODTEST_testappl.xml bash-3.00$ cat PREPROD_testappl.xml | grep http | grep login login_page oa_var="s_login_page" http://testappl.orasol.com:8005/oa_servlets/AppsLogin/login_page bash-3.00$ Here URL is http://testappl.orasol.com:8005 In Applications R12: bash-3.00$ cd $INST_TOP bash-3.00$ ls admin appltmp conf_ERPTEST.txt ora pids rgf temp appl certs logs out portal soa bash-3.00$ cd appl bash-3.00$ ls admin fnd bash-3.00$ cd admin bash-3.00$ ls -l total 228 -rwxr-xr-x 1 applmgr appsdba 90899 Nov 9 12:18 ERPTEST_orasolerp.xml -rw-r--r-- 1 applmgr appsdba 103

We can change color of forms of Oracle Application 11i by setting a profile option. In general we will change the color of forms after preparing a clone from the production Instance. We will do this to differentiate clone and production Instance. Profile Options changes: Java Look and Feel - should be set to oracle or no value, if its set to generic then it will use the default color Java Color Scheme - Specify any of the List of Values from the list available. Navigation: Login as System Administrator resp --> profile --> System Log off and log in again you will fine the change in forms color. Screen display change of profile options: The profile option Java Color Scheme is set to red. Note: This profile value should be set at site level.

This article describes all steps which are required for Installing Oracle Applications R12.1.1 on Oracle Solaris 10 U9 on Sparc-64 Bit. Steps: 1) Verify the OS version bash-3.00$ uname -r 5.10 bash-3.00$ For Installing Apps Release 12.1.1 min OS version is Solaris 10 2) Verify the release of OS bash-3.00$ cat /etc/release Oracle Solaris 10 9/10 s10s_u9wos_14a SPARC Copyright (c) 2010, Oracle and/or its affiliates. All rights reserved. Assembled 11 August 2010 bash-3.00$ 3) Verify all required OS patches List of OS Patches required for Solaris 10: 125100-04 120473-05 127111-02 137111-04 bash-3.00# /usr/sbin/patchadd -p | grep 125100-04 Patch: 144744-01 Obsoletes: 138219-01 Requires: 120473-05 124235-02 125100-04 125800-01 Incompatibles: Packages: SUNWcsl bash-3.00# /usr/sbin/patchadd -p | grep 120473-05 Patch: 144744-01 Obsoletes: 138219-01 Requires: 120473-05 124235-02 125100-04 125800-01 Incompatibles: Packages: SUNWcsl bash-3.00# /u

The below issue is encountered while cloning from one of our production Instance. Error stack from the ApplydbTier logfile: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory Connected to an idle instance. ORA-27102: out of memory SVR4 Error: 22: Invalid argument BEGIN dbms_backup_restore.zeroDbid(0); END; * ERROR at line 1: ORA-01034: ORACLE not available ERROR at line 1: ORA-01034: ORACLE not available declare lib_ver varchar2(3); * ERROR at line 1: ORA-01034: ORACLE not available ERROR: ORA-01012: not logged on Disconnected exit_code=1 Checking for errors ... ORA-27102: out of memory ORA-01034: ORACLE not available ORA-01034: ORACLE not available ORA-01034: ORACLE not available ORA-01034: ORACLE not available ORA-01034: ORACLE not available ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist ORA-27102: out of memory ORA-01034: ORACLE not available ORA-27102: out of memory ORA-01034: ORACLE