Converting an Administrator-Managed Database to a Policy-Managed Database

In this article, We can convert Administrator managed database to Policy managed database :

First of all, let’s check the configuration of the database :

[oracle@rac1 ~]$ srvctl config database -d demo
Database unique name: demo
Database name: demo
Oracle home: /appndb/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/demo/spfiledemo.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: demo
Database instances: demo1,demo2
Disk Groups: DATA
Mount point paths:
Services:
Type: RAC
Database is administrator managed

In above output, we can see the last line shows us my demo database is an administrator-managed database.

Now next we need to create a server pool.

[oracle@rac1 ~]$ srvctl add srvpool -g mypool -l 0 -u 2 -i 1

In the above command, 0[-l] is the minimum number of servers you want in the server pool and 2[-u] is the maximum.

Now stop the database using srvctl or enterprise managed :

[oracle@rac1 ~]$ srvctl stop database -d demo

Modify the database to be in the new server pool :

[oracle@rac1 ~]$ srvctl modify database -d demo -g mypool

Now see a configuration of a database using the following command :

[oracle@rac1 bin]$ srvctl config database -d demo
Database unique name: demo
Database name: demo
Oracle home: /appndb/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/demo/spfiledemo.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: mypool
Database instances:
Disk Groups: DATA
Mount point paths:
Services:
Type: RAC
Database is policy managed
[oracle@rac1 bin]$

We can see here Database is converted to policy managed database.

Stay tuned for More articles on Oracle RAC 

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp