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