Database Administration Tasks
Either you or your Oracle DBA must carry out the following tasks, in order that a UNIX Acquire can capture data from Oracle instances on the same machine.
-
You must specify two settings in the init.ora file for each instance that you want to capture data from:
timed_statistics = true
os_authent_prefix = “ops$” – Oracle 11g and below
os_authent_prefix = “c##” – Oracle 12c
If timed_statistics is not set, you will not capture any CPU utilization data from within Oracle.
-
For both these settings to become effective, you will have to shut down and restart the database instance. However, you can dynamically alter the timed_statistics setting from sqlplus by using the alter session command.
-
You must know the Oracle_SID of each Oracle instance.
-
You must know the Oracle_HOME of each Oracle instance.
-
The Oracle part of the Acquire executes a SQL*Plus script against the V$ tables of the Oracle instance being monitored. You must know the location of the sqlplus executable.
-
You must create an Oracle ops$ user (or c## user for Oracle12c) for each target Oracle database. This will map the UNIX user ID under which Acquire is installed (typically metron) onto an Oracle user (thus, typically ops$metron). The use of an ops$ user removes the need to provide any additional user and password authentication. For more information, refer to the following notes.