1.查看状态
[oracle@rone1 ~]$ srvctl config database -d rone Database unique name: rone Database name: rone Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1 Oracle user: oracle Spfile: +DATA/rone/spfilerone.ora Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: rone Database instances: Disk Groups: DATA,CRS Mount point paths: Services: bbone Type: RACOneNode Online relocation timeout: 30 Instance name prefix: rone Candidate servers: rone1,rone2 Database is administrator managed [oracle@rone1 ~]$ srvctl status database -d rone Instance rone_1 is running on node rone1 Online relocation: INACTIVE
2.以oracle用户执行转换
[oracle@rone1 ~]$ srvctl convert database -d rone -c rac
3.添加新的实例
[oracle@rone1 ~]$ srvctl add instance -d rone -i rone_2 -n rone2
4.验证转化结果
[oracle@rone1 ~]$ srvctl config database -d rone Database unique name: rone Database name: rone Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1 Oracle user: oracle Spfile: +DATA/rone/spfilerone.ora Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: rone Database instances: rone_1,rone_2 Disk Groups: DATA,CRS Mount point paths: Services: bbone Type: RAC Database is administrator managed
要先执行转换，然后再添加实例，否则会报以下错误：
[oracle@rone1 ~]$ srvctl add instance -d rone -i rone_2 -n rone2 PRKO-2134 : 'srvctl add instance' command is not supported with RAC One Node databases [oracle@rone1 ~]$ oerr prko 2134 2134, ADD_INST_NOT_SUPPORTED_RACONE, "'srvctl add instance' command is not supported with RAC One Node databases" // *Cause: The specified database does not support 'srvctl add instance' command. // *Action: Convert the RAC One Node database to a RAC database by using the 'srvctl convert database' command and then rerun 'srvctl add instance' command.