Convert Oracle RAConeNode to RAC 19c, Database is administrator managed

This article explains the steps to convert an existing Oracle database 19c (19.9) RAConeNode to RAC 2 Nodes on Oracle Linux 8u2.

Steps:

• Check Configuration of the database RAConeNode
• Convert the database type from RACONENODE to RAC
• Create a new instance on node 2
• Start the new instance

What we have:

Oracle RAConeNode Database 19.9 on Oracle Linux 8u2.

Steps:

Step 1: Check Configuration of the database RAConeNode

$ srvctl config database -d orcl
 Database unique name: orcl
 Database name: orcl
 Oracle home: /u01/app/oracle/product/19c/dbhome_1
 Oracle user: oracle
 Spfile: +DATA/ORCL/PARAMETERFILE/spfile.272.1077272417
 Password file: +DATA/ORCL/PASSWORD/pwdorcl.256.1077270987
 Domain: 
 Start options: open
 Stop options: immediate
 Database role: PRIMARY
 Management policy: AUTOMATIC
 Server pools: 
 Disk Groups: FRA,DATA
 Mount point paths: 
 Services: orcl_srv
 Type: RACOneNode
 Online relocation timeout: 30
 Instance name prefix: orcl1
 Candidate servers: host01
 OSDBA group: dba
 OSOPER group: oper
 Database instances: orcl1_1
 CSS critical: no
 CPU count: 0
 Memory target: 0
 Maximum memory: 0
 Default network number for database services: 
 Database is administrator managed

Step 2: Convert the database type from RACONENODE to RAC

$  srvctl convert database -db orcl -dbtype rac

Note: Now we should create a new instance to be RAC 2 nodes

Step 3: Create a new instance on node 2

$ srvctl add instance -db orcl -instance orcl2 -node host02

Step 4: Check Configuration for RAC 2 nodes,

$ srvctl config database -d orcl
 Database unique name: orcl
 Database name: orcl
 Oracle home: /u01/app/oracle/product/19c/dbhome_1
 Oracle user: oracle
 Spfile: +DATA/ORCL/PARAMETERFILE/spfile.272.1077272417
 Password file: +DATA/ORCL/PASSWORD/pwdorcl.256.1077270987
 Domain: 
 Start options: open
 Stop options: immediate
 Database role: PRIMARY
 Management policy: AUTOMATIC
 Server pools: 
 Disk Groups: FRA,DATA
 Mount point paths: 
 Services: orcl_srv
 Type: RAC
 Start concurrency: 
 Stop concurrency: 
 OSDBA group: dba
 OSOPER group: oper
 Database instances: orcl1,orcl2
 Configured nodes: host01,host02
 CSS critical: no
 CPU count: 0
 Memory target: 0
 Maximum memory: 0
 Default network number for database services: 
 Database is administrator managed

Step 5: Start the instance:

$ srvctl start instance -db orcl -instance orcl2

Enjoy 😉