PRVF-5300 : Failed to retrieve active version for CRS on this node

When i am trying to install the non-RAC database installation fails with the below error

PRVF-5300 : Failed to retrieve active version for CRS on this node

MOS DOC: Installation of Standalone (Non-RAC) 11gR2 Database Fails with Errors: "PRVF-5300, PRKC-1033, PRCT-1406" (Doc ID 1380126.1)

The issue is we have the RAC setup in past on this server and we have removed few days back. Now we are trying to install the Oracle Restart (ASM+DB) but installation failing.

Here we have identified the problem, as OCR/OLR is still present in the server due to that installation failing.  Once you removed the OCR/OLR that solves the our problem.

Check the OCR/OLR locations
[oracle@test dba]$ ls -lhrt /etc/ocr.loc
ls: /etc/ocr.loc: No such file or directory
[oracle@test dba]$ ls -lhrt /etc/oracle/olr.loc
-rw-r----- 1 root oinstall 103 Jul 22  2015 /etc/oracle/olr.loc

so, here olr is present in server level. Remove the olr disk and start the installation


Happy Learning :)

Convert RAC database from Archivelog Mode to NoArchivelog Mode

[oracle@pard15 ~]$. oraenv
ORACLE_SID = [oracle]STG1
The Oracle base has been changed from /u01/app/oracle to /u02/app/oracle
[oracle@pard15 ~]$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 10 07:12:55 2014

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +RECO
Oldest online log sequence     26114
Next log sequence to archive   26116
Current log sequence           26116
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
[oracle@pard15 ~]$srvctl status database -d STG
Instance STG1 is running on node pard15
Instance STG2 is running on node pard16
[oracle@pard15 ~]$srvctl stop database -d STG
[oracle@pard15 ~]$srvctl status database -d STG
Instance STG1 is not running on node pard15
Instance STG2 is not running on node pard16
[oracle@pard15 ~]$srvctl start instance -i STG1 -d STG -o mount
[oracle@pard15 ~]$srvctl status database -d STG
Instance STG1 is running on node pard15
Instance STG2 is not running on node pard16
[oracle@pard15 ~]$. oraenv
ORACLE_SID = [STG1] ?
The Oracle base remains unchanged with value /u02/app/oracle
[oracle@pard15 ~]$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 10 07:15:01 2014

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> select inst_id,instance_name,status from gv$instance;

   INST_ID INSTANCE_NAME    STATUS
---------- ---------------- ------------
         1       STG1           MOUNTED

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +RECO
Oldest online log sequence     26114
Next log sequence to archive   26116
Current log sequence           26116
SQL> alter database noarchivelog;

Database altered.

SQL> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            +RECO
Oldest online log sequence     26114
Current log sequence           26116
SQL> alter database open;

Database altered.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
[oracle@pard15 ~]$srvctl status database -d STG
Instance STG1 is running on node pard15
Instance STG2 is not running on node pard16
[oracle@pard15 ~]$srvctl stop instance -i STG1 -d STG
[oracle@pard15 ~]$srvctl start database -d STG
[oracle@pard15 ~]$srvctl status database -d STG
Instance STG1 is running on node pard15
Instance STG2 is running on node pard16
[oracle@pard15 ~]$. oraenv
ORACLE_SID = [STG1] ?
The Oracle base remains unchanged with value /u02/app/oracle
[oracle@pard15 ~]$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 10 07:17:57 2014

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> select inst_id,instance_name,status from gv$instance;

   INST_ID INSTANCE_NAME    STATUS
---------- ---------------- ------------
         1 STG1           OPEN
         2 STG2           OPEN

SQL> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            +RECO
Oldest online log sequence     26114
Current log sequence           26116