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 :)

[INS-35172] Target database memory (XXXMB) exceeds the systems available shared memory ({0} MB) solution

If you receives the above error while installation of Oracle database, Please follow as below.

You are trying to use the MEMORY_TARGET feature. This feature requires the /dev/shm filesystem to be mounted for at least maximum size than you specified at the time of installation. 

df -h /dev/shm will show you the current size of your shared memory file system.

[oracle@node1 Desktop]$ df -h /dev/shm

Filesystem            Size  Used Avail Use% Mounted on

tmpfs                 504M  272K  503M   1% /dev/shm

The size of this file is the real size of the key control AMM.  Modify the size of the tmpfs greater than the size of MEMORY_TARGET. Modify the /etc/fstab file  like below.

To adjust the shared memory file system size issue the following commands, specifying the required size of shared memory. However this is temporary

# umount tmpfs
# mount -t tmpfs shmfs -o size=2G /dev/shm

Make the setting permanent by amending the "tmpfs" setting of the "/etc/fstab" file to look like this.
After the above change if you check shared memory file system value will effect like below.

[oracle@node1 Desktop]$ df -h /dev/shm

Filesystem            Size  Used Avail Use% Mounted on

tmpfs                     2G  272K  2G   1% /dev/shm

Before:

*******

[root@node1 ~]# cat /etc/fstab

#

# /etc/fstab

# Created by anaconda on Sat Jan 10 19:24:12 2015

#

# Accessible filesystems, by reference, are maintained under '/dev/disk'

# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info

#

/dev/mapper/vg_node1-lv_root /                       ext4    defaults        1 1

UUID=510fd298-43dc-419d-a3ae-829e999d2430 /boot                   ext4    defaults        1 2

/dev/mapper/vg_node1-lv_swap swap                    swap    defaults        0 0

tmpfs                   /dev/shm                tmpfs   defaults        0 0

devpts                  /dev/pts                devpts  gid=5,mode=620  0 0

sysfs                   /sys                    sysfs   defaults        0 0

proc                    /proc                   proc    defaults        0 0

After:

*****

[root@node1 ~]# cat /etc/fstab

#

# /etc/fstab

#Created by anaconda on Sat Jan 10 19:24:12 2015

#

# Accessible filesystems, by reference, are maintained under '/dev/disk'

# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info

#

/dev/mapper/vg_node1-lv_root /                       ext4    defaults        1 1

UUID=510fd298-43dc-419d-a3ae-829e999d2430 /boot                   ext4    defaults        1 2

/dev/mapper/vg_node1-lv_swap swap                    swap    defaults        0 0

tmpfs                   /dev/shm                tmpfs   defaults,size=2G  0 0

devpts                  /dev/pts                devpts  gid=5,mode=620  0 0

sysfs                   /sys                    sysfs   defaults        0 0

proc                    /proc                   proc    defaults        0 0

To avoid reboot after editing /etc/fstab you can do:

umount tmpfs
mount -a

Happy Learning :)