Oracle Grid Infrastructure & DMK

One major advantage of DMK is the ability to support multiple ORACLE_BASE environments, especially useful for Oracle Grid Infrastructure. Oracle and dbi services recommend separating the duties of an ASMDBA (ASM storage DBA) from an Oracle Database DBA (SYSDBA). In this short chapter we present how one can realize it with DMK.

Firstly, install the DMK under one user as explained in the installation chapter. Before starting with the installation for the second user, set the correct permissions, as presented by the following example:

grid@vmoraoel:/u01/app/grid/local/dmk/ [grid] chmod -R g+x bin
grid@vmoraoel:/u01/app/grid/local/dmk/ [grid] chmod -R g+w etc
grid@vmoraoel:/u01/app/grid/local/dmk/ [grid] chmod -R g+w log

In the above example the root installation has been done as the GRID user.

DMK uses the Perl interpreter from ORACLE_HOME and therefore some privileges must be changed; either on the Grid Infrastructure, or on the Oracle RDBMS home - depending on your installation. In the following example, we grant the user ORACLE to execute the perl from Grid Infrastructure Oracle Home.

grid@vmoraoel:/u01/app/grid/ [grid] chmod g+x $ORACLE_HOME/perl/bin/perl
grid@vmoraoel:/u01/app/grid/ [grid] chmod -R g+r $ORACLE_HOME/perl/lib

Example of one error, if missed to change:

2012-06-25_20:38:34::dmk.bash::MainProgram ::CRITICAL ==> Execution permision missing on PERL_EXEC=/u01/app/grid/…

ℹ️The above operations affect the privileges of the oracle user, because DMK is installed as user “grid”, but they are also needed to enable the reverse situation.