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 😉

Bookmark the permalink.
Loading Facebook Comments ...

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.