Table of Contents
Check Database and Pool Status
Check RAC database status [grid@ractw21 ~]$ srvctl config database -d ractw Database unique name: ractw Database name: ractw Oracle home: /u01/app/oracle/product/122/ractw2 Oracle user: oracle Spfile: +DATA/RACTW/PARAMETERFILE/spfile.325.941894301 Password file: +DATA/RACTW/PASSWORD/pwdractw.284.941893247 Domain: example.com Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: Disk Groups: DATA Mount point paths: Services: Type: RAC Start concurrency: Stop concurrency: OSDBA group: dba OSOPER group: Database instances: ractw1,ractw2 Configured nodes: ractw21,ractw22 CSS critical: no CPU count: 0 Memory target: 0 Maximum memory: 0 Default network number for database services: Database is administrator managed Check pool status [oracle@ractw21 ~]$ srvctl status srvpool -a Server pool name: Free Active servers count: 0 Active server names: Server pool name: Generic Active servers count: 2 Active server names: ractw21,ractw22 NAME=ractw21 STATE=ONLINE NAME=ractw22 STATE=ONLINE
Convert Database to Policy Managed
Stop database,add RAC database to pool and finally check pool status [grid@ractw21 grid]$ srvctl stop database -d ractw [grid@ractw21 grid]$ srvctl add srvpool -g TopPriority -l 1 -u 2 -i 5 [grid@ractw21 grid]$ srvctl modify database -d ractw -g TopPriority PRCD-1130 : Failed to convert administrator-managed database ractw into a policy-managed database to use server pool TopPriority PRCR-1071 : Failed to register or update resource ora.ractw.db CRS-0245: User doesn't have enough privilege to perform the operation Run as user Oracle : [oracle@ractw21 ~]$ srvctl modify database -d ractw -g TopPriority [grid@ractw21 grid]$ srvctl config srvpool -g TopPriority Server pool name: TopPriority Importance: 5, Min: 1, Max: 2 Category: hub Candidate server names: [grid@ractw21 grid]$ srvctl config database -d ractw Database unique name: ractw Database name: ractw Oracle home: /u01/app/oracle/product/122/ractw2 Oracle user: oracle Spfile: +DATA/RACTW/PARAMETERFILE/spfile.325.941894301 Password file: +DATA/RACTW/PASSWORD/pwdractw.284.941893247 Domain: example.com Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: TopPriority Disk Groups: DATA Mount point paths: Services: Type: RAC Start concurrency: Stop concurrency: OSDBA group: dba OSOPER group: Database instances: Configured nodes: CSS critical: no CPU count: 0 Memory target: 0 Maximum memory: 0 Default network number for database services: Database is policy managed [oracle@ractw21 ~]$ srvctl start database -d ractw PRCR-1079 : Failed to start resource ora.ractw.db CRS-2643: The server pool(s) where resource 'ora.ractw.db' could run have no servers Remove category and add servers Trying to add servers [grid@ractw21 ~]$ srvctl modify srvpool -serverpool TopPriority -servers "ractw21,ractw22" -verbose [grid@ractw21 ~]$ srvctl config srvpool -serverpool TopPriority Server pool name: TopPriority Importance: 5, Min: 1, Max: 2 Category: Candidate server names: ractw21,ractw22 [grid@ractw21 ~]$ srvctl status srvpool -a Server pool name: Free Active servers count: 0 Active server names: Server pool name: Generic Active servers count: 2 Active server names: ractw21,ractw22 NAME=ractw21 STATE=ONLINE NAME=ractw22 STATE=ONLINE Server pool name: TopPriority Active servers count: 0 Active server names: Both severs ractw21,ractw22 still assigned to GENERIC pool ! Removing our admin managed test database ! [oracle@ractw21 ~]$ srvctl remove database -db test Remove the database test? (y/[n]) y
Verify Database Status and Pool Status after changes
Now verify pool [grid@ractw21 ~]$ 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: TopPriority Active servers count: 2 Active server names: ractw21,ractw22 NAME=ractw21 STATE=ONLINE NAME=ractw22 STATE=ONLINE --> Now both servers are assigned to our TopPriority pool Starting ractw database and confirm cluster resource status [oracle@ractw21 dbs]$ srvctl start database -db ractw ***** Cluster Resources: ***** Resource NAME INST TARGET STATE SERVER STATE_DETAILS --------------------------- ---- ------------ ------------ --------------- ----------------------------------------- ora.ractw.db 1 ONLINE ONLINE ractw21 Open,HOME=/u01/app/oracle/product/122/ractw2,STABLE ora.ractw.db 2 ONLINE ONLINE ractw22 Open,HOME=/u01/app/oracle/product/122/ractw2,STABLE