Get the App
SLTechnology News&Howtos  ›  Database  › 

19c OneNode Convert to RAC

Shulou Source: shulou.com Published: 2022-06-01 05:15:17 11月17日 Update

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

Tags: Instance status result node query Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Docker OPPO Reno Shulou Tech Info Linux MySQL