Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • useful dg links Oracle
  • sbind.sql Find Bind variable from sql_id sqlid Oracle
  • Very clear article about oracle dataguard Oracle
  • OPENING A STANDBY DATABASE IN READ-ONLY MODE Oracle
  • Facts about SCN and Rollback Segment Oracle
  • Caching sequence in Memory Oracle
  • temp_use.sql diplays usage of temp ts Oracle
  • cold backup scripts to copy locally Linux/Unix
  • Getting started with notebook Python/PySpark
  • reset Sequence Oracle
  • Example of How To Resize the Online Redo Logfiles Note:1035935.6 Oracle
  • How to connect to Oracle Database with Wallet with Python. Oracle
  • oracle tips… from http://www.bijoos.com/oracle/douknow.htm Oracle
  • Windows based Command line mailing program like mailx (Sednmail for windows) PHP/MYSQL/Wordpress
  • Load SPM baseline from AWR 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

  • Temporary tablespace explaination Oracle
  • Implementing Listener Security Oracle
  • sid_wise_cursor.sql find open cursor basis on username or SID Oracle
  • Alter procedure auditing Oracle
  • Reclaim temp tablespace for oracle 8, 8i Oracle
  • 276434.1 Modifying the VIP or VIP Hostname of a 10g or 11g Oracle Clusterware Node 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
  • find_du.ksh to find # of files, their sizes in current folder and its subdolder Linux/Unix
  • Find_table_size.sql Oracle
  • How to find who is using which Rollback segment and how many rows or blocks in that rollback segments, Oracle
  • ORA-1841 Error Connecting to Upgraded Database After Set PASSWORD_LIFE_TIME Oracle
  • DBMS_JOB all example Oracle
  • Load SPM baseline from AWR Oracle
  • Find Plan Hash value fphv.sql Oracle
  • findobj.sql Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme