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.