{"id":8040,"date":"2019-01-17T10:29:34","date_gmt":"2019-01-17T10:29:34","guid":{"rendered":"https:\/\/dbtut.com\/?p=8040"},"modified":"2019-01-17T10:29:34","modified_gmt":"2019-01-17T10:29:34","slug":"how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/","title":{"rendered":"How to Convert Administrator-Managed Database to Policy-Managed Database in Oracle"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>Cluster database configuration can be Policy-Managed or Administrator-Managed. A Policy-Managed database has managed instances on the basis of server pools for the effective use of resources. An Admin-Managed database has instances connected to specific servers.<\/p>\n<p>The following figure shows the differences in behavior.<\/p>\n<p id=\"lGfiyyr\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-8041  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c405630c0854.png\" alt=\"\" width=\"607\" height=\"205\" \/><\/p>\n<h3>Some benefits of the Policy-Managed configuration:<\/h3>\n<ul>\n<li>Provides distribution according to demand.<\/li>\n<li>Manages business requirements effectively.<\/li>\n<li>Scales just in time.<\/li>\n<li>Maximizes data center efficiency.<\/li>\n<\/ul>\n<p>By default, there are two server pools, GENERIC and FREE. We can display existing pools as follows.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ srvctl config srvpool\r\nServer pool name: Free\r\nImportance: 0, Min: 0, Max: -1\r\nCandidate server names: \r\nServer pool name: Generic\r\nImportance: 0, Min: 0, Max: -1\r\nCandidate server names: oradb1,oradb2<\/pre>\n<h3>Features of server pools :<\/h3>\n<p><strong>\u00a0min : (-l)<\/strong><\/p>\n<p>The minimum number of servers that must be protected in the server pool.<\/p>\n<p><strong>max : (-u)<\/strong><\/p>\n<p>Maximum number of servers allowed in server pool.<\/p>\n<p><strong>imp : (-i)<\/strong><\/p>\n<p>The server pool with an imp value is filled to the Min values first. imp determines the order of precedence.<\/p>\n<p>By following these steps, you can convert a database that is created as Admin-Managed to a Policy-Managed database.<\/p>\n<p>First, let&#8217;s look at our current configuration.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ srvctl config database -d TESTDB\r\nDatabase unique name: TESTDB\r\nDatabase name: TESTDB\r\nOracle home: \/u01\/app\/oracle\/product\/11.2.0\/dbhome_1\r\nOracle user: oracle\r\nSpfile: +DATA\/TESTDB\/spfileTESTDB.ora\r\nDomain: \r\nStart options: open\r\nStop options: immediate\r\nDatabase role: PRIMARY\r\nManagement policy: AUTOMATIC\r\nServer pools: TESTDB\r\nDatabase instances: TESTDB1,TESTDB2\r\nDisk Groups: DATA,RECO\r\nMount point paths: \r\nServices: \r\nType: RAC\r\nDatabase is administrator managed<\/pre>\n<p>Let&#8217;s create a new pool. The min and max values for the new pool are set to 2.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ srvctl add serverpool -g testpool -l 2 -u 2<\/pre>\n<p>When we view existing pools, the pool we just created is visible.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ srvctl config srvpool\r\nServer pool name: Free\r\nImportance: 0, Min: 0, Max: -1\r\nCandidate server names: \r\nServer pool name: Generic\r\nImportance: 0, Min: 0, Max: -1\r\nCandidate server names: oradb1,oradb2\r\nServer pool name: testpool\r\nImportance: 0, Min: 2, Max: 2\r\nCandidate server names:<\/pre>\n<p>Now, we can convert our database.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ srvctl modify database -d TESTDB -g testpool<\/pre>\n<p>The database configuration will now appear as policy managed.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ srvctl config database -d TESTDB\r\nDatabase unique name: TESTDB\r\nDatabase name: TESTDB\r\nOracle home: \/u01\/app\/oracle\/product\/11.2.0\/dbhome_1\r\nOracle user: oracle\r\nSpfile: +DATA\/TESTDB\/spfileTESTDB.ora\r\nDomain: \r\nStart options: open\r\nStop options: immediate\r\nDatabase role: PRIMARY\r\nManagement policy: AUTOMATIC\r\nServer pools: testpool\r\nDatabase instances: \r\nDisk Groups: DATA,RECO\r\nMount point paths: \r\nServices: \r\nType: RAC\r\nDatabase is policy managed<\/pre>\n<p>Now our database is policy managed. Our database will run when there is an appropriate server for the testpool we created above. We can check the status of the server repositories as follows.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ srvctl status serverpool\r\nServer pool name: Free\r\nActive servers count: 0\r\nServer pool name: Generic\r\nActive servers count: 0\r\nServer pool name: testpool\r\nActive servers count: 2<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_8040\" class=\"pvc_stats all  \" data-element-id=\"8040\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Cluster database configuration can be Policy-Managed or Administrator-Managed. A Policy-Managed database has managed instances on the basis of server pools for the effective use of resources. An Admin-Managed database has instances connected to specific servers. The following figure shows the differences in behavior. Some benefits of the Policy-Managed configuration: Provides distribution according to demand. &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_8040\" class=\"pvc_stats all  \" data-element-id=\"8040\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[1680,1682,1681],"class_list":["post-8040","post","type-post","status-publish","format-standard","","category-oracle","tag-administrator-managed-database","tag-convert-administrator-managed-database-to-policy-managed-database","tag-policy-managed-database"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":476,"today_views":1},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Convert Administrator-Managed Database to Policy-Managed Database in Oracle - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How to Convert Administrator-Managed Databases to Policy-Managed Databases in Oracle\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Convert Administrator-Managed Database to Policy-Managed Database in Oracle - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How to Convert Administrator-Managed Databases to Policy-Managed Databases in Oracle\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-17T10:29:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c405630c0854.png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How to Convert Administrator-Managed Database to Policy-Managed Database in Oracle\",\"datePublished\":\"2019-01-17T10:29:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/\"},\"wordCount\":250,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c405630c0854.png\",\"keywords\":[\"Administrator-Managed Database\",\"Convert Administrator-Managed Database to Policy-Managed Database\",\"Policy-Managed Database\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/\",\"name\":\"How to Convert Administrator-Managed Database to Policy-Managed Database in Oracle - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c405630c0854.png\",\"datePublished\":\"2019-01-17T10:29:34+00:00\",\"description\":\"How to Convert Administrator-Managed Databases to Policy-Managed Databases in Oracle\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c405630c0854.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c405630c0854.png\",\"width\":708,\"height\":239},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Convert Administrator-Managed Database to Policy-Managed Database in Oracle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Convert Administrator-Managed Database to Policy-Managed Database in Oracle - Database Tutorials","description":"How to Convert Administrator-Managed Databases to Policy-Managed Databases in Oracle","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/","og_locale":"en_US","og_type":"article","og_title":"How to Convert Administrator-Managed Database to Policy-Managed Database in Oracle - Database Tutorials","og_description":"How to Convert Administrator-Managed Databases to Policy-Managed Databases in Oracle","og_url":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/","og_site_name":"Database Tutorials","article_published_time":"2019-01-17T10:29:34+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c405630c0854.png","type":"","width":"","height":""}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How to Convert Administrator-Managed Database to Policy-Managed Database in Oracle","datePublished":"2019-01-17T10:29:34+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/"},"wordCount":250,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c405630c0854.png","keywords":["Administrator-Managed Database","Convert Administrator-Managed Database to Policy-Managed Database","Policy-Managed Database"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/","url":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/","name":"How to Convert Administrator-Managed Database to Policy-Managed Database in Oracle - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c405630c0854.png","datePublished":"2019-01-17T10:29:34+00:00","description":"How to Convert Administrator-Managed Databases to Policy-Managed Databases in Oracle","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c405630c0854.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c405630c0854.png","width":708,"height":239},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/how-to-convert-administrator-managed-database-to-policy-managed-database-in-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How to Convert Administrator-Managed Database to Policy-Managed Database in Oracle"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/8040","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=8040"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/8040\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=8040"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=8040"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=8040"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}