{"id":7427,"date":"2016-03-20T21:14:53","date_gmt":"2016-03-20T20:14:53","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/rac-to-ron-then-ron-to-rac-and-singleton-service\/"},"modified":"2016-03-20T21:14:53","modified_gmt":"2016-03-20T20:14:53","slug":"rac-to-ron-then-ron-to-rac-and-singleton-service","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/rac-to-ron-then-ron-to-rac-and-singleton-service\/","title":{"rendered":"RAC to RON then RON to RAC and singleton service"},"content":{"rendered":"

By Franck Pachot<\/h2>\n

.
\nYou will probably never do it, but let’s imagine you have a RAC database, policy managed, with singleton service. Then you convert it to RAC One Node and you change your mind and convert it back to RAC. Be careful, the singleton services are converted to uniform ones when converting to RAC
\n
\nMy RACDB database is running on two nodes:<\/p>\n

[oracle@racp1vm1 ~]$ srvctl status database -db racdb\nInstance RACDB_1 is running on node racp1vm1\nInstance RACDB_2 is running on node racp1vm2<\/code><\/pre>\n
it is policy managed and in a server pool of two servers:<\/p>\n
\n[oracle@racp1vm1 ~]$ srvctl config database -db racdb | grep pool\nServer pools: pool1\n[oracle@racp1vm1 ~]$ srvctl status srvpool -serverpool pool1\nServer pool name: pool1\nActive servers count: 2\n<\/code><\/pre>\n
I’m in RAC and have the singleton service ‘S’ running on first node<\/p>\n
\n[oracle@racp1vm1 ~]$ srvctl config service -db racdb -service S\nService name: s\nServer pool: pool1\nCardinality: UNIFORM\nDisconnect: false\nService role: PRIMARY\nManagement policy: AUTOMATIC\n...\n<\/code><\/pre>\n
I want to go to RAC One Node so I need to have only one instance running<\/p>\n
\n[oracle@racp1vm1 ~]$ srvctl stop instance -db racdb -instance RACDB_2 -f\n<\/code><\/pre>\n
and then convert<\/p>\n
\n[oracle@racp1vm1 ~]$ srvctl convert database -db racdb -dbtype RACONENODE\n<\/code><\/pre>\n
Then I check the service:<\/p>\n
\n[oracle@racp1vm1 ~]$ srvctl status service -db racdb -service s\nService s is running on nodes: racp1vm1\n<\/code><\/pre>\n
still running on one node of course, and still defined as SINGLETON<\/p>\n
\n[oracle@racp1vm1 ~]$ srvctl  config service -db racdb -service s\nService name: s\nServer pool: pool1\nCardinality: SINGLETON\nDisconnect: false\nService role: PRIMARY\nManagement policy: AUTOMATIC\n<\/code><\/pre>\n
Let’s now convert back to RAC<\/p>\n
\n[oracle@racp1vm1 ~]$ srvctl convert database -db racdb -dbtype RAC\n<\/code><\/pre>\n
and check the service:<\/p>\n
\n[oracle@racp1vm1 ~]$ srvctl status service -db racdb -service s\nService s is running on nodes: racp1vm1,racp1vm2\n<\/code><\/pre>\n
Ouch. My service that was a singleton is now running on all nodes.<\/p>\n
\n[oracle@racp1vm1 ~]$ srvctl config service -db racdb -service s\nService name: s\nServer pool: pool1\nCardinality: UNIFORM\nDisconnect: false\nService role: PRIMARY\nManagement policy: AUTOMATIC\n<\/code><\/pre>\n
It seems that the conversion from RAC One Node to RAC has modified all service cardinality to be UNIFORM.<\/p>\n
You have to set it back to SINGLETON:<\/p>\n
\n[oracle@racp1vm1 ~]$ srvctl modify service -db racdb -cardinality singleton -service s -f\n<\/code><\/pre>\n
Be careful with that.
\nA service for which the application has not be designed to be load balanced across several nodes may have horrible performance. It’s always a good idea to check the service config and where they are running.<\/p>\n","protected":false},"excerpt":{"rendered":"
By Franck Pachot . You will probably never do it, but let’s imagine you have a RAC database, policy managed, with singleton service. Then you convert it to RAC One Node and you change your mind and convert it back to RAC. Be careful, the singleton services are converted to uniform ones when converting to […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[96,788,535],"type_dbi":[],"class_list":["post-7427","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-oracle","tag-policy-managed","tag-rac"],"acf":[],"yoast_head":"\nRAC to RON then RON to RAC and singleton service - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/rac-to-ron-then-ron-to-rac-and-singleton-service\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"RAC to RON then RON to RAC and singleton service\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . You will probably never do it, but let’s imagine you have a RAC database, policy managed, with singleton service. Then you convert it to RAC One Node and you change your mind and convert it back to RAC. Be careful, the singleton services are converted to uniform ones when converting to […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/rac-to-ron-then-ron-to-rac-and-singleton-service\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-03-20T20:14:53+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\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:\\\/\\\/www.dbi-services.com\\\/blog\\\/rac-to-ron-then-ron-to-rac-and-singleton-service\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/rac-to-ron-then-ron-to-rac-and-singleton-service\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"RAC to RON then RON to RAC and singleton service\",\"datePublished\":\"2016-03-20T20:14:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/rac-to-ron-then-ron-to-rac-and-singleton-service\\\/\"},\"wordCount\":229,\"commentCount\":0,\"keywords\":[\"Oracle\",\"Policy Managed\",\"RAC\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/rac-to-ron-then-ron-to-rac-and-singleton-service\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/rac-to-ron-then-ron-to-rac-and-singleton-service\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/rac-to-ron-then-ron-to-rac-and-singleton-service\\\/\",\"name\":\"RAC to RON then RON to RAC and singleton service - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2016-03-20T20:14:53+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/rac-to-ron-then-ron-to-rac-and-singleton-service\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/rac-to-ron-then-ron-to-rac-and-singleton-service\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/rac-to-ron-then-ron-to-rac-and-singleton-service\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"RAC to RON then RON to RAC and singleton service\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/oracle-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"RAC to RON then RON to RAC and singleton service - dbi Blog","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:\/\/www.dbi-services.com\/blog\/rac-to-ron-then-ron-to-rac-and-singleton-service\/","og_locale":"en_US","og_type":"article","og_title":"RAC to RON then RON to RAC and singleton service","og_description":"By Franck Pachot . You will probably never do it, but let’s imagine you have a RAC database, policy managed, with singleton service. Then you convert it to RAC One Node and you change your mind and convert it back to RAC. Be careful, the singleton services are converted to uniform ones when converting to […]","og_url":"https:\/\/www.dbi-services.com\/blog\/rac-to-ron-then-ron-to-rac-and-singleton-service\/","og_site_name":"dbi Blog","article_published_time":"2016-03-20T20:14:53+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/rac-to-ron-then-ron-to-rac-and-singleton-service\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/rac-to-ron-then-ron-to-rac-and-singleton-service\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"RAC to RON then RON to RAC and singleton service","datePublished":"2016-03-20T20:14:53+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/rac-to-ron-then-ron-to-rac-and-singleton-service\/"},"wordCount":229,"commentCount":0,"keywords":["Oracle","Policy Managed","RAC"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/rac-to-ron-then-ron-to-rac-and-singleton-service\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/rac-to-ron-then-ron-to-rac-and-singleton-service\/","url":"https:\/\/www.dbi-services.com\/blog\/rac-to-ron-then-ron-to-rac-and-singleton-service\/","name":"RAC to RON then RON to RAC and singleton service - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2016-03-20T20:14:53+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/rac-to-ron-then-ron-to-rac-and-singleton-service\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/rac-to-ron-then-ron-to-rac-and-singleton-service\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/rac-to-ron-then-ron-to-rac-and-singleton-service\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"RAC to RON then RON to RAC and singleton service"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7427","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=7427"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7427\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=7427"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=7427"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=7427"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=7427"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}