19c OneNode Convert to RAC
First, check the status
[oracle@ora19crac1 ~] $srvctl config database-d wooDatabase unique name: wooDatabase name: wooOracle home: / u01/app/oracle/product/19.3.0/dbhome_1Oracle user: oracleSpfile: + DATA_GP01/WOO/PARAMETERFILE/spfile.272.1034102483Password file: + DATA_GP01/WOO/PASSWORD/pwdwoo.256.1034100671Domain: Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools: Disk Groups: DATA_GP01Mount point paths: Services: onenode Server_tafType: RACOneNodeOnline relocation timeout: 30Instance name prefix: wooCandidate servers: ora19crac1OSDBA group: dbaOSOPER group: operDatabase instances: woo_1CSS critical: noCPU count: 0Memory target: 0Maximum memory: 0Default network number for database services: Database is administrator managed II. Convert to RAC
[oracle@ora19crac1 ~] $srvctl add instance-d woo-I woo2-n ora19crac2 3. Result after query conversion:
[oracle@ora19crac1 ~] $srvctl config database-d wooDatabase unique name: wooDatabase name: wooOracle home: / u01/app/oracle/product/19.3.0/dbhome_1Oracle user: oracleSpfile: + DATA_GP01/WOO/PARAMETERFILE/spfile.272.1034102483Password file: + DATA_GP01/WOO/PASSWORD/pwdwoo.256.1034100671Domain: Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools: Disk Groups: DATA_GP01Mount point paths: Services: onenode,server_tafType: RACStart concurrency: Stop concurrency: OSDBA group: dbaOSOPER group: operDatabase instances: woo1,woo2Configured nodes: ora19crac1 Ora19crac2CSS critical: noCPU count: 0Memory target: 0Maximum memory: 0Default network number for database services: Database is administrator managed 4. Launch Node 2 instance:
[oracle@ora19crac1 ~] $srvctl start instance-d woo-n ora19crac2 [oracle@ora19crac1 ~] $srvctl status database-d wooInstance woo1 is running on node ora19crac1Instance woo2 is running on node ora19crac2