Oracle PRIMECLUSTERTM Wizard for 4.1 Manuel D’Utilisation
1.1
Feature outline
PRIMECLUSTER Wizard for Oracle is a software product that facilitates cluster operation
management for Oracle operating on a PRIMECLUSTER system.
This is required for scalable operation and standby operation for a cold standby Oracle instance.
The scalable operation requires Oracle9i Real Application Clusters (Oracle9i RAC). The
standby operation does not require Oracle9i RAC, but requires Oracle cold standby instead.
management for Oracle operating on a PRIMECLUSTER system.
This is required for scalable operation and standby operation for a cold standby Oracle instance.
The scalable operation requires Oracle9i Real Application Clusters (Oracle9i RAC). The
standby operation does not require Oracle9i RAC, but requires Oracle cold standby instead.
Module structure
For Oracle operation on PRIMECLUSTER, the module consists of the followings:
Environment setup Wizard
Environment setup tool to enable Oracle operation on
PRIMECLUSTER
PRIMECLUSTER
Detector
Module to monitor Oracle
Scripts
Control Oracle startup and stop
Setup/operation command
Commands used to set up and operate
Environment setup
The environment setup tool provides “ORACLE” Wizard that creates userApplication in the
environment configuration of PRIMECLUSTER RMS.
environment configuration of PRIMECLUSTER RMS.
Monitoring
A detector monitors Oracle instances and Oracle listeners. The detector is connected to Oracle
using system user to monitor the Oracle instance. Then, it periodically creates, updates, and
deletes dummy table, which is created in the system user’s default tablespace by executing the
SQL command. This enables the detector to detect a logical failure as well as the process state
of the Oracle instance. When the Oracle instance
using system user to monitor the Oracle instance. Then, it periodically creates, updates, and
deletes dummy table, which is created in the system user’s default tablespace by executing the
SQL command. This enables the detector to detect a logical failure as well as the process state
of the Oracle instance. When the Oracle instance
hangs, and if the SQL command is not
returned within a specified time, the detector times out to notify a user of the failure. The two
types of monitoring of the Oracle listener are process detection and the “tnsping” command.
types of monitoring of the Oracle listener are process detection and the “tnsping” command.
Startup and stop control
Along with the state transition of a cluster system, scripts automatically start or stop Oracle
instances or Oracle listeners. These scripts first check and then start up the Oracle instance.
If damage has occurred, the scripts automatically recover the Oracle instance. For example, if
the Oracle instance fails during online backup, the scripts automatically execute “end backup” to
start up the Oracle instance (When the AutoRecover is set to “Yes”.) When stopping the Oracle
instance, the scripts stop it in the immediate mode (default). If this does not occur properly, the
scripts stop the instance in the abort mode. This means operational node switchover can be
performed at high-speed.
instances or Oracle listeners. These scripts first check and then start up the Oracle instance.
If damage has occurred, the scripts automatically recover the Oracle instance. For example, if
the Oracle instance fails during online backup, the scripts automatically execute “end backup” to
start up the Oracle instance (When the AutoRecover is set to “Yes”.) When stopping the Oracle
instance, the scripts stop it in the immediate mode (default). If this does not occur properly, the
scripts stop the instance in the abort mode. This means operational node switchover can be
performed at high-speed.
5