Oracle Apps DBA

My photo
More than 5+ Years of IT Experience in administering Enterprise wide Multi Vendor UNIX Servers, Oracle Databases (8i to 11gR2), Middle-tiers, Applications and Clusters. I am a Sun Certified System Administrator (SCSA) for Solaris 10, oracle 10g database certified associate(OCA), Oracle 10g Database certified professional (OCP) and Oracle E-Business suite R12 certified professionl(OCP)

Oracle Database and Applications

Friday, 26 November 2010

11gR2 Installation Error with patch 124861-15 as pre Req

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...


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.

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 are already Installed and with higher version. These packages are bundled with Sun Studio 12.1 and 12.2 , if you Installed Sun Studio 12.0 then it will allow you to Install the required patch 124861-15. This patch is for C compiler which is already installed with Sun Studio 12.x. So here Installing this patch doesn't make any sense as we already have these packages with higher version.

You can verify the packages bundled with this patch installed on your system or not:

bash-3.00# pkginfo -i SPROlang SPROlangx SPROsunms SPROmrcom
application SPROlang Sun Studio 12 update 1 Compilers Common Components
application SPROlangx Sun Studio 12 update 1 Common 64-bit Components
application SPROmrcom Sun Studio 12 update 1 Common Compiler Man Pages/Online Info
application SPROsunms Sun Studio 12 update 1 Unbundled Shared libsunmath

Is these packages are Installed on your system, then you can avoid installing 124861-15 patch.

Here how you will avoid Installing this patch ?????

Just you need to comment pre-requiste file from 11g stage area.


Find entry for patch 124861-15 :

original entry

!-- C Compiler Patches --

Update Entry

!-- C Compiler Patches --

save this file and re-run the Installer it will not check this patch as a pre-requisite.

Happy reading.

Wednesday, 24 November 2010

How to check Oracle Application URL in 11i and R12 on UNIX prompt

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
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"

Here URL is

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 10392 Nov 9 12:10 adovars_ERPTEST_orasolerp.env
-rw------- 1 applmgr appsdba 1016 Nov 9 12:10 oamextensions.xml
-rw------- 1 applmgr appsdba 3340 Nov 9 12:10 ojspCompile.conf
-rw------- 1 applmgr appsdba 7476 Nov 9 12:10

bash-3.00$ cat ERPTEST_orasolerp.xml | grep http | grep login
login_page oa_var="s_login_page"
bash-3.00$ pwd

Here URL is

Tuesday, 23 November 2010

Changing Apps 11i Forms colour after clone

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.

Sunday, 21 November 2010

Oracle Applications R12.1.1 Installation on Oracle Solaris 10 U9

This article describes all steps which are required for Installing Oracle Applications R12.1.1 on Oracle Solaris 10 U9 on Sparc-64 Bit.


1) Verify the OS version

bash-3.00$ uname -r

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

3) Verify all required OS patches

List of OS Patches required for Solaris 10:


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# /usr/sbin/patchadd -p | grep 127111
Patch: 127127-11 Obsoletes: 118557-09 118560-02 118562-14 118843-01 120046-01 120068-03 120737-01
/usr/sbin/patchadd -p | grep 137111
Patch: 137137-09 Obsoletes: 120741-01 120986-12 120992-02 121008-02 121274-01 121414-01

4) Verify Required packages:

List of required packages


bash-3.00# pkginfo -i SUNWuiu8 SUNWulcf SUNWlibC
system SUNWlibC Sun Workshop Compilers Bundled libC
system SUNWuiu8 Iconv modules for UTF-8 Locale
system SUNWulcf UTF-8 Locale Environment Common Files

5) Other Software requirements:

X Display Server

Check for all these files exists in /usr/ccs/bin location.

bash-3.00$ pwd
bash-3.00$ ls -l ar
-r-xr-xr-x 1 root bin 35796 Jun 28 2008 ar
bash-3.00$ ls -l make
-rwxr-xr-x 1 root bin 245764 Dec 7 2006 make
bash-3.00$ ls -l ld
-rwxr-xr-x 1 root bin 10704 Aug 10 20:51 ld

Also make sure that you have Xdisplay Server configured on Machine.

6) Configure ulimit settings:

time (seconds) = unlimited
file (blocks) = unlimited
data (kbytes) = 4194303
stack (kbytes) = 65536
coredump (blocks) = unlimited
nofiles (descriptors) = 65536
vmemory (kbytes) = unlimited

core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
open files (-n) 4096
pipe size (512 bytes, -p) 10
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 29995
virtual memory (kbytes, -v) unlimited

7) Configure kernel parameters:

Recommended settings:

Solaris 10 (5.10)
rlim_fd_max 65536
noexec_user_stack 1
semsys:seminfo_semmni 100
semsys:seminfo_semmsl 256
shmsys:shminfo_shmmax 4294967295
shmsys:shminfo_shmmni 100

configured settings in /etc/system file as per 4 GB RAM

set shmsys: shminfo_shmmni = 256
set semsys: seminfo_semvmx = 32767
#set sehmsys:shminfo_shmmax = 8589934592
set shmsys:shminfo_shmmax=12025908428
set shmsys: shminfo_shmseg = 50
set rlim_fd_max=65536
set rlim_fd_cur=4096

8) Host Name Settings:

Verify the /etc/hosts file for correct entries, the valid entries should be like: localhost.localdomain localhost
ip_address node_name.domain_name node_name

bash-3.00$ cat /etc/hosts
# Internet host table
::1 localhost localhost testerp loghost

There are some known Issues for this Installation, before starting Installation configure Server with below steps:

OPMN port conflict

By default, the OPMN service of the Application Server listens on port 6000 and this can conflict with X11 port used for the graphics on UNIX machine.

To avoid this issue:

