Convert RAC 19c administrator managed to policy manager

This article explains the steps to convert Oracle database 19c RAC 2 nodes administrator managed to policy manager,

Steps:

• Check Configuration of the database
• Create a Policy pool of two nodes
• Convert the Administrator Managed to Policy Manager
• Start database

What we have:

Oracle Database RAC 19.9 (Two nodes) on Oracle Linux 8u2.

Steps:

Step 1: Check Configuration of the databas

$ srvctl config database -db orcl
 Database unique name: orcl
 Database name: orcl
 Oracle home: /u01/app/oracle/product/19c/dbhome_1
 Oracle user: oracle
 Spfile: +DATA/ORCL/PARAMETERFILE/spfile.272.1077272417
 Password file: +DATA/ORCL/PASSWORD/pwdorcl.256.1077270987
 Domain: 
 Start options: open
 Stop options: immediate
 Database role: PRIMARY
 Management policy: AUTOMATIC
 Server pools: 
 Disk Groups: FRA,DATA
 Mount point paths: 
 Services: orcl_srv
 Type: RAC
 Start concurrency: 
 Stop concurrency: 
 OSDBA group: dba
 OSOPER group: oper
 Database instances: orcl1,orcl2
 Configured nodes: host01,host02
 CSS critical: no
 CPU count: 0
 Memory target: 0
 Maximum memory: 0
 Default network number for database services: 
 Database is administrator managed

Step 2: Create a Policy pool of two node

$ srvctl add srvpool -serverpool pool_orcl  -min 2 -max 2 -servers host01,host02
$ srvctl config srvpool -serverpool pool_orcl
 Server pool name: pool_orcl
 Importance: 0, Min: 2, Max: 2
 Category: 
 Candidate server names: host01,host02

Step 3: Convert the Administrator Managed to Policy Manager

$ srvctl modify database -db orcl -serverpool  pool_orcl
$ srvctl config database -db orcl
 Database unique name: orcl
 Database name: orcl
 Oracle home: /u01/app/oracle/product/19c/dbhome_1
 Oracle user: oracle
 Spfile: +DATA/ORCL/PARAMETERFILE/spfile.272.1077272417
 Password file: +DATA/ORCL/PASSWORD/pwdorcl.256.1077270987
 Domain: 
 Start options: open
 Stop options: immediate
 Database role: PRIMARY
 Management policy: AUTOMATIC
 Server pools: pool_orcl
 Disk Groups: FRA,DATA
 Mount point paths: 
 Services: orcl_srv
 Type: RAC
 Start concurrency: 
 Stop concurrency: 
 OSDBA group: dba
 OSOPER group: oper
 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

Step 4: Start database

$ srvctl start database -db orcl
$ srvctl status database -db orcl
 Instance orcl_1 is running on node host02
 Instance orcl_2 is running on node host01

Enjoy 😉