PRIMECLUSTER Wizard for Oracle (PRIMEQUEST) 4.3 Configuration and Administration Guide

3.1.1 Oracle resources Startup and Shutdown

Oracle instance Startup

Startup procedure of an Oracle instance is as follows:

1. su - <Oracle DBA user>

2. sqlplus / nolog

3. connect / as sysdba

4. startup nomount or startup mount

5. alter database mount (if "startup nomount" was executed at step "4")

6. 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

  The server parameter file should be located in the shared disk because it is dynamically changed. When you use the server parameter file, specify the full path of the server parameter file to the initialization parameter file. Refer to "2.2.6 Oracle Database Creation and Setting".
  It is recommended that the initialization parameter file settings are the same on the operating nodes and standby nodes.

  Note

  In single-node cluster operation, the definition described at "Initialized parameter file and server parameter file" is not necessary.

• 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.

• 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:

  1. su - <Oracle DBA user>

  2. sqlplus / nolog

  3. connect / as sysdba

  4. shutdown <immediate / abort / transactional> (Setup with StopModeStop)
     Default : immediate

  5. If Oracle is not stopped at step "4" (except for abort), use shutdown abort.

  6. 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:

  1. su - <Oracle DBA user>

  2. sqlplus / nolog

  3. connect / as sysdba

  4. shutdown <immediate / abort> (Setup with StopModeFail)
     Default : abort

  5. If Oracle is not stopped at step "4" (except for abort), use shutdown abort.

  6. If Oracle is not stopped at step "4" or "5", shut it down forcibly by sending SIGKILL to the background processes.

Listener Startup

Startup procedure of a Listener is as follows:

1. su - <Oracle user>

2. lsnrctl start <ListenerName>

3. Makes sure that a Listener process does exist.

Listener Shutdown

Shutdown procedure of a Listener is as follows:

1. su - <Oracle user>

2. lsnrctl stop <ListenerName>

3. Makes sure that a Listener process does not exist.

4. If Listener is not stopped at step "3", shut it down forcibly by sending SIGKILL to the background process.

ASM instance Startup

Startup procedure of an ASM instance is as follows:

1. su - <Oracle DBA user>

2. sqlplus / nolog

3. connect / as sysasm

4. 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:

  1. su - <Oracle DBA user>

  2. sqlplus / nolog

  3. connect / as sysasm

  4. shutdown <immediate / abort / transactional> (Setup with StopModeStop)
     Default : immediate

  5. If ASM is not stopped at step "4" (except for abort), use shutdown abort.

  6. 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:

  1. su - <Oracle DBA user>

  2. sqlplus / nolog

  3. connect / as sysasm

  4. shutdown <immediate / abort> (Setup with StopModeFail)
     Default : abort

  5. If ASM is not stopped at step "4" (except for abort), use shutdown abort.

  6. If ASM is not stopped at step "4" or "5", shut it down forcibly by sending SIGKILL to the background processes.