修改实例名称

修改实例名称

wndb -> orcl

当前实例状态检查

[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.

修改相应节点initsid.ora

[oracle@wndb1 dbs]$ cat initwndb1.ora 
SPFILE='+DATADG/wndb/spfileorcl.ora'
[oracle@wndb2 dbs]$ cat initwndb2.ora 
SPFILE='+DATADG/wndb/spfileorcl.ora'

[oracle@wndb1 dbs]$ srvctl remove db -d wndb
[oracle@wndb1 dbs]$ srvctl add db -d wndb -o /u01/app/oracle/product/11.2.0/db_home1 -p '+DATADG/wndb/spfileorcl.ora' -r primary -a DATADG,FRADG
[oracle@wndb1 dbs]$ srvctl add instance -d wndb -i orcl1 -n wndb1
[oracle@wndb1 dbs]$ srvctl add instance -d wndb -i orcl2 -n wndb2

启动数据库

[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

修改密码文件

orapwd password='*****' file='/xxx/xxx/xxx/orapwxxx'