Configuration requirements for Oracle data capture – BequeathConnection - syncsort_capacity_management - 12 - 12.40

Syncsort Capacity Management Installation Guide

Product type
Software
Portfolio
Integrate
Product family
Syncsort
Product
Syncsort Capacity Management
Version
12.40
Language
English
Product name
Syncsort Capacity Management
Title
Syncsort Capacity Management Installation Guide
Topic type
How Do I
Copyright
2023
First publish date
1985

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.