Oracle PRKC-1002错误原因和解决方案
Jun 07, 2016 pm 04:19 PM小编在 VMware Server 1.0.8 中安装 Oracle RAC 时, 碰到到了 PRKC-1002 错误:WARNING: Error while copying directory /u01/oracle/product/10.2.0/db_1 with exclude file list null to nodes rac2. [PRKC-1002 : All the submitted commands did not exe
小编在 VMware Server 1.0.8 中安装 Oracle RAC 时, 碰到到了 PRKC-1002 错误:WARNING: Error while copying directory /u01/oracle/product/10.2.0/db_1 with exclude file list ‘null’ to nodes ‘rac2′. [PRKC-1002 : All the submitted commands did not execute successfully]
苦搜细索,最后在 Oracle 技术支持页面找到了问题的原因和解决方案:
Cause:
This is because the date on the local node is higher than the date on the remote node(s).
Solution:
To fix this, set the times of the nodes to be the same. You can do this with “ntpupdate ” to sync the dates.
其实 PRKC-1002 错误关键是解决时间同步问题,尽管我在安装 VMware-tools 之后,勾选 vmware-toolbox 的 Miscellaneous Options 选项,但 node1 的时间还是比 node2 的快十几秒。参考了一下《大话Oracle RAC》这本书,,决定选用 NTP 服务来使时间同步。 刚开始我是用 node1 来做 NTP 服务的,但做完后发现 node1 的时间还是比 node2 的快几秒,为了保守起见, 我用 node2 来做 NTP 服务。
在 node2 用 root 用记编辑 /etc/ntp.conf,加入下面这段
## add for rac
server 127.127.1.0
fudge 127.127.1.0 stratum 11
driftfile /var/lib/ntp/drift
broadcastdelay 0.008
然后在 node1 用 root 用记编辑 /etc/ntp.conf,加入下面这段
## add for rac
server 192.168.1.131 prefer
driftfile /var/lib/ntp/drift
broadcastdelay 0.008
#注意是 127.127.1.0 而不是 127.0.0.1,还有就是 192.168.1.131 是节点一的IP地址
然后在两个节点执行下面的命令使NTP服务启动
# /etc/init.d/ntpd start
若这样还不可以,那就要把安装数据库的 node1 的时间调得比 node2 慢点。

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

Solution to Windows Update prompt Error 0x8024401c error

Function to calculate the number of days between two dates in oracle

How long will Oracle database logs be kept?

The order of the oracle database startup steps is

Implementing Machine Learning Algorithms in C++: Common Challenges and Solutions

Oracle database server hardware configuration requirements

How to see the number of occurrences of a certain character in Oracle
