Stop the database in RAC environment:

[oracle@host01 ~]$ srvctl stop database -db orcl

Convert one Node RAC to multiple node RAC in Oracle

[oracle@host01 ~]$ srvctl convert database -db orcl -dbtype RAC

Check the status for database

[oracle@host01 ~]$ srvctl status database -db orcl

Instance orcl_2 is running on node host01

Add the instance in RAC

[oracle@host01 ~]$ srvctl stop database -db orcl

[oracle@host01 ~]$ 


[oracle@host01 ~]$ srvctl add instance -db orcl -instance orcl_1 -node host02

Start the RAC database and check the status

[oracle@host01 ~]$ srvctl start database -db orcl

[oracle@host01 ~]$ srvctl status database -db orcl

Instance orcl_1 is running on node host02

Instance orcl_2 is running on node host01

Check the configuration of RAC database

-- Check the configuration of database 


[oracle@host01 ~]$ srvctl config database -db orcl

Database unique name: orcl

Database name: orcl

Oracle home: /u01/app/oracle/product/19.3.0/dbhome_1

Oracle user: oracle

Spfile: +DATA/ORCL/PARAMETERFILE/spfile.272.1157786363

Password file: +DATA/ORCL/PASSWORD/pwdorcl.257.1157785563

Domain: 

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: 

Disk Groups: FRA,DATA

Mount point paths: 

Services: actest,srvhr,srvtest

Type: RAC

Start concurrency: 

Stop concurrency: 

OSDBA group: dba

OSOPER group: oper

Database instances: orcl_1,orcl_2

Configured nodes: host02,host01

CSS critical: no

CPU count: 0

Memory target: 0

Maximum memory: 0

Default network number for database services: 

Database is administrator managed

Move back and correct the instance name associated with host name

Change the database name and instance name if they shown different as shown below:

Change an instance name after a RAC database is created



[oracle@host01 ~]$ srvctl remove instance -db orcl -instance orcl_1 -force



[oracle@host01 ~]$ 

[oracle@host01 ~]$ srvctl remove instance -db orcl -instance orcl_2 -force

PRKO-3147 : Instance orcl_2 cannot be removed because it is the only preferred instance for service(s) actest,srvhr,srvtest for database orcl

[oracle@host01 ~]$ srvctl stop database -db orcl

[oracle@host01 ~]$ srvctl remove instance -db orcl -instance orcl_2 -force

PRKO-3147 : Instance orcl_2 cannot be removed because it is the only preferred instance for service(s) actest,srvhr,srvtest for database orcl

[oracle@host01 ~]$ srvctl remove service -db orcl -s actest

[oracle@host01 ~]$ srvctl remove service -db orcl -s srvhr

[oracle@host01 ~]$ srvctl remove service -db orcl -s srvtest

[oracle@host01 ~]$ srvctl remove instance -db orcl -instance orcl_2 -force

[oracle@host01 ~]$ srvctl add instance -db orcl -instance orcl1 -node host1

PRKO-2006 : Invalid node name: host1

[oracle@host01 ~]$ srvctl add instance -db orcl -instance orcl1 -node host01

[oracle@host01 ~]$ srvctl add instance -db orcl -instance orcl2 -node host02

[oracle@host01 ~]$ srvctl start database -db orcl





[oracle@host01 ~]$ srvctl status database -db orcl



Instance orcl1 is running on node host01

Instance orcl2 is running on node host02