Thursday, January 21, 2016

Start and Stop an Instance in RAC environment

This is a simple example on how to start and stop and Instance in RAC environment.

----------------------------------------------------------------
STOP AN INSTANCE IN RAC ENVIRONMENT :
----------------------------------------------------------------
CMD TO STOP INSTANCE:

srvctl stop instance -d ORCLRAC -i RAC212

Description:

-d crm  : HERE -d IS TO PASS DATABASE AND CRM IS THE DB_UNIQUE_NAME
-i crm1 : HERE -i IS TO PASS INSTANCE AND CRM1 IS THE INSTANCE_NAME

EXAMPLE :

oracle@RAC212:[~] $ echo $ORACLE_SID
ORCLRAC2

LET US FIRST CHECK IF THE INSTANCE IS RUNNING ::

oracle@RAC212:[~] $ ps -ef |grep pmon
oracle   13020     1  0 09:59 ?        00:00:00 ora_pmon_ORCLRAC2
grid     28699     1  0 Jan18 ?        00:00:22 asm_pmon_+ASM2
oracle   41095 21699  0 11:45 pts/0    00:00:00 grep pmon

STOP INSTANCE FROM RAC :

oracle@RAC212:[~] $ srvctl stop instance -d ORCLRAC -i ORCLRAC2
oracle@RAC212:[~] $
--------------------------------------------------------------------------------------------------------------------------------

NOW FROM NODE 1 LETS VERIFY:

oracle@RAC211:[~] $ sqlplus atoorpu@ORCLRAC

SQL*Plus: Release 11.2.0.4.0 Production on Wed Jan 20 11:46:30 2016

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

Enter password:

Connected to:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
ORCLRAC1

SQL> select instance_name from gv$instance;

INSTANCE_NAME
----------------
ORCLRAC1

oracle@RAC212:[~] $ ps -ef |grep pmon
grid     28699     1  0 Jan18 ?        00:00:22 asm_pmon_+ASM2
oracle   41618 21699  0 11:47 pts/0    00:00:00 grep pmon

----------------------------------------------------------------
YOU CAN ALSO CONFIRM LIKE THIS :
----------------------------------------------------------------

oracle@RAC212:[~] $ echo $ORACLE_SID
ORCLRAC2

oracle@RAC212:[~] $ sqlplus /"As sysdba"

SQL*Plus: Release 11.2.0.4.0 Production on Wed Jan 20 12:39:30 2016

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

Connected to an idle instance.

----------------------------------------------------------------
START AN INSTANCE IN RAC ENVIRONMENT :
----------------------------------------------------------------

oracle@RAC212:[~] $ ps -ef |grep pmon
grid     28699     1  0 Jan18 ?        00:00:23 asm_pmon_+ASM2
oracle   53731 21699  0 12:42 pts/0    00:00:00 grep pmon

oracle@RAC212:[~] $ srvctl start instance -d ORCLRAC -i ORCLRAC2

oracle@RAC212:[~] $ ps -ef |grep pmon
grid     28699     1  0 Jan18 ?        00:00:23 asm_pmon_+ASM2
oracle   53851     1  0 12:42 ?        00:00:00 ora_pmon_ORCLRAC2
oracle   54051 21699  0 12:43 pts/0    00:00:00 grep pmon

No comments:

Post a Comment