OAUG SysAdmin SIG MeetingOAUG SysAdmin SIG Meeting

Sunday, Oct 11, 2009Sunday, Oct 11, 2009San Francisco, CASan Francisco, CA

Moscone West 3009Moscone West 3009

Welcome!

• Welcome to Oracle OpenWorld 2009!• Welcome to the SysAdmin SIG!• Thank You Oracle!

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

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, resources and information that can enhance their System Administration knowledge and experience.

SysAdmin SIG Topic Areas• EBS Systems Management• Concurrent Managers• SysAdmin Scripts• Patching • Architecture & Security• 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

http://sysadminsig.oaug.org/index.shtml

Related OAUG SIGs

• Related SIGs– DBA SIG– Upgrade SIG– Workflow SIG– E-Business Applications Technology SIG– Fusion Middleware SIG– Governance, Risk & Compliance SIG

SysAdmin SIG Meetings

• Two meetings per year:– Collaborate– Oracle OpenWorld

• Next Meeting:– Collaborate 2010 - April 18-22 in Las Vegas

SysAdmin-Related Sessions• See Handout for OOW Sessions

Relating to:

– EBS System Administration– EBS Technology– EBS Security– Virtualization– OS (Linux, Solaris, etc.)

News & Notes

MetaLink Is Being Retired• Classic MetaLink Retires Friday, 11/6• Being Replaced by My Oracle Support• Doc ID: 950042.1 FAQ• Doc ID: 841061.1 Latest details• How Many Still Use “MetaLink Classic”?• Hopefully more successful than Coca-Cola’s

attempt at improvement…

MetaLink Is Being Retired…• BENEFITS

– User Dashboard – System Health (via Configuration Manager)– Improved Service Request management (via

Configuration Manager)– Community

MetaLink Is Being Retired…• DRAWBACKS

– Tightly coupled with the Configuration Manager– UI is challenging and busy (sometimes distracting)

and you can’t:• Always copy screen text to clipboard• Can’t resize some screen windows • Can’t Shift+Insert into search box

– Has a learning curve, so don’t wait until last minute.

• Note: OCM now embedded in RDA

Patch Set Update (PSU)• PSUs are proactive cumulative patches

containing recommended bug fixes• PSUs contain the CPU patches as well as

additional “controlled content” (i.e. no optimizer plan changes, no configuration changes)

• Released on the same quarterly schedule as the Critical Patch Updates (CPU)

• Rolling RAC installable• Regression tested

Patch Set Update (PSU)…• A PSU serves as a new baseline version for

reporting issues to Oracle (e.g. Initial Release 10.2.0.4.1)

• A PSU can be applied:– on the base release version– on any earlier PSU– on an any earlier CPU for the base release version– on the CPU released at the same time

PSU vs CPU• The PSU and CPU released each quarter

contain the same security content. • The patches employ different patching

mechanisms, so…• “…customers need to choose wisely which

patch satisfies their needs better…”

PSU vs CPU…• Once a PSU has been installed, the

recommended way to get future security content is to apply subsequent PSUs.

• “…Reverting from PSU back to CPU, while possible, would require significant effort, and so is not advised...”

• “Choose wisely grasshopper…”

Patch Set Update (PSU)…• For more information:

– 854428.1 - Introduction to Patch Set Updates – 861152.1 - Does Initial PSU (10.2.0.4.1) Change

The 10.2.0.4.0 Database Version to 10.2.0.4.1 ?

Critical Patch Updates• Speaking of CPUs…• CPU release dates are the Tuesday closest

to the 15th of January, April, July, and October. However, the October 2009 release date has been moved - 3615609.993

• The next four CPU release dates:• October 20, 2009• January 12, 2010• April 13, 2010• July 13, 2010

Browser Certifications• IE8 Now Certified with EBS 11i• Requirements:

– Maintenance Pack 11.5.10 CU2 or later– 11i.ATG_PF.H Rollup 6 (RUP 6, Patch 5903765) or

later– Oracle Forms6i Patchset 19 (6.0.8.28.x) - 125767.1– Forms6i MLR Patch 8888184

Browser Certifications…• Firefox 3.5 Now Certified with EBS 11i• Requirements:

– Maintenance Pack 11.5.10 CU2 or later– 11i.ATG_PF.H Rollup 6 (RUP 6, Patch 5903765) or

later– Oracle Forms6i Patchset 18 (6.0.8.27.x) - 125767.1– Applications Framework Patch 7651759– Strongly recommended to apply patch 7567782 to

switch Firefox to a non-static versioning model

Browser Certifications…• Desktop Client Requirements for both

IE8 and Firefox 3.x…– Windows XP Service Pack 2 (min)– Windows Vista Service Pack 1 (min)– Sun JRE 1.5.0_12 or later, or JRE 1.6.0_03

or later

Browser Certifications…• Oracle Notes:

– Recommended Browsers for Oracle E-Business Suite Release 11i - 285218.1

– Upgrading Sun JRE (Native Plug-in) with Oracle Applications 11i for Windows Clients - 290807.1

Database Certifications• 11gR2 Database Certified with E-

Business Suite 11i – Linux Only now.• Other Platforms and R12 Pending

EBS Database Parameters

• Recently Updated• Database Initialization Parameters for

Oracle Applications– Release 11i - 216205.1 – Release 12 - 396009.1

Next Generation AD

• Feasibility Studies At OOW• Survey and Poll• Future, Ongoing Participation With Our

SIG

Oracle Presentation