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 😉

Bookmark the permalink.
Loading Facebook Comments ...

Leave a Reply