PRIMECLUSTER Wizard for Oracle is a software product that facilitates cluster operation management for Oracle database operating on a PRIMECLUSTER system.
The standby operation with Oracle database is enabled. The single-node cluster operation requires an operation node in which a cluster consists of one node.
This software provides the following features:
Feature | Description |
Environment Setup | Environment setup tool to enable clustering of Oracle database |
Monitoring | Daemon processes to monitor Oracle instance, Listener and detect their failures |
Start and Stop Control | Scripts used for startup and stop of Oracle instances, Listeners |
Setup and Operation Commands | Commands used for setup and operations |
Environment Setup
To enable clustering of Oracle database, it is required that Oracle instances and Listeners are registered on userApplication(cluster application) as a "resource". PRIMECLUSTER Wizard for Oracle enables it. For details, refer to "Chapter 2 Environment Setup".
Monitoring
PRIMECLUSTER Wizard for Oracle provides daemon processes to monitor Oracle instances and Listeners and detect their failures. For details, refer to "3.1 Oracle Control through PRIMECLUSTER Wizard for Oracle".
Oracle instance Monitoring
The daemon process connects to the Oracle instance as the SYSTEM user. It also cyclically monitors background processes ("Process Monitoring") and manipulates data with SQL statements ("Table Monitoring").
The daemon process monitors PMON, SMON, DBWn, LGWR and CKPT of the background processes in the process monitoring, and creates a table for monitoring in the SYSTEM schema, and manipulate data on the table with SQL statements (INSERT, UPDATE, DELETE and COMMIT) in the table monitoring. Therefore, it means that not only the background process failures but also logical failures can be detected.
If ORA-xxxxx error occurs and the daemon process detected it in monitoring, restart of the Oracle instance and failover are automatically performed according to the detected error. Moreover, if the Oracle instance hangs and the SQL statements are not returned within a specified time, it is notified as a timeout error.
Listener Monitoring
The daemon process monitors a Listener process. In standby operation, it also monitors the Listener with "tnsping" command.
Start and Stop Control
PRIMECLUSTER Wizard for Oracle provides scripts to start up and stop Oracle instances and Listeners automatically, according to the state transition of userApplication. For details, refer to "3.1 Oracle Control through PRIMECLUSTER Wizard for Oracle".
Oracle instance Start and Stop
In standby operation, the script starts up the Oracle instance, checking the state and recovering. For example, if the Oracle instance had failed during online backup, the scripts automatically execute "END BACKUP" during the startup.
When stopping, the scripts stop the instance in the IMMEDIATE mode. If it fails, the script immediately tries in the ABORT. It means that the failover of userApplication can be performed at high-speed.
Listener Start and Stop
In standby operation, the script starts up and stops the Listener with "lsnrctl start/stop" command, checking the state.
Setup and Operation Commands
PRIMECLUSTER Wizard for Oracle provides auxiliary commands for setup and operation. For details, refer to "Chapter 4 Command".