This section discusses how PRIMECLUSTER Wizard for Oracle controls Oracle in standby operation.
Oracle instance Startup
Startup procedure of an Oracle instance is as follows:
su - <Oracle DBA user>
sqlplus / nolog
connect / as sysdba
startup nomount or startup mount
alter database mount (if "startup nomount" was executed at step "4")
alter database open
Initialized parameter file and server parameter file
The initialized parameter file is not specified for Oracle startup through PRIMECLUSTER Wizard for Oracle, so the default initialized parameter file will be used instead. Specify the initialized parameter file for the following default path (symbolic link).
<$ORACLE_HOME>/dbs/init<$ORACLE_SID>.ora
A server parameter file should be located in the shared disk because the file contents are changed dynamically. When a server parameter file is used, enter the full path of the server parameter file in an initialization parameter file.
It is recommended that the same values for initialization parameters are set between cluster nodes.
The server parameter file must be located on the shared disk device because it is dynamically changed. When you use the server parameter file, enter the full path for the initialized parameter file. Refer to "2.2.6 Oracle Database Creation and Setting".
It is recommended that the initialized parameter file settings are the same on the operating nodes and standby nodes.
Recovery processing
PRIMECLUSTER Wizard for Oracle recovers the Oracle instance in the following cases:
When there is ACTIVE table space in the V$BACKUP view.
When there are files required to be recovered in the V$RECOVER_FILE view.
When RAC is running, the above recovery processing is exception.
DBA authentication
PRIMECLUSTER Wizard for Oracle connects to Oracle instance with SYSDBA system privilege to start up or stop Oracle instance/database. In this case, local connection in operating system authentication is used.
Oracle instance Shutdown
Shutdown procedure of an Oracle instance by user operation is as follows:
su - <Oracle DBA user>
sqlplus / nolog
connect / as sysdba
shutdown <immediate / abort / transactional> (Setup with StopModeStop)
Default : immediate
If Oracle is not stopped at step "4" (except for abort), use shutdown abort.
If Oracle is not stopped at step "4" or "5", shut it down forcibly by sending SIGKILL to the background processes.
Shutdown procedure of an Oracle instance by resource failure or failover is as follows:
su - <Oracle DBA user>
sqlplus / nolog
connect / as sysdba
shutdown <immediate / abort / transactional> (Setup with StopModeFail)
Default : abort
If Oracle is not stopped at step "4" (except for abort), use shutdown abort.
If Oracle is not stopped at step "4" or "5", shut it down forcibly by sending SIGKILL to the background processes.
Oracle instance Monitoring
Monitoring procedure of an Oracle instance is as follows:
Check the background process (PMON, SMON) periodically. If the process status can be confirmed, go to step "2".
su - <Oracle DBA user>
Local connection to the Oracle instance as the SYSTEM user
Check if Oracle status is OPEN
Check if the background processes (PMON, SMON, DBWn, LGWR, CKPT) are alive.
Check if "INSERT", "UPDATE", "DELETE" and "COMMIT" can be properly executed using the monitoring table on the SYSTEM user's default table space.
Oracle is reconnected once every 24 hours.
If Oracle is stopped, "1" is executed at a 30 second interval (static).
If Oracle gets activated, "2" and after are executed. If node startup is completed then the node is operating, only "5" and "6" are executed at a regular interval. The default value is 30 seconds, and can be changed. Note that "6" is executed at a 60-second interval at least.
SYSTEM user password
PRIMECLUSTER Wizard for Oracle monitors Oracle as the SYSTEM user. Set the SYSTEM user's password. Refer to "4.3 clorapass - Register Password for Monitoring".
Monitoring table
PRIMECLUSTER Wizard for Oracle creates a monitoring table on the SYSTEM user's default table space if the monitoring table does not exist. The table is only a few bites, and will not be deleted.
Warning notification
If the following symptoms are detected, PRIMECLUSTER Wizard for Oracle will notify RMS of the warning state. It is not the Fault state, so a failover will not occur.
Oracle cannot be connected due to incorrect SYSTEM user's password that is registered with the "clorapass" command (ORA-01017 detected)
Since the SYSTEM user account is locked, so Oracle connection is not allowed (ORA-28000 detected)
When the max session or max process error occurs, so Oracle connection is not allowed
While monitoring SQL (e.g. insert and update) is not replied for a certain period of time, but Oracle connection is allowed, and the Oracle status is OPEN.
Since the SYSTEM user's password has expired, so Oracle connection is not allowed (ORA-28001 detected)
Monitoring timeout
If SQL statement(INSERT, UPDATE) is released, and there is no reply from Oracle after a certain period of time, the monitoring timeout will be considered then the Oracle instance resource will be put into Warning. If the monitoring timeout occurs for twice in a row, a resource will be considered as fault then a failover will be performed.
The monitoring timeout (the wait time from Oracle) can be changed with WatchTimeout.
Listener Startup
Startup procedure of a Listener is as follows:
su - <Oracle user>
lsnrctl start <ListenerName>
Makes sure that a Listener process does exist.
Listener Shutdown
Shutdown procedure of a Listener is as follows:
su - <Oracle user>
lsnrctl stop <ListenerName>
Makes sure that a Listener process does not exist.
If Listener is not stopped at step "3", shut it down forcibly by sending SIGKILL to the background process.
Listener Monitoring
Monitoring procedure of a Listener is as follows:
Makes sure that a Listener process does not exist.
Makes sure that the net service name is valid with "tnsping" if TNSName is set.
If a Listener of a standby node is stopped, execute "1" at regular time intervals.
If the Listener gets activated and becomes an operating node, execute "1" and "2" at regular time intervals.
The default interval time is 30 seconds, and it can be changed with Interval. Note that "2" is executed at a 60-second interval at least.
ASM instance Startup
Startup procedure of an ASM instance is as follows
su - <Oracle DBA user>
sqlplus / nolog
connect / as sysasm
startup mount (if "STARTED" already, "alter diskgroup all mount" is executed.)
ASM instance Shutdown
Shutdown procedure of an ASM instance by user operation is as follows:
su - <Oracle DBA user>
sqlplus / nolog
connect / as sysasm
shutdown <immediate / abort / transactional> (Setup with StopModeStop)
Default : immediate
If ASM is not stopped at step "4" (except for abort), use shutdown abort.
If ASM is not stopped at step "4" or "5", shut it down forcibly by sending SIGKILL to the background processes.
Shutdown procedure of an ASM instance by resource failure or failover is as follows:
su - <Oracle DBA user>
sqlplus / nolog
connect / as sysasm
shutdown <immediate / abort / transactional> (Setup with StopModeFail)
Default : abort
If ASM is not stopped at step "4" (except for abort), use shutdown abort.
If ASM is not stopped at step "4" or "5", shut it down forcibly by sending SIGKILL to the background processes.
ASM instance Monitoring
ASM is not monitored. NullDetector flag is automatically enabled.