TWiki> LHCb Web>LHCbOnline>Oracle>InstalledDbs (revision 8)EditAttachPDF
Note: Usually a user is assign one of three roles: reader (read only access), user (read&write access) or developer (read&write, ability to create various objects plus unlimited tablespace). The developer role permissions are a superset of user permissions which in turn include the reader role permissions. For more information on the actual privileges each role contains please read "Users and Role" twiki entry.

RAC databases (rac01-rac04):

  • Database oradb01:
    • Listener port: 1521
    • Service confdb
      • Users: see Configuration Db twiki page
    • Service rundb
      • Users: rundb_admin, rundb_writer, rundb_reader
    • Service lbemdh
      • Users: lbemdh_admin, lbemdh_writer, lbemdh_reader

  • Database oradb02 (PVSS Archiving):
    • Listener port: 1522
    • Users, tablespaces: not created

ora01 databases:

  • Database "test" on lbondiskdev.cern.ch. Used for database development (SHIFTDB presently)
    • Created users: root with SYSDBA priviledges

  • Database "test" on lbonrac2.cern.ch (not used)
    • Created users: root with SYSDBA priviledges

  • Database "ELOG" on lbora01.cern.ch/ora01.lbdaq.cern.ch (inside the DAQ network). The database is turned off.
    • Listener port: 1521
    • EM port: 5501 (not turned on)

  • Database "RUNDB" on lbora01.cern.ch/ora01.lbdaq.cern.ch (inside the DAQ network).
    • Listener port: 1522
    • EM port: 5502 (not turned on by default)
    • Users:
      • ROOT: (sysdba)

  • Database "LBEMDH" on lbora01.cern.ch/ora01.lbdaq.cern.ch (inside the DAQ network). The database is synchronized each week (Saturday night) with the CERN LHCb Integration database.
    • Uses ASM
    • Created users: LHCBINTEGRATION with database developer priviledges and profile DEV_PROFILE
    • Listener port: 1523
    • EM port: 5503 (not turned on by default)
    • Users:
      • LHCBINTEGRATION_READER (default reader privileges)
      • LHCBINTEGRATION (default admin privileges)
      • LHCB_INTEGRATION

  • Database "CALODB" on lbora01.cern.ch/ora01.lbdaq.cern.ch (inside the DAQ network).
    • Uses ASM
    • Created users: CALO_USER with database developer priviledges and profile DEV_PROFILE
    • Listener port: 1524
    • EM port: 5504 (not turned on by default)
    • Users:
      • CALO_OP
      • HCAL_EX
      • ECAL_EX
      • CALO_USER

  • Database "CONDITIONSDB" on lbora01.cern.ch/ora01.lbdaq.cern.ch (inside the DAQ network).
    • Uses ASM
    • Listener port: 1526
    • EM port: 5506 (not turned on by default)
    • Users:
      • LHCB_CONDDB_READER
      • LHCB_CONDBDB
      • LHCB_ONLINE_CONDDB
      • LHCB_CONDDB_MANAGER

  • Database "PVSSARCH" on lbora01.cern.ch/ora01.lbdaq.cern.ch (inside the DAQ network). Used for testing the PVSS archiving.
    • Uses ASM. Datafiles on ORADG01 and archive logs + backups on ORADG02
    • Listener port: 1527
    • EM port: 5507 (not turned on by default)
    • Users:
      • S361_TEST (default developer privileges)

  • Database "HISTOGRAMDB" on lbora01.cern.ch/ora01.lbdaq.cern.ch (inside the DAQ network).
    • Uses ASM. Datafiles on ORADG01 and archive logs + backups on ORADG02
    • Listener port: 1528
    • EM port: 5528 (not turned on by default)
    • Users:
      • HIST_WRITER (default user privileges)
      • HIST_READER (default reader privileges)
      • HIST_ADMIN (default developer privileges)

  • Database "SYSTEMINFODB" on lbora01.cern.ch/ora01.lbdaq.cern.ch (inside the DAQ network).
    • Uses ASM. Datafiles on ORADG01 and archive logs + backups on ORADG02
    • Listener port: 1529
    • EM port: 5509 (not turned on by default)
    • Users:
      • SYSINFO_READER (default reader privileges)
      • SYSINFO_ADMIN(default developer privileges)

  • Database "CONFIGDB" on lbora01.cern.ch/ora01.lbdaq.cern.ch (inside the DAQ network).
    • Uses ASM. Datafiles on ORADG01 and archive logs + backups on ORADG02
    • Listener port: 1530
    • EM port: 5530 (not turned on by default)
Edit | Attach | Watch | Print version | History: r9 < r8 < r7 < r6 < r5 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r8 - 2007-10-22 - RaduStoica
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    LHCb All webs login

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