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.ch
- Accounts:
owner |
reader |
writer |
expected_2006 |
max_conn |
avg_conn |
lcg_lfc_local |
lcg_lfc_local_r |
lcg_lfc_local_w |
3GB |
80 |
30 |
lcg_lfc_shared |
lcg_lfc_shared_r |
lcg_lfc_shared_w |
1GB |
40 |
5 |
lcg_lfc_lhcb |
lcg_lfc_lhcb_r |
lcg_lfc_lhcb_w |
3GB |
60 |
30 |
lcg_lfc_restore |
lcg_lfc_restore_r |
lcg_lfc_restore_w |
1GB |
- |
- |
lcg_lfc_test |
lcg_lfc_test_r |
lcg_lfc_test_w |
1GB |
40 |
- |
lcg_lfc_global |
lcg_lfc_global_r |
lcg_lfc_global_w |
3GB |
100 |
70 |
(please inform for any changes to the values above)
(DESCRIPTION=
(LOAD_BALANCE=no)
(ADDRESS=(PROTOCOL=TCP)(HOST=lcgr2-v.cern.ch)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=lcgr1-v.cern.ch)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=lcg_lfc.cern.ch)))
Worklog
Miguel Anjo, 08/12/2005
- Created accounts for lcg_lfc_global in LCGR (for moving from pilot)
- created lfc_lhcb_test account in GRID1 (for lhcb validation tests)
Miguel Anjo, 27/10/2005, 16:00, wiki
- Production RAC
- Monitoring: EM, sms, monpack (quota+ts monitoring/miguel, session monitoring/jacek)
- Backups: every 10 minutes
Miguel Anjo, 23/08/2005, 16:00, wiki
- Created account LFC_UNOSAT on pilot node (GRID1)
Miguel Anjo, 31/05/2005, 16:00, wiki
- Production machine
- Host: grid7.cern.ch / Service name: lfc_prod.cern.ch
- Accounts to be created: done
- schema owners:
lfc_prod, lfc_restore
- Tablespaces to be created: homonimous to owner accounts suffix _data01 done
- Initial size of tablespaces: LFC_PROD_DATA01 20GB, LFC_RESTORE_DATA01 1GB autoextensible to 500GB done
- Monitoring: EM, sms, monpack (quota+ts monitoring/miguel, session monitoring/jacek) done
- Backups: every 10 minutes done
Marta Jakubowska-Sobczak, 10/05/2005, 11:00, wiki
- Pilot machine
- Host: grid1.cern.ch / Service name: lfc.cern.ch
- Accounts to be created: done
- schema owners:
lfc_prod, lfc_restore
- Tablespaces to be created: homonimous to owner accounts done
- Initial size of tablespaces: 128MB, autoextensible to 20GB done
- Monitoring: EM, monpack (quota+ts monitoring/miguel, session monitoring/jacek) done
- Backups: every 10 minutes done
Marta Jakubowska-Sobczak, 06/07/2005, 17:07, wiki
The explanation of usage host and service name to connect to the database.
It can be used in so called "easy connect identifiaction" which has the following form:
sqlplus user_name/password@host/service_name
This requires 10g version of client.
On lxplus it can be set by:
/afs/cern.ch/project/oracle/script/setoraenv.csh -s 10103
or
/afs/cern.ch/project/oracle/script/setoraenv.sh -s 10103
Topic revision: r14 - 2005-12-08
- unknown