| WARNING: This web is not used anymore. Please use PDBService.LFC instead! |
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 |
- Connection url:
(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)
- Production RAC
- Monitoring: EM, sms, monpack (quota+ts monitoring/miguel, session monitoring/jacek)
- Backups: every 10 minutes
- Created account LFC_UNOSAT on pilot node (GRID1)
- Production machine
- Host: grid7.cern.ch / Service name: lfc_prod.cern.ch
- Accounts to be created: done
- schema owners:
lfc_prod, lfc_restore
- schema owners:
- 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
- schema owners:
- 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
 |
|
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