Managing Server Pools

Managing Serverpools

Change maximum and minimum numbers of a server pool
$ srvctl status database -d GRACE2
Instance GRACE2_3 is running on node grac2
Instance GRACE2_2 is running on node grac3

$ srvctl status srvpool -a
Server pool name: Free
Active servers count: 1
Active server names: grac1
NAME=grac1 STATE=ONLINE
Server pool name: Generic
Active servers count: 0
Active server names: 
Server pool name: SrvPool1
Active servers count: 2
Active server names: grac2,grac3
NAME=grac2 STATE=ONLINE
NAME=grac3 STATE=ONLINE

Modify both minumun ( -l ) and maximiun ( -u ) server pool attribute
$ srvctl modify srvpool -g SrvPool1 -l 2 -u 3
$ srvctl status database -d GRACE2
Instance GRACE2_1 is running on node grac1
Instance GRACE2_3 is running on node grac2
Instance GRACE2_2 is running on node grac3
[oracle@grac1 DRM]$  srvctl status srvpool -a
Server pool name: Free
Active servers count: 0
Active server names: 
Server pool name: Generic
Active servers count: 0
Active server names: 
Server pool name: SrvPool1
Active servers count: 3
Active server names: grac1,grac2,grac3
NAME=grac1 STATE=ONLINE
NAME=grac2 STATE=ONLINE
NAME=grac3 STATE=ONLINE

Use -f switch if you need to lower cardinality 
$ srvctl modify srvpool -g SrvPool1 -l 1 -u 2
PRCS-1011 : Failed to modify server pool SrvPool1
CRS-2736: The operation requires stopping resource 'ora.grace2.db' on server 'grac1'
CRS-2738: Unable to modify server pool 'ora.SrvPool1' as this will affect running resources, but the force option was not specified
$ srvctl modify srvpool -g SrvPool1 -l 1 -u 2 -f
$ srvctl status database -d GRACE2
Instance GRACE2_3 is running on node grac2
Instance GRACE2_2 is running on node grac3

Check Serverpool,Servers and Database status

$ srvctl status srvpool -detail
Server pool name: Free
Active servers count: 0
Active server names: 
Server pool name: Generic
Active servers count: 0
Active server names: 
Server pool name: STANDARD_PRIORITY
Active servers count: 1
Active server names: gract2
NAME=gract2 STATE=ONLINE
Server pool name: TOP_PRIORITY
Active servers count: 1
Active server names: gract1
NAME=gract1 STATE=ONLINE

$ srvctl config srvpool
Server pool name: Free
Importance: 0, Min: 0, Max: -1
Category: 
Candidate server names: 
Server pool name: Generic
Importance: 0, Min: 0, Max: -1
Category: 
Candidate server names: 
Server pool name: STANDARD_PRIORITY
Importance: 5, Min: 1, Max: 1
Category: hub
Candidate server names: 
Server pool name: TOP_PRIORITY
Importance: 10, Min: 1, Max: 3
Category: hub
Candidate server names: 

$ srvctl status server -servers gract1,gract2,gract3 -detail
Server active pools: ora.TOP_PRIORITY
Server name: gract1
Server state: ONLINE
Server state details: 
Server active pools: ora.STANDARD_PRIORITY
Server name: gract2
Server state: ONLINE
Server state details: 
PRCR-1001 : Resource gract3 does not exist
+ echo ''

$ srvctl status database -d dw -verbose
Instance dw_1 is not running on node gract2
Instance dw_2 is not running on node gract1
$ srvctl config database -d dw -verbose
Database unique name: dw
Database name: dw
Oracle home: /u01/app/oracle/product/121/racdb
Oracle user: oracle
Spfile: +DATA/dw/spfiledw.ora
Password file: +DATA/dw/orapwdw
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: STANDARD_PRIORITY,TOP_PRIORITY
Database instances: 
Disk Groups: DATA
Mount point paths: 
Services: 
Type: RAC
Start concurrency: 
Stop concurrency: 
Database is policy managed

$ srvctl status database -d erp -verbose
Instance ERP_1 is running on node gract1. Instance status: Open.
Instance ERP_2 is running on node gract2. Instance status: Open.
$ srvctl config database -d erp -verbose
Database unique name: ERP
Database name: ERP
Oracle home: /u01/app/oracle/product/121/racdb
Oracle user: oracle
Spfile: +DATA/ERP/spfileERP.ora
Password file: +DATA/ERP/orapwerp
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: STANDARD_PRIORITY,TOP_PRIORITY
Database instances: 
Disk Groups: 
Mount point paths: 
Services: 
Type: RAC
Start concurrency: 
Stop concurrency: 
Database is policy managed

Leave a Reply

Your email address will not be published. Required fields are marked *