Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Looping for remote servers and find its database from oratab file. Linux/Unix
  • Alter procedure auditing Oracle
  • Getting started with notebook Python/PySpark
  • arch_configUOCIOTTO.ora Oracle
  • currwait.sql Oracle
  • Explain Plan Output 2 Oracle
  • Physical Standby switchover with session active Oracle
  • Sequence Resetting Oracle
  • CPU speed on Linux Linux/Unix
  • Load testing on Oracle 19C RAC with HammerDB Oracle
  • purge_trc.sh Linux/Unix
  • Goldengate document from Porus Oracle
  • Insert cause enqueue locks Oracle
  • Changing unix system clock when Oracle database is running. Oracle
  • Gather Stats manually using DBMS_STATS after disabling DBMS_SCHEDULER jobs as previous entry Oracle

339939.1 Running Cluster Verification Utility to Diagnose Install Problems

Posted on 04-Jan-2009 By Admin No Comments on 339939.1 Running Cluster Verification Utility to Diagnose Install Problems

In this Document

Purpose

Scope and Application

Running Cluster Verification Utility to Diagnose Install Problems

References

Applies to:

Oracle Server – Enterprise Edition – Version: 10.1 to 11.1

Information in this document applies to any platform.

Purpose

The purpose of this document is to enable the DBA to diagnose install failures using Cluster Verification Utility (cluvfy).

Scope and Application

This note is intended for DBAs installing Oracle Clusterware (CRS) and Oracle Real Application Cluster, which need to see if their environment is setup correctly.

Running Cluster Verification Utility to Diagnose Install Problems

CRS Software Install Failures

There are 2 options for running Cluster verification.

1. It is highly recommended to get the latest CVU (cluvfy) software from OTN.

The software can be used for Oracle 10.1, 10.2 and 11.1 installations.

Follow the readme that comes with cluvfy.

./cluvfy.sh stage -pre crsinst -n , -verbose | tee /tmp/cluvfy_preinst.log

Replace , with your actual nodenames, for example dbnode1,dbnode2

2. Make use of cluvfy if the CRS software stack is installed.

If the CRS software is installed you can find cluvfy under $ORA_CRS_HOME/bin

cd $ORA_CRS_HOME/bin

./runcluvfy.sh stage -pre crsinst -n , -verbose | tee /tmp/cluvfy_preinst.log

./cluvfy stage -post crsinst -n all -verbose | tee /tmp/cluvfy_postinst.log

Replace , with your actual nodenames, for example dbnode1,dbnode2

CVU log files can be found under $CV_HOME/cv/log directory. The CV_HOME can be $ORA_CRS_HOME/cv/log location as well as the /TMP location.

The output of CLUVFY is usefull to see what is wrong for the installation, the file created in /tmp should be uploaded to the for further analysis.

RDBMS Software Install Failures

Normally when the CRS software will install correct, the chance is small you are facing an install issue with the RDBMS software but if this is the case you can follow the above part but instead of using -pre crsinst make use of -pre dbinst, the other part of the above command can be the same, for example:

./runcluvfy.sh stage -pre dbinst -n , -verbose | tee /tmp/cluvfy_dbinst.log

./cluvfy stage -pre dbinst -n , -verbose | tee /tmp/cluvfy_dbinst.log

Collecting Information For Cluvfy Failures

In some cases cluvfy can fail. If that is the case and you can not diagnose the issue it is recommended to set the environment variable SRVM_TRACE to true and repeat the command. The output will be written to a file in $CV_HOME/cv/log directory. You may open a service request and upload the corresponding logfile to the service request.

For example:

SRVM_TRACE=true

export SRVM_TRACE

cluvfy comp ssa -n dbnode1,dbnode2 -s

References

Note 316817.1 – CLUSTER VERIFICATION UTILITY FAQ

Oracle, RAC

Post navigation

Previous Post: 751131.1 New Article Error 2819 While Requesting a Systemstate Dump
Next Post: Configure ssh authentications for RAC

Related Posts

  • My Test Case On 21-OCT-2005 Oracle
  • compile_inv.sql Oracle
  • create user with unlimited quota Oracle
  • PLSQL Table Syntax 1 Oracle
  • Find Stale DR Physical Standby Oracle
  • How to know current SID Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Move WordPress site from one hosting service to other. PHP/MYSQL/Wordpress
  • Gather Stats manually using DBMS_STATS after disabling DBMS_SCHEDULER jobs as previous entry Oracle
  • All Hints for Oracle Databases Oracle
  • Search and replace editor command in vi Linux/Unix
  • Find Multiple levels of object dependencies : depen.sql Oracle
  • How do I get Oracle to automatically start when my server boots up? Oracle
  • restarting network in linux Linux/Unix
  • Jai Shree Ram Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme