WARNING: This web is not used anymore. Please use PDBService.DbaArea instead!

DBA Area

DBA Tools and Links

DBA Shift

RAC installation and service inventory

Patching and Service Changes

Backup and Recovery

Storage and SAN documentation

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

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

Post mortem analysis


Unsorted documentation (aging out)

Edit | Attach | Watch | Print version | History: r191 < r190 < r189 < r188 < r187 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r191 - 2009-07-14 - LucaCanali
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    PSSGroup All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2023 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback