Converting 11gR2 & quot; Administrator & quot; managed database to & quot; Policy & quot; managed and vice versa (Document ID 1486772.

Source: Internet
Author: User
Tags number sign

In this Document


Applies to: Oracle Server-Enterprise Edition-Version and later
Information in this document applies to any platform.

This document describes how to convert an administrator managed database to policy managed database and vice versa.


Converting an Administrator managed database to a Policy managed Database

1. Check the current configuration of all services and the database

Srvctl config database-d db_unique_name
Srvctl config service-d db_unique_name

Before converting the instance name shows:

$ Ps-eaf | grep pmon | grep orcl
Oracle 16450 1 0 Aug31? 00:00:02 Ora_pmon_orcl1

2. Create a server pool for the policy-managed database (you must have GI Administrator privileges to do this), as follows:

Srvctl add srvpool-g server_pool-l 0-u n (In the preceding command, n is the number of servers you want in the server pool .)

3. Modify the database to be in the new server pool, as follows:

Srvctl modify database-d db_unique_name-g server_pool

4. After restart, check the status of the database to confirm that it is now policy managed by repeating the commands in step 1.

After converting the instance name show:

$ Ps-eaf | grep pmon | grep orcl
Oracle 14462 1 0? 00:00:00 Ora_pmon_orcl_1

After convering the database to policy-managed, instance name will be db_unique_name _ # (notice the additional underscore (_) before the number sign (#) character ).

Converting Policy managed databases to administrtor managed Database

You cannot directly convert a policy-managed database to an administrator-managed database. Instead, you need to remove the policy-managed configuration and then register the same database as an administrator managed databases.

1. Remove the database and services

Srvctl remove database-d <dbname>
Srvctl remove service-d <dbname>-s <service name>

2. Register the same database as an administrator-managed databases

Srvctl add database-d <dbname>-o <RDBMS_HOME>
Srvctl add instance-d <dbname>-I <instance_name>-n <nodename>
Srvctl add service-d <db_unique_name>-s <service_name>-u-r <new_pref_inst> |-a <new_avail_inst>

Referenceshttp: //
NOTE: 1481647.1-11gR2 Database Services for "Policy" and "Administrator" Managed Databases
NOTE: 1484800.1-Can pre 11.2 databases coexist with 11gR2 DB policy managed databases in GI (Grid Infrastructure )?
NOTE: 1473998.1-11gR2 DBCA Instance Management Option Greyed Out for Policy Managed Database

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.