DBA Area

DBA Tools and Links

• DBA Tools and Links page
• List of all alarms opened and the closed on the last 3 days
• Remedy logger tickets

DBA Shift

• Shift List
• Private phones

RAC installation and service inventory

• Installation procedure RHEL5 - Installation recipe for 10g RAC on Linux, with Clusterware and ASM on RHEL 5 64bit
• Single_node_Installation
• Installation procedure RHEL4 - Installation recipe for 10g RAC on Linux, with Clusterware and ASM on RHEL4
• Deployed RACs - HW inventory and DB service details
• Legacy APEX inventory application - legacy inventory (to be retired)
• AddNode - how-to add cluster node(s) to 10gR2 RAC
• RemoveNode - how-to remove cluster node(s) from 10gR2 RAC
• MigrationWithDataGuard - How to migrate a RAC database to a new hardware (and from 32 to 64 bit) with Data Guard
• DataGuardSetup - How to configure a physical standby database
• ActiveDataGuardSetup - How to configure an active physical standby database (using DUPLICATE DB with RMAN) for 11g1 and 11g2
• Installation_verbose11gbeta1 - Installation recipe for 11g2 beta 1 RAC on Linux 32-bit and 11g2 beta 2 on 64-bit

Patching and Service Changes

• PatchApply - general document for applying patches
• QuadcoreMigration - info related to the quadcore migration in April 2008
• PatchSet10204Production, PatchSet10204 - upgrade from 10.2.0.3 to 10.2.0.4
• CPUApr09, CPUJan09, CPUOct08_and_other_patches, Patch6746196, REH4U7update, CpuJul08, CPUApr08, CpuJan08, CpuOct07, CpuJul07, CpuApr07, CpuJan07, CpuOct06, CpuJul06, CpuApril06, CpuJanuary06, CpuOctober05 - security patches
• StreamsPatches
• PatchesOnTop10204 - extra patches from a clean 10.2.0.4 installation
• PatchesOnTop10203 - extra patches from a clean 10.2.0.3 installation
• ReconfigureCMSR - reconfiguration of the CMSR database for the downstream datacapture
• BugSep06 - 5458753, SENTENCES EXECUTED IN WRONG SCHEMA WITH OCI APPLICATION
• UpgrKernelAsmlib - kernel upgrade and asmilib upgrade
• Note : before a scheduled intervention on RAC, please announce also to the following lists: it-dep-fio-smod@cern.ch; it-dep-gd-gmod@cern.ch

Backup and Recovery

• RacRecovery - Point in time recovery from on-disk backup, duplication, recovery to the test recovery service
• LostControlfile - How to restore multiplexing of the controlfile
• PdbBackupRecovery - How to recover pdb-backup machine
• HandlingHumanErrors - How to deal with human errors
• OpenDataGuardForTest - How to open in read/write mode and then flashback database using Physical DataGuard
• RecoveryStandbyGaps - How to recover standby DB gaps
• AutomaticRecovery - How to setup and run automatic recoveries
• Backups using RMAN10g, Backup Implementation - PDB backup for 10g with RMAN, short description of the scripts and of the Backup procedure
• CurrentTapeBackupSchedule
• BackupPredictions

Storage and SAN documentation

• StorageOperations - ASM operations and reactions to disk failures

Post-install actions

1. OEM setup
2. RACmon - instance ad service monitoring
3. Monpack - Session, tablespace usage and user quotas
4. CernRoles - Password verification, Roles and profiles setup
5. BackupSetup
6. Session Manager
7. tnsnames.ora Propagation
8. logrotation for oracle logs
9. Service_Definition - Add services to the DB and CRS cluster
10. Recycle Bin purging - setup of automatically purged recyclebin
11. Killing sniped sessions - automatic sniped sessions' killing
12. ExtraOracleFunctionality - gvuser$ gvall$ views, mb/gb functions

Installations Q1 2008

• CheckListQ12008 - Checklist for HW deployment, Q1 2008

Installations Q4 2006

• OSspecification - Changes to the OS specification, Q4 2006
• InstallationPlan - RAC HW allocation plan (for installation and inventory see the paragraph above)

Tools and Utilities

