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
(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


Edit | Attach | Watch | Print version | History: r14 < r13 < r12 < r11 < r10 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r14 - 2005-12-08 - unknown
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    PSSGroup All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback