Oracle Applications User Group
SysAdmin SIG 2006 Oracle OpenWorld
Randy Giefer
SysAdmin SIG Chairperson Slide 2:Welcome
Welcome to Oracle OpenWorld 2006!
Welcome to the SysAdmin SIG!
Audience survey
Slide 3:Agenda
OAUG Overview
SIG Overview
SIG Briefings
News and Notables
Items pertaining to System Administration
Questions and Answers
Slide 4:OAUG Member Benefits
Advocacy opportunities to influence Oracle on product enhancements, usability, new features, Oracle support, pricing and quality
Knowledge that showcases the latest trends and techniques used by industry leaders through our national and regional events and our publications, such as OAUG Insight magazine
Communication with other OAUG members worldwide through participation in OAUG committees, leadership positions, interaction with Oracle Corporation's user initiatives, frequent member surveys, and Oracle management briefings
Education through the hundreds of career-enhancing presentations in our conference paper database archive, as well as discounts to conferences and Oracle education
Networking with Oracle customers, industry experts, third-party software firms, and other Oracle Applications specialists through our Member Database and Online Vendor Directory
Slide 5:OAUG Resources
OAUG Enhancement/Fusion Feature Request System
OAUG Community Forum
OAUG Skills Marketplace
OAUG Fusion Council
OAUG Customer Support Council
OAUG Pricing Council
OAUG Best Practices Forums
OAUG Vendor Directory
Slide 6:OAUG Resources (cont.)
OAUG Vendor Directory
OAUG Member Database
OAUG Conference Paper Database
FAQs
OAUG Press Room
Oracle Resources
OAUG-Sponsored Listservers
Other Listservers
OAUG Emporium
Other User Groups
Slide 7:OAUG “Road To Las Vegas”
Road To Las Vegas - Release 11i Workshops
Dallas, TX
Raleigh, NC
Denver, CO
Atlanta, GA
Detroit, MI
Connection Point 2007
April 15-19, 2007
Mandalay Bay Resort and Casino
Slide 8:SysAdmin SIG
Share knowledge and experience about a variety of topics relating to Oracle Applications System Administration
Oracle Applications System Administration
Operating System Administration for Oracle Applications Installations
Slide 9:Purpose & Mission Statement
The SysAdmin Special Interest Group (SIG) provides a forum for OAUG members and participants to share updates, tips and successful practices relating to System Administration in an Oracle Applications environment.
The SysAdmin SIG strives to enable System Administrators to become more effective and efficient in their jobs by providing them with access to people and information that can their System Administration knowledge and experience.
Slide 10:SysAdmin SIG Topic Areas
Concurrent Managers
SysAdmin Scripts
Architecture
Workflow Administration
Printer Drivers & Keyboard Mappings
System Administrator Roles & Responsibilities
Oracle Tools and Utilities
Third-Party Tools
Useful Links and Webmaster
Oracle Enhancements
UNIX
Linux
System Profiles
Slide 11:SysAdmin SIG and other OAUG SIGs
Related SIGs
DBA SIG
Upgrade SIG
Workflow SIG
Middleware SIG (Formerly Apps Technology Stack SIG)
Internal Control & Security SIG
Slide 13:Web Site Organization
Oracle Applications System Administration
Concurrent Managers
Printer Drivers & Keyboard Mappings
Architecture
Workflow Administration
Oracle Tools and Utilities
Third-Party Tools
System Administration
UNIX
Linux
Windows
Slide 14:Web Site Organization (cont.)
General
SIG Mission
SIG List Server
Useful Links and Webmaster
System Administrator Roles and Responsibilities
Oracle Enhancement Requests
SysAdmin Scripts
Slide 15:SIG Briefings
Two meetings per year:
Connection Point
Oracle OpenWorld
Next Meeting at OAUG Connection Point
Slide 16:News and Notables
Release 11i certification with Oracle RDBMS 10g
Application Technology Rollups
ATG_PF.H Rollup 3
ATG_PF.H Rollup 4
RUP N-1
October Critical Patch Update (CPU)
Slide 17:10g R2 RDBMS Certification
Oracle Applications Release 11i certification with Oracle RDBMS 10g Release 2 (362203.1)
Pre-Requisites
11.5.10 E-Business Suite Consolidated Update 2
Developer 6i Patch set 17
Sun Solaris mandatory patch required
Mandatory patch required to be installed and run AFTER installation of the 10.2.0.2 Patch Set on Sun Sparc Solaris 64-bit. See Note 5117016.8
Slide 18:Applications Technology Rollups
Applications Technology Group (ATG)
11.5.10 Product Family (PF) H and higher
“Oracle Applications Technology 11i.ATG_PF.H”
Series of Cumulative Rollups
11.5.10.2 = Rollup 2
From a Technology Perspective:
Rollup 3 ~ 11.5.10.3
Rollup 4 ~ 11.5.10.4
Released apx. every 6 months
Slide 19:ATG_PF.H Rollup 3 Enhancements
Profile “Password Case Option“
Forces Case Sensitivity in User Passwords
Better security, better integration with OID
Values: Sensitive, Insensitive, Mixed
Profile “Server+Responsibility” Hierarchy Type (Allows profile values to be set for specific combinations of servers and responsibilities)
Oracle User Management: Configurable User Name Policy (Validates a specified format for user names – e.g. e-mail address)
Slide 20:ATG_PF.H Rollup 4 (RUP4)
About Oracle Applications Technology 11i.ATG_PF.H Rollup 4 – MetaLink Note: 365228.1 - Patch 4676589
Security Patch Rollup As Well
From: January 2005 Critical Patch Update
Through: July 2006 Critical Patch Update
As well as the previous Security Alerts
Except:
Patch 3904641 (FND)
Patch 3417698 (BNE)
Patch 5021981 (SSO)
Slide 21:ATG_PF.H Rollup 4 Enhancements
Oracle Alert
Alert now leverages the Workflow Notification Mailer
Oracle Workflow
Notification Enhancements
Monitor Responses Page
Workflow XML Loader Enhancements
On-Demand Item Attributes
Oracle XML Gateway
Dynamically Embedding of XML Fragments
Slide 22:ATG_PF.H Rollup 4 Enhancements
Oracle Applications Framework
Attachments - Publish to Catalog
Partial Page Rendering (PPR) - Debugging
Personalizations - Advanced Tables
Personalizations - Creating a Link
Personalizations - Customizing Look-and-Feel (CLAF)
Personalizations - URL Parameters Retained
Extensions - Deploying
Oracle Application Object Library
Forms Personalization - New Property Type for Blocks
Slide 23:ATG_PF.H Rollup 4 Changes
Deleted Profile: ‘Password Case Option’
New Profile: ‘Signon Password Case’
'Insensitive‘
'Sensitive‘ ('Mixed' is no longer supported)
Slide 24:RUP N-1
RUP4 is a Rebaselined Codebase (363827.1)
New Patching Methodology for the Oracle Applications Technology Product Family
Baseline = earliest code level for one-off patches
ATG is only going to maintain current baseline (RUP N) and previous baseline (RUP N-1)
Starting in July 2007*
Oracle strongly recommends RUP4 by EOY ’06!
Slide 25:October Critical Patch Update (CPU)
Roadmap to the Oracle Critical Patch Update October 2006 documentation(391560.1)
Critical Patch Update Advisory (391558.1)
101 New Security Fixes Across All Products!
CPU Format Improvements:
New Common Vulnerability Scoring System (CVSS) to summarize vulnerabilities
Each product suite contains a brief executive summary of the number and type of vulnerabilities
Slide 26:CPU / Vulnerability Scoring
New method adopted by Oracle to assess Risk using the Common Vulnerability Scoring System (CVSS).
CVSS is an attempt to "standardize" the definition of a vulnerability's severity.
http://www.first.org/cvss/cvss-guide.html
Score defines the severity of the vulnerability
Ranges between 0.0 and 10.0
10.0 represents the highest
Terms and Definitions for Risk Matrix (394486.1)
Slide 27:E-Business Suite Critical Patch Update Note 372931.1
For the October 2006 Critical Patch Update (CPUOct2006), the minimum supported baseline for Oracle E-Business Suite Release 11.5.10.x will be Oracle Applications Technology 11i.ATG_PF.H RUP3 (4334965).
The 11.5.10 CU2 for ATG Product Family will not be a supported baseline for CPUOct2006.
The minimum supported baseline for all other 11i releases, including 11.5.7, 11.5.8, and 11.5.9, will remain at the patch levels listed in Note 363827.1
Slide 28:SysAdmin-Related OOW Sessions
S281377 Technology Directions for Oracle Applications
Monday: 11:00 AM -12:00 PM 103 Moscone South
S281408 Extending Oracle E-Business Suite with Desktop Applications, Using WebADI
Monday: 3:15 PM -4:15 PM 2005 Moscone West
S281398 Oracle and Pella: A Case Study in Reducing Oracle E-Business Suite Maintenance Downtime
Monday: 4:45 PM -5:45 PM 2005 Moscone West
Slide 29:SysAdmin-Related OOW Sessions
S281651 10 Things You Can Do Now to Prepare for Oracle Fusion Applications
Tuesday: 10:45 AM - 11:45 AM 2010 Moscone West
S280814 Oracle E-Business Suite Technology Updates
Tuesday: 12:15 PM -1:15 PM 2009-2011 Moscone West
S281383 Deep Dive: Oracle E-Business Suite Release 12 New Technology Stack
Tuesday: 1:45 PM -2:45 PM 2008 Moscone West
Slide 30:SysAdmin-Related OOW Sessions
S281400 Oracle XML Publisher: Enterprise Reporting and Delivery Platform
Tuesday: 1:45 PM - 2:45 PM 2009-2011 Moscone West
S281402 Oracle Application Framework (OAF): Architecture, Personalization, and Extensibility in Oracle E-Business Suite Release 12
Tuesday: 1:45 PM - 2:45 PM 2010 Moscone West
S281393 Tuning Oracle E-Business Suite
Tuesday: 4:30 PM - 5:30 PM 2005 Moscone West
Slide 31:SysAdmin-Related OOW Sessions
S281407 Oracle Application Framework: Troubleshooting
Tuesday: 4:30 PM - 5:30 PM 2010 Moscone West
S281396 E-Business Suite Lifecycle Management
Wednesday: 11:30 AM - 12:30 PM 2007 Moscone West
S281397 Oracle E-Business Suite System Management: Release 12 New Features
Wednesday: 2:30 PM - 3:30 PM 2008 Moscone West
Slide 32:SysAdmin-Related OOW Sessions
S281386 Implementing Oracle Applications 11.5.10 on Oracle Real Application Clusters 10g and Automatic Storage Management
Wednesday: 4:00 PM - 5:00 PM 2005 Moscone
S281394 How to Secure Your Oracle E-Business Suite Deployment
Wednesday: 4:00 PM - 5:00 PM 2010 Moscone West
S281403 Oracle E-Business Suite Release 12: Installation and Cloning Enhancements
Wednesday: 4:00 PM - 5:00 PM 2008 Moscone West
Slide 33:SysAdmin-Related OOW Sessions
S282213 Optimizing Oracle/Siebel Applications for the Sun Microsystems Chip Multithreading (CMT) Platform
Wednesday: 4:00 PM - 5:00 PM Salon 12 Marriott Hotel
S285139 Streamlining Your Oracle Deployment with VMware Infrastructure
Wednesday: 4:00 PM - 5:00 PM 200 Moscone South
S281395 Security Administration in Oracle E-Buisness Suite: Overview of Oracle User Management
Wednesday: 5:30 PM - 6:30 PM 2010 Moscone West
Slide 34:SysAdmin-Related OOW Sessions
S281414 Oracle Workflow: Oracle E-Business Suite Release 12 Updates
Thursday: 8:00 AM -9:00 AM 2009 Moscone West
S281593 Oracle XML Publisher for Oracle E-Business Suite, with a Customer (City of West Palm Beach) Case Study
Thursday: 8:00 AM -9:00 AM 2010 Moscone West
S281399 Oracle E-Business Suite Patch Management: A Dive into OAM/AD Features
Thursday: 9:30 AM -10:30 AM 2008 Moscone West
Slide 35:SysAdmin-Related OOW Sessions
S281412 The Oracle E-Business Suite Release 12: Process, Integration, and Eventing
Thursday: 9:30 AM -10:30 AM 2007 Moscone West
S281654 Partitioning and Purging Best Practices for Oracle E-Business Suite
Thursday: 9:30 AM -10:30 AM 2010 Moscone West
S282865 How to Personalize Your Oracle E-Business Suite Without Writing Code: A Talk About Forms Personalization and the OA Framework
Thursday: 12:30 PM -1:30 PM 2010 Moscone West
Slide 36:SysAdmin-Related OOW Sessions
S281409 Oracle Forms Personalization Without Coding
Thursday: 2:00 PM - 3:00 PM 2010 Moscone West
S283117 Fax and E-mail from Oracle E-Business Suite, Using Oracle XML Publisher
Thursday: 3:30 PM - 4:30 PM 2006 Moscone West
S283537 Concurrent Manager Queue Overlap Analysis
Thursday: 3:30 PM - 4:30 PM 3024 Moscone West
Slide 37:Lunch
Yosemite lounge area (across from Yosemite A/B/C) between 10:45am and 12:00pm to pick up lunch tickets
Thank you!
Randy Giefer
rgiefer@solutionbeacon.com Slide 38:Questions and Answers
Watch for our new book:
Installing, Upgrading and Maintaining Oracle E-Business Suite Applications 11.5.10.2
It’s coming THIS YEAR!
Sign Up For the Solution Beacon Newsletter at www.solutionbeacon.com
so you’ll be notified when it’s available!