Oracle Resource Type
type Oracle (
static keylist SupportedActions = { VRTS_GetInstanceName,
VRTS_GetRunningServices, DBRestrict, DBUndoRestrict, DBResume,
DBSuspend, DBTbspBackup }
static str ArgList[] = { Sid, Owner, Home, Pfile, StartUpOpt,
ShutDownOpt, EnvFile, AutoEndBkup, DetailMonitor, User, Pword,
Table, MonScript, AgentDebug, Encoding }
str Sid
str Owner
str Home
str Pfile
str StartUpOpt = STARTUP
str ShutDownOpt = IMMEDIATE
str EnvFile
boolean AutoEndBkup = 1
int DetailMonitor
str MonScript = "./bin/Oracle/SqlTest.pl"
str User
str Pword
str Table
boolean AgentDebug = 0
str Encoding
)
Attribute Definitions
Required Attributes
|
Type and Dimension
|
Definition
|
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.
|
Owner
|
string-scalar
|
The Oracle user, as the defined owner of executables and database files in /etc/passwd.
|
Home
|
string-scalar
|
The $ORACLE_HOME path to Oracle binaries and configuration files. For example, you could specify the path as /opt/ora_home.
Note Do not append a slash (/) at the end of the path.
|
Optional Attributes
|
Type and Dimension
|
Definition
|
StartUpOpt
|
string-scalar
|
Startup options for the Oracle instance. This attribute can take the following values:
- STARTUP
- RESTRICTED
- RECOVERDB
- SRVCTLSTART
- CUSTOM
Default is STARTUP.
|
ShutDownOpt
|
string-scalar
|
Shut down options for the Oracle instance. This attribute can take the following values:
- IMMEDIATE
- TRANSACTIONAL
- SRVCTLSTOP
- CUSTOM
Default 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.
|
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
|
integer-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
|
DetailMonitor
|
integer-scalar
|
Setting this flag to a non-zero enables detail monitoring for Oracle. The value indicates the number of monitor cycles after which the agent will monitor Oracle in detail. For example, the value 5 indicates that the agent will monitor Oracle in detail every five monitor intervals.
Default = 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/VRTSvcs/bin/Oracle/SqlTest.pl.
MonScript also accepts a pathname relative to $VCS_HOME. 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, described on Encrypting Passwords.
|
Table
|
string-scalar
|
Table for update by User/Pword.
|
Encoding
|
string-scalar
|
Specifies operating system encoding that corresponds to Oracle encoding for the displayed Oracle output. The default is "".
|
AgentDebug
|
boolean-scalar
|
Additional debug messages are logged when this flag is set.
Default = 0
|
|