Change Hidden Parameter in Oracle 11g RAC


bash-3.2$ ps -afe | grep smon
 oracle 19016 1 0 Jun 20 ? 6:50 asm_smon_+ASM1
 oracle 16578 1 0 Sep 15 ? 37:35 ora_smon_AZKKDB1
 root 5429 1 0 Oct 01 ? 29594:01 /u02/app/oracle/product/grid/db_1/bin/osysmond.bin
 oracle 3581 28381 0 00:17:51 pts/2 0:00 grep smon
bash-3.2$ 
bash-3.2$ 
bash-3.2$ sqll
SQL*Plus: Release 11.2.0.3.0 Production on Sun Dec 22 00:17:52 2013
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> set linesize 1000
SQL> set pagesize 100
SQL> 
SQL> 
SQL> select name,open_mode from gv$database;
NAME OPEN_MODE
--------- --------------------
AZKKDB READ WRITE
AZKKDB READ WRITE
SQL> alter system set "_ktb_debug_flags"=8 scope=both sid='*';
System altered.
SQL> exit
Disconnected from 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
bash-3.2$ srvctl stop database -d AZKKDB -o immediate
bash-3.2$ ps -afe | grep smon
 oracle 13212 28381 0 00:20:44 pts/2 0:00 grep smon
 oracle 19016 1 0 Jun 20 ? 6:50 asm_smon_+ASM1
 root 5429 1 0 Oct 01 ? 29595:25 /u02/app/oracle/product/grid/db_1/bin/osysmond.bin
bash-3.2$ 
bash-3.2$ 
bash-3.2$ srvctl start database -d AZKKDB
bash-3.2$ 
bash-3.2$ sqll
SQL*Plus: Release 11.2.0.3.0 Production on Sun Dec 22 00:21:50 2013
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> set linesize 1000
SQL> set pagesize 100
SQL> 
SQL> select name,open_mode from gv$database;
NAME OPEN_MODE
--------- --------------------
AZKKDB READ WRITE
AZKKDB READ WRITE
SQL>
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

%d bloggers like this: