Question

Difference between admin managed and policy managed databases

Answer 1

Before discussing the ADMIN and POLICY managed db, we will have a short description of the server pools.

Server pool : Server pool divides the cluster logically. Server pool is used basically when the cluster/db is being POLICY managed. The db is assigned to the server pool and oracle takes the control to manage the instances. Oracle decides which instance to run on which node. There is no hard coded rule to run the instance on a perticular node as in administrator managed databases.

Types of Server pool : By default oracle creates two server pools, i.e, Free and Generic Pool. These pools are internally managed and has limitations of changing the attributes.