Friday, September 6, 2013

PRVF-4037 : CRS is not installed on any of the nodes

During the health check, we observed that has service status is showing as down in EM12C

Error as shown in the Incident Manager :

PRVF-4037 : CRS is not installed on any of the nodes,Verification cannot proceed,,,CRS integrity check failed,,Verification of CRS integrity was unsuccessful on all the specified nodes. ,NODE_STATUS::<Host>:EFAIL,OVERALL_STATUS::EFAIL

Logged in to the host as Grid owner :


[oracle@<host> ~]$  cluvfy comp ocr

Verifying OCR integrity

Checking OCR integrity...

ERROR:
PRVF-4037 : CRS is not installed on any of the nodes

Verification cannot proceed

OCR integrity check failed

Verification of OCR integrity was unsuccessful on all the specified nodes.
[oracle@<host> ~]$

Cause :


/etc/oraInst.loc was pointing to incorrect Inventory..

Solution :

Corrected the /etc/oraInst.loc and pointed it to expected ( Grid ) Inventory

[oracle@<host> ~]$  cluvfy comp ocr

Verifying OCR integrity

Checking OCR integrity...

Checking the absence of a non-clustered configuration...
All nodes free of non-clustered, local-only configurations


ASM Running check passed. ASM is running on all specified nodes

Checking OCR config file "/etc/oracle/ocr.loc"...

OCR config file "/etc/oracle/ocr.loc" check successful


Disk group for ocr location "+DA_XX" available on all the nodes


NOTE:
This check does not verify the integrity of the OCR contents. Execute 'ocrcheck' as a privileged user to verify the contents of OCR.

OCR integrity check passed

Verification of OCR integrity was successful.
[oracle@<host> ~]$

Friday, July 5, 2013

Create an Alias for [ sqlplus "/as sysdba" ]

We can use this OS utility to create an alias of the commands we use very frequently:

Here, for example :

-bash-3.00$ cat .bash_profile

alias sqllogin='sqlplus "/as sysdba"'

-bash-3.00$

-bash-3.00$ sqllogin

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jul 5 07:24:46 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

Hope this helps !!