Table of Contents
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