Installing Updated Muon Calibration Schema

New schema was made available in early February 2008. Since the changes were significant I totally removed the original data and schema. On the umors.grid.umich.edu machine there was a directory /app/oracle/ATLAS_MDT_Calibration_DB_0.1 which contained the original schema. I used the cleanall.sql script to remove the atlas_muon_calib user/tables.

Since the machine hadn't been updated in a while I put on the newest RHEL4 kernel (2.6.9-67.0.4-ELsmp) and updated the ASM rpm package to be compatible. This server also has a special RAID hardware device that must be rebuilt when the kernel is changed.

Gancho pointed out some relevant Oracle Streams patches on metalink, Note:437838.1, the section "Recommended Patches for Streams on top of 10.2.0.3". The list in this article needs modification since patch 6267873 was superseded by 5581472. The patches I applied (after shutting down Oracle) were:

• 5093060
• 6081547
• 6081550
• 5581472
• 6043052
• 6163622

After restarting Oracle, I copied over the new tarball from /afs/cern.ch/user/f/fabrizio/public/MuonCalibDbScripts-00-00-01.tgz and unpacked it (as user oracle) on umors.grid.umich.edu in /app/oracle/MuonCalibDbScripts.

First step (as user 'oracle') is create the user:

• cd /app/oracle/MuonCalibDbScripts/share
• sqplus SYS/Password as sysdba @create_user.sql atlas_muon_calib UM userpw ATLAS_MUON_CALIB_DATA01 TEMP

muoncal on umors.grid.umich.edu: sqlplus SYS/xxxxxx as sysdba @create_user.sql atlas_muon_calib UM xxxxxx ATLAS_MUON_CALIB_DATA01 TEMP

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Feb 13 16:46:11 2008

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

old   1: DROP USER &1
new   1: DROP USER atlas_muon_calib

User dropped.

old   1: CREATE USER &1 PROFILE "DEFAULT" IDENTIFIED BY &3 DEFAULT TABLESPACE &4 TEMPORARY TABLESPACE &5 ACCOUNT UNLOCK
new   1: CREATE USER atlas_muon_calib PROFILE "DEFAULT" IDENTIFIED BY xxxxxx DEFAULT TABLESPACE ATLAS_MUON_CALIB_DATA01 TEMPORARY TABLESPACE TEMP ACCOUNT UNLOCK

User created.


old   1: GRANT UNLIMITED TABLESPACE TO &1
new   1: GRANT UNLIMITED TABLESPACE TO atlas_muon_calib

Grant succeeded.

old   1: GRANT CONNECT TO &1
new   1: GRANT CONNECT TO atlas_muon_calib

Grant succeeded.

old   1: GRANT RESOURCE TO &1
new   1: GRANT RESOURCE TO atlas_muon_calib

Grant succeeded.

old   1: GRANT CREATE TABLE TO &1
new   1: GRANT CREATE TABLE TO atlas_muon_calib

Grant succeeded.

old   1: GRANT CREATE SESSION to &1
new   1: GRANT CREATE SESSION to atlas_muon_calib

Grant succeeded.

old   1: GRANT CREATE TABLE to &1
new   1: GRANT CREATE TABLE to atlas_muon_calib

Grant succeeded.

old   1: GRANT CREATE MATERIALIZED VIEW to &1
new   1: GRANT CREATE MATERIALIZED VIEW to atlas_muon_calib

Grant succeeded.

old   1: GRANT QUERY REWRITE to &1
new   1: GRANT QUERY REWRITE to atlas_muon_calib

Grant succeeded.

old   1: GRANT SELECT ANY DICTIONARY to &1
new   1: GRANT SELECT ANY DICTIONARY to atlas_muon_calib

Grant succeeded.

• Last step is to run the do_all command: ./do_all atlas_muon_calib UM xxxxxx ATLAS_MUON_CALIB_DATA01

This ran without errors and loaded lots of data.

-- ShawnMcKee - 13 Feb 2008