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

oracle rac修改服务器时间

在路上 2025-02-20
176

1.停止数据库

srvctl stop database -d csqdb

Instance csqdb1 is not running on node ceshidb01
Instance csqdb2 is not running on node ceshidb02

2.停监听

srvctl status listener

srvctl stop listener 停所有监听

Listener LISTENER is enabled
Listener LISTENER is not running

3.停crs(每个节点执行)

su - root

cd /u01/11.2.0/grid/bin/

---节点1
[root@ceshidb01 bin]# ./crsctl stop crs
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'ceshidb01'
CRS-2673: Attempting to stop 'ora.crsd' on 'ceshidb01'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'ceshidb01'
CRS-2673: Attempting to stop 'ora.OCR.dg' on 'ceshidb01'
CRS-2673: Attempting to stop 'ora.RECOC1.dg' on 'ceshidb01'
CRS-2673: Attempting to stop 'ora.DATAC1.dg' on 'ceshidb01'
CRS-2673: Attempting to stop 'ora.ceshidb01.vip' on 'ceshidb01'
CRS-2677: Stop of 'ora.RECOC1.dg' on 'ceshidb01' succeeded
CRS-2677: Stop of 'ora.DATAC1.dg' on 'ceshidb01' succeeded
CRS-2677: Stop of 'ora.ceshidb01.vip' on 'ceshidb01' succeeded
CRS-2672: Attempting to start 'ora.ceshidb01.vip' on 'ceshidb02'
CRS-2676: Start of 'ora.ceshidb01.vip' on 'ceshidb02' succeeded
CRS-2677: Stop of 'ora.OCR.dg' on 'ceshidb01' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'ceshidb01'
CRS-2677: Stop of 'ora.asm' on 'ceshidb01' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'ceshidb01'
CRS-2677: Stop of 'ora.ons' on 'ceshidb01' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'ceshidb01'
CRS-2677: Stop of 'ora.net1.network' on 'ceshidb01' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'ceshidb01' has completed
CRS-2677: Stop of 'ora.crsd' on 'ceshidb01' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'ceshidb01'
CRS-2673: Attempting to stop 'ora.evmd' on 'ceshidb01'
CRS-2673: Attempting to stop 'ora.asm' on 'ceshidb01'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'ceshidb01'
CRS-2677: Stop of 'ora.evmd' on 'ceshidb01' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'ceshidb01' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'ceshidb01' succeeded
CRS-2677: Stop of 'ora.asm' on 'ceshidb01' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'ceshidb01'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'ceshidb01' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'ceshidb01'
CRS-2677: Stop of 'ora.cssd' on 'ceshidb01' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'ceshidb01'
CRS-2677: Stop of 'ora.crf' on 'ceshidb01' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'ceshidb01'
CRS-2677: Stop of 'ora.gipcd' on 'ceshidb01' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'ceshidb01'
CRS-2677: Stop of 'ora.gpnpd' on 'ceshidb01' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'ceshidb01' has completed
CRS-4133: Oracle High Availability Services has been stopped.
--节点2
[root@ceshidb02 bin]# ./crsctl stop crs
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'ceshidb02'
CRS-2673: Attempting to stop 'ora.crsd' on 'ceshidb02'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'ceshidb02'
CRS-2673: Attempting to stop 'ora.OCR.dg' on 'ceshidb02'
CRS-2673: Attempting to stop 'ora.RECOC1.dg' on 'ceshidb02'
CRS-2673: Attempting to stop 'ora.DATAC1.dg' on 'ceshidb02'
CRS-2673: Attempting to stop 'ora.ceshidb02.vip' on 'ceshidb02'
CRS-2673: Attempting to stop 'ora.oc4j' on 'ceshidb02'
CRS-2673: Attempting to stop 'ora.cvu' on 'ceshidb02'
CRS-2677: Stop of 'ora.cvu' on 'ceshidb02' succeeded
CRS-2677: Stop of 'ora.DATAC1.dg' on 'ceshidb02' succeeded
CRS-2677: Stop of 'ora.RECOC1.dg' on 'ceshidb02' succeeded
CRS-2677: Stop of 'ora.ceshidb02.vip' on 'ceshidb02' succeeded
CRS-2673: Attempting to stop 'ora.ceshidb01.vip' on 'ceshidb02'
CRS-2677: Stop of 'ora.ceshidb01.vip' on 'ceshidb02' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'ceshidb02' succeeded
CRS-2677: Stop of 'ora.OCR.dg' on 'ceshidb02' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'ceshidb02'
CRS-2677: Stop of 'ora.asm' on 'ceshidb02' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'ceshidb02'
CRS-2677: Stop of 'ora.ons' on 'ceshidb02' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'ceshidb02'
CRS-2677: Stop of 'ora.net1.network' on 'ceshidb02' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'ceshidb02' has completed
CRS-2677: Stop of 'ora.crsd' on 'ceshidb02' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on 'ceshidb02'
CRS-2673: Attempting to stop 'ora.crf' on 'ceshidb02'
CRS-2673: Attempting to stop 'ora.ctssd' on 'ceshidb02'
CRS-2673: Attempting to stop 'ora.evmd' on 'ceshidb02'
CRS-2673: Attempting to stop 'ora.asm' on 'ceshidb02'
CRS-2677: Stop of 'ora.mdnsd' on 'ceshidb02' succeeded
CRS-2677: Stop of 'ora.crf' on 'ceshidb02' succeeded
CRS-2677: Stop of 'ora.evmd' on 'ceshidb02' succeeded
CRS-2677: Stop of 'ora.asm' on 'ceshidb02' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'ceshidb02'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'ceshidb02' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'ceshidb02' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'ceshidb02'
CRS-2677: Stop of 'ora.cssd' on 'ceshidb02' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'ceshidb02'
CRS-2677: Stop of 'ora.gipcd' on 'ceshidb02' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'ceshidb02'
CRS-2677: Stop of 'ora.gpnpd' on 'ceshidb02' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'ceshidb02' has completed
CRS-4133: Oracle High Availability Services has been stopped.

4.修改时间(两节点),时钟同步

date -s "Thu Feb 20 17:38:38 CST 2025"

hwclock -w

5.启动crs(每个节点执行)

su - root

cd /u01/11.2.0/grid/bin/

[root@ceshidb02 bin]# ./crsctl start crs

CRS-4123: Oracle High Availability Services has been started.

6.启动数据库

srvctl start database -d csqdb

srvctl status database -d csqdb

Instance csqdb1 is running on node ceshidb01
Instance csqdb2 is running on node ceshidb02

7.启动监听

srvctl start listener

Listener LISTENER is enabled
Listener LISTENER is running on node(s): ceshidb02,ceshidb01

8.查看crs

crs_stat -t

 

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

评论