变更目的,将数据库对外提供访问的从5239变更为5336
操作大致步骤:
1、更改dmdcr_cfg.ini中配置
2、更改dm.ini配置
3、停止所有数据库进程重新初始化dcr、vote加载新配置
4、启动所有进程完成变更
1)更改dmdcr_cfg.ini和dm.ini中数据库端口为5336,更改前先导出dcr配置信息备份
使用dmasmcmd工具导出dcr配置
ASM>export dcrdisk '/dev/dm/asm-dmdcr' to '/home/dmdba/dmdcr_cfg.ini.bak'
ASMCMD export DCRDISK success.
Used time: 3.592(ms)
2)修改配置,grp_dsc组的DCR_EP_PORT修改为5336,dm.ini的port_num修改为5336
当两个配置文件端口不一致时,以DCR_EP_PORT的端口为准。
3)停止数据库所有进程,重新加载dcr配置
[dmdba@localhost ~]$ dmasmcmd
DMASMCMD V8
ASM>init dcrdisk '/dev/dm/asm-dmdcr' from '/home/dmdba/dsc_config/dmdcr_cfg.ini' identified by 'dameng123'
[TRACE]DG 126 alloc one extent for inodes, addr(disk_id, disk_auno, extent_no):(0,0,1).
[TRACE]DG 126 allocate 4 extents for file 0xfe000002.
[TRACE]DG 126 alloc 4 extents for 0xfe000002, addr(disk_id, disk_auno, extent_no):(0, 0, 2)->(0, 0, 5), need_init = 1.
Used time: 00:00:09.838.
ASM>init votedisk '/dev/dm/asm-dmvote' from '/home/dmdba/dsc_config/dmdcr_cfg.ini'
[TRACE]DG 125 alloc one extent for inodes, addr(disk_id, disk_auno, extent_no):(0,0,1).
[TRACE]DG 125 allocate 4 extents for file 0xfd000002.
[TRACE]DG 125 alloc 4 extents for 0xfd000002, addr(disk_id, disk_auno, extent_no):(0, 0, 2)->(0, 0, 5), need_init = 1.
Used time: 00:00:09.822.
4)启动所有进程查看端口