Transcript R12 New Features

11i Cloning Panel
Panel Moderator: Sandra
Vucinic
March, 8 2004
NCOAUG Conference
Presenter For Custom
Solution – Surender Sara
Panel Members
•
•
•
•
Marc Vieux – Chicago Public Schools
Raman Batra - GE Comm. Finance
Surender Sara - Verities Solutions
Sandra Vucinic – Solution Beacon
Agenda
•
•
•
•
•
•
•
Available cloning methods
Differences between methods
Cloning Options available for each method
Introduction to 11i cloning
11i Cloning at Chicago Public Schools
Custom “F.A.S.T” Method
Questions
How can I clone an Oracle
Applications 11i System?
• Available methods:
– Cloning using AD Clone utility (adclone.pl)
– Cloning using Rapid Clone
– Custom cloning methods such as F.A.S.T
What are differences between
available cloning methods?
• Cloning using adclone.pl method
– Applicable for all 11i releases up to 11.5.5 that
are not AutoConfig enabled
– adclone.pl method requires that you run Rapid
Install and apply RDBMS and Technology
Stack patches to target system
What are differences between
available cloning methods?
• Cloning using Rapid Clone
– Applicable for all 11i systems that have
migrated to AutoConfig and enabled Rapid
Clone
Which cloning method is best for
your environment?
• The best method depends on:
– Version of applications:
• Prior to version 11.5.7 (adclone.pl)
• Version 11.5.7 and higher (Rapid Clone)
– Version of Database:
• 8i (adclone.pl and Rapid Clone)
• 9i (Rapid Clone only)
What cloning options are available for
each method?
Single-node Multi-node
to Singleto Multinode
node
Single-node Multi-node to
to MultiSingle-node
node
Cloning 11i
apps using
adclone.pl
Supported
Supported
Not
Available
Not Available
Cloning 11i
apps using
Rapid
Clone
Supported
Supported
Supported
Not Available
Cloning 11i
• More than one method….
–
–
–
–
Ad Clone
Rapid Clone
Custom methods (F.A.S.T etc)
11.5.9 Enhancements (Application Manager console)
• With same end goal(s)
– Create copies of environments
– To support DEV/QA/Test/Training activity
– Create separate “sandboxes”
Cloning 11i in a nutshell
• Why is Cloning 11i different….
–
–
–
–
11i Architecture
Two distinct application delivery methods
Forms (Applets) and HTML/JSP
Application Technology Stack different from earlier
releases
11i Technology Stack
Desktop Tier
Java Compatible Web Browser
(Jinitiator)
Forms Server
Application
Server Tier
Database Tier
Discoverer Server
Reports Server
Administrative
Server
Concurrent
Processing Server
Web Server
Database
(8i/9i)
Cloning 11i in a nutshell
• The Process….
– Create a system map of “From” and “To”
– Document your source and targets (file systems, paths, port
numbers)
– Copy Applications and Database Tiers (binaries and files)
– Clone the database instance and rename it.
– Update key Application related Database Profile tables
– Edit key Configuration and Environment files on the related
nodes
Cloning 11i in a nutshell
• The Process….
– Relink Applications Programs on related nodes (not
always needed)
– Create a new banner (logo.gif, if applicable)
– Regenerate Java Archive Files (JAR Files) (not always
needed)
CPS Environment
• Oracle Applications 11.5.8
– Multi-Node HPUX 11.11
– 9.2.0.4 Database
– EMC 8830 Symmetrix
• Recently Migrated from 11.0.3/8.0.5
– First to 11.5.7 on 8.1.7
– Then 11.5.8. on 8.1.7
– Currently 11.5.8 on 9.2.0.4
RapidClone in Action at CPS
• Sync/Split a BCV
– BCV Set includes full App Tier and DB Tier file systems
• Mount BCV to Development Hardware
• Change Directory Names, Owners, Perms
• Modify the DB tier Oracle_Home
– Oracle_Home Edits
• <sid>.env
• Tnsnames, Listener.ora
• Nmliblist
– Relink Oracle_Home
• Recover Database
• Modify the DB tier and APP tier 8.0.6_Homes
– 8.0.6_Home Edits
• <sid>.env
• Tnsnames.ora
• Rdbms/lb/nmliblist
– Make –f ins_rdbms.mk install
– Make –f ins_network.mk install
RapidClone in Action at CPS
• Modify the DB tier and APPS tier Appl_Top
– Appl_top Edits
• Apps<sid>.env
• Custom<sid>.env
• Adovars.env
• <sid>.xml
– Run $COMN_TOP/editcontext/editcontext
– Run $AD_TOP/bin/adconfig.sh
– Edit IAS_Home/Apache/Apache/bin/appachectl
• Startup the App Tier First
– Modify your Profile Options.
– Cancel Pending Conc. Reqs.
F.A.S.T Cloning
• The Method
– Identify the data you need to change and list
that in a file,<old><new> value pair
– Get the directories where changes will be
imposed into a file
– Run the perl script to make changes
automatically under those directories using
<old><new> value pair
F.A.S.T Cloning
• Script new structure creation
– Create new Directories ( APPL_TOP, 806, iAS,
8i home) (scripted)
– Create database using RMAN duplication
(scripted)
– Run the perl script to make changes
– Run $COMMON_TOP/admin/install scripts to
change the database information
F.A.S.T Cloning
• Example Snippets ( sun solaris )
– Create new Directories
tar cf - . | compress -c | rsh ora3800 "(cd
/u01/app/oracle/product;
uncompress -c | tar xf -)“
- create a file with dir list
- loc1=/u017/app/oracle/admin/ows/PSGOLD/httpd_apps280
- loc2=/u017/app/oracle/product/PSGOLD816/Apache/Apac
he
- loc3=/u017/app/oracle/product/PSGOLD816/Apache/Jserv
F.A.S.T Cloning
• Advantages
–
–
–
–
Setup once for a given Source-Target instance pair
Fully automated into touch button cloning
Works on all releases 10.7 NCA, 1103, 11.5.X
Used at 20 clients or so personally
• Disadvantages
– Not for junior DBA
– Not oracle supported
• FULL Scripts and paper can be found at
www.veritiesllc.com
Questions
Thank You!
F.A.S.T Represented by
Surender Sara - [email protected]