TWiki> LHCb Web>LHCbOnline>Oracle>InstalledDbs (revision 7)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.

  • 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: r7 - 2007-10-05 - 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