surender sara sharing appl top r11i
TRANSCRIPT
-
7/31/2019 Surender Sara Sharing APPL TOP R11i
1/14
Sharing APPL_TOP in R11i
SURENDER SARA
NCOAUGEmail :
-
7/31/2019 Surender Sara Sharing APPL TOP R11i
2/14
Default Architecture of
Apps11i
-
7/31/2019 Surender Sara Sharing APPL TOP R11i
3/14
Implementation MethodologyWith the widespread use of the Oracle Applications
for DOTCOMS and other small to midsizeorganizations, 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.
-
7/31/2019 Surender Sara Sharing APPL TOP R11i
4/14
Implementation with 11iMost 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 bedone using R11i
Now we have CRP1, setup environment is shaped now with the help ofconsulting function members, by the client functional people
CRP2 only client team do the setups and customization is invoked atthis 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
-
7/31/2019 Surender Sara Sharing APPL TOP R11i
5/14
-
7/31/2019 Surender Sara Sharing APPL TOP R11i
6/14
BenefitsCan 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 somany instances in so many places.
-
7/31/2019 Surender Sara Sharing APPL TOP R11i
7/14
METHODOLOGYEach 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
-
7/31/2019 Surender Sara Sharing APPL TOP R11i
8/14
Oracle HOME environment
filesORACLE.envPresent under 8.0.6, 8.1.6 and webdb (2.5) home
.env file present under each home which calls
ORACLE.env as base setup file
-
7/31/2019 Surender Sara Sharing APPL TOP R11i
9/14
WEBDB 2.2 listener $ pwd
/u01/apps/oracle/visora/8.0.6/listener
Create a new directory for each oracle database attached tothis oracle home cfg cfg_ log log_
$ pwd /u01/apps/oracle/visora/8.0.6/listener/cfg_
wdbsvr.app , wdbsvr.cfg
Modify DAD information and connect string in wdbsvr.app file
wdbsvr.cfg file contents to point to our APPL_TOP
-
7/31/2019 Surender Sara Sharing APPL TOP R11i
10/14
WEBDB oracle home,2.5, listener files
$ pwd /u01/apps/oracle/visora/webdb/listener
$ ls
cfg cfg_ images images_ loglog_
$ pwd /u01/apps/oracle/visora/webdb/listener/cfg_
wdbsvr.app , wdbsvr.cfg
Modify DAD information and connect string inwdbsvr.app file
Point wdbsvr.cfg file contents to point to ourAPPL_TOP
-
7/31/2019 Surender Sara Sharing APPL TOP R11i
11/14
ENV files under APPL_TOP $ pwd
/u02/apps/11i/visappl
$ ls *.env create files called .env , APPLSYS_.env , APPSORA_.env
Modify the APPLSYS_.env
FORMS60_WEB_CONFIG_FILE FORMS60_MAPPING
and APPSORA_.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_.cfg
-
7/31/2019 Surender Sara Sharing APPL TOP R11i
12/14
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
-
7/31/2019 Surender Sara Sharing APPL TOP R11i
13/14
Questions and
Answers
-
7/31/2019 Surender Sara Sharing APPL TOP R11i
14/14
Sharing APPL_TOP in R11i
Surender Sara
Phone: 7082505983Email: [email protected]