1.

In 11g Rac We Want To Separate Asm Admins From Dbas And Create Different Users And Groups. How Do We Set This Up?

Answer»

For clarification:

  • SEPARATE Oracle Home for ASM and RDBMS.
  • RDBMS instance connects to ASM USING OSDBA group of the ASM instance.
  • Thus, software owner for each RDBMS instance CONNECTING to ASM must bea member of ASM's OSDBA group.
  • CHOOSE a different OSDBA group for ASM instance (asmdba) than forRDBMS instance (dba)
  • In 11g, ASM administrator has to be member of a separate SYSASM group toseparate ASM Admin and DBAS.

For clarification:


Discussion

No Comment Found

Related InterviewSolutions