Requirements checklist
To configure an instance for monitoring, a PATROL OS account user must have SQLPlus connection to the instance. For this, the following permissions are required:
Permissions for PATROL OS account user on UNIX or Windows to connect to SQLPlus
Directory name | Permissions |
|---|---|
For SQLPlus binary: | |
$ORACLE_HOME | r + x |
$ORACLE_HOME/bin | r + x |
$ ORACLE_HOME/lib | r + x |
$ ORACLE_HOME/lib/libsqlplus.so | r |
$ ORACLE_HOME/lib/libclntsh.so | r + x |
$ORACLE_HOME/lib/libclntsh.so.10.1 | r |
$ORACLE_HOME/lib/libnnz10.so | r |
$ORACLE_HOME/sqlplus | r + x |
$ORACLE_HOME/sqlplus/mesg | r + x |
$ORACLE_HOME/oracore | r + x |
$ORACLE_HOME/oracore/mesg | r + x |
$ORACLE_HOME/oracore/zoneinfo | r + x |
$ORACLE_HOME/oracore/mesg/lfius.msb | r |
$ORACLE_HOME/oracore/mesg/lrmus.msb | r |
$ORACLE_HOME/oracore/zoneinfo/timezone.dat | r + x |
$ORACLE_HOME/oracore/zoneinfo/readme.txt | r |
$ORACLE_HOME/oracore/zoneinfo/timezlrg.dat | r |
For lsnrctl: | |
$ORACLE_HOME/network | r + x |
$ORACLE_HOME/network/mesg | r + x |
All files under $ORACLE_HOME/network/mesg | r |
During instance configuration, if the PATROL OS user belongs to the others group and the Oracle environment is set with permissions on UNIX platform, as shown in the following example, the configuration will fail.
For the instance configuration to be successful, you must skip the permission check by setting the /OracleConfig.ORACLE_SID.ACLFlag pconfig variable to 1.
The following table provides a checklist of the requirements that PATROL for Oracle Database needs to operate successfully.
PATROL for Oracle Database requirements checklist