Ferhat's Blog

There will be only one database

Playing with policy managed databases

Posted by fsengonul on March 17, 2011

It was a great idea to try quality of service in 11gR2. But unfortunately at the moment it only supports OLTP workload.(average response time of less than one second, and preferably, an average response time of less than 0.5 seconds) and it does not support parallel queries.

Even though I can’t use them at the moment, I can still gain something from the server pool architecture.
I can move nodes from one database to another.
Below you may find my first tries.


oracle@node01:/home/oracle>srvctl status srvpool -g POOL1B

Server pool name: POOL1B
Active servers count: 1
oracle@node01:/home/oracle>srvctl status srvpool -g POOL1B -a
Server pool name: POOL1B
Active servers count: 1
Active server names: node14
NAME=node14 STATE=ONLINE
oracle@node01:/home/oracle>srvctl config database -d XDB
Database unique name: XDB
Database name: XDB
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/XDB/spfileXDB.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: POOL1B
Database instances:
Disk Groups: DATA
Mount point paths:
Services:
Type: RAC
Database is policy managed
oracle@node01:/home/oracle>srvctl status srvpool -g POOL1B -a
Server pool name: POOL1B
Active servers count: 1
Active server names: node14
NAME=node14 STATE=ONLINE
oracle@node01:/home/oracle>srvctl start database -d XDB
oracle@node01:/home/oracle>srvctl status database -d XDB
Instance XDB_1 is running on node node14
oracle@node01:/home/oracle>srvctl modify srvpool -g POOL1B -n "node14,node15"
oracle@node01:/home/oracle>srvctl status srvpool -g POOL1B -a
Server pool name: POOL1B
Active servers count: 2
Active server names: node14,node15
NAME=node14 STATE=ONLINE
NAME=node15 STATE=ONLINE
oracle@node01:/home/oracle>srvctl status database -d XDB
Instance XDB_1 is running on node node14
Instance XDB_4 is running on node node15
oracle@node01:/home/oracle>srvctl modify srvpool -g POOL1B -n "node14"
PRCS-1011 : Failed to modify server pool POOL1B
CRS-2736: The operation requires stopping resource 'ora.XDB.db' on server 'node15'
CRS-2738: Unable to modify server pool 'ora.POOL1B' as this will affect running resources, but the force option was not specified
oracle@node01:/home/oracle>srvctl stop instance -d XDB -n node15
oracle@node01:/home/oracle>srvctl status database -d XDB
Instance XDB_1 is running on node node14
Instance XDB_4 is not running on node node15
oracle@node01:/home/oracle>srvctl modify srvpool -g POOL1B -n "node14"
oracle@node01:/home/oracle>srvctl status database -d XDB
Instance XDB_1 is running on node node14
oracle@node01:/home/oracle>

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: