PRIMECLUSTER Wizard for Oracle is a software product which operates Oracle Database (abbreviated as Oracle) built on a cluster system in PRIMECLUSTER. PRIMECLUSTER Wizard for Oracle ensures scalable operation with Oracle Real Application Clusters (abbreviated as RAC) and the switching standby operation.
In line with the state transition of the cluster system, scripts automatically start or stop the Oracle instance.
Scalable operation
Oracle instance
Use the Oracle srvctl start/stop instance command to start and stop the Oracle instance.
Oracle Clusterware
Start and stop the Oracle Clusterware.
Standby operation
Oracle instance
Check the state of the Oracle instance and start while the recovery is performed.
For example, if the Oracle instance is down during the ONLINE BACKUP of the Oracle instance, execute the end backup automatically to perform the automatic start of the Oracle instance.
The scripts stop the Oracle instance in the immediate mode.
When it cannot be stopped normally, it can be switched fast by stopping the Oracle instance with the abort mode.
Oracle Listener
Use the Oracle lsnrctl start/stop command to start and stop the Oracle listener.
Check the listener process at the same time of start/stop process and confirm that they have been performed correctly.
A detector monitors the Oracle instance and Oracle listener.
Monitoring of Oracle Instance
Connects itself to Oracle using system user.
Use a dummy table for monitoring to update the data.
Confirming Oracle error code
A logical failure can be detected as well as the process of the Oracle instance being active or inactive by this monitoring method.
Monitoring of Oracle listener
Monitor the listener process.
For the standby operation, monitoring by using the Oracle tnsping command is possible. (It is possible when the monitoring items of Wizard are set up).
The environment setup tool provides the Oracle resource setup and Environment setup Wizard to create a cluster application in PRIMECLUSTER.
