{"id":36050,"date":"2024-12-02T16:54:39","date_gmt":"2024-12-02T15:54:39","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=36050"},"modified":"2024-12-02T16:54:42","modified_gmt":"2024-12-02T15:54:42","slug":"convert-single-instance-database-to-rac-on-an-oda","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/convert-single-instance-database-to-rac-on-an-oda\/","title":{"rendered":"Convert Single Instance database to RAC on an ODA"},"content":{"rendered":"\n

In this article, I will show you how to convert a SI (Single Instance) database to a RAC database on an ODA using rconfig. Of course this is only possible with the ODA 2-HA model as it comes with a 2 nodes cluster. There is no way to do RAC database on the ODA light model. I will also ensure that there is no impact to the other databases running in the same oracle home. This is why, I will create 2 test databases with the same oracle home. Please note that there will be downtime knowing the database needs to be restarted.<\/p>\n\n\nRead more: Convert Single Instance database to RAC on an ODA<\/span><\/a>\n\n\n

Preparation<\/h2>\n\n\n\n

I will first create a new oracle home on the existing ODA.<\/p>\n\n\n\n

\n[root@node0 ~]# odacli list-dbhomes\nID                                       Name                 DB Version           DB Edition Home Location                                            Status\n---------------------------------------- -------------------- -------------------- ---------- -------------------------------------------------------- ----------\n03e59f95-e77f-4429-a9fc-466bea89545b     OraDB19000_home4     19.23.0.0.240416     EE         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_4     CONFIGURED\n\n[root@node0 ~]# odacli create-dbhome -de EE -v 19.23.0.0.240416\n\nJob details\n----------------------------------------------------------------\n                     ID:  0f02be31-a2b5-4ba1-af66-76c83d9808f2\n            Description:  Database Home OraDB19000_home5 creation with version :19.23.0.0.240416\n                 Status:  Created\n                Created:  November 26, 2024 4:02:27 PM CET\n                Message:  Create Database Home\n\nTask Name                                Node Name                 Start Time                               End Time                                 Status\n---------------------------------------- ------------------------- ---------------------------------------- ---------------------------------------- ----------------\n\n[root@node0 ~]# odacli describe-job -i 0f02be31-a2b5-4ba1-af66-76c83d9808f2\n\nJob details\n----------------------------------------------------------------\n                     ID:  0f02be31-a2b5-4ba1-af66-76c83d9808f2\n            Description:  Database Home OraDB19000_home5 creation with version :19.23.0.0.240416\n                 Status:  Success\n                Created:  November 26, 2024 4:02:27 PM CET\n                Message:  Create Database Home\n\nTask Name                                Node Name                 Start Time                               End Time                                 Status\n---------------------------------------- ------------------------- ---------------------------------------- ---------------------------------------- ----------------\nSetting up SSH equivalence               node0                 November 26, 2024 4:02:49 PM CET         November 26, 2024 4:02:54 PM CET         Success\nSetting up SSH equivalence               node0                 November 26, 2024 4:02:54 PM CET         November 26, 2024 4:02:58 PM CET         Success\nCreating ACFS database home              node0                 November 26, 2024 4:02:58 PM CET         November 26, 2024 4:02:58 PM CET         Success\nValidating dbHome available space        node0                 November 26, 2024 4:02:59 PM CET         November 26, 2024 4:02:59 PM CET         Success\nValidating dbHome available space        node1                 November 26, 2024 4:02:59 PM CET         November 26, 2024 4:02:59 PM CET         Success\nCreating DbHome Directory                node1                 November 26, 2024 4:03:01 PM CET         November 26, 2024 4:03:01 PM CET         Success\nCreate required directories              node0                 November 26, 2024 4:03:01 PM CET         November 26, 2024 4:03:01 PM CET         Success\nExtract DB clone                         node0                 November 26, 2024 4:03:02 PM CET         November 26, 2024 4:05:00 PM CET         Success\nProvDbHome by using RHP                  node0                 November 26, 2024 4:05:00 PM CET         November 26, 2024 4:08:20 PM CET         Success\nEnable DB options                        node0                 November 26, 2024 4:08:21 PM CET         November 26, 2024 4:08:48 PM CET         Success\nCreating wallet for DB Client            node0                 November 26, 2024 4:09:02 PM CET         November 26, 2024 4:09:03 PM CET         Success\n\n[root@node0 ~]# odacli list-dbhomes\nID                                       Name                 DB Version           DB Edition Home Location                                            Status\n---------------------------------------- -------------------- -------------------- ---------- -------------------------------------------------------- ----------\n03e59f95-e77f-4429-a9fc-466bea89545b     OraDB19000_home4     19.23.0.0.240416     EE         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_4     CONFIGURED\n1c6059a2-f6c7-4bca-a07a-8efc0757ed08     OraDB19000_home5     19.23.0.0.240416     EE         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_5     CONFIGURED\n\n<\/pre>\n<\/br>\n\n\n\n
I will create 2 new databases on this new dbhome : TEST1 and TEST2.<\/p>\n\n\n\n
\n[root@node0 ~]# odacli list-databases\nID                                       DB Name    DB Type  DB Version           CDB     Class    Edition  Shape    Storage  Status       DB Home ID\n---------------------------------------- ---------- -------- -------------------- ------- -------- -------- -------- -------- ------------ ----------------------------------------\n2d824a9f-735a-4e8d-b6c8-5393ddc894e9     DBSI6       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n0393d997-50aa-4511-b5b9-c4ff2da393db     DBGI3       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n712d542e-ded7-4d1a-9b9d-7c335042ffc0     DAWHT       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n28026894-0c2d-417b-b11a-d76516805247     DBSI1       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n11a12489-2483-4f8a-bb60-7145417181a1     DBSI4       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\ncd183219-3daa-4154-b4a4-41b92d4f8155     DBBI1       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\nfdfe3197-223f-4660-a834-4736f50110ef     DBSI2       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n7391380b-f609-4457-be6b-bd9afa51148c     DBBI2       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\nce4350ed-e291-4815-8c43-3c6716d6402f     DBGI6       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n274e6069-b174-43fb-8625-70e1e333f160     DBSI5       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n52eadf14-4d20-4910-91ca-a335361d53b2     RCDB        SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\nec54945d-d0de-4b92-8822-2bd0d31fe653     DBSI3       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n95420f39-db33-4c4d-8d85-a5f8d42945e6     DBBI3       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\nb7c42ea7-6eab-4b98-8ea7-8dd4ce9517a1     DBBI4       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n707251cc-f19a-4b8c-89cc-63477c5747d0     DBGI4       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n2bbd4391-5eed-4878-b2e5-3670587527f6     DBBI6       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\nf540b5d1-c074-457a-85e2-d35240541efd     DBGI2       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n16a24733-cfba-4e75-a9ce-59b3779dc82e     DBGI1       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n\n[root@node0 ~]# odacli create-database -n TEST1 -u TEST1 -y SI -g 0 -cl OLTP -no-c -no-co -cs UTF8 -ns AL16UTF16 -l AMERICAN -dt AMERICA -dh 1c6059a2-f6c7-4bca-a07a-8efc0757ed08 -s odb1 -r ACFS\nEnter SYS and SYSTEM user password:\nRetype SYS and SYSTEM user password:\n\nJob details\n----------------------------------------------------------------\n                     ID:  88cd622d-7896-4a7c-b2d5-bb113438b2d2\n            Description:  Database service creation with DB name: TEST1\n                 Status:  Created\n                Created:  November 26, 2024 4:12:37 PM CET\n                Message:\n\nTask Name                                Start Time                               End Time                                 Status\n---------------------------------------- ---------------------------------------- ---------------------------------------- ----------------\n\n[root@node0 ~]# odacli describe-job -i 88cd622d-7896-4a7c-b2d5-bb113438b2d2\n\nJob details\n----------------------------------------------------------------\n                     ID:  88cd622d-7896-4a7c-b2d5-bb113438b2d2\n            Description:  Database service creation with DB name: TEST1\n                 Status:  Success\n                Created:  November 26, 2024 4:12:37 PM CET\n                Message:\n\nTask Name                                Node Name                 Start Time                               End Time                                 Status\n---------------------------------------- ------------------------- ---------------------------------------- ---------------------------------------- ----------------\nSetting up SSH equivalence               node0                 November 26, 2024 4:12:45 PM CET         November 26, 2024 4:12:49 PM CET         Success\nSetting up SSH equivalence               node0                 November 26, 2024 4:12:49 PM CET         November 26, 2024 4:12:52 PM CET         Success\nCreating volume dclTEST1                 node0                 November 26, 2024 4:12:53 PM CET         November 26, 2024 4:13:14 PM CET         Success\nCreating volume datTEST1                 node0                 November 26, 2024 4:13:14 PM CET         November 26, 2024 4:13:35 PM CET         Success\nCreating ACFS filesystem for DATA        node0                 November 26, 2024 4:13:36 PM CET         November 26, 2024 4:14:06 PM CET         Success\nDatabase Service creation                node0                 November 26, 2024 4:14:10 PM CET         November 26, 2024 4:27:39 PM CET         Success\nDatabase Creation by RHP                 node0                 November 26, 2024 4:14:10 PM CET         November 26, 2024 4:24:27 PM CET         Success\nChange permission for xdb wallet files   node1                 November 26, 2024 4:24:29 PM CET         November 26, 2024 4:24:32 PM CET         Success\nPlace SnapshotCtrlFile in sharedLoc      node0                 November 26, 2024 4:24:33 PM CET         November 26, 2024 4:24:37 PM CET         Success\nSqlPatch upgrade                         node0                 November 26, 2024 4:26:06 PM CET         November 26, 2024 4:26:28 PM CET         Success\nRunning dbms_stats init_package          node0                 November 26, 2024 4:26:29 PM CET         November 26, 2024 4:26:32 PM CET         Success\nSet log_archive_dest for Database        node0                 November 26, 2024 4:26:32 PM CET         November 26, 2024 4:26:34 PM CET         Success\nUpdating the Database version            node1                 November 26, 2024 4:26:35 PM CET         November 26, 2024 4:26:40 PM CET         Success\nCreate Users tablespace                  node0                 November 26, 2024 4:27:39 PM CET         November 26, 2024 4:27:42 PM CET         Success\nClear all listeners from Database        node0                 November 26, 2024 4:27:43 PM CET         November 26, 2024 4:27:44 PM CET         Success\nCopy Pwfile to Shared Storage            node0                 November 26, 2024 4:27:47 PM CET         November 26, 2024 4:27:50 PM CET         Success\nConfigure All Candidate Nodes            node0                 November 26, 2024 4:27:50 PM CET         November 26, 2024 4:27:52 PM CET         Success\n\n[root@node0 ~]# odacli create-database -n TEST2 -u TEST2 -y SI -g 0 -cl OLTP -no-c -no-co -cs UTF8 -ns AL16UTF16 -l AMERICAN -dt AMERICA -dh 1c6059a2-f6c7-4bca-a07a-8efc0757ed08 -s odb1 -r ACFS\nEnter SYS and SYSTEM user password:\nRetype SYS and SYSTEM user password:\n\nJob details\n----------------------------------------------------------------\n                     ID:  95f53872-96c8-4eb4-903f-f9e5a4701db5\n            Description:  Database service creation with DB name: TEST2\n                 Status:  Created\n                Created:  November 26, 2024 4:29:45 PM CET\n                Message:\n\nTask Name                                Start Time                               End Time                                 Status\n---------------------------------------- ---------------------------------------- ---------------------------------------- ----------------\n\n[root@node0 ~]# odacli describe-job -i 95f53872-96c8-4eb4-903f-f9e5a4701db5\n\nJob details\n----------------------------------------------------------------\n                     ID:  95f53872-96c8-4eb4-903f-f9e5a4701db5\n            Description:  Database service creation with DB name: TEST2\n                 Status:  Success\n                Created:  November 26, 2024 4:29:45 PM CET\n                Message:\n\nTask Name                                Node Name                 Start Time                               End Time                                 Status\n---------------------------------------- ------------------------- ---------------------------------------- ---------------------------------------- ----------------\nSetting up SSH equivalence               node0                 November 26, 2024 4:29:54 PM CET         November 26, 2024 4:29:58 PM CET         Success\nSetting up SSH equivalence               node0                 November 26, 2024 4:29:58 PM CET         November 26, 2024 4:30:02 PM CET         Success\nCreating volume dclTEST2                 node0                 November 26, 2024 4:30:03 PM CET         November 26, 2024 4:30:26 PM CET         Success\nCreating volume datTEST2                 node0                 November 26, 2024 4:30:26 PM CET         November 26, 2024 4:30:51 PM CET         Success\nCreating ACFS filesystem for DATA        node0                 November 26, 2024 4:30:51 PM CET         November 26, 2024 4:31:24 PM CET         Success\nDatabase Service creation                node0                 November 26, 2024 4:31:28 PM CET         November 26, 2024 4:44:52 PM CET         Success\nDatabase Creation by RHP                 node0                 November 26, 2024 4:31:28 PM CET         November 26, 2024 4:41:51 PM CET         Success\nChange permission for xdb wallet files   node1                 November 26, 2024 4:41:53 PM CET         November 26, 2024 4:41:55 PM CET         Success\nPlace SnapshotCtrlFile in sharedLoc      node0                 November 26, 2024 4:41:55 PM CET         November 26, 2024 4:42:00 PM CET         Success\nSqlPatch upgrade                         node0                 November 26, 2024 4:43:26 PM CET         November 26, 2024 4:43:47 PM CET         Success\nRunning dbms_stats init_package          node0                 November 26, 2024 4:43:47 PM CET         November 26, 2024 4:43:49 PM CET         Success\nSet log_archive_dest for Database        node0                 November 26, 2024 4:43:49 PM CET         November 26, 2024 4:43:52 PM CET         Success\nUpdating the Database version            node1                 November 26, 2024 4:43:52 PM CET         November 26, 2024 4:43:57 PM CET         Success\nCreate Users tablespace                  node0                 November 26, 2024 4:44:52 PM CET         November 26, 2024 4:44:56 PM CET         Success\nClear all listeners from Database        node0                 November 26, 2024 4:44:57 PM CET         November 26, 2024 4:44:59 PM CET         Success\nCopy Pwfile to Shared Storage            node0                 November 26, 2024 4:45:02 PM CET         November 26, 2024 4:45:05 PM CET         Success\nConfigure All Candidate Nodes            node0                 November 26, 2024 4:45:05 PM CET         November 26, 2024 4:45:07 PM CET         Success\n<\/pre>\n<\/br>\n\n\n\n
So we have 2 new databases TEST1 and TEST2 on new oracle home dbhome_5.<\/p>\n\n\n\n
\n[root@node0 ~]# odacli list-dbhomes\nID                                       Name                 DB Version           DB Edition Home Location                                            Status\n---------------------------------------- -------------------- -------------------- ---------- -------------------------------------------------------- ----------\n03e59f95-e77f-4429-a9fc-466bea89545b     OraDB19000_home4     19.23.0.0.240416     EE         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_4     CONFIGURED\n1c6059a2-f6c7-4bca-a07a-8efc0757ed08     OraDB19000_home5     19.23.0.0.240416     EE         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_5     CONFIGURED\n\n[root@node0 ~]# odacli list-databases\nID                                       DB Name    DB Type  DB Version           CDB     Class    Edition  Shape    Storage  Status       DB Home ID\n---------------------------------------- ---------- -------- -------------------- ------- -------- -------- -------- -------- ------------ ----------------------------------------\n2d824a9f-735a-4e8d-b6c8-5393ddc894e9     DBSI6       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n0393d997-50aa-4511-b5b9-c4ff2da393db     DBGI3       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n712d542e-ded7-4d1a-9b9d-7c335042ffc0     DAWHT       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n28026894-0c2d-417b-b11a-d76516805247     DBSI1       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n11a12489-2483-4f8a-bb60-7145417181a1     DBSI4       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\ncd183219-3daa-4154-b4a4-41b92d4f8155     DBBI1       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\nfdfe3197-223f-4660-a834-4736f50110ef     DBSI2       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n7391380b-f609-4457-be6b-bd9afa51148c     DBBI2       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\nce4350ed-e291-4815-8c43-3c6716d6402f     DBGI6       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n274e6069-b174-43fb-8625-70e1e333f160     DBSI5       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n52eadf14-4d20-4910-91ca-a335361d53b2     RCDB        SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\nec54945d-d0de-4b92-8822-2bd0d31fe653     DBSI3       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n95420f39-db33-4c4d-8d85-a5f8d42945e6     DBBI3       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\nb7c42ea7-6eab-4b98-8ea7-8dd4ce9517a1     DBBI4       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n707251cc-f19a-4b8c-89cc-63477c5747d0     DBGI4       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n2bbd4391-5eed-4878-b2e5-3670587527f6     DBBI6       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\nf540b5d1-c074-457a-85e2-d35240541efd     DBGI2       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n16a24733-cfba-4e75-a9ce-59b3779dc82e     DBGI1       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n4358287c-9cf0-45d4-a7e3-a59f933e86b2     TEST1       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   1c6059a2-f6c7-4bca-a07a-8efc0757ed08\n110f26e7-f9f3-412e-9443-a201d24201a0     TEST2       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   1c6059a2-f6c7-4bca-a07a-8efc0757ed08\n[root@node0 ~]#\n<\/pre>\n<\/br>\n\n\n\n
Check TEST1 and TEST2 Single Instance databases<\/h2>\n\n\n\n
TEST1 database is opened READ\/WRITE.<\/p>\n\n\n\n
\noracle@node0:~\/ [rdbms1900] TEST1\n\n ******************************************************\n INSTANCE_NAME   : TEST1\n DB_NAME         : TEST1\n DB_UNIQUE_NAME  : TEST1\n STATUS          : OPEN READ WRITE\n LOG_MODE        : ARCHIVELOG\n USERS\/SESSIONS  : Normal: 0\/0, Oracle-maintained: 2\/6\n DATABASE_ROLE   : PRIMARY\n FLASHBACK_ON    : NO\n FORCE_LOGGING   : YES\n VERSION         : 19.23.0.0.0\n NLS_LANG        : AMERICAN_AMERICA.UTF8\n CDB_ENABLED     : NO\n ******************************************************\n Statustime: 2024-11-27 09:25:43\n<\/pre>\n<\/br>\n\n\n\n
The name of the instance is the name of the database, TEST1. It is a single instance and we choosed the node0 as node (option -g 0 from odacli command). This is confirmed we only have one instance running on node 0.<\/p>\n\n\n\n
\noracle@node0:~\/ [TEST1] ps -ef | grep -i [p]mon | grep -i test1\noracle   22300     1  0 Nov26 ?        00:00:03 ora_pmon_TEST1\n\noracle@node1:~\/ [rdbms192300_a] ps -ef | grep -i [p]mon | grep -i test\noracle@node1:~\/ [rdbms192300_a]\n\noracle@node0:~\/ [TEST1] srvctl status database -d TEST1\nInstance TEST1 is running on node node0\n<\/pre>\n<\/br>\n\n\n\n
Checking grid cluster configuration, we see that we only have one instance and 2 configured nodes :<\/p>\n\n\n\n
Database instance: TEST1<\/code><\/p>\n\n\n\n
Configured nodes: node0,node1<\/code><\/p>\n\n\n\n
<\/p>\n\n\n\n
\noracle@node0:~\/ [TEST1] srvctl config database -d TEST1\nDatabase unique name: TEST1\nDatabase name: TEST1\nOracle home: \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_5\nOracle user: oracle\nSpfile: \/u02\/app\/oracle\/oradata\/TEST1\/dbs\/spfileTEST1.ora\nPassword file: \/u02\/app\/oracle\/oradata\/TEST1\/dbs\/orapwTEST1\nDomain: swisslos.local\nStart options: open\nStop options: immediate\nDatabase role: PRIMARY\nManagement policy: AUTOMATIC\nServer pools:\nDisk Groups: DATA\nMount point paths: \/u01\/app\/odaorahome,\/u02\/app\/oracle\/oradata\/TEST1,\/u03\/app\/oracle\/,\/u01\/app\/odaorabase0,\/u01\/app\/odaorabase1\nServices:\nType: SINGLE\nOSDBA group: dba\nOSOPER group: dbaoper\nDatabase instance: TEST1\nConfigured nodes: node0,node1\nCSS critical: no\nCPU count: 0\nMemory target: 0\nMaximum memory: 0\nDefault network number for database services:\nDatabase is administrator managed\n<\/pre>\n<\/br>\n\n\n\n
And we can check and see that the cluster_database instance parameter is set to FALSE.<\/p>\n\n\n\n
\noracle@node0:~\/ [TEST1] sqh\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Wed Nov 27 09:32:33 2024\nVersion 19.23.0.0.0\n\nCopyright (c) 1982, 2023, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.23.0.0.0\n\nSQL> select inst_id, name, value from gv$parameter where name='cluster_database';\n\n   INST_ID NAME                 VALUE\n---------- -------------------- --------------------\n         1 cluster_database     FALSE\n\nSQL>\n<\/pre>\n<\/br>\n\n\n\n
The same can be checked on the TEST2 database.<\/p>\n\n\n\n
\noracle@node0:~\/ [TEST1] TEST2\n\n ******************************************************\n INSTANCE_NAME   : TEST2\n DB_NAME         : TEST2\n DB_UNIQUE_NAME  : TEST2\n STATUS          : OPEN READ WRITE\n LOG_MODE        : ARCHIVELOG\n USERS\/SESSIONS  : Normal: 0\/0, Oracle-maintained: 2\/5\n DATABASE_ROLE   : PRIMARY\n FLASHBACK_ON    : NO\n FORCE_LOGGING   : YES\n VERSION         : 19.23.0.0.0\n NLS_LANG        : AMERICAN_AMERICA.UTF8\n CDB_ENABLED     : NO\n ******************************************************\n Statustime: 2024-11-27 09:33:30\n\noracle@node0:~\/ [TEST2] ps -ef | grep -i [p]mon | grep -i test2\noracle   89478     1  0 Nov26 ?        00:00:03 ora_pmon_TEST2\n\noracle@node1:~\/ [rdbms192300_a] ps -ef | grep -i [p]mon | grep -i test\noracle@node1:~\/ [rdbms192300_a]\n\noracle@node0:~\/ [TEST2] srvctl status database -d TEST2\nInstance TEST2 is running on node node0\n\noracle@node0:~\/ [TEST2] srvctl config database -d TEST2\nDatabase unique name: TEST2\nDatabase name: TEST2\nOracle home: \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_5\nOracle user: oracle\nSpfile: \/u02\/app\/oracle\/oradata\/TEST2\/dbs\/spfileTEST2.ora\nPassword file: \/u02\/app\/oracle\/oradata\/TEST2\/dbs\/orapwTEST2\nDomain: swisslos.local\nStart options: open\nStop options: immediate\nDatabase role: PRIMARY\nManagement policy: AUTOMATIC\nServer pools:\nDisk Groups: DATA\nMount point paths: \/u01\/app\/odaorahome,\/u02\/app\/oracle\/oradata\/TEST2,\/u03\/app\/oracle\/,\/u01\/app\/odaorabase0,\/u01\/app\/odaorabase1\nServices:\nType: SINGLE\nOSDBA group: dba\nOSOPER group: dbaoper\nDatabase instance: TEST2\nConfigured nodes: node0,node1\nCSS critical: no\nCPU count: 0\nMemory target: 0\nMaximum memory: 0\nDefault network number for database services:\nDatabase is administrator managed\noracle@node0:~\/ [TEST2]\n\noracle@node0:~\/ [TEST2] sqh\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Wed Nov 27 09:34:40 2024\nVersion 19.23.0.0.0\n\nCopyright (c) 1982, 2023, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.23.0.0.0\n\nSQL> select inst_id, name, value from gv$parameter where name='cluster_database';\n\n   INST_ID NAME                 VALUE\n---------- -------------------- --------------------\n         1 cluster_database     FALSE\n\nSQL>\n<\/pre>\n<\/br>\n\n\n\n
Convert TEST1 database to RAC using rconfig<\/h2>\n\n\n\n
rconfig template<\/h3>\n\n\n\n
rconfig is using a XML configuration file. Templates can be found in the oracle dbhome.<\/p>\n\n\n\n
\noracle@node0:~\/ [TEST1] ls -ltrh $ORACLE_HOME\/assistants\/rconfig\/sampleXMLs\ntotal 8.0K\n-rw-r----- 1 oracle oinstall 2.6K Mar  9  2018 ConvertToRAC_PolicyManaged.xml\n-rw-r----- 1 oracle oinstall 2.5K Jul 16  2018 ConvertToRAC_AdminManaged.xml\n<\/pre>\n<\/br>\n\n\n\n
We will use the ConvertToRAC_AdminManaged.xml template and adapt it for our need into a new XML file, named ConvertToRAC_TEST1.xml, in order to convert TEST1 database.<\/p>\n\n\n\n
\noracle@node0:~\/mwagner\/ [TEST1] mkdir rconfig_xml\n\noracle@node0:~\/mwagner\/ [TEST1] cd rconfig_xml\n\noracle@node0:~\/mwagner\/rconfig_xml\/ [TEST1] cp -p $ORACLE_HOME\/assistants\/rconfig\/sampleXMLs\/ConvertToRAC_AdminManaged.xml .\/ConvertToRAC_TEST1.xml\n\noracle@node0:~\/mwagner\/rconfig_xml\/ [TEST1] vi ConvertToRAC_TEST1.xml\n<\/pre>\n<\/br>\n\n\n\n
Let’s list the XML file that has been updated and that will be used for the conversion.<\/p>\n\n\n\n
\noracle@node0:~\/mwagner\/rconfig_xml\/ [TEST1] cat ConvertToRAC_TEST1.xml\n<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<n:RConfig xmlns:n=\"http:\/\/www.oracle.com\/rconfig\"\n           xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\n           xsi:schemaLocation=\"http:\/\/www.oracle.com\/rconfig rconfig.xsd\">\n    <n:ConvertToRAC>\n<!-- Verify does a precheck to ensure all pre-requisites are met, before the conversion is attempted. Allowable values are: YES|NO|ONLY -->\n\t<n:Convert verify=\"ONLY\">\n<!--Specify current OracleHome of non-rac database for SourceDBHome -->\n\t      <n:SourceDBHome>\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_5<\/n:SourceDBHome>\n<!--Specify OracleHome where the rac database should be configured. It can be same as SourceDBHome -->\n\t      <n:TargetDBHome>\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_5<\/n:TargetDBHome>\n<!--Specify SID of non-rac database -->\n              <n:SourceDBInfo SID=\"TEST1\"\/>\n<!--Specify the list of nodes that should have rac instances running for the Admin Managed Cluster Database. LocalNode should be the first node in this nodelist. -->\n\t      <n:NodeList>\n\t        <n:Node name=\"node0\"\/>\n\t        <n:Node name=\"node1\"\/>\n\t      <\/n:NodeList>\n<!--Specify RacOneNode along with servicename to convert database to RACOne Node -->\n              <!--n:RacOneNode  servicename=\"salesrac1service\"\/-->\n<!--Instance Prefix tag is optional starting with 11.2. If left empty, it is derived from db_unique_name.-->\n\t      <n:InstancePrefix><\/n:InstancePrefix>\n<!-- Listener details are no longer needed starting 11.2. Database is registered with default listener and SCAN listener running from Oracle Grid Infrastructure home. -->\n<!--Specify the type of storage to be used by rac database. Allowable values are CFS|ASM. The non-rac database should have same storage type. ASM credentials are no needed for conversion. -->\n\t      <n:SharedStorage type=\"ASM\">\n<!--Specify Database Area Location to be configured for rac database.If this field is left empty, current storage will be used for rac database. For CFS, this field will have directory path. -->\n\t        <n:TargetDatabaseArea><\/n:TargetDatabaseArea>\n<!--Specify Fast Recovery Area to be configured for rac database. If this field is left empty, current recovery area of non-rac database will be configured for rac database. If current database is not using recovery Area, the resulting rac database will not have a recovery area. -->\n\t        <n:TargetFlashRecoveryArea><\/n:TargetFlashRecoveryArea>\n\t      <\/n:SharedStorage>\n        <\/n:Convert>\n    <\/n:ConvertToRAC>\n<\/n:RConfig>\n<\/pre>\n<\/br>\n\n\n\n
Some of the xml tags are quite easy to understand, others would need to be handled carefully.<\/p>\n\n\n\n
TAG<\/th>Explanation<\/th><\/tr><\/thead>
Convert verify<\/td>Can be YES, NO or ONLY.
If it is set to ONLY rconfig will just check if the conversion is possible but will not run it.
In case of YES or NO, the conversion will be run. I would stongly recommend to use YES and to avoid NO<\/td><\/tr>
SourceDBHome<\/td>DB Home used by the database to convert, in our case:
\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_5<\/td><\/tr>
TargetDBHome<\/td>DB Home the RAC database will use. We will chose to keep same one.<\/td><\/tr>
SourceDBInfo SID<\/td>Database SID, in our case TEST1<\/td><\/tr>
NodeList
  Node name<\/td>		List of all node hostname<\/td><\/tr>
RacOneNode servicename<\/td>N\/A, as you can see, this tag has been put in comment. Note !–<\/td><\/tr>
InstancePrefix<\/td>Prefix to be used to name the instances.
In our case we let it blank, so it will use the db_unique_name as prefix and name the instances as db_unique_name[1-X]:
TEST11
TEST12<\/td><\/tr>
SharedStorage type<\/td>Here, we need to pay attention. We are using ACFS, so we need to ensure we enter ASM. Configuring it incorrectly might delete all the database files.<\/td><\/tr>
TargetDatabaseArea<\/td>Here, we need to pay attention too. We are using ACFS, so we need to ensure to leave it blank. Referring ACFS database files directory, will incorrectly delete all the database files.<\/td><\/tr>
TargetFlashRecoveryArea<\/td>We keep it blank as we will reuse the same recovery area.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
Please pay attention of both SharedStorage type <\/strong>and TargetDatabaseArea<\/strong> parameter.<\/p>\n\n\n\n
Check\/test conversion<\/h3>\n\n\n\n
We will ensure that the convert verify value is set to ONLY in the xml template, so rconfig will only check if the conversion is possible, and will not run any conversion.<\/p>\n\n\n\n
\noracle@node0:~\/mwagner\/rconfig_xml\/ [TEST1] grep -i \"Convert verify\" ConvertToRAC_TEST1.xml\n\t<n:Convert verify=\"ONLY\">\noracle@node0:~\/mwagner\/rconfig_xml\/ [TEST1]\n<\/pre>\n<\/br>\n\n\n\n
I will now run rconfig.<\/p>\n\n\n\n
\noracle@node0:~\/mwagner\/rconfig_xml\/ [TEST1] cd $ORACLE_HOME\/bin\noracle@node0:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_5\/bin\/ [TEST1] .\/rconfig ~\/mwagner\/rconfig_xml\/ConvertToRAC_TEST1.xml\nSpecify sys user password for the database\n\n<?xml version=\"1.0\" ?>\n<RConfig version=\"1.1\" >\n<ConvertToRAC>\n    <Convert>\n      <Response>\n        <Result code=\"0\" >\n          Operation Succeeded\n        <\/Result>\n      <\/Response>\n      <ReturnValue type=\"object\">\nThere is no return value for this step     <\/ReturnValue>\n    <\/Convert>\n  <\/ConvertToRAC><\/RConfig>\n<\/pre>\n<\/br>\n\n\n\n
The rconfig conversion check has been successfully executed, and the database is ready to be converted. Note the result code value to be 0 and the message “Operation Succeeded”.<\/p>\n\n\n\n
<\/p>\n\n\n\n
Convert the database<\/h1>\n\n\n\n
So we can now convert the database. We will change the template and have “convert verify” setup to YES.<\/p>\n\n\n\n
\noracle@node0:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_5\/bin\/ [TEST1] vi ~\/mwagner\/rconfig_xml\/ConvertToRAC_TEST1.xml\noracle@node0:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_5\/bin\/ [TEST1] grep -i \"Convert verify\" ~\/mwagner\/rconfig_xml\/ConvertToRAC_TEST1.xml\n\t<n:Convert verify=\"YES\">\n<\/pre>\n<\/br>\n\n\n\n
And we can run the conversion.<\/p>\n\n\n\n
\noracle@node0:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_5\/bin\/ [TEST1] .\/rconfig ~\/mwagner\/rconfig_xml\/ConvertToRAC_TEST1.xml\nSpecify sys user password for the database\n\nConverting Database \"TEST1.swisslos.local\" to Cluster Database. Target Oracle Home: \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_5. Database Role: PRIMARY.\nSetting Data Files and Control Files\nAdding Trace files\nAdding Database Instances\nCreate temporary password file\nAdding Redo Logs\nEnabling threads for all Database Instances\nSetting TEMP tablespace\nAdding UNDO tablespaces\nSetting Fast Recovery Area\nUpdating Oratab\nCreating Password file(s)\nConfiguring related CRS resources\nStarting Cluster Database\n<?xml version=\"1.0\" ?>\n<RConfig version=\"1.1\" >\n<ConvertToRAC>\n    <Convert>\n      <Response>\n        <Result code=\"0\" >\n          Operation Succeeded\n        <\/Result>\n      <\/Response>\n      <ReturnValue type=\"object\">\n<Oracle_Home>\n         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_5\n       <\/Oracle_Home>\n       <Database type=\"ADMIN_MANAGED\"  >\n         <InstanceList>\n           <Instance SID=\"TEST11\" Node=\"node0\"  >\n           <\/Instance>\n           <Instance SID=\"TEST12\" Node=\"node1\"  >\n           <\/Instance>\n         <\/InstanceList>\n       <\/Database>     <\/ReturnValue>\n    <\/Convert>\n  <\/ConvertToRAC><\/RConfig>\noracle@node0:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_5\/bin\/ [TEST1]\n<\/pre>\n<\/br>\n\n\n\n
Note the result code value to be 0 and the message “Operation Succeeded”. This means the conversion has been executed successfully.<\/p>\n\n\n\n
UNDO and REDO creation<\/h3>\n\n\n\n
As expected, knowing we are now having 2 instances, we need 2 UNDO tablespace and 2 sets of ONLINE LOG. We can see that an additionnal UNDO tablespace has been created.<\/p>\n\n\n\n
We can check this on the file system and see additionnal UNDO tablespace file.<\/p>\n\n\n\n
Before:<\/p>\n\n\n\n
\noracle@node1:~\/ [rdbms192300_a] ls -ltrh \/u02\/app\/oracle\/oradata\/TEST1\/TEST1\/datafile\/\ntotal 2.4G\n-rw-r----- 1 oracle asmadmin  5.1M Nov 26 16:32 o1_mf_users_mnct7fwn_.dbf\n-rw-r----- 1 oracle asmadmin  252M Nov 26 22:06 o1_mf_temp_mncso2l7_.tmp\n-rw-r----- 1 oracle asmadmin 1011M Nov 27 10:18 o1_mf_sysaux_mncslcxc_.dbf\n-rw-r----- 1 oracle asmadmin  101M Nov 27 10:18 o1_mf_undotbs1_mncslvbn_.dbf\n-rw-r----- 1 oracle asmadmin  1.1G Nov 27 10:25 o1_mf_system_mncsk8kf_.dbf\n<\/pre>\n<\/br>\n\n\n\n
After:<\/p>\n\n\n\n
\noracle@node1:~\/ [rdbms192300_a] ls -ltrh \/u02\/app\/oracle\/oradata\/TEST1\/TEST1\/datafile\/\ntotal 2.6G\n-rw-r----- 1 oracle asmadmin  5.1M Nov 26 16:32 o1_mf_users_mnct7fwn_.dbf\n-rw-r----- 1 oracle asmadmin  101M Nov 27 10:18 o1_mf_undotbs1_mncslvbn_.dbf\n-rw-r----- 1 oracle asmadmin  101M Nov 27 10:42 o1_mf_undotbs2_mnft7oh9_.dbf\n-rw-r----- 1 oracle asmadmin 1011M Nov 27 10:42 o1_mf_sysaux_mncslcxc_.dbf\n-rw-r----- 1 oracle asmadmin  1.1G Nov 27 10:42 o1_mf_system_mncsk8kf_.dbf\n-rw-r----- 1 oracle asmadmin  284M Nov 27 10:42 o1_mf_temp_mncso2l7_.tmp\n<\/pre>\n<\/br>\n\n\n\n
But this can be, of course, confirmed from the alert log file.<\/p>\n\n\n\n
\noracle@node0:\/u01\/app\/odaorabase\/oracle\/diag\/rdbms\/test1\/TEST11\/trace\/ [TEST11] grep -i UNDOTBS2 alert_TEST11.log\ncreate undo tablespace UNDOTBS2 datafile  size 102400K  AUTOEXTEND ON MAXSIZE UNLIMITED\nCompleted: create undo tablespace UNDOTBS2 datafile  size 102400K  AUTOEXTEND ON MAXSIZE UNLIMITED\nALTER SYSTEM SET undo_tablespace='UNDOTBS2' SCOPE=SPFILE SID='TEST12';\noracle@node0:\/u01\/app\/odaorabase\/oracle\/diag\/rdbms\/test1\/TEST11\/trace\/ [TEST11]\n\noracle@node0:\/u01\/app\/odaorabase\/oracle\/diag\/rdbms\/test1\/TEST11\/trace\/ [TEST11] vi alert_TEST11.log\n...\n...\n...\n2024-11-27T10:40:05.316493+01:00\nALTER SYSTEM SET undo_tablespace='UNDOTBS1' SCOPE=SPFILE SID='TEST11';\ncreate undo tablespace UNDOTBS2 datafile  size 102400K  AUTOEXTEND ON MAXSIZE UNLIMITED\n2024-11-27T10:40:06.594880+01:00\nCompleted: create undo tablespace UNDOTBS2 datafile  size 102400K  AUTOEXTEND ON MAXSIZE UNLIMITED\n2024-11-27T10:40:06.726472+01:00\nALTER SYSTEM SET undo_tablespace='UNDOTBS2' SCOPE=SPFILE SID='TEST12';\n2024-11-27T10:40:06.735353+01:00\nALTER SYSTEM RESET undo_tablespace SCOPE=SPFILE SID='*';\n<\/pre>\n<\/br>\n\n\n\n
In the alert log we can find the new redo log group creation for the additional instance.<\/p>\n\n\n\n
\noracle@node0:\/u01\/app\/odaorabase\/oracle\/diag\/rdbms\/test1\/TEST11\/trace\/ [TEST11] grep -i \"alter database add logfile\" alert_TEST11.log\nalter database add logfile thread 2 group 4 size 4294967296\nCompleted: alter database add logfile thread 2 group 4 size 4294967296\nalter database add logfile thread 2 group 5 size 4294967296\nCompleted: alter database add logfile thread 2 group 5 size 4294967296\nalter database add logfile thread 2 group 6 size 4294967296\nCompleted: alter database add logfile thread 2 group 6 size 4294967296\n\noracle@node0:\/u01\/app\/odaorabase\/oracle\/diag\/rdbms\/test1\/TEST11\/trace\/ [TEST11] vi alert_TEST11.log\n...\n...\n...\n2024-11-27T10:34:46.267851+01:00\nCJQ0 started with pid=67, OS id=69666\nalter database add logfile thread 2 group 4 size 4294967296\n2024-11-27T10:34:49.541664+01:00\nCompleted: alter database add logfile thread 2 group 4 size 4294967296\nalter database add logfile thread 2 group 5 size 4294967296\n2024-11-27T10:34:52.100314+01:00\nCompleted: alter database add logfile thread 2 group 5 size 4294967296\nalter database add logfile thread 2 group 6 size 4294967296\n2024-11-27T10:34:55.037728+01:00\nCompleted: alter database add logfile thread 2 group 6 size 4294967296\n<\/pre>\n<\/br>\n\n\n\n
Check that TEST1 database is now a RAC database<\/h2>\n\n\n\n
Let’s check that TEST1 database is now a RAC database.<\/p>\n\n\n\n
The database is opened READ\/WRITE.<\/p>\n\n\n\n
\noracle@node0:~\/ [rdbms1900] TEST11\n\n ******************************************************\n INSTANCE_NAME   : TEST11\n DB_NAME         : TEST1\n DB_UNIQUE_NAME  : TEST1\n STATUS          : OPEN READ WRITE\n LOG_MODE        : ARCHIVELOG\n USERS\/SESSIONS  : Normal: 0\/0, Oracle-maintained: 2\/6\n DATABASE_ROLE   : PRIMARY\n FLASHBACK_ON    : NO\n FORCE_LOGGING   : YES\n VERSION         : 19.23.0.0.0\n NLS_LANG        : AMERICAN_AMERICA.UTF8\n CDB_ENABLED     : NO\n ******************************************************\n Statustime: 2024-11-27 10:45:40\n<\/pre>\n<\/br>\n\n\n\n
We now have 2 instances for the databases, with name db_unique_name[1-2], one running on each node.<\/p>\n\n\n\n
\noracle@node0:~\/ [TEST11] ps -ef | grep -i [p]mon | grep -i test1\noracle   92045     1  0 10:41 ?        00:00:00 ora_pmon_TEST11\noracle@node0:~\/ [TEST11]\n\noracle@node1:~\/ [rdbms192300_a] ps -ef | grep -i [p]mon | grep -i test\noracle    6721     1  0 10:41 ?        00:00:00 ora_pmon_TEST12\noracle@node1:~\/ [rdbms192300_a]\n\noracle@node0:~\/ [TEST11] srvctl status database -d TEST1\nInstance TEST11 is running on node node0\nInstance TEST12 is running on node node1\n<\/pre>\n<\/br>\n\n\n\n
The grid infra configuration hast been updated with additional instance.<\/p>\n\n\n\n
\noracle@node0:~\/ [TEST11] srvctl config database -d TEST1\nDatabase unique name: TEST1\nDatabase name: TEST1\nOracle home: \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_5\nOracle user: oracle\nSpfile: \/u02\/app\/oracle\/oradata\/TEST1\/dbs\/spfileTEST1.ora\nPassword file: \/u02\/app\/oracle\/oradata\/TEST1\/\/orapwTEST1\nDomain: swisslos.local\nStart options: open\nStop options: immediate\nDatabase role: PRIMARY\nManagement policy: AUTOMATIC\nServer pools:\nDisk Groups:\nMount point paths: \/u01\/app\/odaorahome\nServices:\nType: RAC\nStart concurrency:\nStop concurrency:\nOSDBA group: dba\nOSOPER group: dbaoper\nDatabase instances: TEST11,TEST12\nConfigured nodes: node0,node1\nCSS critical: no\nCPU count: 0\nMemory target: 0\nMaximum memory: 0\nDefault network number for database services:\nDatabase is administrator managed\noracle@node0:~\/ [TEST11]\n<\/pre>\n<\/br>\n\n\n\n
As we can see, we will need to fine tue “Password file” and “Mount point paths”.<\/p>\n\n\n\n
I also checked that cluster_database parameter is now set to TRUE and for 2 instances. I also confirmed the datafile, logfile and tempfile are still the one expected in the respective ACFS file systems.<\/p>\n\n\n\n
\noracle@node0:~\/ [TEST11] sqh\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Wed Nov 27 10:50:34 2024\nVersion 19.23.0.0.0\n\nCopyright (c) 1982, 2023, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.23.0.0.0\n\nSQL> select inst_id, name, value from gv$parameter where name='cluster_database';\n\n   INST_ID NAME                 VALUE\n---------- -------------------- --------------------\n         1 cluster_database     TRUE\n         2 cluster_database     TRUE\n\nSQL> select name from v$datafile;\n\nNAME\n------------------------------------------------------------------------------------------------------------------------\n\/u02\/app\/oracle\/oradata\/TEST1\/TEST1\/datafile\/o1_mf_system_mncsk8kf_.dbf\n\/u02\/app\/oracle\/oradata\/TEST1\/TEST1\/datafile\/o1_mf_undotbs2_mnft7oh9_.dbf\n\/u02\/app\/oracle\/oradata\/TEST1\/TEST1\/datafile\/o1_mf_sysaux_mncslcxc_.dbf\n\/u02\/app\/oracle\/oradata\/TEST1\/TEST1\/datafile\/o1_mf_undotbs1_mncslvbn_.dbf\n\/u02\/app\/oracle\/oradata\/TEST1\/TEST1\/datafile\/o1_mf_users_mnct7fwn_.dbf\n\nSQL> select member from v$logfile;\n\nMEMBER\n------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\n\/u04\/app\/oracle\/redo\/TEST1\/onlinelog\/o1_mf_3_mncsngg8_.log\n\/u04\/app\/oracle\/redo\/TEST1\/onlinelog\/o1_mf_2_mncsngdv_.log\n\/u04\/app\/oracle\/redo\/TEST1\/onlinelog\/o1_mf_1_mncsngbc_.log\n\/u04\/app\/oracle\/redo\/TEST1\/onlinelog\/o1_mf_4_mnfsxpww_.log\n\/u04\/app\/oracle\/redo\/TEST1\/onlinelog\/o1_mf_5_mnfsxsls_.log\n\/u04\/app\/oracle\/redo\/TEST1\/onlinelog\/o1_mf_6_mnfsxw39_.log\n\n6 rows selected.\n\nSQL> select name from v$tempfile;\n\nNAME\n--------------------------------------------------------------------------------\n\/u02\/app\/oracle\/oradata\/TEST1\/TEST1\/datafile\/o1_mf_temp_mncso2l7_.tmp\n\nSQL>\n<\/pre>\n<\/br>\n\n\n\n
And the files are existing in the appropriate folder. All good!<\/p>\n\n\n\n
\noracle@node0:~\/ [TEST11] ls -ltrh \/u02\/app\/oracle\/oradata\/TEST1\/TEST1\/datafile\/\ntotal 2.6G\n-rw-r----- 1 oracle asmadmin  5.1M Nov 27 10:41 o1_mf_users_mnct7fwn_.dbf\n-rw-r----- 1 oracle asmadmin  101M Nov 27 10:41 o1_mf_undotbs2_mnft7oh9_.dbf\n-rw-r----- 1 oracle asmadmin  284M Nov 27 10:52 o1_mf_temp_mncso2l7_.tmp\n-rw-r----- 1 oracle asmadmin  1.1G Nov 27 10:52 o1_mf_system_mncsk8kf_.dbf\n-rw-r----- 1 oracle asmadmin  101M Nov 27 10:52 o1_mf_undotbs1_mncslvbn_.dbf\n-rw-r----- 1 oracle asmadmin 1011M Nov 27 10:52 o1_mf_sysaux_mncslcxc_.dbf\n\noracle@node0:~\/ [TEST11] ls -ltrh \/u04\/app\/oracle\/redo\/TEST1\/onlinelog\/\ntotal 25G\n-rw-r----- 1 oracle asmadmin 4.1G Nov 27 10:34 o1_mf_5_mnfsxsls_.log\n-rw-r----- 1 oracle asmadmin 4.1G Nov 27 10:41 o1_mf_2_mncsngdv_.log\n-rw-r----- 1 oracle asmadmin 4.1G Nov 27 10:41 o1_mf_3_mncsngg8_.log\n-rw-r----- 1 oracle asmadmin 4.1G Nov 27 10:41 o1_mf_4_mnfsxpww_.log\n-rw-r----- 1 oracle asmadmin 4.1G Nov 27 10:41 o1_mf_6_mnfsxw39_.log\n-rw-r----- 1 oracle asmadmin 4.1G Nov 27 10:52 o1_mf_1_mncsngbc_.log\noracle@node0:~\/ [TEST11]\n\noracle@node0:~\/ [TEST11] ls -ltrh \/u04\/app\/oracle\/redo\/TEST1\/controlfile\/\ntotal 11M\n-rw-r----- 1 oracle asmadmin 11M Nov 27 11:23 o1_mf_mncsnfst_.ctl\n<\/pre>\n<\/br>\n\n\n\n
Check TEST2 database<\/h2>\n\n\n\n
I also checked and ensure that nothing was modified for the other TEST2 database running in the same oracle dbhome.<\/p>\n\n\n\n
\noracle@node0:~\/ [TEST11] TEST2\n\n ******************************************************\n INSTANCE_NAME   : TEST2\n DB_NAME         : TEST2\n DB_UNIQUE_NAME  : TEST2\n STATUS          : OPEN READ WRITE\n LOG_MODE        : ARCHIVELOG\n USERS\/SESSIONS  : Normal: 0\/0, Oracle-maintained: 2\/6\n DATABASE_ROLE   : PRIMARY\n FLASHBACK_ON    : NO\n FORCE_LOGGING   : YES\n VERSION         : 19.23.0.0.0\n NLS_LANG        : AMERICAN_AMERICA.UTF8\n CDB_ENABLED     : NO\n ******************************************************\n Statustime: 2024-11-27 11:18:49\n\noracle@node0:~\/ [TEST2] ps -ef | grep -i [p]mon | grep -i test2\noracle   89478     1  0 Nov26 ?        00:00:04 ora_pmon_TEST2\noracle@node0:~\/ [TEST2]\n\noracle@node1:~\/ [rdbms192300_a] ps -ef | grep -i [p]mon | grep -i test2\noracle@node1:~\/ [rdbms192300_a]\n\noracle@node0:~\/ [TEST2] srvctl status database -d TEST2\nInstance TEST2 is running on node node0\noracle@node0:~\/ [TEST2]\n\noracle@node0:~\/ [TEST2] srvctl config database -d TEST2\nDatabase unique name: TEST2\nDatabase name: TEST2\nOracle home: \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_5\nOracle user: oracle\nSpfile: \/u02\/app\/oracle\/oradata\/TEST2\/dbs\/spfileTEST2.ora\nPassword file: \/u02\/app\/oracle\/oradata\/TEST2\/dbs\/orapwTEST2\nDomain: swisslos.local\nStart options: open\nStop options: immediate\nDatabase role: PRIMARY\nManagement policy: AUTOMATIC\nServer pools:\nDisk Groups: DATA\nMount point paths: \/u01\/app\/odaorahome,\/u02\/app\/oracle\/oradata\/TEST2,\/u03\/app\/oracle\/,\/u01\/app\/odaorabase0,\/u01\/app\/odaorabase1\nServices:\nType: SINGLE\nOSDBA group: dba\nOSOPER group: dbaoper\nDatabase instance: TEST2\nConfigured nodes: node0,node1\nCSS critical: no\nCPU count: 0\nMemory target: 0\nMaximum memory: 0\nDefault network number for database services:\nDatabase is administrator managed\noracle@node0:~\/ [TEST2]\n\noracle@node0:~\/ [TEST2] ls -ltrh \/u02\/app\/oracle\/oradata\/TEST2\/TEST2\/datafile\/\ntotal 2.5G\n-rw-r----- 1 oracle asmadmin 5.1M Nov 26 16:50 o1_mf_users_mncv7rhb_.dbf\n-rw-r----- 1 oracle asmadmin 252M Nov 26 22:06 o1_mf_temp_mnctonly_.tmp\n-rw-r----- 1 oracle asmadmin  96M Nov 27 11:20 o1_mf_undotbs1_mnctmgrj_.dbf\n-rw-r----- 1 oracle asmadmin 1.1G Nov 27 11:20 o1_mf_system_mnctkw20_.dbf\n-rw-r----- 1 oracle asmadmin 1.1G Nov 27 11:20 o1_mf_sysaux_mnctlzhd_.dbf\n\noracle@node0:~\/ [TEST2] ls -ltrh \/u04\/app\/oracle\/redo\/TEST2\/onlinelog\/\ntotal 13G\n-rw-r----- 1 oracle asmadmin 4.1G Nov 26 16:44 o1_mf_2_mncto2qz_.log\n-rw-r----- 1 oracle asmadmin 4.1G Nov 26 16:44 o1_mf_3_mncto2s1_.log\n-rw-r----- 1 oracle asmadmin 4.1G Nov 27 11:21 o1_mf_1_mncto2nv_.log\n\noracle@node0:~\/ [TEST2] ls -ltrh \/u04\/app\/oracle\/redo\/TEST2\/controlfile\/\ntotal 11M\n-rw-r----- 1 oracle asmadmin 11M Nov 27 11:21 o1_mf_mncto22y_.ctl\n\noracle@node0:~\/ [TEST2] sqh\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Wed Nov 27 11:21:34 2024\nVersion 19.23.0.0.0\n\nCopyright (c) 1982, 2023, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.23.0.0.0\n\nSQL> select inst_id, name, value from gv$parameter where name='cluster_database';\n\n   INST_ID NAME                 VALUE\n---------- -------------------- --------------------\n         1 cluster_database     FALSE\n\nSQL> select name from v$datafile;\n\nNAME\n------------------------------------------------------------------------------------------------------------------------\n\/u02\/app\/oracle\/oradata\/TEST2\/TEST2\/datafile\/o1_mf_system_mnctkw20_.dbf\n\/u02\/app\/oracle\/oradata\/TEST2\/TEST2\/datafile\/o1_mf_sysaux_mnctlzhd_.dbf\n\/u02\/app\/oracle\/oradata\/TEST2\/TEST2\/datafile\/o1_mf_undotbs1_mnctmgrj_.dbf\n\/u02\/app\/oracle\/oradata\/TEST2\/TEST2\/datafile\/o1_mf_users_mncv7rhb_.dbf\n\nSQL> select name from v$tempfile;\n\nNAME\n------------------------------------------------------------------------------------------------------------------------\n\/u02\/app\/oracle\/oradata\/TEST2\/TEST2\/datafile\/o1_mf_temp_mnctonly_.tmp\n\nSQL> select member from v$logfile;\n\nMEMBER\n------------------------------------------------------------------------------------------------------------------------\n\/u04\/app\/oracle\/redo\/TEST2\/onlinelog\/o1_mf_3_mncto2s1_.log\n\/u04\/app\/oracle\/redo\/TEST2\/onlinelog\/o1_mf_2_mncto2qz_.log\n\/u04\/app\/oracle\/redo\/TEST2\/onlinelog\/o1_mf_1_mncto2nv_.log\n<\/pre>\n<\/br>\n\n\n\n
Change grid infra password file for converted TEST1 database<\/h2>\n\n\n\n
As we could see in the checks, the grid infra password file is using a password file coming from the conversion, and not stored in the appropriate subdirectory.<\/p>\n\n\n\n
The conversion has created new password file.<\/p>\n\n\n\n
\noracle@node0:\/u02\/app\/oracle\/oradata\/TEST1\/ [TEST11] ls -ltrh\ntotal 224K\ndrwx------ 2 root   root      64K Nov 26 16:14 lost+found\ndrwxr-x--- 3 oracle asmadmin  20K Nov 26 16:15 TEST1\ndrwxrwx--- 2 oracle oinstall  20K Nov 26 16:26 arc10\ndrwxr-x--- 2 oracle oinstall  20K Nov 26 16:27 dbs\n-rw-r----- 1 oracle oinstall 2.0K Nov 27 10:41 orapwTEST1\n<\/pre>\n<\/br>\n\n\n\n
Let’s confirm previous password file still exists.<\/p>\n\n\n\n
\noracle@node0:\/u02\/app\/oracle\/oradata\/TEST1\/ [TEST11] ls -ltrh \/u02\/app\/oracle\/oradata\/TEST1\/dbs\/orapwTEST1\n-rw-r----- 1 oracle asmadmin 2.0K Nov 26 16:17 \/u02\/app\/oracle\/oradata\/TEST1\/dbs\/orapwTEST1\n<\/pre>\n<\/br>\n\n\n\n
I then updated the value in the grid infra.<\/p>\n\n\n\n
\noracle@node0:\/u02\/app\/oracle\/oradata\/TEST1\/ [TEST11] srvctl config database -d TEST1 | grep -i Password\nPassword file: \/u02\/app\/oracle\/oradata\/TEST1\/\/orapwTEST1\n\noracle@node0:\/u02\/app\/oracle\/oradata\/TEST1\/ [TEST11] srvctl modify database -d TEST1 -pwfile \/u02\/app\/oracle\/oradata\/TEST1\/dbs\/orapwTEST1\n\noracle@node0:\/u02\/app\/oracle\/oradata\/TEST1\/ [TEST11] srvctl config database -d TEST1 | grep -i Password\nPassword file: \/u02\/app\/oracle\/oradata\/TEST1\/dbs\/orapwTEST1\n<\/pre>\n<\/br>\n\n\n\n
Change grid infra mount point paths for converted TEST1 database<\/h2>\n\n\n\n
All ACFS databases mount paths should be added to the grid infra again for dependencies.<\/p>\n\n\n\n
Here are the list of the ACFS File System database will be using.<\/p>\n\n\n\n
\noracle@node1:~\/ [rdbms192300_a] df -h \/u01\/app\/odaorahome\nFilesystem               Size  Used Avail Use% Mounted on\n\/dev\/asm\/orahome_sh-446   80G   30G   51G  37% \/u01\/app\/odaorahome\n\noracle@node1:~\/ [rdbms192300_a] df -h \/u02\/app\/oracle\/oradata\/TEST1\nFilesystem             Size  Used Avail Use% Mounted on\n\/dev\/asm\/dattest1-446  100G  3.0G   98G   3% \/u02\/app\/oracle\/oradata\/TEST1\n\noracle@node1:~\/ [rdbms192300_a] df -h \/u03\/app\/oracle\/\nFilesystem         Size  Used Avail Use% Mounted on\n\/dev\/asm\/reco-348  7.5T   18G  7.5T   1% \/u03\/app\/oracle\n\noracle@node1:~\/ [rdbms192300_a] df -h \/u04\/app\/oracle\/redo\nFilesystem         Size  Used Avail Use% Mounted on\n\/dev\/asm\/redo-195  240G   93G  148G  39% \/u04\/app\/oracle\/redo\n\noracle@node1:~\/ [rdbms192300_a] df -h \/u01\/app\/odaorabase0\nFilesystem               Size  Used Avail Use% Mounted on\n\/dev\/asm\/odabase_n0-446  100G   11G   90G  11% \/u01\/app\/odaorabase0\n\noracle@node1:~\/ [rdbms192300_a] df -h \/u01\/app\/odaorabase1\nFilesystem               Size  Used Avail Use% Mounted on\n\/dev\/asm\/odabase_n1-446  100G  3.4G   97G   4% \/u01\/app\/odaorabase1\n<\/pre>\n<\/br>\n\n\n\n
I then updated grid infra mount point paths value.<\/p>\n\n\n\n
\noracle@node0:\/u02\/app\/oracle\/oradata\/TEST1\/ [TEST11] srvctl config database -d TEST1 | grep -i Mount\nMount point paths: \/u01\/app\/odaorahome\n\noracle@node0:\/u02\/app\/oracle\/oradata\/TEST1\/ [TEST11] srvctl modify database -d TEST1 -acfspath \"\/u01\/app\/odaorahome,\/u02\/app\/oracle\/oradata\/TEST1,\/u03\/app\/oracle,\/u04\/app\/oracle\/redo,\/u01\/app\/odaorabase0,\/u01\/app\/odaorabase1\"\n\noracle@node0:\/u02\/app\/oracle\/oradata\/TEST1\/ [TEST11] srvctl config database -d TEST1 | grep -i Mount\nMount point paths: \/u01\/app\/odaorahome,\/u02\/app\/oracle\/oradata\/TEST1,\/u03\/app\/oracle\/,\/u04\/app\/oracle\/redo\/,\/u01\/app\/odaorabase0,\/u01\/app\/odaorabase1\n<\/pre>\n<\/br>\n\n\n\n
Final check and database restart<\/h2>\n\n\n\n
I did some final grid infra configuration checks.<\/p>\n\n\n\n
\noracle@node0:\/u02\/app\/oracle\/oradata\/TEST1\/ [TEST11] srvctl config database -d TEST1\nDatabase unique name: TEST1\nDatabase name: TEST1\nOracle home: \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_5\nOracle user: oracle\nSpfile: \/u02\/app\/oracle\/oradata\/TEST1\/dbs\/spfileTEST1.ora\nPassword file: \/u02\/app\/oracle\/oradata\/TEST1\/dbs\/orapwTEST1\nDomain: swisslos.local\nStart options: open\nStop options: immediate\nDatabase role: PRIMARY\nManagement policy: AUTOMATIC\nServer pools:\nDisk Groups:\nMount point paths: \/u01\/app\/odaorahome,\/u02\/app\/oracle\/oradata\/TEST1,\/u03\/app\/oracle\/,\/u04\/app\/oracle\/redo\/,\/u01\/app\/odaorabase0,\/u01\/app\/odaorabase1\nServices:\nType: RAC\nStart concurrency:\nStop concurrency:\nOSDBA group: dba\nOSOPER group: dbaoper\nDatabase instances: TEST11,TEST12\nConfigured nodes: node0,node1\nCSS critical: no\nCPU count: 0\nMemory target: 0\nMaximum memory: 0\nDefault network number for database services:\nDatabase is administrator managed\n<\/pre>\n<\/br>\n\n\n\n
And I tested the database restart with oracle restart.<\/p>\n\n\n\n
\noracle@node0:~\/ [TEST11] srvctl status database -d TEST1\nInstance TEST11 is running on node node0\nInstance TEST12 is running on node node1\n\noracle@node0:~\/ [TEST11] srvctl stop database -d TEST1\n\noracle@node0:~\/ [TEST11] srvctl status database -d TEST1\nInstance TEST11 is not running on node node0\nInstance TEST12 is not running on node node1\n\noracle@node0:~\/ [TEST11] ps -ef | grep -i [p]mon | grep -i test1\noracle@node0:~\/ [TEST11]\n\noracle@node1:~\/ [TEST12] ps -ef | grep -i [p]mon | grep -i test\noracle@node1:~\/ [TEST12]\n\noracle@node0:~\/ [TEST11] TEST11\n\n *************************\n INSTANCE_NAME   : TEST11\n STATUS          : DOWN\n *************************\n Statustime: 2024-11-27 11:15:51\n\noracle@node1:~\/ [TEST12] TEST12\n\n *************************\n INSTANCE_NAME   : TEST12\n STATUS          : DOWN\n *************************\n Statustime: 2024-11-27 11:16:01\n\noracle@node0:~\/ [TEST11] srvctl start database -d TEST1\n\noracle@node0:~\/ [TEST11] srvctl status database -d TEST1\nInstance TEST11 is running on node node0\nInstance TEST12 is running on node node1\n\noracle@node0:~\/ [TEST11] ps -ef | grep -i [p]mon | grep -i test1\noracle   60785     1  0 11:16 ?        00:00:00 ora_pmon_TEST11\noracle@node0:~\/ [TEST11]\n\noracle@node1:~\/ [TEST12] ps -ef | grep -i [p]mon | grep -i test\noracle   83531     1  0 11:16 ?        00:00:00 ora_pmon_TEST12\noracle@node1:~\/ [TEST12]\n\noracle@node0:~\/ [TEST11] TEST11\n\n ******************************************************\n INSTANCE_NAME   : TEST11\n DB_NAME         : TEST1\n DB_UNIQUE_NAME  : TEST1\n STATUS          : OPEN READ WRITE\n LOG_MODE        : ARCHIVELOG\n USERS\/SESSIONS  : Normal: 0\/0, Oracle-maintained: 2\/6\n DATABASE_ROLE   : PRIMARY\n FLASHBACK_ON    : NO\n FORCE_LOGGING   : YES\n VERSION         : 19.23.0.0.0\n NLS_LANG        : AMERICAN_AMERICA.UTF8\n CDB_ENABLED     : NO\n ******************************************************\n Statustime: 2024-11-27 11:17:48\n\noracle@node1:~\/ [TEST12] TEST12\n\n ******************************************************\n INSTANCE_NAME   : TEST12\n DB_NAME         : TEST1\n DB_UNIQUE_NAME  : TEST1\n STATUS          : OPEN READ WRITE\n LOG_MODE        : ARCHIVELOG\n USERS\/SESSIONS  : Normal: 0\/0, Oracle-maintained: 2\/6\n DATABASE_ROLE   : PRIMARY\n FLASHBACK_ON    : NO\n FORCE_LOGGING   : YES\n VERSION         : 19.23.0.0.0\n NLS_LANG        : AMERICAN_AMERICA.UTF8\n CDB_ENABLED     : NO\n ******************************************************\n Statustime: 2024-11-27 11:17:59\n<\/pre>\n<\/br>\n\n\n\n
Update ODA metadata<\/h2>\n\n\n\n
I checked ODA metadata and could see that database is still referred as a SI database.<\/p>\n\n\n\n
\n[root@node0 ~]# odacli list-dbhomes\nID                                       Name                 DB Version           DB Edition Home Location                                            Status\n---------------------------------------- -------------------- -------------------- ---------- -------------------------------------------------------- ----------\n03e59f95-e77f-4429-a9fc-466bea89545b     OraDB19000_home4     19.23.0.0.240416     EE         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_4     CONFIGURED\n1c6059a2-f6c7-4bca-a07a-8efc0757ed08     OraDB19000_home5     19.23.0.0.240416     EE         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_5     CONFIGURED\n\n[root@node0 ~]# odacli list-databases\nID                                       DB Name    DB Type  DB Version           CDB     Class    Edition  Shape    Storage  Status       DB Home ID\n---------------------------------------- ---------- -------- -------------------- ------- -------- -------- -------- -------- ------------ ----------------------------------------\n2d824a9f-735a-4e8d-b6c8-5393ddc894e9     DBSI6       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n0393d997-50aa-4511-b5b9-c4ff2da393db     DBGI3       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n712d542e-ded7-4d1a-9b9d-7c335042ffc0     DAWHT       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n28026894-0c2d-417b-b11a-d76516805247     DBSI1       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n11a12489-2483-4f8a-bb60-7145417181a1     DBSI4       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\ncd183219-3daa-4154-b4a4-41b92d4f8155     DBBI1       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\nfdfe3197-223f-4660-a834-4736f50110ef     DBSI2       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n7391380b-f609-4457-be6b-bd9afa51148c     DBBI2       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\nce4350ed-e291-4815-8c43-3c6716d6402f     DBGI6       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n274e6069-b174-43fb-8625-70e1e333f160     DBSI5       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n52eadf14-4d20-4910-91ca-a335361d53b2     RCDB        SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\nec54945d-d0de-4b92-8822-2bd0d31fe653     DBSI3       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n95420f39-db33-4c4d-8d85-a5f8d42945e6     DBBI3       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\nb7c42ea7-6eab-4b98-8ea7-8dd4ce9517a1     DBBI4       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n707251cc-f19a-4b8c-89cc-63477c5747d0     DBGI4       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n2bbd4391-5eed-4878-b2e5-3670587527f6     DBBI6       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\nf540b5d1-c074-457a-85e2-d35240541efd     DBGI2       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n16a24733-cfba-4e75-a9ce-59b3779dc82e     DBGI1       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n4358287c-9cf0-45d4-a7e3-a59f933e86b2     TEST1       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   1c6059a2-f6c7-4bca-a07a-8efc0757ed08\n110f26e7-f9f3-412e-9443-a201d24201a0     TEST2       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   1c6059a2-f6c7-4bca-a07a-8efc0757ed08\n[root@node0 ~]#\n<\/pre>\n<\/br>\n\n\n\n
I updated ODA metadata.<\/p>\n\n\n\n
\n[root@node0 ~]# odacli update-registry -n db\n\nJob details\n----------------------------------------------------------------\n                     ID:  650c800a-823c-4e57-afcc-3a6530eb402c\n            Description:  Discover Components : db\n                 Status:  Created\n                Created:  November 27, 2024 11:26:39 AM CET\n                Message:\n\nTask Name                                Node Name                 Start Time                               End Time                                 Status\n---------------------------------------- ------------------------- ---------------------------------------- ---------------------------------------- ----------------\n\n[root@node0 ~]# odacli describe-job -i 650c800a-823c-4e57-afcc-3a6530eb402c\n\nJob details\n----------------------------------------------------------------\n                     ID:  650c800a-823c-4e57-afcc-3a6530eb402c\n            Description:  Discover Components : db\n                 Status:  Success\n                Created:  November 27, 2024 11:26:39 AM CET\n                Message:\n\nTask Name                                Node Name                 Start Time                               End Time                                 Status\n---------------------------------------- ------------------------- ---------------------------------------- ---------------------------------------- ----------------\nDiscover DBHome                          node0                 November 27, 2024 11:26:56 AM CET        November 27, 2024 11:27:02 AM CET        Success\nDiscover DBHome                          node0                 November 27, 2024 11:27:02 AM CET        November 27, 2024 11:27:07 AM CET        Success\nDiscover DB: DAWHT                       node1                 November 27, 2024 11:27:07 AM CET        November 27, 2024 11:27:19 AM CET        Success\nDiscover DB: DBBI1                       node0                 November 27, 2024 11:27:19 AM CET        November 27, 2024 11:27:32 AM CET        Success\nDiscover DB: DBBI2                       node0                 November 27, 2024 11:27:32 AM CET        November 27, 2024 11:27:45 AM CET        Success\nDiscover DB: DBBI3                       node0                 November 27, 2024 11:27:45 AM CET        November 27, 2024 11:27:58 AM CET        Success\nDiscover DB: DBBI4                       node1                 November 27, 2024 11:27:58 AM CET        November 27, 2024 11:28:10 AM CET        Success\nDiscover DB: DBBI6                       node0                 November 27, 2024 11:28:10 AM CET        November 27, 2024 11:28:26 AM CET        Success\nDiscover DB: DBGI1                       node0                 November 27, 2024 11:28:26 AM CET        November 27, 2024 11:28:38 AM CET        Success\nDiscover DB: DBGI2                       node0                 November 27, 2024 11:28:38 AM CET        November 27, 2024 11:28:50 AM CET        Success\nDiscover DB: DBGI3                       node0                 November 27, 2024 11:28:50 AM CET        November 27, 2024 11:29:02 AM CET        Success\nDiscover DB: DBGI4                       node1                 November 27, 2024 11:29:02 AM CET        November 27, 2024 11:29:14 AM CET        Success\nDiscover DB: DBGI6                       node0                 November 27, 2024 11:29:14 AM CET        November 27, 2024 11:29:30 AM CET        Success\nDiscover DB: DBSI1                       node0                 November 27, 2024 11:29:30 AM CET        November 27, 2024 11:29:42 AM CET        Success\nDiscover DB: DBSI2                       node0                 November 27, 2024 11:29:42 AM CET        November 27, 2024 11:29:54 AM CET        Success\nDiscover DB: DBSI3                       node0                 November 27, 2024 11:29:54 AM CET        November 27, 2024 11:30:06 AM CET        Success\nDiscover DB: DBSI4                       node1                 November 27, 2024 11:30:07 AM CET        November 27, 2024 11:30:18 AM CET        Success\nDiscover DB: DBSI5                       node1                 November 27, 2024 11:30:19 AM CET        November 27, 2024 11:30:30 AM CET        Success\nDiscover DB: DBSI6                       node0                 November 27, 2024 11:30:30 AM CET        November 27, 2024 11:30:43 AM CET        Success\nDiscover DB: RCDB                        node0                 November 27, 2024 11:30:43 AM CET        November 27, 2024 11:31:01 AM CET        Success\nDiscover DB: TEST1                       node0                 November 27, 2024 11:31:01 AM CET        November 27, 2024 11:31:15 AM CET        Success\nDiscover DB: TEST2                       node0                 November 27, 2024 11:31:15 AM CET        November 27, 2024 11:31:29 AM CET        Success\n\n[root@node0 ~]#\n<\/pre>\n<\/br>\n\n\n\n
I could confirm that all is good now. TEST1 database is seen as a RAC database.<\/p>\n\n\n\n
\n[root@node0 ~]# odacli list-databases\nID                                       DB Name    DB Type  DB Version           CDB     Class    Edition  Shape    Storage  Status       DB Home ID\n---------------------------------------- ---------- -------- -------------------- ------- -------- -------- -------- -------- ------------ ----------------------------------------\n712d542e-ded7-4d1a-9b9d-7c335042ffc0     DAWHT       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\ncd183219-3daa-4154-b4a4-41b92d4f8155     DBBI1       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n7391380b-f609-4457-be6b-bd9afa51148c     DBBI2       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n95420f39-db33-4c4d-8d85-a5f8d42945e6     DBBI3       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\nb7c42ea7-6eab-4b98-8ea7-8dd4ce9517a1     DBBI4       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n2bbd4391-5eed-4878-b2e5-3670587527f6     DBBI6       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n16a24733-cfba-4e75-a9ce-59b3779dc82e     DBGI1       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\nf540b5d1-c074-457a-85e2-d35240541efd     DBGI2       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n0393d997-50aa-4511-b5b9-c4ff2da393db     DBGI3       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n707251cc-f19a-4b8c-89cc-63477c5747d0     DBGI4       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\nce4350ed-e291-4815-8c43-3c6716d6402f     DBGI6       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n28026894-0c2d-417b-b11a-d76516805247     DBSI1       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\nfdfe3197-223f-4660-a834-4736f50110ef     DBSI2       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\nec54945d-d0de-4b92-8822-2bd0d31fe653     DBSI3       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n11a12489-2483-4f8a-bb60-7145417181a1     DBSI4       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n274e6069-b174-43fb-8625-70e1e333f160     DBSI5       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n2d824a9f-735a-4e8d-b6c8-5393ddc894e9     DBSI6       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n52eadf14-4d20-4910-91ca-a335361d53b2     RCDB        SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   03e59f95-e77f-4429-a9fc-466bea89545b\n4358287c-9cf0-45d4-a7e3-a59f933e86b2     TEST1       RAC      19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   1c6059a2-f6c7-4bca-a07a-8efc0757ed08\n110f26e7-f9f3-412e-9443-a201d24201a0     TEST2       SI       19.23.0.0.240416     false   OLTP     EE       odb1     ACFS     CONFIGURED   1c6059a2-f6c7-4bca-a07a-8efc0757ed08\n[root@node0 ~]#\n<\/pre>\n<\/br>\n\n\n\n
To wrap up<\/h2>\n\n\n\n
As we can see it is quite easy to convert a Single Instance database to a RAC database on an ODA. There is few rconfig template xml parameters that need some attention to ensure there will be no dataloss. I would strongly recommend to test it first on a TEST database, created just for this test purpose.<\/p>\n","protected":false},"excerpt":{"rendered":"
In this article, I will show you how to convert a SI (Single Instance) database to a RAC database on an ODA using rconfig. Of course this is only possible with the ODA 2-HA model as it comes with a 2 nodes cluster. There is no way to do RAC database on the ODA light […]<\/p>\n","protected":false},"author":48,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[2567,96,535],"type_dbi":[],"class_list":["post-36050","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oda-2","tag-oracle","tag-rac"],"acf":[],"yoast_head":"\nConvert Single Instance database to RAC on an ODA - 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\/convert-single-instance-database-to-rac-on-an-oda\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Convert Single Instance database to RAC on an ODA\" \/>\n<meta property=\"og:description\" content=\"In this article, I will show you how to convert a SI (Single Instance) database to a RAC database on an ODA using rconfig. Of course this is only possible with the ODA 2-HA model as it comes with a 2 nodes cluster. There is no way to do RAC database on the ODA light […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/convert-single-instance-database-to-rac-on-an-oda\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-12-02T15:54:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-02T15:54:42+00:00\" \/>\n<meta name=\"author\" content=\"Marc Wagner\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Marc Wagner\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 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\/convert-single-instance-database-to-rac-on-an-oda\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/convert-single-instance-database-to-rac-on-an-oda\/\"},\"author\":{\"name\":\"Marc Wagner\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628\"},\"headline\":\"Convert Single Instance database to RAC on an ODA\",\"datePublished\":\"2024-12-02T15:54:39+00:00\",\"dateModified\":\"2024-12-02T15:54:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/convert-single-instance-database-to-rac-on-an-oda\/\"},\"wordCount\":1129,\"commentCount\":0,\"keywords\":[\"oda\",\"Oracle\",\"RAC\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/convert-single-instance-database-to-rac-on-an-oda\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/convert-single-instance-database-to-rac-on-an-oda\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/convert-single-instance-database-to-rac-on-an-oda\/\",\"name\":\"Convert Single Instance database to RAC on an ODA - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2024-12-02T15:54:39+00:00\",\"dateModified\":\"2024-12-02T15:54:42+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/convert-single-instance-database-to-rac-on-an-oda\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/convert-single-instance-database-to-rac-on-an-oda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/convert-single-instance-database-to-rac-on-an-oda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Convert Single Instance database to RAC on an ODA\"}]},{\"@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\/225d9884b8467ead9a872823acb14628\",\"name\":\"Marc Wagner\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"caption\":\"Marc Wagner\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/marc-wagner\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Convert Single Instance database to RAC on an ODA - 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\/convert-single-instance-database-to-rac-on-an-oda\/","og_locale":"en_US","og_type":"article","og_title":"Convert Single Instance database to RAC on an ODA","og_description":"In this article, I will show you how to convert a SI (Single Instance) database to a RAC database on an ODA using rconfig. Of course this is only possible with the ODA 2-HA model as it comes with a 2 nodes cluster. There is no way to do RAC database on the ODA light […]","og_url":"https:\/\/www.dbi-services.com\/blog\/convert-single-instance-database-to-rac-on-an-oda\/","og_site_name":"dbi Blog","article_published_time":"2024-12-02T15:54:39+00:00","article_modified_time":"2024-12-02T15:54:42+00:00","author":"Marc Wagner","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Marc Wagner","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/convert-single-instance-database-to-rac-on-an-oda\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/convert-single-instance-database-to-rac-on-an-oda\/"},"author":{"name":"Marc Wagner","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628"},"headline":"Convert Single Instance database to RAC on an ODA","datePublished":"2024-12-02T15:54:39+00:00","dateModified":"2024-12-02T15:54:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/convert-single-instance-database-to-rac-on-an-oda\/"},"wordCount":1129,"commentCount":0,"keywords":["oda","Oracle","RAC"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/convert-single-instance-database-to-rac-on-an-oda\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/convert-single-instance-database-to-rac-on-an-oda\/","url":"https:\/\/www.dbi-services.com\/blog\/convert-single-instance-database-to-rac-on-an-oda\/","name":"Convert Single Instance database to RAC on an ODA - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2024-12-02T15:54:39+00:00","dateModified":"2024-12-02T15:54:42+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/convert-single-instance-database-to-rac-on-an-oda\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/convert-single-instance-database-to-rac-on-an-oda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/convert-single-instance-database-to-rac-on-an-oda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Convert Single Instance database to RAC on an ODA"}]},{"@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\/225d9884b8467ead9a872823acb14628","name":"Marc Wagner","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","caption":"Marc Wagner"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/marc-wagner\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/36050","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\/48"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=36050"}],"version-history":[{"count":32,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/36050\/revisions"}],"predecessor-version":[{"id":36110,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/36050\/revisions\/36110"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=36050"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=36050"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=36050"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=36050"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}