Using MOS Latest Features Enhancements and OCM Deployment

Using MOS – Latest Features, Enhancements and OCM Deployment Methods April C. Sims, DBA Southern Utah University Session # 338

Book Author Executive Editor Best Practices Booklet

New Features & Enhancements • • Enhancements in 5. 2. 1 Upgrade Advisors Tips and Tricks List Oracle Configuration Manager

My Oracle Support 5. 2. 1 Users can specify accessibility styles Improved Certification searches SR – Hardware option, 2 new contact fields, grant privs (view only, no access), selectable SR severity Non-tech SR Contact US SRs Health Check Recommendations Search Features More Intuitive - ora-600 error , put in 600. 1 to find Lookup Tool

Lifecycle Processes and Activities Lifecycle processes Innovate Install Upgrade Operate Optimize Support Users Maintain / Manage Activities Evaluate Plan Configure Test Implement Accept

Upgrade Advisors • Dynamic documents – guide you through an upgrade lifecycle – step by step instructions. – Includes best practices collected over numerous upgrades • Benefits of Using Upgrade Advisors – Information presented in multimedia formats – Lifecycle approach- what you need when you need – Supported via Collaborative Support - enabling shared experience with peers and Oracle experts – Regularly updated

Upgrade Advisors available NOW Oracle Database Upgrade from 10. 2 to 11. 2 Oracle Database Upgrade from 9. 2 to 11. 2 Fusion Middleware Oracle. AS 10 g Forms/Reports Services to Oracle Middleware 11 g Rel 1 Fusion Middleware Oracle. AS 10 g Portal to Oracle Middleware 11 g Rel 1 Fusion Middleware Web. Logic Server 9. 2. 3 to 10. 3. 3 JD Edwards One. World Xe to Enterprise. One 9. 0 JD Edwards Enterprise. One 8. 11 SP 1 to Enterprise. One 9. 0 JD Edwards Enterprise. One 8. 12 to Enterprise. One 9. 0 E-Business Suite Upgrade from 11. 5. 10. 2 to 12. 1. 2 People. Soft Peoplesoft People. Tools upgrade from PT 8. 48/PT 8. 49 to PT 8. 50 People. Soft Peoplesoft FSCM upgrade from 8. 9 to 9. 1 People. Soft HCM upgrade from 8. 9 MP 1 to 9. 1 Siebel CRM Upgrade from 7. 8. x or 8. 0. x to Siebel 8. 1. 1. x

Example - Siebel Upgrade Advisor

Oracle Configuration Manager • OCM Standalone Installation • OCM with Support Hub – all OCM agents feed to single Internet connected node • EM with Harvester – uploads in connected mode, not all targets • OCM Product Specific Installations – DB, Fusion MW • RDA (Remote Diagnostic Agent) - integrated with OCM • OCM Troubleshooting • OCM & MOS Administration – see Tip/Tricks Section • Patch Plans • SR Creation with Config • Remove OCM, targets and systems – only Customer User Administrator can do this!

Oracle Configuration Manager • Manage automatic uploads to MOS • Viewable with same CSI number • Contains details about hardware, software, databases and application servers • GUI interface along with configurations provide a personalized visit to MOS • New Mass Deployment Utility for OCM deployment

OCM Mass Deployment Utility • Version 3. 2+ • Found on the MOS collector tab – Configuration Manager Repeater and Mass Deployment Tools • Find the OCM Companion Distribution Guide. • Edit csv template file to enter all servers • Executed on a single node with ssh access to entries in template

Use OCM Securely • Use disconnected mode with Oracle Support Hub • Manual upload of a single node • Mask IP, MAC addresses, Schema usernames • Request deletion of configuration information

Global Customer Support Security Practices • • • Trace, dump, log, ADR, RDA Support Assistant, Oracle Web Conferencing OS Scirpts, output Screenshots Configuration files Scripts Output files Word, Excel and Powerpoint Presentations SQLTXPLAIN TKPROF

Issues with Conflicts and Rollbacks Without My Oracle Support • Download patch then… • Install…. if conflict then… • Check if any key patches rolled back…if rolled then…. • Merge request…. . then • Wait…. might be too late for this CPU, narrow window…. maybe next quarter! With My Oracle Support • Patch Plan • Auto checks prerequisites • Checks Conflicts before downloading • Request Merge before downloading • Check Recommendations • Deployment Plan Available

Troubleshooting Patch Application Failure No configurations Uploaded to Oracle • Most nodes have unique patch history due to hardware rotations • Usually requires a Service Request • Completely manual process • May take weeks to resolve Oracle Configuration Manager and My Oracle Support • Fewer Patch Install Attempts • Less Failures • Less Time Wasted • Less stumbling blocks to getting the patch process completed

GC 10 g- Single EM Harvester instead of OCM collectors • Collecting and uploading configuration data to My Oracle Support • White paper – MOS Doc ID 848962. 1 • Requires OMS 10. 2. 0. 5, connected mode • Only need to install OCM in the OMS home, not all of the targets. • No database PL/SQL install required • Will work with older agents • Supported configurations – Hosts, ORACLE_HOMEs, Database, OAS

Non-Flash Based MOS https: //supporthtml. oracle. com

More Information, Questions? High Availability Blog http: //aprilcsims. wordpress. com