Difference: InstalledDbs (8 vs. 9)

Revision 92008-02-22 - RaduStoica

Line: 1 to 1
 
META TOPICPARENT name="Oracle"
Changed:
<
<
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.
>
>
Note: Usually a user is assign one of these 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 the 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
Changed:
<
<
    • Service confdb
      • Users: see Configuration Db twiki page
    • Service rundb
>
>
    • Service confdb.lbdaq.cern.ch
    • Service conf_con_srv.lbdaq.cern.ch known as CONFDB
      • Users: conf_con_admin, conf_con_writer, conf_con_reader
    • Service rundb.lbdaq.cern.ch known as RUNDB
 
      • Users: rundb_admin, rundb_writer, rundb_reader
Changed:
<
<
    • Service lbemdh
      • Users: lbemdh_admin, lbemdh_writer, lbemdh_reader
>
>
    • Service hist_svc.lbdaq.cern.ch known as HISTDB
      • Users: hist_admin, hist_writer, hist_reader
 
  • Database oradb02 (PVSS Archiving):
Changed:
<
<
    • Listener port: 1522
    • Users, tablespaces: not created
>
>
    • Listener port: 1521
    • Service pvssarch.lbdaq.cern.ch known as PVSSARCH * Users: s362_rich_admin, s362_rich_writer, s362_rich_reader
 
Changed:
<
<

ora01 databases:

>
>

157 databases:

 
  • Database "test" on lbondiskdev.cern.ch. Used for database development (SHIFTDB presently)
    • Created users: root with SYSDBA priviledges
Line: 24 to 28
 
  • Database "test" on lbonrac2.cern.ch (not used)
    • Created users: root with SYSDBA priviledges
Added:
>
>

ora01 databases:

 
  • 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)
Added:
>
>
    • Currently the database is pending deletion.
 
Changed:
<
<
  • Database "RUNDB" on lbora01.cern.ch/ora01.lbdaq.cern.ch (inside the DAQ network).
>
>
  • Database "RUNDB_ORA01" on lbora01.cern.ch/ora01.lbdaq.cern.ch (inside the DAQ network).
 
    • Listener port: 1522
    • EM port: 5502 (not turned on by default)
    • Users:
 
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