Difference: InstalledDbs (6 vs. 7)

Revision 72007-10-05 - RaduStoica

Line: 1 to 1
 
META TOPICPARENT name="Oracle"
Changed:
<
<
  • Database "test" on lbondiskdev.cern.ch
Used for database development (SHIFTDB presently)
>
>
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
Changed:
<
<
  • Database "ELOG" on lbora01.cern.ch/ora01.lbdaq.cern.ch (inside the DAQ network).
The database is turned off.
>
>
  • 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)
Changed:
<
<
  • Database "RUNDB" on lbora01.cern.ch/ora01.lbdaq.cern.ch (inside the DAQ network)
>
>
  • 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)
Added:
>
>
    • Users:
      • ROOT: (sysdba)
 
Changed:
<
<
  • Database "LBEMDH" on lbora01.cern.ch/ora01.lbdaq.cern.ch (inside the DAQ network).
>
>
  • 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)
Added:
>
>
    • 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)
Added:
>
>
    • 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)
Added:
>
>
    • Users:
      • LHCB_CONDDB_READER
      • LHCB_CONDBDB
      • LHCB_ONLINE_CONDDB
      • LHCB_CONDDB_MANAGER
 
Changed:
<
<
  • Database "PVSSARCH" on lbora01.cern.ch/ora01.lbdaq.cern.ch (inside the DAQ network).
Should be used for testing the PVSS archiving
>
>
  • 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)
Changed:
<
<
  • 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:
      • 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)
Added:
>
>
    • 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
 
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