Sharing APPL_TOP in R11i

1
Sharing APPL_TOP in R11i

• Surender Sara
• Sridhar Rajamani

2
Default Architecture of Apps11i
3
Implementation Methodology

• With the widespread use of the Oracle
  Applications for DOTCOMS and other small to
  midsize organizations, the physical disk
  availability (and usage) becomes a key factor.
• This article will discuss about how multiple
  databases like DVLP, CRP1, CRP2, CRP3, TEST,
  TRNG, PTCH can share common APPL_TOPs and common
  ORACLE_HOME between them.

4
Implementation with 11i

• Most of the implementation follows the following
  pattern
• Install the database and this requires 25 GB (for
  a small sized co.) with little room to breathe in
  R11i.
• Other install group (DEV, CRP1, CRP2, CRP3,
  PATCH, TRAINING ) presents the empty database
  install with its set of Technology stack and
  APPL_TOP. This requires approximately 22 GB.
• DEV instance starts with functional people
  gathering business requirements and showing the
  end users how what do they can be done using R11i
• Now we have CRP1, setup environment is shaped now
  with the help of consulting function members, by
  the client functional people
• CRP2 only client team do the setups and
  customization is invoked at this point
• CRP3 ( Pre production setups ) this goes to
  production.
• PATCH instance is required for testing patches
• TRAINING is required for training the end user
  community
• Some other dev1, test1 environments

5
Hardware and Software Space Requirements

• In Oracle Applications R11i, the robust size per
  installation set is close to 25 GB. Every
  APPL_TOP management requires maintaining 14 set
  of scripts, almost 10 environment scripts, 3
  ORACLE_HOME.
• ORACLE_HOME requirements
• As per 11.5.1 installation base have almost 3.5
  GB space requirements for 8.1.6 , 8.0.6 , WEBDB
  home combined together.
• Application Files Each application files , also
  called APPL_TOP requires almost 8 GB per install
• Database Files Each install default database
  files are almost 8Gb
• Hardware and Software Space Requirements
• By oracle default installation methodology it
  needs 2 UNIX logins per install and total of
  almost 20 GB. If there exists 5 to 7 environments
  for the implementation then the total of 120 to
  150 GB space pre production is required.

6
Benefits

• Can save lot of disk space (atleast 15 GB for
  sharing two appl_tops and Oracle Homes)
• Easy for the DBAs to maintain and monitor.
• Time saving - since no need to run the patches in
  so many instances in so many places.

7
METHODOLOGY

• Each install has 3 oracle homes
• 8.1.6 is required for database
• 8.0.6 is required for APPL_TOP files
• webdb is required for webdb listener 2.5

8
Oracle HOME environment files

• ORACLE.env
• Present under 8.0.6, 8.1.6 and webdb (2.5) home
• ltSIDgt.env file present under each home which
  calls ORACLE.env as base setup file

9
WEBDB 2.2 listener

• pwd
• /u01/apps/oracle/visora/8.0.6/listener
• Create a new directory for each oracle database
  attached to this oracle home
• cfg cfg_ltsidgt log log_ltsidgt
• pwd
• /u01/apps/oracle/visora/8.0.6/listener/cfg_ltsidgt
• wdbsvr.app , wdbsvr.cfg
• Modify DAD information and connect string in
  wdbsvr.app file
• wdbsvr.cfg file contents to point to our APPL_TOP

10
WEBDB oracle home, 2.5, listener files

• pwd
• /u01/apps/oracle/visora/webdb/listener
• ls
• cfg cfg_ltSIDgt images
  images_ltSIDgt log log_ltSIDgt
• pwd
• /u01/apps/oracle/visora/webdb/listener/cfg_ltsidgt
• wdbsvr.app , wdbsvr.cfg
• Modify DAD information and connect string in
  wdbsvr.app file
• Point wdbsvr.cfg file contents to point to our
  APPL_TOP

11
ENV files under APPL_TOP

• pwd
• /u02/apps/11i/visappl
• ls .env
• create files called ltSIDgt.env ,
  APPLSYS_ltSIDgt.env , APPSORA_ltSIDgt.env
• Modify the APPLSYS_ltsidgt.env
• FORMS60_WEB_CONFIG_FILE
• FORMS60_MAPPING
• and APPSORA_ltsidgt.env file
• APPL_TOP, OAD_TOP/html/bin
• pwd
• /u02/apps/11i/viscomn/html/bin
• ls
• FNDWRR.exe appsweb.cfg.tmp pasta.cfg
• appsweb.cfg appsweb_ltSIDgt.cfg

12
Oracle Scripts Modifications

• start oracle scripts and then applmgr scripts
• stop applmgr scripts and then oracle scripts
• webdb 2.5 script file modification , adwdbctl.sh
• WV_GATEWAY_CFG
• WDBLOG
• webdb 2.2 listener , adwlnctl.sh
• FORMS60_WEB_CONFIG_FILE