Service Conventions and Policies

• Proposed Policies
  • Service Levels
  • Database Object Naming

• Applications
  • Cool Account Setup

• Conventions and Best Practices
  • Additional Naming Conventions
  • Database Design and Coding Checklist

Database Service Setup Docs

Oracle documentation:

• Oracle Streams Configuration Best Practices: Oracle Database 10gR2
• Oracle Streams Performance Tuning Best Practices: Oracle Database 10gR2

Guidelines for Tier1 sites:

• Streams Configuration Checklist
• Listener configuration (RAC database)
• Tier1 sites Streams optimization steps
• Streams Service Review - Streams service manual for Tier1s + list of known Streams bugs

Guidelines for Streams administration:

• Streams Recommendations
• Streams Configuration Examples
• Downstream Database Configuration Example
• Performing Database Recovery in a Streams environment: Description, Steps and Tests
• Guidelines for creating Oracle DB objects under replication - thanks to Gancho (ATLAS)
• Streams Operations Manual

Resynchronization using Transportable Tablespaces at CERN:

• Transportable Tablespaces for Streams scalable re-synchronization Example
• Additional steps in the production databases (where standby database is configured) after the use of Transportable Tablespaces

Monitoring:

• Monitor Streams - strmmon command line tool and sql scripts
• 3d Monitoring Resources

Scripts Repository:

• Streams scripts Repository

Old documents:

• Additional configuration for RAC as Apply database (9i and 10gR1)
• OEM Setup - provided by Nuala (RAL)

Sharing experience on configuration and operations, CERN and 3D DBAs

• Installation Procedure - installation procedure and key parameters for 10g RAC and ASM on Linux.
• DBA issues log - log of database issues and notes
• Add node, Remove node - How to add and remove node on Oracle RAC 10gR2.
• DBBenchmarkAndStressTest - Benchmark and stress test of DB RACs
• Oracle10gr2_configuration_3D_RAL_Mar_06.ppt: Oracle 10gR2 configuration - 3D DB Workshop at RAL, March 2006.
• Architecture_description.pdf - A short description of the database architecture at tier 0: Oracle 10g RAC on Linux, ASM + SAN storage and backups to disk.
• RAC_storage_performance.pdf , I/O performance tests with Orion - I/O performance measurements and tests for Oracle 10g RAC + ASM on low-cost storage.
• SysAdminOra10gOnRHEL4.doc: System Administration Checklist for Oracle 10g on RHEL4 - provided by Gordon/Nuala (RAL)

Backup and Recovery

• HandsOnExercises

Multi-Core and 64-bit

• QuadCoreTests

Database Caching Setup Docs

FroNtier Setup Docs

• FroNtier project page
• FroNtier sources and downloads
• FroNtier Setup at Tier 0

Squid Setup Docs at Tier 0, 1 and 2)

• Squid deployment instructions and sites