Miguel Anjo, 15.March.2004

---

This memo is to give an overview of the services expected to be performed by a control and monitoring machine for Physics Databases Services. Those operations are now performed using the node “dbsrvpcd06” aliased as “pdb-backup1”. The memo is also aimed to clear out where to find the control and monitoring scripts on the event of necessity to rebuild a machine like “pdb-backup1”. The explanation on the usage of those scripts is expected to be included with them.

For each service is given a short description, the current location of the scripts on pdb-backup1 as well as on CVS. It is specified what is needed by the scripts in addition to the default installation by FIO.

Monitoring DBs

Monitors if it is possible to connect to database instance.

pdb-backup: ~/db_monitoring_scripts/script/monitor
CVS:        lcg-orat1/Applications/MonitoringScripts
Runs:       via crontab every 5 minutes
Uses:       bourne shell and oracle client
Needs:      (none)

Monitoring RLS endpoints

Monitors if it is possible to get response from iAS endpoints

Pdb-backup1: ~/iASmonitor/script/monitor
CVS:         lcg-orat1/MonitoringScripts
Runs:        via crontab every 5 minutes
Uses:        bourne shell and oracle client
Needs:       (none)

DNS switch

Allows switching an subdomain (like rlscms.cern.ch) from one iAS node to other.

Pdb-backup1: ~/production/dns-change   
CVS:         lcg-orat1/Applications/RLS/cern-specific
Uses:        PERL and Oracle client
Needs:       PERL modules: DBD::Oracle (installed by FIO), SOAP::Lite, OpenSSL, 
             Net::SSLeay, Crypt::SSLeay. Install them locally and set $PERL5LIB 
             to its directory.

RLS Dump to XML

Makes a dump to XML of all RLS production database

Pdb-backup1: ~/python/Rls
CVS:         lcg-orat1/Applications/RLS/RlsDump
Runs:        via crontab every 3 hours
Uses:        Python
Needs:       Python 2.1.0; Oracle client; cx_Oracle Python DB API binding 
             (all included in build for RHES in the ~oracle/python directory 
             on pdb-backup1 machine).

Backup script and temporary backup area

Performs backup of databases for physics using pdb-backup as temporary area before send the backup to TSM system. Suggests for necessary backups.

Pdb-backup1: /backup/scripts
CVS:      
Runs:        crontab and command line
Uses:        bourne shell, RMAN, TSM packages
Needs:       RMAN, TSM packages

Script installing oem agent

Installs oem agent on a database server site and registers to OEM service.

Pdb-backup1: ~/production/emagent
CVS:      
Runs:        command line with URL addres of OEM server as a parameter, e.g. sundb05.cern.ch
Uses:        bourne shell, wget
Needs:       a running OEM server

Script configuring cern specific Oracle accounts

Configures pdb_admin and pdbmon accounts.

Pdb-backup1: ~/production/cern_users
CVS:      
Runs:        from sqlplus as sysdba 
Uses:        pl/sql
Needs:       an installed database