PRIMECLUSTER Wizard for Oracle 4.3 Configuration and Administration Guide

3.2.1 Oracle Setting Change

You can change Oracle settings such as initialization parameters and data files using the procedures described below.

Note

Oracle must be stopped depending on the settings. For details, see the Oracle manual.

3.2.1.1 Oracle must be stopped

If Oracle must be stopped, change the settings as follows:

1. Maintenance mode / Monitoring disruption

   # hvutil -m on <userApplication> (Maintenance mode)
   # hvoradisable -a <userApplication> (Monitoring disruption)

2. Confirmation of maintenance mode and stop of monitoring

   Confirm that changing into maintenance mode and stop of monitoring have been successfully done.
   (Refer to note of "4.1 hvoradisable - Discontinue Monitoring Resources".)

3. Oracle stop

   # su - <Oracle user>
   $ sqlplus /nolog
   SQL> connect / as sysdba
   SQL> shutdown immediate

4. Setup change

   Change Oracle settings such as initialization parameters and path of data files.

5. Oracle startup

   # su - <Oracle use>
   $ sqlplus /nolog
   SQL> connect / as sysdba
   SQL> startup

6. Monitoring restart / Maintenance mode stop

   # hvoraenable -a <userApplication> (Monitoring restart)
   # hvutil -m off <userApplication> (Maintenance mode stop)

7. Confirmation of restart of monitoring and maintenance mode

   Confirm that restart of monitoring and changing out of maintenance mode has been successfully done.
   (Refer to note of "4.2 hvoraenable - Restart Monitoring Resources".)