LFC < PSSGroup

WARNING: This web is not used anymore. Please use PDBService.LFC instead!

TWiki>

PSSGroup Web>PhysicsDatabasesSection>Consultancy>LFC (2005-12-08, unknown)

EditAttachPDF

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)

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)

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

PSSGroup

PSSGroup

On Shift

PSSGroup Wiki
Last Changes
Pages Index
Search web

- Cern Search
- TWiki Search
- Google Search
PSSGroup All webs