1) check port 6000 is active

bash-3.00$ netstat -an | grep 6000
*.6000 *.* 0 0 49152 0 LISTEN
*.6000 *.* 0 0 49152 0 LISTEN
*.6000 *.* 0 0 49152 0 LISTEN

2) Shutdown the dtlogin process with the command "/usr/dt/bin/dtconfig -kill"
3) Confirm that nothing is listening at port 6000 ("netstat -a | grep 6000")
4) Disable the local X console for dtlogin with command "/usr/dt/bin/dtconfig -d"
5) Restart dtlogin with command "/usr/dt/bin/dtconfig -e"

bash-3.00# cd /
bash-3.00# /usr/dt/bin/dtconfig -kill
dtlogin kill complete.
bash-3.00# netstat -a | grep 6000
bash-3.00# /usr/dt/bin/dtconfig -d
desktop auto-start disabled.
bash-3.00# /usr/dt/bin/dtconfig -e
desktop auto-start enabled.

RC-20200: Fatal: Could not find Unzip Error while Installing R12.1.1 on Solaris 10 U9

For more information on this issue refer:

9) Create Application, database users and group:

bash-3.00$ groupadd dbaerp
bash-3.00$ useradd -g dbaerp -d /home/applr12 -m applr12
bash-3.00$ useradd -g dbaerp -d /home/orar12 -m orar12

-> User applr12 is used for managing application tier services
-> User orar12 is used for managing database tier services

10) Verify the Disk Space with df -h command, for fresh Installation it needs 90 GB & for Vision Installation it needs 245 GB of free Disk space.

11) Create directory structure and grant appropriate permission on directory

bash-3.00# mkdir /OrApps/appsR12
bash-3.00# mkdir /OrApps/oraR12
bash-3.00# chmod -R 775 /OrApps/appsR12
bash-3.00# chmod -R 775 /OrApps/oraR12
bash-3.00# chown -R applr12:dbaerp /OrApps/appsR12
bash-3.00# chown -R orar12:dbaerp /OrApps/oraR12

12) Configure Stage Area

The stage area required 50 GB of Disk Space with additional NLS Supplement.

create Directories as below:

bash-3.00#mkdir /OrApps/sw_dumps/R12_Stage
bash-3.00#cd /OrApps/sw_dumps/R12_Stage
bash-3.00#mkdir startCD
bash-3.00#mkdir oraDB
bash-3.00#mkdir oraAppDB
bash-3.00#mkdir oraApps
bash-3.00#mkdir tools
bash-3.00#mkdir oraNLS

bash-3.00$ cd R12_Stage/
bash-3.00$ ls
oraAppDB oraDB tools startCD
oraApps oraNLS
bash-3.00$ pwd

-> copy Start Here DVD in startCD
-> copy APPL_TOP DVD in oraApps
-> copy RDBMS DVD in oraDB
-> copy Tools in tools
-> copy Databases DVD in oraAppDB
-> copy additional NLS DVD in oraNLS

13) Verify Proper Display setting by running xclock.

14) Run rapidwiz Installation utility from stage area

15) rapidwiz main Installation screen

16) Screen for selection of Installation type

17) Screen to configure email with oracle support

18) Screen for configuration file

19) Screen for selecting ports to be used by application

20) Screen to configure DB node

21) select type of licensing to be used in apps

22) Select additional licenses if any

23) Select country specific functionality

24) Select internationalization settings

25) Application Node configuration

26) Node Information for Database and Application servers

27) rapidwiz performing system checks to check any error for system configuration

28) System validation screen

On this screen if found any errors need to be fixed before proceeding further for a successful Installation.

29) Screen Display what components rapidwiz will Install

30) Installation progress screens

31) System configuration validation screen, this will check all required components Installed and configured properly

32) Installation completion screen

Login to applications with the valid URL, for this Installation application can be accessed with url

33) Login screen


Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Oracle Solaris on SPARC (64-bit) [ID 761568.1]

Installation completed successful.

Happy reading :)

Sunday, 14 November 2010

Apps 11i clone ORA-27101: shared memory realm does not exist

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

ORA-01012: not logged on


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 not available
ORA-01034: ORACLE not available
ORA-01034: ORACLE not available
ORA-01034: ORACLE not available
ORA-01034: ORACLE not available
The database has not been successfully created. Shutting down the instance ...

SQL*Plus: Release - Production on Sun Nov 14 13:09:10 2010

The error code itself indicates that there is an insufficient memory required for starting up an oracle instance.

The issue is with the larger SGA allocated to an new instance. While running adcfgclone. pl, it created new context file with SGA, PGA, Shared_Pool as per the PRODUCTION parameters. But on clone Server the resource were not available as per these parameters.

Context file entries created with the parameters as per the PRODUCTION parameter file:

SGA_TARGET oa_var="s_db_sga_target" 18G SGA_TARGET
SHARED_POOL_SIZE oa_var="s_db_shared_pool_size" 3G SHARED_POOL_SIZE
PGA_AGGREGATE_TARGET oa_var="s_db_pga_aggregate_target" 3G PGA_AGGREGATE_TARGET

Just we need to modify these parameters in context file as per the resources of clone server.

Modified entries:

SGA_TARGET oa_var="s_db_sga_target" 4G SGA_TARGET
SHARED_POOL_SIZE oa_var="s_db_shared_pool_size" 1G SHARED_POOL_SIZE
PGA_AGGREGATE_TARGET oa_var="s_db_pga_aggregate_target" 1G PGA_AGGREGATE_TARGET

After changing these parameters in _.xml run again by specifying the complete path of the context file.

bash-3.00$ perl appsTier /db/clonedat/dbase/10.2.0/appsutil/clone/bin/clonenew_testdb.xml

After this completed successfully without any issues.