| WARNING: This web is not used anymore. Please use PDBService.WebIndex instead! |
Results from PSSGroup web retrieved at 18:14 (GMT)
Update 25.04.2005: On the meeting we discuss on setting SGA MAX SIZE SGA TARGET 40% / PGA AGGREGATE TARGET 40% of system memory. Taking from a original 10g installation...
RAC meeting 20050408 Maria summarized Q1 2005 operations on assembly, configuration and functional tests Ioannis doing tests on scalability for reading tests...
RAC meeting Minutes 17 06 2005 Contact Tim Whibley for cable correctly the arrays that were assigned to Castor. Tests by DirkD will move from 8 node to...
RAC meeting 12 Dec 2005 Hardware 30 mid range PCs are ready in critical area in GPN network and on LANDB. Today wll go to CCDB and can be started to be installed...
Frontier Stress Tests This page describes FroNtier stress tests. Contact: Ramos Test Plan The objectives of this testing effort are: Develop an application...
Backup Recovery Test for 3D Streams Setup Scenarios to be tested (proposal by Gordon) As described in the 3D meeting, here are the scenarios we should look at for...
Acceptance Tests and Sanity checks for Oracle DB hardware This page details a lists of tests and checks performed on arrival of the new hardware before adding it to...
Adding nodes to an existing RAC version 10g R1 Note for 10gR2 changes are needed Purpose This piece of documentation describes the procedure of adding new nodes to...
Additional Configuration for RAC environment as Apply database If the owning instance of a Streams target queue fails, the ownership of the queue is automatically...
10g RAC on Linux, adding cluster nodes This is an addendum to the installation procedure in Installation procedure Complete the `OS Setup and Prerequisites` as...
ALICE Online Database Contact addresses in ALICE Piquet 24/7 PHONE NUMBER AND MAIL ADDRESS TO BE DEFINED SysAdmins MAIL ADDRESS TO BE DEFINED Announcements...
AMGA Replication tests using Oracle streams SETUP The test will be performed between the 2 Oracle streams test nodes at CERN, one will be the master the other...
Application Schedule for the 3D testbed Status Database Application Distribution Peers Apps responsible finished POOL file catalog (test...
ASM internals
ASM Metadata and Internals A collection of facts on configuration and and diagnostic of Oracle ASM. More on RAC and ASM configuration and performance of CERN Physics...
Tools for ASM and disks administration and monitoring ASM tools lsop lists ASM operations in progress, see example below ~ $ lsop INST ID GROUP...
AsyncIO patch installation Copy the patch: scp lxfs6142:p4199559 92070 LINUX.zip . #Patch Installation Instructions: # # To apply the patch, unzip the...
ATLAS Conditions Replication Test Plan TESTs on replication of COOL data using ATONR as source and INTR as...
Atlas DBs and online network A wiki page for the discussion on how to connect Atlas online (pit) to the DB services in IT A few acronyms ATCN: ATLAS control...
ATLAS Tags Replication to ATLAS Tags wiki
Automatic Recoveries Automatic test recoveries are indispensable element of any backup system. They do not only help to ensure recoverability but also to detect possible...
Backup Implementation Summary The implementation of a backup strategy based on Oracle RMAN 10g is described in this document. This strategy allows for (1) backups...
Backup predictions for 2008 v3.xls: Tape backup volume predictions for the end of 2008 Backup predictions for 2009.xls: Backup volume predictions for 2009
Summary The implementation of a backup strategy based on RMAN 10g is described in this document. This strategy allows for (1) backups to tape and (2) backups to disk...
Introduction to new Oracle users and developers at CERN Are a new Oracle database user or developer at CERN? Please read on. First of all, welcome to Oracle support...
LHCB LHCbBookkeeping LHCb Bookkeeping new 06/10/2005 , Miguel Anjo, wiki Current stage: integration Host: lhcbr1 v.cern.ch, lhcbr2 v.cern.ch / Service...
CernRoles script This document shows how to deploy the `Password Verification Utility`, the CERN profiles and roles as discussed in DBA meetings. Setup Log...
SQLpython changelog 2007 Oct 18th, V1.3.0 added integration with sqlplus and other sqlplus replacement by C.D. 2007 Feb 5th, V1.2.5 added load...
Check list for HW deployment on Q1 2008 The aquisition of 34 mid range servers and 60 storage arrays will replace RAC1 (named RAC5, names to be ITRAC5xx, ITSTOR5xx...
Check Oracle 9i single instance database This applies for all Compass, Harp nodes and rls1 database. Check database status This tutorial shows how to check the...
Procedure 1) Check if the endpoints are reachable (validate service) 2) Check if the container is running If there are problems, the best is to move to another node...
Check PDB cluster Check DB status This tutorial shows how to check pdb01 database on PDB cluster. This can be useful in case of any problem with the database and...
Check list for a iAS production node Quick guide: Go directly to validation page and check if the necessary container on the stand by machine is running Make...
Terminal fanout Tools to run the same command on a multinode cluster Terminal fanout clusterssh (cssh) based on xterm, a master input window sends command...
CMS Conditions Caching
General information The coordinator is Francesca Cavallari (Francesca.Cavallari #64;cernNOSPAMPLEASE.ch). The main developer of this application is Rick Egeland (Ricky...
General info The author of the application is Gennadyi Lukhanin (lukhanin #64;fnalNOSPAMPLEASE.gov) working in Fermi Lab. Some documents describing the project can...
CMS Online Database Contact addresses in CMS Piquet 24/7 PHONE NUMBER AND MAIL ADDRESS TO BE DEFINED SysAdmins MAIL ADDRESS TO BE DEFINED Announcements...
CMS HW sizing 2008 2009.ppt: DB Service for CMS sizing 2007 2009, first discussion
COMPASS Physics Database Service Page Reference contacts COMPASS Offline coordinator: Jorg Pretz COMPASS CDR coordinator: Damien Neyret COMPASS DST...
Connection management with Oracle servers Main considerations This page is a very short guide on connection management for Oracle applications. It does not replace...
# # Shows connections for some users grouped by their duration for last 2 days # create or replace view cms listconn as select count( ) total, os username,trunc...
This page links to the steps done and/or advices given to application developers to optimize their applications. It serves as a standard place for sharing and save...
LHCb COOL worklog Contacts ADC DP: Miguel Anjo Application: Marco Clemencic Worklog Miguel Anjo, 22/09/2005, 16:00, wiki Integration phase : 03.10 to...
COOL data overhead For a folder with 150 days of data (SV MC example) here are the statistics : COLUMN NAME AVG COL LEN CHANNEL ID...
Cool Frontier Stress Tests by David Front
Installation In order to use the mid range servers which do not have AFS access, create a COOL standalone installation : http://cool.cvs.cern.ch/cgi bin/cool.cgi/cool...
Flashback scripts for Cool performance tests 20 Jun 2007 First of all, once the tables are created we should enable row movement on them and grant the flashback privilege...
Persistency Project Wiki Module releases Tests Tag Release date Changes CoralTests 0 0 3 28 Aug, 2008 Persistency 2.0 tests ported back tp Persistency...
How to compile the Persistency Server and run the tests Assumptions: The /afs/cern.ch is mounted You can access the Persistency dependencies from the...
Persistency Server Project Howto CoralServerCompilation Development process notes Normally, we send engineering releases to the experiments weekly. The releases...
Oracle CPU patch April 2006 issues installation instructions CPU April 2006 for 10.2.0.2 contains 1 fix related to sql injection of a sys package. Exploits for this...
Oracle CPU patch January 2007 CPU January 2007 for 10.2.0.2 contains a limited number of vulnerabilities. It can be replaced by: revoke execute on sys.dbms...
Oracle CPU patch January 2006 installation instructions This Wiki page has the scope of documenting the installation steps for the Oracle security patch CPUJAN...
Oracle CPU patch July 2006 @ PDB CPUJUL2006 for Physics Database Services. Database Oracle Homes needs to be patched (all versions) as documented in Metalink`s Note...
Oracle CPU patch October 2005 installation instructions Note the CPU Oct05 patch needs to be applied to the DB Oracle Home and OEM agent home. The following describes...
Create Oracle 10g Database Overview This note describes how to create Oracle 10g Database. Requirements We assume you already have complete a binary install of the...
Create Oracle 9i Database Overview This note describes how to deploy an Oracle 9i Database. Requirements We assume you already have complete a binary install of...
Creating Veritas volumes and Oracle tablespaces on PDB01 The following is a simple tutorial on the steps to follow to create dedicated tablespaces for specific users...
Automatic service relocation to their prefered nodes with crsrelocate.py : crsrelocate.py is a command line utility that uses srvctl to display information about...
Status of the MySQL integration service Date Task Domain Duration Administrator 09/04/2008 MySQL 5.0 server configuration update in order to...
TSM11 ATONR CMRS LHCBR 0 1 2 3 4 5 6 7 8 9 10 11 12 13...
When users are not using bind variables, we can force Oracle to bind their queries. Is a last resource solution. PDB01:SQL GRANT ADMINISTER DATABASE TRIGGER TO atlas...
CVS on PDB Backup Physics Databases have a db4lcg CVS repository created on CERN Central CVS Service There is a passwordless access to the CVS already...
Stages of database applications development Development The development level service characterizes by: 8/5 monitoring and availability DBA consultancy...
Using the Integration Service Service Description The Integration Service facilitates the second step in the development process of a database application. Its goal...
Oracle 10g database installation and creation with kits The information about the software and database installation kits is at http://wwwdb.web.cern.ch/wwwdb/savannah...
DBA Area DBA Tools and Links Tools and Links page of all alarms opened and the closed on the last 3 days day lastday Remedy logger tickets DBA...
Log of database issues and notes 28 10 2008. BNL has found a crash of ASM which needs node reboot to be fixed: Bug 7331323 ORA 27302: FAILURE OCCURRED AT: SKGXPVFYMMTU...
Performance tests and benchmars index page A first little report with figures on the stress test : FirstStressTestReport A rapid procedure to use SwingBench...
Motivation As many database configuration changes are applied at the moment by hand, this can lead and actually leads to configuration divergence which is definitely...
LCG 3D Service Level description of the service level expected from tier 0 and tier 1 sites description of responsibilities of site database teams vs experiment...
DB Services post mortem Atlas PVSS2COOL June 27th, 2009 Incident report and affected services: Sunday afternoon 27 6 Viatcheslav Khomutnikov (Slava) from Atlas reported...
Deploy RLS App using automatic scripts This document describes how to use a script that sets up the Oracle 9iAS and deploy the EDG Local Replica Catalogue (LRC)...
Description of Production Accounts Each application going to production receives three accounts: a main account which is an application owner account (it will...
moved to FIOgroup.TsiDiskWinInfortrendInstall AndrasHorvath 03 Nov 2005
Raise vendor call for FC Disk Arrays Check at https://twiki.cern.ch/twiki/bin/view/FIOgroup/TsiDiskWinVendorCall It will allow you to create a problem ticket...
Disk Replacement on PDB Cluster Saturday`s (12.03.2005) intervention on PDB Cluster: 1. In order to stop flood of emails I commented out the following line in the...
DNS Switch configuration MiguelAnjo 25 Aug 2005 Components On PDB01 cluster rlsdns@pdb01 have tables with information of which IP each node points...
Downstream Database Configuration The objective of this configuration is to isolate the source database against network or database problems at the destination sites...
LCG Gridview worklog Contacts ADC DP: Miguel Anjo Application: Sophie Lemaitre Worklog Miguel Anjo, 25/11/2005, wiki Accounts: owner reader...
LHCb ECAL worklog Contacts ADC DP: Miguel Anjo Application: Oleg Gushchin Worklog Miguel Anjo, 03/10/2005, wiki usernames: lhcb ecal (owner), lhcb ecal r...
Enterprise Manager Command Line Interface Quick Installation Guide goto https://oms.cern.ch/em/console/emcli/download and follow the instructions...
Dear users, The Physics Databases team has been notified there is a problem with the INSERT DB NAMES HERE . We are currently investigating this problem, and will...
Oracle Enterprise Manager Agent setup The following document summarises the steps for installing the agents: Agent install.doc: notes for installing the agents...
FC configuration Table below shows how machines are connected to FC switches at the moment: Note: on Switch N.1 settings for switch box 1 are inverted from the config...
Frontier Setup At Tier0 This page includes a description of the existing Frontier infrastructure at Tier0 (CERN). Cluster description CMS Frontier production cluster...
FTS worklog Contacts ADC DP: Miguel Anjo GD: Gavin Mccance Worklog Miguel Anjo, 27/10/2005, 16:00, wiki Production RAC Host: lcgr1 v(pref),lcgr2 v...
Checklist for well written Oracle application Reference slideshow (last updated March 2006) Use bind variables Place holder variables in SQL statements...
Oracle Services for Physics High Availability and Performance This page aggregates documentation, measurements and studies on the subject of performance, high availability...
Handling Human Errors Human errors and logical data corruptions they cause are one of the most often faced types of failures in any database environment. Handling...
The goal of this exercise is to practice backup and recovery of Tier 1 databases. Due to very limited time only 1 recovery scenario (i.e. full database point in time...
How to install a new servlet in a Frontier server This page contains instructions on how to install a new servlet in a Frontier server that is already running. Installation...
10g RAC on Linux Installation Procedures RHEL3 (see RHEL4 for newer installations) This document describes the installation steps for Oracle 10g for the physics...
10g RAC on RHEL 5 64bit for PDB Installation Procedure This document describes the installation steps for Oracle 10g for the physics database services at CERN....
10g RAC on Linux for PDB Installation Procedure This document describes the installation steps for Oracle 10g for the physics database services at CERN. The key...
Install Oracle 10g Binaries Overview This note explains how to install Oracle 10g Database Server (Oracle10g) release 1 (patchset 10.1.0.3 or 10.1.0.4) on Linux...
Install Oracle 9i binaries Overview This note explains how to install Oracle 9i Database Server (Oracle9i) release 3 (patchset 9.0.2.4) on Linux Red Hat Advanced...
The following is a list of the DB instance parameters for 10.1.0.4 at Tier 0. Please refer to Installation Procedure for 10.2 parameters (a few minor differences can...
Sniped sessions automatic killing This script creates a job that automatically checks and kills all sniped sessions (sessions that timed out, but were not cleaned...
LCG 3D Project Distributed Deployment of Databases for LCG Main Links Project Membership Contact Info Meetings and Minutes Talks and Publications...
LCG Gridview worklog Contacts ADC DP: Miguel Anjo Application: Zdenek Sekera, gridview admin #64;cernNOSPAMPLEASE.ch Worklog Miguel Anjo, 13/10/2005, wiki...
LCG Shiva worklog Contacts ADC DP: Miguel Anjo Application: Zdenek Sekera, shiva admin #64;cernNOSPAMPLEASE.ch Worklog Marta Jacobow, 01/12/2005, wiki Accounts...
LDAP Server on PDB Backup There is LDAP server running on PDB Backup as CRS service named `pdb ldap` To start it or stop it use: crs start pdb ldap or...
LFC worklog Contacts ADC DP: Miguel Anjo GD: Sophie Lemaitre, James Casey Production RAC Host: lcgr1 v(avail),lcgr2 v(pref) / Service name: lcg lfc.cern...
CORAL LFCReplicaSvc overview The LFCReplicaSvc is a plugin used by CORAL applications (including the COOL conditions database) to retrieve the physical database replicas...
LFC Streams Replication Tests Objective: test replication of the LFC using Oracle Streams and Materialized Views Accounts The following accounts were created:...
LHCB LHCbBookkeeping Problems of high load on RAC due bulk deletions 27/Sep/2005 , Luca Canali, email The analysis of the issue is: you have a `delete job...
LHCb Conditions (COOL) Replication LHCb Planning and Schedule to LHCb wiki Schedule (from above link) 31 Jul 2006 04 Aug 2006 Setup streaming...
LHCb Muon MWPC worklog Contacts ADC DP: Miguel Anjo Application: thomas.johansen #64;cernNOSPAMPLEASE.ch Worklog Miguel Anjo, 10/11/2005, wiki usernames:...
LHCb Muon PNPI factory worklog Contacts ADC DP: Miguel Anjo Application: Nelly Sagidova nrs@mail.cern.ch DAD address: https://oraweb.cern.ch/pls/lhcbmuonpnpi...
LHCb LhcbRichhpd worklog Contacts ADC DP: Miguel Anjo Application: Sajan Easo Worklog Miguel Anjo, 11/10/2005, wiki usernames: lhcb richhpd (owner), lhcb...
LHCb Scanbook worklog Contacts ADC DP: Miguel Anjo Application: Joel Closier Worklog Miguel Anjo, 12/10/2005, wiki usernames: lhcb scanbook (owner), lhcb...
Log rotation setup for Oracle log files Oracle logs grow without limit and need rotation to be set. The main goal is to keep online only a subset of logs that is useful...
Restore multiplexing of the controlfile Scenarios: restore of the multiplexing of the controlfile after a failure additional controlfile multiplexing Configuration...
Luca Canali DB Home Page This subwiki aggregates selected documentation and work on the subject of Oracle, RAC and the CERN Physics DB group.
Meetings and Minutes Regular Meetings Agenda pages 15 January 09 29 January 09 12 February 09 5 March 09 19 March 09 15 May...
Memory Parameters Examples CERN name value sga max size 1712M sga target 1712M shared pool reserved size 15938355 shared pool size 0 streams pool...
Migration of a RAC to new nodes Purpose This piece of documentation describes the steps to move a RAC installation/db to a new set of nodes. Steps Configure...
Minutes from the phone discussion August 4th, 2005, 16:00: Participants: Fermilab: Lee, Yuyi CERN: Radovan Radovan summarized the currently available FrontierAccess...
Minutes 6 April 06 Phone: Eric(Fermilab), Nuala(RAL), Gordon(RAL), Andrew(RAL), Gancho(ATLAS), Silkes(GridKa), Marco(LHCb) @CERN: Stefan(Oxford), Paul, Birger...
Minutes 7 November 07 Phone: NDGF: Olli PIC: Luis TRIUMF: Andrew SARA: Alexander BNL: Carlos and John...
Minutes 9 March 06 Phone: Eric(Fermilab), Nuala(RAL), Gordon(RAL), Gancho(ATLAS), Silkes(GridKa), Sasha @CERN: Dirk(3D), Eva(3D) General issues...
Minutes 10 April 08 Phone: Gridka: Andreas RAL: Carmine NDGF: Olli BNL: Carlos TRIUMF: Andrew SARA...
Minutes 10 Aug 06 Phone: TRIUMF: Denise FNAL: Eric RAL: Nuala, Gordon BNL Iris GridKA: Doris, Silke, Andreas...
Minutes 10 May 07 Phone: FNAL: Eric, Dave BNL: Carlos, Iris NDGF: Olli GridKa: Andreas SARA: Alexander...
Minutes 10 November 05 VRVS/phone: Iris(BNL), Lee(CMS), Eric(FNAL), Stefan (ATLAS), Gordon (RAL), Sasha(ATLAS), Marco(LHCb) @CERN: Ioannis, Kuba, Luis,...
Minutes 11 January 07 Phone: TRIUMF: Denise GridKA: Andreas, Doris FNAL: Eric CNAF: Barbara ATLAS: Shasha...
Minutes 11 May 06 Phone: TRIUMF: Denise U Michigan: Ed, Shawn FNAL: Lee, Eric, Dave RAL: Nuala, Gordon BNL...
Minutes 11 October 05 testbed planing Phone conference about 3D testing (11 Oct 2005) Present: Eva, Dirk (CERN), Gordon (Rutherford Lab),...
Present: Saima, Lee, Oliver, Frank (CMS) Eva, Dirk (IT) Discussion work plan details Agreed to start with the first two items on the work plan...
Minutes 12 April 07 Phone: FNAL: Eric NDGF: Olli Triumf: Jim Li CERN: 3D: Dirk, Eva POOL: Ioannis...
Minutes 12 January 06 Phone: Lee(CMS), Stefan(ATLAS), Richard(ATLAS), Gancho(ATLAS), Iris(BNL), Gordon(RAL), Doris(GridKA), Silke(GridKA), Yuri(BNL), Sasha(ATLAS...
Minutes 28 June 07 Phone: FNAL: Eric NDGF: Olli PIC: Luis GRIDKA: Andreas and Doris LHCb: Marco TRIUMF...
Minutes 12 October 06 Phone: TRIUMF: Denise GridKA: Andreas FNAL: Eric, Lee ATLAS: Shasha, David Front CNAF...
Minutes 13 April 06 Phone: Gordon(RAL), Yuri(BNL), Iris(BNL), Barbara(CNAF), Gancho, Sasha @CERN: Luis, Dirk(3D), Eva(3D), Marco(LHCb), Saima, Sophie...
Minutes 13 March 08 Phone: Gridka: Doris and Andreas RAL: Carmine NDGF: Olli BNL: Carlos CNAF: Barbara...
Minutes 15 December 05 VRVS/phone: Lee(CMS), Stefan(ATLAS), Iris(BNL), Eric(FNAL), Elisabetta(CNAF), Barbara(CNAF) @CERN: Radovan(POOL), Birger(ARDA), Marco...
Minutes 14 December 06 Phone: TRIUMF: Denise GridKA: Andreas FNAL: Eric ATLAS: Shasha BNL: Carlos...
Minutes 14 November 05 AMGA test plans Birger Koblitz, Viktor Pose, Luis, Eva Subject: Testing AMGA replication using the 3D testbed Streams setup...
Minutes 15 June 06 Phone: RAL: Nuala ATLAS: Florbella, Gancho CNAF: Barbara IN2P3: CERN: 3D: Dirk, Eva...
Minutes 15 March 07 CERN: 3D: Dirk, Zbigniew, Marcin, Maria, Eva ATLAS: Gancho, Florbela Sites status: PIC: database agent...
Minutes 15 May 08 Phone: Gridka: Doris RAL: Gordon NDGF: Olli BNL: Carlos, John TRIUMF: Andrew SARA...
Minutes 16 July 05 Present: Eva, Dirk, Radovan, Kuba (IT) Lee, Eric (FNAL/CMS) Markus(LHCb) Sasha, Stefan (ATLAS) Doris (GridKA) General...
Minutes 5 October 06 Phone: TRIUMF: Denise GridKA: Andreas FNAL: Eric CNAF: Barbara NDGF: Olli RAL...
Minutes 17 Aug 06 Phone: FNAL: Eric, Lee, Dave RAL: Nuala GridKA: Doris, Silke, Andreas ATLAS: Sasha, Florbela...
Minutes 17 January 08 Phone: TRIUMF: Andrew RAL: Carmine NDGF: Olli BNL: Carlos and John CERN: 3D: Dirk...
Minutes 17 July 08 Phone: Gridka: Camile Triumf: Andrew RAL: Carmine BNL: Carlos PIC: Luis CERN:...
Minutes 18 January 07 Phone: TRIUMF: Denice GridKA: Andreas FNAL: Eric ATLAS: Shasha SARA: Alexander...
Minutes 18 October 07 CERN: LHCb: Marco ATLAS: Sasha 3D: Dirk, Eva ATLAS: Gancho ATLAS status: New requests...
Minutes 18 September 08 Phone: Gridka: Doris, Kamil RAL: Carmine BNL: Carlos NDGF: Olli CNAF: Barbara...
Minutes 19 January 06 Phone: Barbara(CNAF), Eric(FNAL), Silke(GridKA), Stefan(Oxford), Gancho (ATLAS), Jerome(AMI), Iris(BNL), Gordon(RAL), Marco(LHCb), Sacha...
Minutes 19 June 08 Phone: Gridka: Andreas RAL: Carmine NDGF: Olli BNL: Carlos TRIUMF: Andrew SARA...
Minutes 19 October 06 Phone: TRIUMF: Denise GridKA: Andreas FNAL: Eric, Lee, Dave ATLAS: Shasha CNAF: Barbara...
Minutes 1 December 05 VRVS/phone: Yuri Smirnov(BNL), Iris(BNL), Eric Wicklund(FNAL), Lee(FNAL), Dors(Gridka), Elisabetta Vilucchi(CNAF), Saima Iqbal(CMS)...
Minutes 1 June 06 Phone: TRIUMF: Denise FNAL: Lee, Eric, Dave RAL: Nuala BNL Iris ATLAS: Florbella, Gancho...
Minutes 20 April 06 Phone: Nuala(RAL), Gordon(RAL), Stefan(Oxford), Iris(BNL), Sasha @CERN: Luis, Dirk(3D), Eva(3D), Marco(LHCb), Saima, Sophie General...
Minutes 22 February 07 Phone: GridKA: Andreas, Doris FNAL: Eric, Dave SARA: Alexander RAL: Gordon CERN:...
Minutes 22 June 06 Phone: ATLAS: Florbella, Gancho, David Front Fermilab: Lee BNL: Iris, Denis GridKa: Doris...
Minutes 23 February 06 Phone: Barbara, Vicenzo(CNAF), Lee(Fermilab), Stefan(Oxford), Gancho(ATLAS), Yuri(BNL), Doris(GridKa) @CERN: Luis, Luca, Jacek, Dirk...
Minutes 24 August 06 Phone: TRIUMF: Denise RAL: Gordon BNL Iris GridKA: Andreas ATLAS: Sasha Oxford...
Minutes 24 May 07 Phone: FNAL: Eric BNL: Carlos, Iris GridKa: Andreas, Doris SARA: Alexander Triumf: Denice...
Minutes 24 November 05 VRVS/phone: Stefan (ATLAS), Gordon (RAL), Sasha(ATLAS), Yuri Smirnov(BNL), Vladimir Kravchuck(RIPN), Marc Rodriguez(PIC), Pierre Etienne...
Minutes 26 April 07 Phone: FNAL: Eric BNL: Carlos, Iris RAL: Gordon PIC: Luis GridKa: Andreas, Doris...
Minutes 26 January 06 Phone: Barbara(CNAF), Eric(FNAL), Stefan(Oxford), Gancho (ATLAS), Iris(BNL), Gordon(RAL) @CERN: David Front, Marco(LHCb), Dirk(3D)...
Minutes 27 April 06 Phone: Eric(Fermilab), Nuala(RAL), Gordon(RAL), Stefan(Oxford), Gancho(ATLAS), Sasha @CERN: Dirk(3D), Eva(3D), Saima General announcements...
Minutes 27 October 05 VRVS/phone: Julie(Fermilab), Rainer, Doris (GridKA), Andrew, Gordon (RAL), Barbara, Elisabetta(CNAF) @CERN: Saima (CMS), Radovan, Dirk...
Minutes 27 September 07 Phone: NDGF: Olli PIC: Luis TRIUMF: Denice SARA: Alexander BNL: Carlos ATLAS...
Minutes 28 August 08 Phone: Gridka: Doris Triumf: Andrew RAL: Carmine BNL: Carlos NDGF: Olli CNAF...
Minutes 28 February 08 Phone: Gridka: Doris RAL: Carmine NDGF: Olli BNL: Carlos CNAF: Barbara LHCb...
Minutes 28 June 07 Phone: FNAL: Eric CNAF: Barbara NDGF: Olli PIC: Luis GRIDKA: Andreas and Silke...
Minutes 28 September 06 Phone: TRIUMF: Denise GridKA: Andreas Oxford: Stefan FNAL: Eric CERN: 3D: Dirk...
Minutes 29 March 07 Phone: GridKA: Andreas FNAL: Eric NDGF: Olli BNL: Carlos, Iris CERN: 3D: Dirk, Zbigniew...
Minutes 29 September 05 General issues Discussion on Streams users privileges (recommendation from Anil Kumar): dba privileges Streams administrator is a requirement...
Minutes 02 August 07 Phone: FNAL: Eric NDGF: Olli PIC: Luis TRIUMF: Denice SARA: Alexander BNL: Carlos...
Minutes 30 March 06 Phone: Yuri(BNL), Gordon(RAL), Gancho(ATLAS), Doris(GridKa), Stefan(Oxford) @CERN: Luis, Sophie, Saima, Dirk(3D), Eva(3D) General...
Minutes 30 November 06 Phone: TRIUMF: Denise GridKA: Andreas, Doris FNAL: Eric, Lee, Dave ATLAS: Shasha CNAF...
Minutes 30 October 08 Phone: Gridka: Andreas RAL: Carmine BNL: Carlos CNAF: Barbara SARA: Alexander...
Minutes 31 August 06 Phone: RAL: Gordon CERN: 3D: Dirk, Maria, Zbigniew LHCB: Marco FZK: Andreas ARDA...
Minutes 3 July 08 Phone: Gridka: Andreas, Doris, Camile NDGF: Olli IN2P3: Jerome PIC: Luis CERN: 3D:...
Minutes 03 May 07 Phone: FNAL: Eric BNL: Carlos, Iris CNAF: Barbara GridKa: Andreas, Doris SARA: Alexander...
Minutes 5 October 06 Phone: TRIUMF: Denise GridKA: Andreas FNAL: Eric, Lee ATLAS: Shasha, David Front CNAF...
Minutes 6 December 07 Phone: TRIUMF: Andrew ATLAS: Sasha BNL: Carlos CERN: 3D: Dirk, Eva ATLAS: Gancho...
Minutes 7 June 07 Phone: FNAL: Eric BNL: Carlos SARA: Alexander CNAF: Barbara NDGF: Olli CERN:...
Minutes 8 December 05 VRVS/phone: Iris(BNL), Julie(FNAL), Lee(FNAL), Barbara(CNAF), Sasha(ATLAS) @CERN: Luis(3D), Radovan(POOL), Birger(ARDA), Marco Clemencic...
Minutes 8 February 07 Phone: TRIUMF: Jim Li GridKA: Doris FNAL: Eric ATLAS: Shasha BNL: Iris, Carlos...
Minutes 8 March 07 CERN: 3D: Dirk, Zbigniew, Marcin, Eva ATLAS: Gancho, Florbela CORAL: Radovan LHCB: Marco Sites...
Minutes 9 October 08 Phone: Gridka: Doris, Kamil RAL: Carmine BNL: Carlos NDGF: Olli PIC: Luis SARA...
Monitor Streams Status Scripts You can find more information about how to monitor the Streams environment on the Oracle Streams documentation. capture status...
Multipathing with Qlogic HBAs failover and LUN load balancing This is a short guide to the configuration of multipathing with QLogic HBAs for the physics database...
Cluster MYSQL for HA using Oracle CRS Oracle clusterware CRS can be used to cluster for high availability (HA) non Oracle resources. This wiki page describes the steps...
E dit W YSIWYG A ttach PDF P rintable r7 09 Apr 2007 01:27:09 RadovanChytracek You are here: TWiki PSSGroup Web PhysicsDatabasesSection MySQLTesting...
Naming convention for Database services at CERN Last updated: 27.October.2005 Having a general naming convention across all database services at CERN will help not...
REDIRECT{`WebHome` NewWikiLayoutProposal OPIS ODNO #346;NIKA EmergencyNotificationTemplate
Fast failover after cluster node lock up and protection against client hangs Executive summary Oracle client sessions can in certain conditions (such as a locked...
OEM join description
Older 3D Meetings and Minutes 2004 meeting at FNAL 21 22 October 04 (thanks to Lee for this page collecting the material) 2005 16 July 05 04 August...
Ongoing tests
OperationsManual /// StreamsOperationsManual /// SomeUsefulInfo People responsible for individual databases DB name Primary Stand by...
Open Physical Standby database for testing and re enable Dataguard afterwards This document is based on `Data Guard Scenarions` at http://oracle documentation.web...
Operators` help guide The operators receive an alarm in case of a problem with one of the Physics Services machines like : any filesystem full machine not responding...
Introduction This framework has be created to answer the needs for stress testing and performance benchmarking in the IT/PSS/DP section. Here is a picture of how the...
Installation Requirements The framework is coupled to several tools available at CERN. You will need to check if everything is set up correctly. Every client...
Load testing scenario : inserting COOL data This test consists of inserting data into the database with the COOL package. The metric measured is the number of objects...
ORACLE STREAMS TESTS with ATLAS GEOMETRY ACCOUNTS The script attlasdd accounts.sql creates a copy of the accounts structure for the Atlas Geometry application...
ORACLE STREAMS TESTS with COOL COOL ACCOUNTS: SCRIPTS and DOCUMENTATION account model for COOL deployment Please note that this page only deals with Oracle...
Storage Performance Measurements work in progress
System performance measurements, IO and CPU (Orion and jloci) The goal of this page is to share the results of the database system performance specs among the 3D...
Concerned machines Note : this is for 2007 installations on RAC1,RAC2,RAC3,RAC4; Minor changes for 2008 Q1 64 bit installation on RAC4. Quadcore installations are...
Extra fixes on top of 10.2.0.3 for Linux 32 bit NOTE: this is NOT NEEDED when installing with OH cloning using the most current image in pdb backup 1. Bug...
Extra fixes on top of 10.2.0.4 for Linux 64 bit This pages is intended to keep track of patches and bugs on top of 10.2.0.4 for 3D databases, CERN and T1s. See also...
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...
SSH keys $vi ~/.ssh/config Protocol 2A CheckHostIP no StrictHostKeyChecking no RLS Monitoring mkdir /dbs03/oradata/exports/rlsdns mkdir /dbs...
PDB backup machine general information PDB backup machine (currently itrac330 alias pdb backup) hosts several services critical for the PDB Database Service operation...
Templates templates Intervention checklist: RAC example 22.february.2007 RAC example 26.february.2007 Streams move to production 02.november...
PDB Numbers Some numbers related to Physics DB services at CERN. Service Configuration Numbers Infrastructure Service component Value Comment CPU...
Streams Performance Tuning Steps We have been working, with the help of Taiwan, on several Streams optimizations with long latency network links and we have achieved...
Persistency Framework Wiki Projects Project web site Persistency Project Wiki pages Project web site Services Persistency LFCReplicaSvc...
CERN IT Physics Databases Service The Physics Database Services group provides Oracle based database services for the Physics community at CERN. We currently host...
2004 July 13, IT DB Group Meeting POOL Relational Backend, Ioannis Papadopoulos Oracle Client Kits, Andrea Valassi 2004 Mar 30, IT DB Group Meeting Data Guard...
Presentations on Oracle Services for Physics, 2006 UKOUG RACSig Oct06 LC.pdf: Presentation at the UKOUG RAC SIG meeting, October 2006 3D CERN Sep 06 Luca...
Presentations on Oracle Services for Physics, 2007 RAC LoadTesting.ppt: Load Testing and Benchmarks on Oracle RAC, Romain, DB meeting, Dec 2007 Inside Oracle...
Presentations on Oracle Services for Physics, 2008 experience in a multi RAC environment (.pdf), Miguel, RAC HA SIG, Feb 2008 Storage Studies WLCG workshop...
Presentations on Oracle Services for Physics, 2009 Storage Overview DM groupmeeting Q1 2009 LC.ppt: Overview of Storage and IT DM lessons learned DB workshop...
Reporting database related problems via the WLCG communication channels All database interventions, also transparent ones (like single node failures) and also unplanned...
3D Production Setup Available Tier 1 Database Resources and Commissioning Status Site VO Status Resource ASGC ATLAS planned db server...
Publications Laura Iannone: A CONSISTENCY SERVICE FOR REPLICATED HETEROGENEOUS DATABASES IN A GRID ENVIRONMENT
General Information LCG 3D Project Leader: Duellmann PEB Project Proposal: / pdf and http://lcg.web.cern.ch/LCG/PEB/Minutes/Minutes20040720.html minutes...
Last Published Publisher DirkGeppert Date 13 Feb 2008 15:23 {PublishContrib}{Dir} /afs/cern.ch/project/twiki/production/twiki/export/ {PublishContrib}{URL} https...
PVSS ONLINE to OFFLINE Streams replication tests for ATLAS People involved James Cook ATLAS online Florbela Tique Aires Viegas ATLAS offline Gancho...
Quadcore Tests evaluation of a 2 x quadcore Intel x86 64 machine for PDB This page reports on the results of the tests on a latest generation server equipped with...
Connection to RAC database Intermittent ORA 12545 error when trying to connect to RAC database. In a multiple node RAC environment listeners do the load balancing...
Operations Support Document for PDB Level 1 Please make sure you have read the documents linked in SupportLevelRoles OperationsManual General...
RAC on Linux at CERN Pages moved to DBA Area This page contains links and documents to facilitate the deployment and management of the Oracle 10g RAC infrastructure...
Presentations on Oracle 10g RAC services at PSS in 2005
T3 lost RAID 0 Intervention log Author: Magnus L beck Date: Jan 6, 2004 Description: This is a summary of what was done on the T3 array dbsct37 , which lost a...
Disaster recover of PDB cluster This is a step by step description on how to perform a disaster recovery on the PDB cluster database named pdb01. Currently this...
Recover RLS databaseThis document was last revised: March 3, 2004 by Magnus L beck Prerequisites Diskserver with Oracle 9 binaries installed according to RLS...
Recovery from storage failures In our current RAC architecture storage failures are the most problematic ones. In some cases they can lead even to cluster downtime...
Database recovery procedure for COMPASS (at new node) 1. We should make a backup of catalog if we don`t want to loose the backups, with export tool. Jacek to...
Recover Gaps in Standby Databases from primary Using incremental backups A standby database that has fallen behind from prod can be refreshed using incremental...
Recycle Bin automatic purging This script creates a job that automatically purges all objects (tables) in recycle bin that are older than 7 days (edit the default...
Development of Oracle applications Best practices Development of Oracle applications Best practices Jacek Wojcieszuk, IT/PSS March, 2006 Documentation Oracle...
Oracle RAC removal steps Note1: This page shows the necessary steps to completely delete and start re install Oracle RAC software. 1. Stop and remove all ASM and...
10g RAC on Linux, removing cluster nodes Please see also the installation procedure in Installation procedure Stop Oracle services on the node to be removed from...
3D Distribution Test Plans Experiment Activities using the 3D Production Setup Replicated Data Replication Sites Experiment Responsible Planning...
sqlplus for linux with command line history and editing: rlwrap is a `readline wrapper`, a small utility that uses the GNU readline library to allow the editing...
LHCB Routing application Using PL/SQL packages and OCI Ioannis comments 04/Aug/2005 , email Note that I have not yet attempted to run the code itself. I just went...
Monitoring of disk arrays: The agent.ini file (attached) should be uploaded (via FTP) into the `/cfg` subdirectory of the disk arrays. After a controller reset, this...
TWiki search by CERN Search Results You may also search with the internal TWiki WebSearch . Please note that TWiki internal WebSearch may be very slow for large...
Add services to the DB and CRS Setup Oracle 10g services on RAC. Two steps are required (crs registration dbms service stored procedure). The first step will create...
Service Conventions and Policies Proposed Policies Levels Object Naming Applications Account Setup Conventions and Best...
Graphs for usage statistics of the databases Web page options The web page with the statistic graphs loads after choosing from a list of services linking in it. On...
3D Monitoring Resources Service Component Monitoring Link Comments Production Databases OEM Central database status repository for Tier 0 and...
Session Manager This allows the user to use a web interface to see his own sessions and kill them Setup Go to pdb backup1 $ cd ~/production/session manager...
Sessions Manager Tool to look at and manage your sessions From these pages, you can see a list of your sessions, look at details about them (SQL being processed,...
10g RAC Single node installation Single node installation for downstreams capture OS Setup and Prerequisites RHEL 4, Oracle user and group, kernel parameters...
SQLPython SQLPython is a SQL command line client designed with extensibility and personalization in mind. Scope SQLPython is a command line tool written in python...
SQL Trace Access and Analysis: OraSRP This page shortly describes a package to deploy and analyze SQL trace files for DBAs and developers. This package is a...
Infortrend storage array configuration for PDB RACs Each disk array supposed to be used with RAC installation should be configured in the following way: 1. Go to...
Oracle Streams configuration The document StreamsReplication unidir.doc includes: an overview of replication using streams replication environment configuration...
Streams Configuration Checklist The list below contain both minimum and recommended requirements for Tier 1 centers before having Streams configured and connect to...
Streams Apply Service failover on RAC 10gR2 Install the scripts attached to this page to the FAN directory for 10g CRS as detailed here: mkdir $ORA CRS HOME/racg...
Tool for 3D Streams Monitoring Monitor script Python script which is running as a daemon (not Cron job). It collects statistics from each registered database using...
3D Streams Monitor help page Streams monitor is an web application which provides complex online overview of the Oracle Streams enviroment that is used in the...
Streams Operations Manual connect locally to the RAC node as streams administrator user (strmadmin) Streams Monitoring Tools application for Streams monitoring...
Streams Recommended Patches Metalink note 437838.1 10.2.0.4 Bugs fixed : Capture or downstream capture side: 6081550 Tracking Bug for Inventory...
Streams Performance and Scalability Tests Goals This wiki page has the goal of documenting and sharing the results of streams performance and scalability testing...
STREAMS post mortem Network hardware problem affecting availability of several production databases and Oracle replication (Atlas: online offline and Tier0 Tier...
Streams Recommendations Check also metalink note 418755.1 Recommended patches of recommended Streams patches Capture site The capture process writes its own...
Streams Replication Configuration Overview of how to create a single source replication environment using Streams. Prerequisites configuration Checklist...
Streams Service Review General problems in the Streams Environment List of the general problems observed in the Streams environment databases and list of actions...
How to run Swingbench 2.2 in the distributed mode Install the nodes Download the required files 2.2 on http://www.dominicgiles.com/downloads.html Instant Client...
Veritas Volume Manager and T3 Arrays on the PDB cluster Overview of the architecture The PDB cluster is a Sun cluster with two nodes, sundb07 and sundb08. Oracle...
Talks and Conference Papers Conferences and Workshops database techniques.ppt: Resilience Explicit Computing in Grids, July 2008 CHEP07: presentation,...
1.March: Source database: rls1r1 (lxshare084d). Document updated and sent. Streams setup started with FNAL. 2.March: Streams configuration finished...
1. TARGET activate ftp over xdb on port 3100 and open port with iptables: $ sqlsys DB SQL exec dbms xdb.setftpport(3100); SQL exit $ ....
Throughput Tests Preparation Setting Initialization Parameters Relevant to Streams Before setting up the streams replication environment, please review the Configuration...
Log into pdb backup ./edit tnsnames Propagate the AFS file to different UNIX machines and DFS (is run automatically every hour): Login as oracle...
Patches to be applied ALL databases CPUJan08 Recompile views in upgrade mode done on LCGR LCGR 6057422 ORA 25228 repeatedly logged in udump...
Transportable Tablespaces for Scalable Streams Resynchronization Motivation From CERN data is distributed using Oracle Streams to a number of sites around the globe...
TWeeder info for PSSGroup Total Number of topics: 439 0 Topics updated during the last 7 days Days Web Topic Date 0 Topics updated during the...
Oracle RAC upgrade from 10.1.0.3 to 10.1.0.4 Note1: This cookbook shows only the minimal steps to upgrade RAC on the new mid range PCs as configured by FIO for Oracle...
Upgrade 10gR1 to 10gR2 This page describes the steps to upgrade PDB RACs 10gR1 ASM from 10.1.0.4 to 10.2.0.2 Perform a full backup of the DB before starting...
Machines on RHES 2.1 Record modifications to machines on RHES 2.1 ` changerows `on` Hostname 2.4.9 e.65smp lxb0770 Yes rls1163 Yes rls1164...
Minor kernel upgrade and asmlib upgrade This page documents the operations needed for a minor kernel upgrade, in particular RHEL 3 from 2.4.21 37.ELsmp to 2....
Database User Accounts at CERN In the examples below we use the application name CMS DAQ. This name follows the NamingConvention. Owner / Human / Development account...
Misleading errors If Veritas VM reports disk problems while everything seems to be fine on storage level execute the following command: vxdisk list vxedit set failing...
VOMS worklog Contacts ADC DP: Miguel Anjo GD: Maria Dimou Worklog Miguel Anjo, 28.11.2005 owner reader writer expected 2006 min conn max conn...
TWiki`s PSSGroup web The web for users, groups and offices. TWiki is an Enterprise Collaboration Platform.
Welcome to the home of TWiki.PSSGroup. This is a web based collaboration area for ... Physics Services Support Wiki Physics Databases Link to main Physics...
See also the faster WebTopicList
On Shift Sub wikis PhysicsDatabases Area 3D project Persistency Framework Other group public public Services Wiki Wiki...
This is a subscription service to be automatically notified by e mail when topics change in this PSSGroup web. This is a convenient service, so you do not have to...
PSSGroup Web Preferences The following settings are web preferences of the PSSGroup web. These preferences overwrite the site level preferences in .,...
/PSSGroup The web for users, groups and offices. TWiki is an Enterprise Collaboration Platform.
Jan 2006 8927 328 5 603 LCG3DWiki 507 DbaArea 334 PhysicsDatabasesSection 328 WebHome 245 WebStatistics 231 Installation 202 StreamsConfiguration...
See also the verbose WebIndex.
Number of topics: 304
See also the faster WebTopicList 
Edit | Attach | 
 |
|
Copyright &© 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