Shulou(Shulou.com)06/01 Report--

Time synchronization between nodes is very important for Oracle, and before version 11g, time synchronization was often accomplished by setting up NTP servers. In Oracle 11g, a new CTSS (Cluster Time Synchronization Services) service was added to complete time synchronization between cluster nodes. During Grid Infrastructure installation, CTSS is automatically installed if no NTP service is found on the node.

1. NTP Time Synchronization Service Configuration

NTP is a traditional time synchronization service. There is often a dedicated time synchronization server in an enterprise. In this case, NTP can still be used to synchronize the time between nodes.

2. CTSS Time Synchronization Service Configuration

11gR2 Oracle introduced its own time synchronization service, which is only available in all nodes of a RAC and is not synchronized with other systems. If you want to use CTSS to synchronize time, in addition to stopping and disabling automatic restart of NTP service, the/etc/ntp.conf configuration file is not allowed to exist, perform the following steps to clear NTP service.

(1) Stop NTP service

/sbin/service ntpd stop

(2) Disable NTP server auto-start

chkconfig ntpd off

Delete or rename NTP profiles

rm /etc/ntp.conf

Or:

mv /etc/ntp.conf /etc/ntp.conf.bak

This eliminates NTP completely and CTSS is automatically created when Grid Infrastructure is installed.

3. CTSS check failed

The last step in installing Grid Infrastructure may result in the following error:

INFO: CTSS is in Active state. Proceeding with check of clock time offsets on all nodes...

INFO: PRVF-9661 : Time offset is NOT within the specified limits on the following nodes:

INFO: "[rhel2]"

INFO: PRVF-9652 : Cluster Time Synchronization Services check failed

INFO: Post-check for cluster services setup was unsuccessful on all the nodes.

INFO:

WARNING:

INFO: Completed Plugin named: Oracle Cluster Verification Utility

The solutions to the above errors are as follows:

1) Determine whether the time zones of all RAC nodes are consistent.

2) Too long a time interval will cause CTSS to fail. Therefore, manually adjust the host time before performing this step to ensure that the time between hosts is consistent.

2.5.9 Installing the cvuqdisk package

Step 1 Upload the installation package.

Upload Grid Infrastructure and Database installation media to/u01/soft directory using sftp. Both products contain the following 3 zip packages:

q linux.x64_11gR2_grid.zip

q linux.x64_11gR2_database_1of2.zip

q linux.x64_11gR2_database_2of2.zip

linux.x64_11gR2_grid.zip is the installation package for Grid Infrastructure, linux.x64_11gR2_database_1of2.zip and linux.x64_11gR2_database_2of2.zip are two installation packages for Database, which need to be decompressed to the same directory before installing Database to install Database correctly.

Step 2 Install cvuqdisk.

Extract the linux.x64_11gR2_grid.zip file, locate cvuqdisk-1.0.7-1.rpm in the extracted grid/rpm directory, and execute the following cvuqdisk package installation command:

#CVUQDISK_GRP=oinstall; export CVUQDISK_GRP

#rpm -ivh cvuqdisk-1.0.7-1.rpm

Transfer this file to other cluster nodes via sftp and install the package as above.

2.5.10 CVU Verification Installation Environment

It is necessary to use CVU tools to verify that your current environment is ready for Oracle RAC prior to installation. This tool can also be used to find configuration problems before performing a specific installation. Execute the following command to check the installation environment:

./ runcluvfy.sh stage -pre crsinst -n rhel1,rhel2 -fixup -verbose

……

Check: Membership of user "grid" in group "dba"

Node Name User Exists Group Exists User in Group Comment

---------- ------- ------------ ------------ ---------

rhel2 yes yes no failed

rhel1 yes yes no failed

Result: Membership check for user "grid" in group "dba" failed

……

There should be no failure in the authentication process. The above user authentication failure is because CVU tool cannot recognize the asmadmin, asmdba and asmoper groups specified for grid users. It still uses the dba operating system group as the judgment standard, so this error is reported. This error can be ignored if the grid user group is correctly set.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.