[oracle@wndb1 ~]$ srvctl config db
wndb
[oracle@wndb1 ~]$ srvctl status db -d wndb
Instance wndb1 is running on node wndb1
Instance wndb2 is running on node wndb2
创建pfile文件
SQL> create pfile='/home/oracle/pfile.ora' from spfile;
File created.
关闭数据库
[oracle@wndb1 ~]$ srvctl stop db -d wndb -o immediate
[oracle@wndb1 ~]$ srvctl status db -d wndb
Instance wndb1 is not running on node wndb1
Instance wndb2 is not running on node wndb2
修改参数文件实例前缀
wndb1 -> orcl1
wndb2 -> orcl2
启动orcl1实例
export ORACLE_SID=orcl1
sqlplus / as sysdba
startup nomount pfile='/home/oracle/pfile.ora'
创建spfile
create spfile='+datadg/wndb/spfileorcl.ora' from pfile='/home/oracle/pfile.ora';
shutdown abort
ORACLE instance shut down.
[oracle@wndb1 dbs]$ srvctl status db -d wndb
Instance orcl1 is running on node wndb1
Instance orcl2 is running on node wndb2
SQL> select instance_name,status from gv$instance;
INSTANCE_NAME STATUS
---------------- ------------
orcl1 OPEN
orcl2 OPEN
修改实例名称wndb -> orcl当前实例状态检查[oracle@wndb1 ~]$ srvctl config dbwndb[oracle@wndb1 ~]$ srvctl status db -d wndbInstance wndb1 is running on node wndb1Instance wndb2 is running on node wndb2创建pf...