更改数据库实例名（生产勿操作）
单实例修改实例名单实例的数据库修改SID比力简朴，只需要修改pfile干系参数，就可以挂载数据库
RAC 更改实例名
情况阐明
#集群状态
# crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGETSTATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.DATA02.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.GRID.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.LISTENER.lsnr
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.RECOVERY.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.asm
ONLINEONLINE testosa Started
ONLINEONLINE testosb Started
ONLINEONLINE testosc Started
ora.gsd
OFFLINE OFFLINE testosa
OFFLINE OFFLINE testosb
OFFLINE OFFLINE testosc
ora.net1.network
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.ons
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINEONLINE testosa
ora.cvu
1 ONLINEONLINE testosa
ora.oc4j
1 ONLINEONLINE testosa
ora.rac_db.db
1 ONLINEONLINE testosc Open
2 ONLINEONLINE testosa Open
3 ONLINEONLINE testosb Open
ora.scan1.vip
1 ONLINEONLINE testosa
ora.testosa.vip
1 ONLINEONLINE testosa
ora.testosb.vip
1 ONLINEONLINE testosb
ora.testosc.vip
1 ONLINEONLINE testosc
#
# srvctl status database -d rac_db
Instance racdb_2 is running on node testosa
Instance racdb_3 is running on node testosb
Instance racdb_1 is running on node testosc
#
#sql查询实例相关信息
SQL> select HOST_NAME,INSTANCE_NUMBER,INSTANCE_NAME,STATUS from gv$instance order by 1;
HOST_NAME INSTANCE_NUMBER INSTANCE_NAME STATUS
--------- --------------- ------------- ------
testosa 2 racdb_2 OPEN
testosb 3 racdb_3 OPEN
testosc 1 racdb_1 OPEN
SQL>
现在需要修改为以下效果：
HOST_NAME INSTANCE_NUMBER INSTANCE_NAME STATUS
--------- --------------- ------------- ------
testosa 1 racdb_1 OPEN
testosb 2 racdb_2 OPEN
testosc 3 racdb_3 OPEN
更改实例名步骤
修改各个节点数据库参数
-- 查看参数类型
SQL> select NAME,VALUE,ISDEFAULT,ISSES_MODIFIABLE,ISSYS_MODIFIABLE,ISINSTANCE_MODIFIABLE,ISMODIFIED,ISBASIC
2from v$parameter where name = 'instance_name';
NAME VALUE ISDEFAULT ISSES_MODIFIABLE ISSYS_MODIFIABLE ISINSTANCE_MODIFIABLE ISMODIFIED ISBASIC
------------- ------- --------- ---------------- ---------------- --------------------- ---------- -------
instance_name racdb_1 TRUE FALSE FALSE FALSE FALSE FALSE
-- 修改 INSTANCE_NAME 参数
SQL> alter system set INSTANCE_NAME='racdb_1' scope=spfile sid='racdb_2';
System altered.
SQL> alter system set INSTANCE_NAME='racdb_2' scope=spfile sid='racdb_3';
System altered.
SQL> alter system set INSTANCE_NAME='racdb_3' scope=spfile sid='racdb_1';
System altered.
-- 重启所有实例
# srvctl stop database -d rac_db
#
# srvctl start database -d rac_db
#
-- 查询实例运行状态
# srvctl status database -d rac_db
Instance racdb_1 is running on node testosa
Instance racdb_2 is running on node testosb
Instance racdb_3 is running on node testosc
#
-- sql查询实例相关信息
SQL> select HOST_NAME,INSTANCE_NUMBER,INSTANCE_NAME,STATUS from gv$instance order by 1;
HOST_NAMEINSTANCE_NUMBER INSTANCE_NAME STATUS
---------- --------------- -------------------------------- ------------------------
testosa 1 racdb_1 OPEN
testosb 2 racdb_2 OPEN
testosc 3 racdb_3 OPEN
如上可以看出参数里面修改OK了
#查询集群资源信息
# crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGETSTATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.DATA02.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.GRID.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.LISTENER.lsnr
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.RECOVERY.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.asm
ONLINEONLINE testosa Started
ONLINEONLINE testosb Started
ONLINEONLINE testosc Started
ora.gsd
OFFLINE OFFLINE testosa
OFFLINE OFFLINE testosb
OFFLINE OFFLINE testosc
ora.net1.network
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.ons
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINEONLINE testosa
ora.cvu
1 ONLINEONLINE testosb
ora.oc4j
1 ONLINEONLINE testosb
ora.rac_db.db
1 ONLINEONLINE testosc Open # 还需要修改此处信息
2 ONLINEONLINE testosa Open
3 ONLINEONLINE testosb Open
ora.scan1.vip
1 ONLINEONLINE testosa
ora.testosa.vip
1 ONLINEONLINE testosa
ora.testosb.vip
1 ONLINEONLINE testosb
ora.testosc.vip
1 ONLINEONLINE testosc
#
如上集群的信息里面，还是乱的
更新ocr信息
移除数据库注册信息
#先停止数据库
# srvctl stop database -d rac_db
#
#移除数据库注册信息
# srvctl remove database -d rac_db
Remove the database rac_db? (y/) y
#
#查询集群资源信息
# crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGETSTATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.DATA02.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.GRID.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.LISTENER.lsnr
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.RECOVERY.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.asm
ONLINEONLINE testosa Started
ONLINEONLINE testosb Started
ONLINEONLINE testosc Started
ora.gsd
OFFLINE OFFLINE testosa
OFFLINE OFFLINE testosb
OFFLINE OFFLINE testosc
ora.net1.network
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.ons
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINEONLINE testosa
ora.cvu
1 ONLINEONLINE testosb
ora.oc4j
1 ONLINEONLINE testosb
ora.scan1.vip
1 ONLINEONLINE testosa
ora.testosa.vip
1 ONLINEONLINE testosa
ora.testosb.vip
1 ONLINEONLINE testosb
ora.testosc.vip
1 ONLINEONLINE testosc
#
重新注册数据库（oracle用户操作）
$srvctl add database -d rac_db -o /oracle/app/oracle/product/11.2.0/db_1
$
#查询集群资源状态
# crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGETSTATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.DATA02.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.GRID.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.LISTENER.lsnr
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.RECOVERY.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.asm
ONLINEONLINE testosa Started
ONLINEONLINE testosb Started
ONLINEONLINE testosc Started
ora.gsd
OFFLINE OFFLINE testosa
OFFLINE OFFLINE testosb
OFFLINE OFFLINE testosc
ora.net1.network
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.ons
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINEONLINE testosa
ora.cvu
1 ONLINEONLINE testosb
ora.oc4j
1 ONLINEONLINE testosb
ora.rac_db.db
1 OFFLINE OFFLINE
ora.scan1.vip
1 ONLINEONLINE testosa
ora.testosa.vip
1 ONLINEONLINE testosa
ora.testosb.vip
1 ONLINEONLINE testosb
ora.testosc.vip
1 ONLINEONLINE testosc
#
重新注册实例信息
# srvctl add instance -d rac_db -i racdb_1 -n testosa
#
# srvctl add instance -d rac_db -i racdb_2 -n testosb
#
# srvctl add instance -d rac_db -i racdb_3 -n testosc
#
#查询集群资源状态
# crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGETSTATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.DATA02.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.GRID.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.LISTENER.lsnr
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.RECOVERY.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.asm
ONLINEONLINE testosa Started
ONLINEONLINE testosb Started
ONLINEONLINE testosc Started
ora.gsd
OFFLINE OFFLINE testosa
OFFLINE OFFLINE testosb
OFFLINE OFFLINE testosc
ora.net1.network
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.ons
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINEONLINE testosa
ora.cvu
1 ONLINEONLINE testosb
ora.oc4j
1 ONLINEONLINE testosb
ora.rac_db.db
1 OFFLINE OFFLINE
2 OFFLINE OFFLINE
3 OFFLINE OFFLINE
ora.scan1.vip
1 ONLINEONLINE testosa
ora.testosa.vip
1 ONLINEONLINE testosa
ora.testosb.vip
1 ONLINEONLINE testosb
ora.testosc.vip
1 ONLINEONLINE testosc
#
#启动数据库
# srvctl start database -d rac_db
#
#查询集群资源状态
# crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGETSTATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.DATA02.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.GRID.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.LISTENER.lsnr
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.RECOVERY.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.asm
ONLINEONLINE testosa Started
ONLINEONLINE testosb Started
ONLINEONLINE testosc Started
ora.gsd
OFFLINE OFFLINE testosa
OFFLINE OFFLINE testosb
OFFLINE OFFLINE testosc
ora.net1.network
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.ons
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINEONLINE testosa
ora.cvu
1 ONLINEONLINE testosb
ora.oc4j
1 ONLINEONLINE testosb
ora.rac_db.db
1 ONLINEONLINE testosa Open
2 ONLINEONLINE testosb Open
3 ONLINEONLINE testosc Open
ora.scan1.vip
1 ONLINEONLINE testosa
ora.testosa.vip
1 ONLINEONLINE testosa
ora.testosb.vip
1 ONLINEONLINE testosb
ora.testosc.vip
1 ONLINEONLINE testosc
#
查抄实例名
#数据库查询
SQL> select HOST_NAME,INSTANCE_NUMBER,INSTANCE_NAME,STATUS from gv$instance order by 1;
HOST_NAMEINSTANCE_NUMBER INSTANCE_NAME STATUS
---------- --------------- -------------------------------- ------------------------
testosa 1 racdb_1 OPEN
testosb 2 racdb_2 OPEN
testosc 3 racdb_3 OPEN
SQL>
#集群资源查询
# crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGETSTATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.DATA02.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.GRID.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.LISTENER.lsnr
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.RECOVERY.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.asm
ONLINEONLINE testosa Started
ONLINEONLINE testosb Started
ONLINEONLINE testosc Started
ora.gsd
OFFLINE OFFLINE testosa
OFFLINE OFFLINE testosb
OFFLINE OFFLINE testosc
ora.net1.network
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.ons
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINEONLINE testosa
ora.cvu
1 ONLINEONLINE testosb
ora.oc4j
1 ONLINEONLINE testosb
ora.rac_db.db
1 ONLINEONLINE testosa Open
2 ONLINEONLINE testosb Open
3 ONLINEONLINE testosc Open
ora.scan1.vip
1 ONLINEONLINE testosa
ora.testosa.vip
1 ONLINEONLINE testosa
ora.testosb.vip
1 ONLINEONLINE testosb
ora.testosc.vip
1 ONLINEONLINE testosc
#
参考资料
https://blog.csdn.net/weixin_42405705/article/details/116328072
https://blog.csdn.net/weixin_39992199/article/details/116328076
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。
页:
[1]