正確部署Oracle EBS R12 on Exadata V2 MAA and Hight Performance

前些日子做第一個 吃螃蟹的人,做過的,

近期將進行幾天的hands-on 的培訓

詳細步驟如下:

[@more@]

1. Oracle EBS R12 on Database Machine MAA & Performance
Architecture.

2. Oracle EBS R12 Single Instance Node Deployment Procedure. .1. Preinstall
2.1.4. Start Rapid Install Wizard.

3. Oracle EBS R12 Single Instance Node Chinese Patch Update.

3.1. Preparing for Patching.
3.1.1. Download patch.
3.1.2. Examine readme file.
3.1.3. Patch Analysis and Testing.
3.2. Applying Patches.
3.3. Monitoring and Troubleshooting.
3.3.1. Monitoring.
3.3.2. Troubleshooting.
3.4. Post-patching steps.
4. Upgrade Application Database Version to 11g Release 2.
4.1. Before the Database Installation..
4.1.1. First apply the flowing patches.
4.1.2. Deregister the current database server (conditional) 29
4.1.3. Update application tier context file with new database
listener port number (conditional)
4.2. Database Installation..
4.3. Post installation : Apply additional 11.2.0.1 RDBMS
patches.
4.4. Database Upgrade
4.4.1. Run the Pre-Upgrade Information Tool
4.4.2. Upgrade database process.
5. Deploy Clone Application Database to Sun Oracle Database
Machine.
5.1. Section 1: Prerequisite Tasks.
5.1.1. Verify OS requirements on target system...
5.1.2. Verify source and target system software components and versions.
5.1.3. Apply the latest AD patch.
5.1.4. Apply the latest AutoConfig template patch.
5.1.5. Apply the latest Rapid Clone patches.
5.1.6. Run AutoConfig on the application tiers.
5.1.7. Synchronize appsutil on the database tier nodes. 47
5.1.8. Run AutoConfig on the database tier.
5.1.9. Maintain snapshot information.
5.2. Section 2: Cloning Tasks.
5.2.1. Prepare the source system...
5.2.2. Copy the source system to the target system...
5.2.3. Configure the target system...
5.3. Section 3: Finishing Tasks.
5.3.1. Update profile options.
5.3.2. Update printer settings.
5.3.3. Update Workflow configuration settings.
5.3.4. Verify the APPLCSF variable setting.
5.3.5. Update the SESSION_COOKIE_DOMAIN value in ICX_PARAMETERS.
5.3.6. Re-Implement SSL and SSO configuration.
6. Migrate Application Database File System to Exadata ASM
Storage.
6.1 The requirements before migration.
6.2 Migrate the Database From File System to ASM...
7. Covert Application Database Single Instance to RAC..
8. Configure High Availability & High Performance
Architecture with Exadata.
8.1. Establish Applications Environment for Oracle RAC..
8.1.1. Preparatory Steps.
8.1.2. Set Up Load Balancing.
8.2. Configure Parallel Concurrent Processing.
8.2.1. Check prerequisites for setting up Parallel Concurrent
Processing.
8.2.2. Set Up PCP.
8.2.3. Set Up Transaction Managers.
8.2.4. Set Up Load Balancing on Concurrent Processing Nodes.
9. Appendix I :Configuration Files Example.
9.1. PROD_cnxddb08.xml 69
9.2. APPSPROD_cnxddb08.env.
10. Appendix II: ASM and Exadata Cell Management 152
11. Appendix III: RAC Maintainance with Exadata. 157
12. Appendix IV: Exadata Backup and Recovery Best Practice.
12.1. Backing up databases to an ASM Disk Group..
12.2. Backing up databases to OSB Media Servers.
12.3. Backing up databases to a local file system...
12.4. Backing up non database files in a Database Machine.
13. Appendix V: Exadata Performance Tuning Best Practice.
13.1. Optimize ASM Diskgroup Balance.
Check Diskgroup Balance.
13.2. Optimize Scan Rates.
13.2.1. Set ASM Allocation Unit Size to 4MB.
13.2.2. Ensure Database Extent Sizes are at Least 4MB.
13.3. Size the Buffer Cache to Hold Space Metadata for Partitioned
Tables.
13.4. Use External Tables instead of Parallel SQL Loader for
Highly Partitioned Tables
13.5. Avoid Large Segment Fragmentation..
13.6. Use the SQL Tuning Advisor.
13.7. Use the SQL Monitor.
13.8. Assess Index Impact with INVISIBLE Indexes.
13.9. Understand direct reads for serial execution plans. 1
13.10. Understand the clustering ratio when performing range scans.
13.11. Optimize file creation performance.
13.12. Confirm correct latency for Small IOs.
13.13. Ensure auto extend size will allocate space on all disks in
the diskgroup..
13.14. Diagnose underperforming ("sick") disks.
13.15. Optimize network throughput by setting SDU size to 32767.
13.16. Size ASM cache properly for large environments.
14. Appendix VI: Exadata Security Best Practice.
14.1. Ensure proper flow when configuring Exadata security.
14.2. Ensure consistent Exadata security settings.
14.3. The dcli tool is quite useful in ensuring this consistency
is achieved.