© 2005 Solution Beacon, LLC. All Rights Reserved.
Release 11i Workshops
Introduction to Oracle Applications Release 11i… Part 1: Architecture and InstallationSession LeaderRandy Giefer, Solution Beacon
Release 11i WorkshopsSan Ramon, CA • Worthington, MA •
Los Angeles, CA • St. Louis, MO • Orlando, FLwww.solutionbeacon.com
TRAIL to TEXAS sm
2© 2005 Solution Beacon, LLC. All Rights Reserved.
Introduction Welcome and IntroductionWelcome and Introduction Session OverviewSession Overview
The focus of this presentation The focus of this presentation is to share “Real-World“ is to share “Real-World“ experience as well as tips and experience as well as tips and techniques to install, upgrade techniques to install, upgrade and tune the complex Oracle and tune the complex Oracle Application environment Application environment delivered with Release 11delivered with Release 11ii
© 2005 Solution Beacon, LLC. All Rights Reserved.
Release 11i Concepts,Architecture, and
Installation
4© 2005 Solution Beacon, LLC. All Rights Reserved.
Release 11i Basics to Remember Release 11Release 11ii is not a static release is not a static release Release 11Release 11ii installs everything regardless installs everything regardless
of licensingof licensing Release 11Release 11ii contains constantly evolving contains constantly evolving
technologytechnology Release 11Release 11i i point upgrades introduce point upgrades introduce
significant changes to functionality and significant changes to functionality and technologytechnology
Release 11Release 11ii has significant has significant interdependencies of Critical Products: AD, interdependencies of Critical Products: AD, FND, AK, HZ (TCA), OWF, TXK, ADX, SHT, FND, AK, HZ (TCA), OWF, TXK, ADX, SHT, ATG, AU, FWK, OAMATG, AU, FWK, OAM
5© 2005 Solution Beacon, LLC. All Rights Reserved.
The Biggest and Most Complex Oracle The Biggest and Most Complex Oracle Applications Release Ever!Applications Release Ever!
Eight CD bundle releases containing:Eight CD bundle releases containing: major changes to the tools and major changes to the tools and
technology stacktechnology stack bug fixes bug fixes NEW functionality!NEW functionality!
What is Release 11i?
6© 2005 Solution Beacon, LLC. All Rights Reserved.
Completely New Architecture, Tools and Completely New Architecture, Tools and Technology – True Three-TierTechnology – True Three-Tier Internet Computing Architecture (ICA)Internet Computing Architecture (ICA) Technology Stack – Forms, Java, Apache(html)Technology Stack – Forms, Java, Apache(html) Oracle8Oracle8ii/Oracle9/Oracle9ii – CBO, Partitioning – CBO, Partitioning
Multiple Application Server ComponentsMultiple Application Server Components Forms-Based: ERP, Back OfficeForms-Based: ERP, Back Office HTML/JAVA-Based: Self Service, Workflow, “HTML/JAVA-Based: Self Service, Workflow, “i i ” ”
ProductsProducts Business Intelligence: Discoverer 3Business Intelligence: Discoverer 3ii/4/4ii, Reports, Reports
What is Release 11i?
7© 2005 Solution Beacon, LLC. All Rights Reserved.
Release 11i Products Increased Modules, Functionality, and Increased Modules, Functionality, and
FeaturesFeatures Release 10.7 Release 10.7 40 products40 products Release 11.0.x Release 11.0.x 50 products50 products :: Release 11.5.5 Release 11.5.5 161 products161 products Release 11.5.6 Release 11.5.6 175 products175 products Release 11.5.7 Release 11.5.7 179 products179 products Release 11.5.8 Release 11.5.8 191 products 191 products Release 11.5.9Release 11.5.9 197 products197 products Release 11.5.10Release 11.5.10 209 products209 products
8© 2005 Solution Beacon, LLC. All Rights Reserved.
Bug FixesMore stable functionality (technical and
applications) continuously appearing with each major patch release
11.5.5/6 – ~ 20,000 bug fixes 11.5.7 – ~ 40,000 bug fixes 11.5.8 – > 60,000 bug fixes 11.5.9 – > 100,000 bug fixes 11.5.10 – ~180,000 bug fixes
Initially released on Oracle9i Workflow changed … again Rapid cloning changed … again AD enhancements
Note: metrics from Vision instances
9© 2005 Solution Beacon, LLC. All Rights Reserved.
Vision Database Objects “Stub” applications, performance
improvements, additional functionality continuously appearing with each major patch release
10.7 – ~ 25,000 objects 11.0 – ~ 30,000 objects 11.5.5/6 – ~ 200,000 objects 11.5.7 – ~ 240,000 objects 11.5.8 – ~ 280,000 objects 11.5.9 – ~ 310,000 objects 11.5.10 – ~ 270,000 objects Fresh 11.5.9 – ~ 200,000 objectsNote: metrics from Vision
instances
10 © 2005 Solution Beacon, LLC. All Rights Reserved.
Release 11i Guiding Principles
KISSKISS
Keep it Simple and SupportableKeep it Simple and Supportablesmsm
Possible vs. PracticalPossible vs. Practical
11 © 2005 Solution Beacon, LLC. All Rights Reserved.
10.7 Architecture – Components
Release 10.7 Release 10.7 Client Client Tier Tier
Application Technology StackApplication Technology Stack
Applications / Database Applications / Database Tier Tier
7.3.4.X ORACLE_HOME
Admin Server
Forms Server
Concurrent Processing Server
7.3.4.XDatabase
12 © 2005 Solution Beacon, LLC. All Rights Reserved.
11i Architecture – Components
Release 11.5.10 DVD ReleaseRelease 11.5.10 DVD ReleaseClient Client Tier Tier
Web HTTP Servers Application Technology StackWeb HTTP Servers Application Technology Stack Middle Middle Tier Tier
*optional*optional 9iAS ORACLE_HOME 8.0.6.3 ORACLE_HOME (1.0.2.2.2)Database Database Tier Tier 9.2.0.5 ORACLE_HOME
JInitiator
DiscovererServer *
Apache Admin Server
Forms Server
Concurrent Processing Server
ReportsServer
9.2.0.5Database
13 © 2005 Solution Beacon, LLC. All Rights Reserved.
Architecture – 11.5.1/11.5.2 ClientClient
Oracle JInitiator 1.1.7.27Oracle JInitiator 1.1.7.27 Middle TierMiddle Tier
Webservers (WebDB 2.2 Webservers (WebDB 2.2 andand WebDB 2.5) WebDB 2.5) Jserv 1.1Jserv 1.1 JRE (Java Runtime Environment) 1.1.8JRE (Java Runtime Environment) 1.1.8 Web Listener 2.2Web Listener 2.2 Oracle Forms/Reports 6Oracle Forms/Reports 6ii (6.0.8.8.0) (6.0.8.8.0) Workflow 2.5Workflow 2.5
Database TierDatabase Tier Oracle8Oracle8ii Enterprise Edition 8.1.6 Enterprise Edition 8.1.6 Other Oracle Home Software Directories Other Oracle Home Software Directories
– App 8.0.6, WebDB 8.1.6– App 8.0.6, WebDB 8.1.6
14 © 2005 Solution Beacon, LLC. All Rights Reserved.
Architecture – 11.5.3 ClientClient
Oracle JInitiator 1.1.7.27Oracle JInitiator 1.1.7.27 Middle TierMiddle Tier
Apache Web Server 1.3.9 (Full – jsp, JServ)Apache Web Server 1.3.9 (Full – jsp, JServ) Jserv 1.1Jserv 1.1 JRE (Java Runtime Environment) 1.1.8JRE (Java Runtime Environment) 1.1.8 JDK (Java Development Kit) 1.1.8JDK (Java Development Kit) 1.1.8 Oracle Forms/Reports 6Oracle Forms/Reports 6ii (6.0.8.8.0) (6.0.8.8.0) Workflow 2.5Workflow 2.5
Database TierDatabase Tier Oracle8Oracle8i i Enterprise Edition 8.1.6Enterprise Edition 8.1.6 Other Oracle Home Software Directories – Other Oracle Home Software Directories –
App 8.0.6, iAS 8.1.6 = 9iAS 1.0.2.1App 8.0.6, iAS 8.1.6 = 9iAS 1.0.2.1
15 © 2005 Solution Beacon, LLC. All Rights Reserved.
Architecture – 11.5.4 ClientClient
Oracle JInitiator 1.1.8.7 on ClientOracle JInitiator 1.1.8.7 on Client Middle TierMiddle Tier
Apache Web Server 1.3.9 (Full - jsp, JServ)Apache Web Server 1.3.9 (Full - jsp, JServ) Jserv 1.1Jserv 1.1 JRE (Java Runtime Environment) 1.1.8JRE (Java Runtime Environment) 1.1.8 JDK (Java Development Kit) 1.2.2 (1.3*)JDK (Java Development Kit) 1.2.2 (1.3*) Self Service Framework 5.2.3CSelf Service Framework 5.2.3C Oracle Forms/Reports 6Oracle Forms/Reports 6ii (6.0.8.12.1-Patch 3) (6.0.8.12.1-Patch 3) Workflow 2.5Workflow 2.5
Database TierDatabase Tier Oracle8Oracle8i i Enterprise Edition 8.1.7.1Enterprise Edition 8.1.7.1 Other Oracle Home Software Directories – Other Oracle Home Software Directories – App App
8.0.6, 8.0.6, iiAS 8.1.6 = 9AS 8.1.6 = 9iiAS 1.0.2.1AS 1.0.2.1
16 © 2005 Solution Beacon, LLC. All Rights Reserved.
Architecture – 11.5.5/11.5.6 ClientClient
Oracle JInitiator 1.1.8.13 on ClientOracle JInitiator 1.1.8.13 on Client Middle TierMiddle Tier
Apache Web Server 1.3.9 (Full – jsp, JServ)Apache Web Server 1.3.9 (Full – jsp, JServ) JRE (Java Runtime Environment) 1.1.8JRE (Java Runtime Environment) 1.1.8 JDK (Java Development Kit) 1.3 JDK (Java Development Kit) 1.3 Self Service Framework 5.2.3CSelf Service Framework 5.2.3C Oracle Forms/Reports 6Oracle Forms/Reports 6ii (6.0.8.14.2 – P5) (6.0.8.14.2 – P5) Workflow 2.5Workflow 2.5
Database TierDatabase Tier Oracle8Oracle8i i Enterprise Edition 8.1.7.1Enterprise Edition 8.1.7.1 Other Oracle Home Software Directories – Other Oracle Home Software Directories –
App 8.0.6.3, App 8.0.6.3, iiAS 8.1.6 = 9AS 8.1.6 = 9iiAS 1.0.2.1AS 1.0.2.1
17 © 2005 Solution Beacon, LLC. All Rights Reserved.
Architecture – 11.5.7 ClientClient
Oracle JInitiator 1.1.8.13 on Client Middle TierMiddle Tier
Apache Web Server 1.3.19 (Full – jsp, JServ)Apache Web Server 1.3.19 (Full – jsp, JServ) JRE (Java Runtime Environment) 1.1.8JRE (Java Runtime Environment) 1.1.8 JDK (Java Development Kit) 1.3.1_02 JDK (Java Development Kit) 1.3.1_02 Self Service Framework 5.6ESelf Service Framework 5.6E Oracle Forms/Reports 6Oracle Forms/Reports 6ii (6.0.8.18 – Patch 9) (6.0.8.18 – Patch 9) Workflow 2.6Workflow 2.6
Database TierDatabase Tier Oracle8Oracle8i i Enterprise Edition 8.1.7.3Enterprise Edition 8.1.7.3 Other Oracle Home Software Directories – App Other Oracle Home Software Directories – App
8.0.6.3, 8.0.6.3, iiAS 8.1.7 = 9AS 8.1.7 = 9iiAS 1.0.2.2.2 (Release 1)AS 1.0.2.2.2 (Release 1) Oracle Portal 3.0.9.8.1Oracle Portal 3.0.9.8.1
18 © 2005 Solution Beacon, LLC. All Rights Reserved.
Architecture – 11.5.8 ClientClient
Oracle JInitiator 1.1.8.16 on ClientOracle JInitiator 1.1.8.16 on Client Middle TierMiddle Tier
Apache Web Server 1.3.19 (Full – jsp, JServ)Apache Web Server 1.3.19 (Full – jsp, JServ) JRE (Java Runtime Environment) 1.1.8JRE (Java Runtime Environment) 1.1.8 JDK (Java Development Kit) 1.3.1_02 JDK (Java Development Kit) 1.3.1_02 Self Service Framework 5.6ESelf Service Framework 5.6E Oracle Forms/Reports 6Oracle Forms/Reports 6ii (6.0.8.18 – Patch 9) (6.0.8.18 – Patch 9) Workflow 2.6Workflow 2.6
Database TierDatabase Tier Oracle8Oracle8i i Enterprise Edition 8.1.7.4Enterprise Edition 8.1.7.4 Other Oracle Home Software Directories – App Other Oracle Home Software Directories – App
8.0.6.3, 8.0.6.3, iiAS 8.1.7 = 9AS 8.1.7 = 9iiAS 1.0.2.2.2 (Release 1)AS 1.0.2.2.2 (Release 1) Oracle Portal 3.0.9.8.1Oracle Portal 3.0.9.8.1
19 © 2005 Solution Beacon, LLC. All Rights Reserved.
Architecture – 11.5.9 ClientClient
Oracle JInitiator 1.1.8.16 on ClientOracle JInitiator 1.1.8.16 on Client Middle TierMiddle Tier
Apache Web Server 1.3.19 (Full – jsp, JServ)Apache Web Server 1.3.19 (Full – jsp, JServ) JRE (Java Runtime Environment) 1.1.8JRE (Java Runtime Environment) 1.1.8 JDK (Java Development Kit) 1.3.1_02 JDK (Java Development Kit) 1.3.1_02 Self Service Framework 5.7HSelf Service Framework 5.7H Oracle Forms/Reports 6Oracle Forms/Reports 6ii (6.0.8.21 – Patch 12) (6.0.8.21 – Patch 12) Workflow 2.6.2+Workflow 2.6.2+
Database TierDatabase Tier Oracle9Oracle9i i Enterprise Edition 9.2.0.3Enterprise Edition 9.2.0.3 Other Oracle Home Software Directories – App Other Oracle Home Software Directories – App
8.0.6.3, 8.0.6.3, iiAS 8.1.7 = 9AS 8.1.7 = 9iiAS 1.0.2.2.2 (Release 1)AS 1.0.2.2.2 (Release 1) Oracle Portal 3.0.9.8.4Oracle Portal 3.0.9.8.4
Discoverer 4Discoverer 4ii (4.1.46) (4.1.46)
20 © 2005 Solution Beacon, LLC. All Rights Reserved.
Architecture – 11.5.10 ClientClient
Oracle JInitiator 1.3.1.18. on ClientOracle JInitiator 1.3.1.18. on Client Middle TierMiddle Tier
Apache Web Server 1.3.19 (Full – jsp, JServ)Apache Web Server 1.3.19 (Full – jsp, JServ) JRE (Java Runtime Environment) 1.4.2_04-b05JRE (Java Runtime Environment) 1.4.2_04-b05 JDK (Java Development Kit) 1.4.2JDK (Java Development Kit) 1.4.2 Self Service Framework 5.10Self Service Framework 5.10 Oracle Forms/Reports 6Oracle Forms/Reports 6ii (6.0.8.24 – Patch 15) (6.0.8.24 – Patch 15) Workflow 2.6.3 (OWF.H)Workflow 2.6.3 (OWF.H)
Database TierDatabase Tier Oracle9Oracle9i i Enterprise Edition 9.2.0.5Enterprise Edition 9.2.0.5 Other Oracle Home Software Directories – App Other Oracle Home Software Directories – App
8.0.6.3, 8.0.6.3, iiAS 8.1.7 = 9AS 8.1.7 = 9iiAS 1.0.2.2.2 (Release 1)AS 1.0.2.2.2 (Release 1) Oracle Portal 3.0.9.8.4Oracle Portal 3.0.9.8.4
Discoverer 4Discoverer 4ii (4.1.48) (4.1.48)
21 © 2005 Solution Beacon, LLC. All Rights Reserved.
Single Server Configuration
Single Tier Definition: All Application Single Tier Definition: All Application components installed on a single servercomponents installed on a single server ProsPros
Ease of Administration – installation and Ease of Administration – installation and process controlprocess control
No network trafficNo network traffic Ease of maintenance – single tier patchingEase of maintenance – single tier patching
ConsCons Scalable only within the single server – Scalable only within the single server –
must provide for present and future must provide for present and future growth needsgrowth needs
All or nothing performance tuningAll or nothing performance tuning
22 © 2005 Solution Beacon, LLC. All Rights Reserved.
Multi-Server Configuration Multi-Tier Definition: All Multi-Tier Definition: All
Applications components installed Applications components installed on two or more servers (up to 5 on two or more servers (up to 5 separate nodes)separate nodes) ProsPros
Separate database server Separate database server Load balancingLoad balancingSpecific component level Specific component level
performance tuning performance tuning Ability to add additional front-end Ability to add additional front-end
servers as user load increasesservers as user load increases
23 © 2005 Solution Beacon, LLC. All Rights Reserved.
Multi-Server Configuration Multi-Tier Definition, continuedMulti-Tier Definition, continued
ConsCons Increased network trafficIncreased network traffic Increased administration – process control Increased administration – process control
and backupsand backups Increased maintenance – more patches Increased maintenance – more patches
and platformsand platforms Greater architectural complexityGreater architectural complexity Consistent production, test and Consistent production, test and
development environmentsdevelopment environments More complicated load balancing – OLTP More complicated load balancing – OLTP
vs. Batch vs. Webvs. Batch vs. Web Higher OS license costsHigher OS license costs
24 © 2005 Solution Beacon, LLC. All Rights Reserved.
Server Configuration Recommendations
Single TierSingle Tier New Paradigm ShiftNew Paradigm Shift
ScalableScalable As Needed GrowthAs Needed Growth
MaintenanceMaintenance PatchingPatching
25 © 2005 Solution Beacon, LLC. All Rights Reserved.
Server Sizing Configurations
Disk Space (for fresh install)Disk Space (for fresh install) 50GB for the software and database50GB for the software and database 15GB for the software staging areas15GB for the software staging areas 10-25GB for patches, log/out files, 10-25GB for patches, log/out files,
archives, disk backups, temporary files, archives, disk backups, temporary files, etc.etc.
RAID for disk drives is necessaryRAID for disk drives is necessary Typical ERP Server ConfigurationTypical ERP Server Configuration
Combined Single ServerCombined Single Server 4CPU, 4GB RAM (Scalable)4CPU, 4GB RAM (Scalable) 75GB disk effective (after RAID)75GB disk effective (after RAID)
26 © 2005 Solution Beacon, LLC. All Rights Reserved.
Server Sizing Recommendations
MemoryMemory Oracle Recommendation – 8MB/userOracle Recommendation – 8MB/user Real World RecommendationReal World Recommendation
15MB for every active user15MB for every active user15MB for concurrent manager 15MB for concurrent manager
processesprocesses20MB for database background 20MB for database background
processesprocesses500MB SGA (pinning packages and 500MB SGA (pinning packages and
sequences)sequences)
27 © 2005 Solution Beacon, LLC. All Rights Reserved.
CPUCPU Oracle Recommendation – 70 Oracle Recommendation – 70
users/CPUusers/CPU Real World RecommendationReal World Recommendation
15 Active Users/CPU (super users)15 Active Users/CPU (super users)50 Logged Users/CPU50 Logged Users/CPU1 CPU Dedicated – Database and 1 CPU Dedicated – Database and
Application Processes (DB, Forms, Application Processes (DB, Forms, Web, Concurrent Managers)Web, Concurrent Managers)
Server Sizing Recommendations
28 © 2005 Solution Beacon, LLC. All Rights Reserved.
Desktop OS and Sizing – Oracle Minimum
Windows Windows WindowsWindows Windows Windows NT 4.0 2K XPNT 4.0 2K XP
CPU – MHzCPU – MHz Pentium Pentium Pentium Pentium PentiumPentium
200+200+ 200+ 200+ 200+200+““you will realize significant performance you will realize significant performance improvement with faster (1.4GHz +) processors”improvement with faster (1.4GHz +) processors”
Memory Memory 64MB 64MB 64MB 64MB 64MB64MB
““users who are concurrently running Oracle users who are concurrently running Oracle Applications with other desktop applications, will Applications with other desktop applications, will experience better performance with at least 96 experience better performance with at least 96 MB of RAM”MB of RAM”
Macintosh?Macintosh?•at least 200MHz PowerPC G3 •Apple Mac OS clients require a minimum of 128 MB
29 © 2005 Solution Beacon, LLC. All Rights Reserved.
Desktop Sizing – Real WorldCPUCPU 1GHz+1GHz+
MemoryMemory Minimum 512MB (1024MB better)Minimum 512MB (1024MB better)
Color PaletteColor Palette Must be able to run a minimum of 256 Must be able to run a minimum of 256 colorscolors (a Java requirement), but ideally (a Java requirement), but ideally 65,536 (64K) colors65,536 (64K) colors
JinitiatorJinitiator Latest release that is certified for the Latest release that is certified for the Oracle Applications Release (1.1.8.16 Oracle Applications Release (1.1.8.16 released with 11.5.8)released with 11.5.8)
BrowserBrowser Either Netscape Navigator 4.73 or higher or Either Netscape Navigator 4.73 or higher or Internet Explorer* 5 or higherInternet Explorer* 5 or higher
* Why IE? - Preferred by Oracle - MetaLink* Why IE? - Preferred by Oracle - MetaLink
Windows Windows 95/98/200095/98/2000
30 © 2005 Solution Beacon, LLC. All Rights Reserved.
Desktop Considerations Java applets are particularly CPU intensive since they Java applets are particularly CPU intensive since they
are run locally on the user’s PC; a faster CPU has a are run locally on the user’s PC; a faster CPU has a more noticeable affect on performance, all other more noticeable affect on performance, all other things being equalthings being equal
JInitiator 1.1.8.7 and certain other Oracle tools are JInitiator 1.1.8.7 and certain other Oracle tools are incompatible with Pentium 4 Processors (minimum of incompatible with Pentium 4 Processors (minimum of 1.1.8.10 required)1.1.8.10 required)
Automatic download and installation of the JInitiator Automatic download and installation of the JInitiator requires temporary changes to IE security settingsrequires temporary changes to IE security settings
Periodic “cleaning” of cache and other temporary Periodic “cleaning” of cache and other temporary files is necessary to reduce browser/memory issues files is necessary to reduce browser/memory issues while accessing the Oracle Applications (see Clean while accessing the Oracle Applications (see Clean Cache in Free Tools section at Cache in Free Tools section at http://www.solutionbeacon.comhttp://www.solutionbeacon.com ) )
31 © 2005 Solution Beacon, LLC. All Rights Reserved.
Single UNIX Account Owner
ProsPros Ease of accessEase of access Ease of administrationEase of administration Ease of maintenance – specifically patchingEase of maintenance – specifically patching
ConsCons Less auditability (NT)Less auditability (NT) Less control – more access to entire systemLess control – more access to entire system
Single User – oraappl, oraSID, or any Single User – oraappl, oraSID, or any other other single account other than oracle*single account other than oracle*
*Why not oracle?*Why not oracle?
32 © 2005 Solution Beacon, LLC. All Rights Reserved.
Multiple UNIX Account Owners
ProsPros Separation of duties / responsibilities Separation of duties / responsibilities
by accountby account Auditability – increased security, Auditability – increased security,
restricted access restricted access
Multi-User – oraSID (database, database Multi-User – oraSID (database, database software) and applSID (applications/web software) and applSID (applications/web software)software)
33 © 2005 Solution Beacon, LLC. All Rights Reserved.
Multiple UNIX Account Owners
ConsCons Need root access for installation (NT)Need root access for installation (NT) Increased complexity of Apps process Increased complexity of Apps process
managementmanagement Application vs. database maintenance Application vs. database maintenance
must be closely coordinated and controlledmust be closely coordinated and controlled Directory and file permissions may need to Directory and file permissions may need to
be adjusted for dual access / managementbe adjusted for dual access / management Increased sharing of database/application Increased sharing of database/application
filesfiles
34 © 2005 Solution Beacon, LLC. All Rights Reserved.
Account Recommendation Use a single account instead of multiple Use a single account instead of multiple
accounts which typically increases the accounts which typically increases the overall amount of time until an Application overall amount of time until an Application issue is resolvedissue is resolved
For most companies, the distinction For most companies, the distinction between Applications between Applications management/maintenance and control is management/maintenance and control is constantly being blurred by business constantly being blurred by business considerations that force support staff to considerations that force support staff to respond quicker to Application issuesrespond quicker to Application issues
At a minimum, if multiple accounts are At a minimum, if multiple accounts are used, the accounts must use the same used, the accounts must use the same group (dba)group (dba)
35 © 2005 Solution Beacon, LLC. All Rights Reserved.
“Simplified” OFARapid Install Directories – 11.5.9Rapid Install Directories – 11.5.9ORACLE_SID@servername > du -sk* (K bytes)ORACLE_SID@servername > du -sk* (K bytes)15,784,80715,784,807 SIDappl (APPL_TOP = 16GB)SIDappl (APPL_TOP = 16GB)650,190650,190 SIDcomn (COMN_TOP) – for SIDcomn (COMN_TOP) – for Java/HTMLJava/HTML25,360,69625,360,696 SIDdata (25GB = Database Files)SIDdata (25GB = Database Files)5,106,0895,106,089 SIDdb (2.1GB = 8.1.7, SIDdb (2.1GB = 8.1.7, oraInventory oraInventory
and JRE)and JRE)6,038,2136,038,213 SIDora (6GB = 8.0.6 (APPL_TOP), SIDora (6GB = 8.0.6 (APPL_TOP),
iiAS (APACHE/9AS (APACHE/9iiAS) Oracle AS) Oracle HomesHomes
60GB60GB Total (Approx)Total (Approx)*Increasing with every release – 11.5.10 Vision is 85 GB!*Increasing with every release – 11.5.10 Vision is 85 GB!
36 © 2005 Solution Beacon, LLC. All Rights Reserved.
Software Staging Directories3.3GB3.3GB ora8i/DBora8i/DB10.7GB10.7GB oraAppDB - compressed oraAppDB - compressed datafilesdatafiles4.7GB4.7GB oraAppsoraApps2.2GB2.2GB oraiASoraiAS390K390K red/startCD*red/startCD*
22GB Total Staging Area required is 22GB Total Staging Area required is approximate approximate and varies based on platform. and varies based on platform. On Linux, 11.5.10 is approximately On Linux, 11.5.10 is approximately 24GB.24GB.
Only Minimum Application Software – no Only Minimum Application Software – no other Software, Doc or Patch CDs Loaded.other Software, Doc or Patch CDs Loaded.
37 © 2005 Solution Beacon, LLC. All Rights Reserved.
Supplemental Directories*../SIDadm – Administrative../SIDadm – Administrative../SIDarch – Archive Logs (Large), $ARCH_TOP../SIDarch – Archive Logs (Large), $ARCH_TOP../SIDexp – Exports../SIDexp – Exports../SIDinst – Installation../SIDinst – Installation../SIDlog – Log Files (Large)../SIDlog – Log Files (Large)../SIDout – Output Files (Large)../SIDout – Output Files (Large)../SIDptch – Patches (Large), $PATCH_TOP../SIDptch – Patches (Large), $PATCH_TOP../SIDscr – Scripts, $SCRIPTS_TOP ../SIDscr – Scripts, $SCRIPTS_TOP ../SIDtmp – Temporary (Large)../SIDtmp – Temporary (Large)
As compared to: As compared to: ../SIDcomn – $COMN_TOP../SIDcomn – $COMN_TOP
* DBA created* DBA created
38 © 2005 Solution Beacon, LLC. All Rights Reserved.
Applications Process Ports
Note: 11.5.7/8/9/10 Apps will reserve Note: 11.5.7/8/9/10 Apps will reserve multiple sequential portsmultiple sequential ports
SIDSIDServerServerFunctionFunctionDatabaseDatabaseRPCRPCReportsReportsWeb ListenerWeb ListenerServletServletForms ListenerForms ListenerMetrics Server DataMetrics Server DataMetrics Server Req.Metrics Server Req.JTF Fullfilment ServerJTF Fullfilment Server
iMeeting Collaboration iMeeting Collaboration ServerServeriMeeting Recording iMeeting Recording ServerServeriMeeting MonitoriMeeting MonitorMap Viewer ServletMap Viewer ServletOEM Web UtilityOEM Web UtilityVisiBroker Orb ServerVisiBroker Orb ServerMSCA ServerMSCA ServerMSCA DispatcherMSCA DispatcherOACORE Servlet RangeOACORE Servlet RangeDiscoverer Servlet RangeDiscoverer Servlet RangeForms Servlet RangeForms Servlet RangeForms StartForms Start
39 © 2005 Solution Beacon, LLC. All Rights Reserved.
Environment Management Three Specific Oracle Environments for Three Specific Oracle Environments for
supporting the 11supporting the 11ii Applications – Database, Applications – Database, Applications, WebApplications, Web
Manually create profiles for each Manually create profiles for each environment (profile.SID.app, profile.SID.db, environment (profile.SID.app, profile.SID.db, profile.SID.web)profile.SID.web)
Create a list profiles program to Create a list profiles program to automatically list all available environment automatically list all available environment profiles upon signonprofiles upon signon
Source the appropriate profile for the task(s) Source the appropriate profile for the task(s) to be performed including start, stop, to be performed including start, stop, backups and patchingbackups and patching
40 © 2005 Solution Beacon, LLC. All Rights Reserved.
Environment Profile Management
Facilitates .profile establishment (DB, Facilitates .profile establishment (DB, Apps, Web)Apps, Web)
No need for multiple UNIX .profile No need for multiple UNIX .profile scriptsscripts
Provides start/stop/status – all Provides start/stop/status – all componentscomponents
Download from Free 11Download from Free 11ii Tools section of Tools section of Solution Beacon websiteSolution Beacon website
Oracle Applications Environment Manager (OAEM)
41 © 2005 Solution Beacon, LLC. All Rights Reserved.
Recommendations Summary Single TierSingle Tier Single AccountSingle Account Single MountpointSingle Mountpoint
42 © 2005 Solution Beacon, LLC. All Rights Reserved.
Q&AHope you enjoyed this Release 11i Hope you enjoyed this Release 11i session! session!
Remember:Remember: KISSKISS
Keep It Simple and Keep It Simple and SupportableSupportablesmsm
Randy [email protected] www.solutionbeacon.com