Wednesday, July 17, 2013

ASM 11gR2 Installation & Configuration (Role Separation).

Before the database creation of an 11.2.0.X.X, 11.1.0.X.X  or 10.2.0.X.X database using ASM 11.2.0.X.X (as storage option), then you need to set the ASM GID to the oracle kernel (<10.2, 11.1 or 11.2 RDBMS Oracle Home>/bin/oracle executable), this needs to be set before you execute the DBCA.




Oracle Cluster OS groups

Owner and Groups driver interface ASM

Oracle RDBMS OS groups

Add ASM GID to the RDBMS oracle executable


 ls –l <10.2, 11.1 or 11.2 RDBMS DB Oracle Home>/bin/oracle
 su - grid
<Oracle Grid Home>/bin/setasmgidwrap o=<10.2, 11.1 or 11.2 RDBMS DB OracleHome >/bin/oracle
 ls –l <10.2, 11.1 or 11.2 RDBMS DB Oracle Home>/bin/oracle


The “asmadmin” group is now associated to the RDBMS $ORACLE_HOME/bin/oracle kernel executable.

Note:
Grid Infrastructure Standalone (non-RAC) configuration on 11.2 software. The user grid needs to be included the OSDBA OS group. The grid infrastructure components must be able to connect to the database as SYSDBA for starting and stoping of the database.