1. Users creation: DEVDB10 user, Benthic workspace(see also Naming Convention)
2. ConnectionsByOsUsername
3. CursorSharing - Trigger after logon
4. RlWrap - sqlplus with command line and history, for Linux
5. SQLTraceAnalysis - orasrp, SQL trace formatter, alternative to tkprof
6. SQLpython - sqlplus-like command line with focus on customizations, in python
7. EditDADs - edit DADs of users
8. AsmTools - tools for Oracle ASM monitoring and administration
9. Terminal Fanout - tools to execute the same command on multiple nodes and terminal fanout
10. EM CLI - Oracle Enterprise Manager Command Line Interface - quick installation and usage guide
11. Streams Monitor - tool for Oracle Streams monitoring
12. TNS LDAP Server on PDB backup
13. Version control - CVS on PDB backup - CVS is now obsolete, please use SVN
14. Version control - SVN on PDB backup
15. Service Graphs - Plots of service statistics - installation and usage

Service docs, configuration details, tips

• OCIClientHangProtection - How to prevent OCI clients from hanging in case of DB server (node) freeze
• MysqlOraCRS - Oracle 10gR2 clusterware for non-oracle services, mysql HA configuration
• AtlasOnlineNetworkDiscussion - Discussion on the configuration for atlas online to offline network
• AtlasPDBDocs2007 - Repository for discussions with Atlas
• CMSPDBDocs2007 - Repository for discussions with CMS
• PDBNumbers
• SizingPDB - Documents related to PDB sizing 2007-2009
• MySQL testing - Test matrix for combinations of MySQL clients and servers
• OrionTests - A few notes on using Oracle's Orion to test the IO subsystem
• NetworkConfigDetails - The network configuration on experiments online database machines
• MachineList
• QuattorProfileConversion

Post mortem analysis

• StreamsPostMortem - Streams post mortem analysis
• DBServicePostMortem - Other DB services post mortem analysis

Tests

• 11gR2BetaTests - Oracle 11gR2 beta testing
• AuditMON - wiki of the auditmon application

Unsorted documentation (aging out)

• obsolete: MigrationTo64bits - How to migrate a 32bit RAC database to 64bit platform
• PatchSet10203 - upgrade from 10.2.0.2 to 10.2.0.3
• Multipathing - setup LUN failover and load balancing for Qlogic HBAs
• StorageConfiguration - Preinstall and storage configuration
• Installation_procedure_RHEL3
• Remove Oracle 10g RAC
• Recovery from Storage failures
• Migration of RAC to new nodes
• Upgrade 10gR1 to 10gR2
• DiskArrayVendorCalls - create vendor call for disk array problem
• SANMonitoring - how set up diskarray monitoring
• RacManagementNetwork - internal network for management
• FIOgroup.TsiDiskWinInfortrendInstall - installation of Infortrend diskarrays
• FC Fabric Configuration
• Old Install doc for Oracle 10gR1 RAC
• Upgrade10.1.0.4
• Inventory and problems
• Adding nodes to an existing RAC
• Acceptance Tests - description of harware acceptance tests
• Install Oracle 10g binaries
• Create Oracle 10g database
• Install Oracle 9i binaries
• Create Oracle 9i database
• AsynIOPatch
• CompassToRac - wiki page for compass migration to 10gR2 RAC
• Validate service
• DNS Switch
• Other checks
• PSSGroup.10gMemoryParameters
• Install Oracle Database
• PDB-Backup - Contents, DnsSwitch, Pdb-backupInstallation
• PDB Cluster - T3 storage architecture, Create PDB01 tablespace, Veritas tips
• RLS - CheckSpareMachine, DeployWebApps
• Compass - DeployCompassDB
• OperatorsGuide
• DB configuration verification
• Backups Recovery
• UpgradeRHES21 - machines on RHES 2.1
• Backups using RMAN10g - a proposal of backup mechanism which uses RMAN 10g
• Single node installations: single node recovery
• Backup policy - policies defined for RMAN 10g backups
• ValidationService
• UserAccounts
• NamingConvention
• DevelopmentStages
• Page restructuring proposal (by pradowie)
• Page restructuring proposal (by pradowie) no redirect
• Intervention procedure proposal (by pradowie)