Veritas InfoScale™ 8.0.2 Storage and Availability Management for Oracle Databases - AIX, Linux, Solaris

Sid

string-scalar

The variable $ORACLE_SID that represents the Oracle instance. The Sid is considered case-sensitive by the Oracle agent and by the Oracle database server.

For a policy managed database, the Sid attribute should be set to Sid prefix.

Owner

string-scalar

The Oracle user who has privileges to start or stop the database instance.

The agent also supports LDAP users as Oracle user.

Home

string-scalar

The $ORACLE_HOME path to Oracle binaries and configuration files. For example, you could specify the path as /opt/ora_home.

StartUpOpt

string-scalar

Default is STARTUP_FORCE.

Startup options for the Oracle instance in pluggable database. This attribute can take the following values:

ShutDownOpt

string-scalar

Default is IMMEDIATE.

Shut down options for the Oracle instance in pluggable database is IMMEDIATE.

EnvFile

string-scalar

The full path name of the file that is sourced by the entry point scripts. This file contains the environment variables set by the user for the Oracle database server environment such as LD_LIBRARY_PATH, NLS_DATE_FORMAT, and so on.

The syntax for the contents of the file depends on the login shell of Owner. File must be readable by Owner. The file must not contain any prompts for user input.

Sample EnvFile content with ORACLE_BASE path for Oracle 21c

[root@inaqalnx013 Oracle]# cat /opt/VRTSagents/ha/bin/Oracle/envfile ORACLE_BASE="/u02/app/oracle/product/21.0.0/dbhome_1/"; export ORACLE_BASE;

Sample attribute value

EnvFile = "/opt/VRTSagents/ha/bin/Oracle/envfile"

Pfile

string-scalar

The name of the initialization parameter file with the complete path of the startup profile.

You can also use the server parameter file. Create a one-line text initialization parameter file that contains only the SPFILE parameter. See the Oracle documentation for more information.

AutoEndBkup

boolean-scalar

Setting the AutoEndBkup attribute to a non-zero value takes the datafiles in the database out of the backup mode, during Online.

Default = 1

MonitorOption

integer-scalar

Monitor options for the Oracle instance. This attribute can take values 0 or 1.

Default = 0

The agent supports intelligent resource monitoring only for traditional and CDBs when the attribute value is set to 0.

MonScript

string-scalar

Pathname to the script provided for detail monitoring. The default (basic monitoring) is to monitor the database PIDs only.

The pathname to the supplied detail monitor script is /opt/VRTSagents/ha/bin/Oracle/SqlTest.pl.

MonScript also accepts a pathname relative to /opt/VRTSagents/ha. A relative pathname should start with "./", as in the path ./bin/Oracle/SqlTest.pl.

User

string-scalar

Internal database user. Connects to the database for detail monitoring.

Pword

string-scalar

Encrypted password for internal database-user authentication.

Encrypt passwords only when entering them using the command-line. Passwords must be encrypted using the VCS Encrypt Utility (/opt/VRTSvcs/bin/vcsencrypt).

Table

string-scalar

Table for update by User/Pword.

DBName

string-scalar

Set this attribute only when the database is a policy managed RAC database. The value of this attribute must be set to the database unique name.

ManagedBy

string-scalar

Default value for this attribute is ADMIN. In a policy managed RAC database this attribute must be set to POLICY.

PDBName

string-scalar

This attribute must be configured for a PDB. And the value should be set for a PDB database name. For traditional and CDB database, do not set this attribute.

UseSystemD

Boolean

systemD is a system and service manager for Linux operating systems. It helps manage applications across Linux distributions that support systemD feature.

When Online Entry point is invoked with UseSystemD attribute enabled, the Oracle resource comes online as a service in system.slice. Without the UseSystemD attribute enabled, a typical online entry point starts the resource in user.slice.

Consideration: Upon a system reboot, if application resource has been started under user.slice, there is a possibility that the processes are not stopped gracefully. This may cause the database to corrupt. This behavior is different for each Oracle application version. Hence, enable UseSystemD attribute for Oracle on you system.

The application process can be viewed as vcs-<resource_name>.service, in /etc/systemd/system.

Set the UseSystemD value to 0 or 1.

SystemDAttrList

string-scalar

Ensure that UseSystemD is enabled before you set the key-value pairs in the SystemDAttrList attribute. For more information, refer to the Red Hat website to know more about the different limits you can apply to the application.

For example,

# hares -modify oracle SystemDAttrList LimitLOCKS 44433

Where, LimitLOCKS is the key and 44433 is the value for the key.

AgentDirectory

static-string

Specifies the location of binaries, scripts, and other files related to the Oracle agent.

Default is /opt/VRTSagents/ha/bin/Oracle.