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 Oracle Real Application Clusters ("RAC" or "Oracle RAC 10g"hereafter). The standby operation does not require Oracle RAC, but requires Oracle cold-standby instead.
Startup and stop control
In line with the state transition of the userApplication, scripts automatically start or stop an Oracle instance or an Oracle listener. 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.
In the operation of Oracle RAC 10g, starting and stopping of Oracle services are also controlled.
Monitoring
A detector monitors an Oracle instance and an Oracle listener. The detector connects itself to Oracle using system user. Then, this enables the detector periodically to create, update and delete a dummy table, which should be generated in the system user's default table space, by executing an SQL command. Consequently, a logical failure can be detected as well as the process of the Oracle instance being active or inactive. Oracle ORA-XXXX errors are detected after the SQL command is executed, failover and restart of Oracle instance are automatically initiated according to the error level. When the Oracle instance hangs, and if the SQL command is not returned within a specified time, the detector times out and notifies a user of the failure. The two types of monitoring of the Oracle listener are process detection and the "tnsping" command.
In the operation of Oracle RAC 10g, monitoring of the Oracle service, Oracle instance, and Oracle listener are carried, while recovery and degeneration in the event of failures are performed by Oracle RAC 10g CRS (Cluster Ready Services).
Environment setup
The environment setup tool provides an "ORACLE" Wizard that generates userApplications in the RMS configuration by executing the "hvw" command of PRIMECLUSTER RMS Wizard.
