Oracle RAC : Rolling Instance shutdown – No Downtime

Changes the Oracle RAC static Initialization parameter without down the database service completely

Node-1
========
-bash-4.1$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Mon Apr 13 19:13:34 2015
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> select * from gv$instance;

   INST_ID INSTANCE_NUMBER INSTANCE_NAME  HOST_NAME VERSION           STARTUP_T STATUS       PAR    THREAD# ARCHIVE LOG_SWITCH_WAIT LOGINS     SHU DATABASE_STATUS   INSTANCE_ROLE      ACTIVE_ST BLO
---------- --- ----------------- ------------------ --------- ---
         1               1 orcldb1         ecnode2   11.2.0.3.0        13-APR-15 OPEN         YES          1 STOPPED ALLOWED    NO  ACTIVE            PRIMARY_INSTANCE   NORMAL    NO
         2               2 orcldb2         ecnode3   11.2.0.3.0        13-APR-15 OPEN         YES          2 STOPPED ALLOWED    NO  ACTIVE            PRIMARY_INSTANCE   NORMAL    NO


SQL> show parameter spfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      +DATA/orcldb/spfileorcldb.ora
SQL>
SQL> show parameter processes

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
processes                            integer     1601
SQL>
SQL> alter system set processes=1600 scope=spfile sid='*';

System altered.

SQL> quit
-bash-4.1$
-bash-4.1$ srvctl stop instance -d orcldb -i orcldb1
-bash-4.1$ srvctl start instance -d orcldb -i orcldb1
-bash-4.1$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Apr 13 19:16:21 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> show parameter processes

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
processes                            integer     1600
SQL>
SQL> show parameter processes

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
processes                            integer     1600
SQL> quit
-bash-4.1$ sqlplus netvertex64622/netvertex64622@orcldb
SQL*Plus: Release 11.2.0.3.0 Production on Mon Apr 13 19:18:14 2015
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> quit
Node-2

-bash-4.1$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Mon Apr 13 19:16:31 2015
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> show parameter processes

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
processes                            integer     1601
SQL>
SQL> quit
-bash-4.1$
-bash-4.1$ srvctl stop instance -d orcldb -i orcldb2
-bash-4.1$ srvctl start instance -d orcldb -i orcldb2
-bash-4.1$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Mon Apr 13 19:17:51 2015
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> show parameter processes

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
processes                            integer     1600
SQL>
SQL> quit
-bash-4.1$ sqlplus netvertex64622/netvertex64622@orcldb
SQL*Plus: Release 11.2.0.3.0 Production on Mon Apr 13 19:18:00 2015
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> quit
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s