暂无图片
暂无图片
5
暂无图片
暂无图片
暂无图片

oracle学习之-exadata修改存储节点dns

原创 游湖 2022-12-17
498

Change the DNS Server on Oracle Exadata Storage Server
This procedure describes how to change the DNS server on Oracle Exadata Storage
Servers.
1. Log in to the Oracle Exadata Storage Server as the root user.
2. Specify a time interval to repair the disk and bring it back online.
The default DISK_REPAIR_TIME attribute value of 3.6 hours should be long enough
for most environments.
a. Check the repair time for all mounted disk groups.
Log in to the Oracle ASM instance and run the following query:
SQL> SELECT dg.name,a.value FROM v$asm_diskgroup dg, v$asm_attribute \
a WHERE dg.group_number=a.group_number AND a.name='disk_repair_time';
b. Adjust the DISK_REPAIR_TIME parameter, if needed.
In the following command, h.n is the amount of time in hours, such as 4.6.
SQL> ALTER DISKGROUP DATA SET ATTRIBUTE 'DISK_REPAIR_TIME'='h.nH';
3. Check that putting the grid disks offline will not cause a problem for Oracle ASM.
cellcli -e list griddisk attributes name,asmmodestatus,asmdeactivationoutcome
The value Yes should be returned for the grid disks. If one or more disks does not
return a Yes value, then restore data redundancy for the disk group, and repeat the
command until all disk groups return a Yes value.
4. Inactivate all grid disks on the cell.
# cellcli -e alter griddisk all inactive
This command may take more than 10 minutes to complete. Inactivating the grid
disks automatically sets the disk to offline in the Oracle ASM instance.
5. Confirm the grid disks are offline.
a. Check the status of the grid disks.
# cellcli -e list griddisk attributes name, asmmodestatus, \
asmdeactivationoutcome
The output should show asmmodestatus=OFFLINE or asmmodestatus=UNUSED, and
asmdeactivationoutcome=Yes for all grid disks.
b. List the grid disk to confirm that they are offline.
# cellcli -e list griddisk
6. Shut down the cell services and ocrvottargetd service.
# cellcli -e alter cell shutdown services all
# service ocrvottargetd stop
7. Use the ipconf utility to change the DNS settings.
# /usr/local/bin/ipconf
8. Restart the cell services and ocrvottargetd service.
# service ocrvottargetd start
# cellcli -e alter cell startup services all
The server does not need to reboot.
9. Activate the grid disks when the cell comes online.
# cellcli -e alter griddisk all active
10. Verify the disks are active.
# cellcli -e list griddisk
The output should show active.
11. Verify the grid disk status.
a. Check that all grid disks are online.
# cellcli -e list griddisk attributes name, asmmodestatus
b. Wait for Oracle ASM synchronization to complete for all grid disks.
Each disk will go to a SYNCING state first then ONLINE.
The following is an example of the output:
DATA_CD_00_dm01cel01 ONLINE
DATA_CD_01_dm01cel01 SYNCING
DATA_CD_02_dm01cel01 OFFLINE
DATA_CD_03_dm01cel01 OFFLINE
DATA_CD_04_dm01cel01 OFFLINE
DATA_CD_05_dm01cel01 OFFLINE
DATA_CD_06_dm01cel01 OFFLINE
DATA_CD_07_dm01cel01 OFFLINE
DATA_CD_08_dm01cel01 OFFLINE
DATA_CD_09_dm01cel01 OFFLINE
DATA_CD_10_dm01cel01 OFFLINE
DATA_CD_11_dm01cel01 OFFLINE
Oracle ASM synchronization is complete when all grid disks show
asmmodestatus=ONLINE.
12. Repeat this procedure for each Oracle Exadata Storage Server.

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论