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

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

11gR2stage/stage/cvu/cvu_prereq.xml

Find entry for patch 124861-15 :





original entry

!-- C Compiler Patches --
OSPATCH VALUE="124861-15" SEVERITY="IGNORABLE"

Update Entry

!-- C Compiler Patches --
!-- OSPATCH VALUE="124861-15" SEVERITY="IGNORABLE --"





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
/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 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 ojspCompile.properties

bash-3.00$ cat ERPTEST_orasolerp.xml | grep http | grep login
login_page oa_var="s_login_page"http://orasolerp.orasol.com:8008/OA_HTML/AppsLogin/login_page
bash-3.00$ pwd
/OrApps/appsR12/inst/apps/ERPTEST_orasolerp/appl/admin
bash-3.00$





Here URL is http://orasolerp.orasol.com:8008

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.

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# /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

SUNWuiu8
SUNWulcf
SUNWlibC




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
bash-3.00#




5) Other Software requirements:

ar
ld
make
X Display Server

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




bash-3.00$ pwd
/usr/ccs/bin
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:

127.0.0.1 localhost.localdomain localhost
ip_address node_name.domain_name node_name




bash-3.00$ cat /etc/hosts
#
# Internet host table
#
::1 localhost
127.0.0.1 localhost
192.168.1.11 testerp.orasol.com testerp loghost
bash-3.00$




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
bash-3.00$




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
done
dtlogin kill complete.
bash-3.00# netstat -a | grep 6000
bash-3.00# /usr/dt/bin/dtconfig -d
done
desktop auto-start disabled.
bash-3.00# /usr/dt/bin/dtconfig -e
done
desktop auto-start enabled.
bash-3.00#




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

For more information on this issue refer:

http://appsdbaworkshop.blogspot.com/2010/10/rc-20200-fatal-could-not-find-unzip.html


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
/OrApps/sw_dumps/R12_Stage




-> 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 http:testerp.orasol.com:8000

33) Login screen





References:

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


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 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 10.2.0.4.0 - 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 adcfgclone.pl again by specifying the complete path of the context file.


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


After this adcfgclone.pl completed successfully without any issues.