Friday, May 11, 2007

Stop All Processes in 10g

Stop All Processes

Stop all listeners and other processes running in the Oracle home directory, where you need to install the patch set.


Note:

If you shut down ASM instances, you must first shut down all database instances that use ASM, even if these databases run from different Oracle homes.

  • If you are upgrading a single instance installation, shut down the following Oracle Database 10g processes before installing the patch set:


    Note:

    You must perform these steps in the order listed.

    1. Shut down all processes in the Oracle home that might be accessing a database, for example Oracle Enterprise Manager Database Control or iSQL*Plus.


      Note:

      Before you shutdown all processes that are monitored by Enterprise Manager Grid Control, set a blackout in Grid Control for the processes that you intend to shut down. This is necessary so that the availability records for these processes indicate that the shutdown was planned downtime rather than an unplanned system outage.

    2. Shut down all database instances running in the Oracle home directory, where you need to install the patch set.

    3. Shut down the ASM instance, if the ASM instance is running in the Oracle home directory, where you need to install the patch set.

    4. Shut down all listeners running in the Oracle home directory, where you need to install the patch set.

    5. Shut down the Oracle Cluster Synchronization Services (CSS) daemon as the root user:

      # oracle_home/bin/crsctl stop crs

  • If you are upgrading an Oracle Clusterware installation, shut down the following Oracle Database 10g processes before installing the patch set:


    Note:

    You must perform these steps in the order listed.

    1. Shut down all processes in the Oracle home on each node that might be accessing a database, for example Oracle Enterprise Manager Database Control.


      Note:

      Before you shutdown all processes that are monitored by Enterprise Manager Grid Control, set a blackout in Grid Control for the processes that you intend to shut down. This is necessary so that the availability records for these processes indicate that the shutdown was planned downtime rather than an unplanned system outage.

    2. Shut down all RAC instances on all nodes. To shut down all RAC instances for a database, enter the following command where db_name is the name of the database:

      $ oracle_home/bin/srvctl stop database -d db_name -i inst_name

    3. Shut down all ASM instances on all nodes. To shut down an ASM instance, enter the following command where node is the name of the node where the ASM instance is running:

      $ oracle_home/bin/srvctl stop asm -n node

    4. Stop all node applications on all nodes. To stop node applications running on a node, enter the following command where node is the name of the node where the applications are running:

      $ oracle_home/bin/srvctl stop nodeapps -n node

    5. Shut down the Oracle Clusterware process by entering the following command on all nodes as the root user:

      # crs_home/bin/crsctl stop crs


      Note:

      In these examples, crs_home is the Oracle Clusterware home directory where the Oracle Clusterware 10g installation that you want to upgrade is installed.


      Note:

      If the Oracle Clusterware installation is not on a shared Oracle home you can upgrade the Oracle Clusterware installation one node at a time. To do this, perform the preceding steps only on the first node that you are upgrading, then follow the instructions on the installer screen.

  • If you are upgrading a RAC installation, shut down the following Oracle Database 10g processes before installing the patch set:


    Note:

    You must perform these steps in the order listed.

    1. Shut down all processes in the Oracle home on each node that might be accessing a database, for example Oracle Enterprise Manager Database Control.


      Note:

      Before you shutdown all processes that are monitored by Enterprise Manager Grid Control, set a blackout in Grid Control for the processes that you intend to shut down. This is necessary so that the availability records for these processes indicate that the shutdown was planned downtime rather than an unplanned system outage.

    2. Shut down all RAC instances on the nodes, which run from the Oracle home on which you are going to apply the patch set. To shut down all RAC instances for a database, enter the following command where db_name is the name of the database:

      $ oracle_home/bin/srvctl stop database -d db_name

    3. Shut down all ASM instances on all nodes. To shut down an ASM instance, enter the following command where node is the name of the node where the ASM instance is running:

      $ oracle_home/bin/srvctl stop asm -n node

    4. Stop any listeners that are running from the Oracle home that you are patching on all nodes. To stop the listener running on a node, enter the following command, where node is the name of the node where the listener is running:

      $ oracle_home/bin/srvctl stop listener -n node [-l listenername]