RAC - Convert an Admin Managed RAC Database to Policy Managed for 11gR2 database

Convert an Admin Managed RAC Database to Policy Managed for 11gR2 database

Check the current pool status

[oracle@o1 dbs]$ srvctl config database -d RAC

Database unique name: RAC

Database name: RAC

Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1

Oracle user: oracle

Spfile: +DATA/RAC/spfileRAC.ora

Domain: localdomain

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: RAC

Database instances: RAC1,RAC2

Disk Groups: DATA

Mount point paths:

Services:

Type: RAC

Database is administrator managed

Check the status of server pool.

[oracle@o1 dbs]$ 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: o1,o2

NAME=o1 STATE=ONLINE

NAME=o2 STATE=ONLINE

Stop database -

[oracle@o1 dbs]$ srvctl stop database -d RAC

Create a server pool for the policy managed database.

[oracle@o1 dbs]$ srvctl add srvpool -g SrvPool1 -l 1 -u 2

-l refers to Minimum size of the server pool

-u refers to Maximum suze if the server pool

Modify the admin database to the new server pool

[oracle@o1 dbs]$ srvctl modify database -d RAC -g SrvPool1

Verify the status of the server pool

[oracle@o1 dbs]$ 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: 2

Active server names: o1,o2

NAME=o1 STATE=ONLINE

NAME=o2 STATE=ONLINE

Verify the status of the database to confirm the conversion to a policy managed database

[oracle@o1 dbs]$ srvctl config database -d RAC

Database unique name: RAC

Database name: RAC

Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1

Oracle user: oracle

Spfile: +DATA/RAC/spfileRAC.ora

Domain: localdomain

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: SrvPool1

Database instances:

Disk Groups: DATA

Mount point paths:

Services:

Type: RAC

Database is policy managed