Sunday, October 11, 2015

How to resolve PRVF-0002: could not retrieve local node name

Introduction

In this short post I'd like to show you how to resolve error "PRVF-0002: could not retrieve local node name". When I started an Oracle 12.1.0.2 installation on Solaris x86-64 (Version [11.2] Description [SunOS 5.11]) I encountered the following error:





















Solution

First, verify that the "hostname" command returns the host name:

isrvmsol07:ora[43] /oravl01/database> hostname
isrvmsol07

Afterwards check that /etc/hosts file, and if you find out that the hostname doesn't appear for the local IP address (127.0.0.1), add the following entry to the /etc/hosts file:

127.0.0.1       isrvmsol07

Re-execute the installation and then everything should work properly:







































Conclusion

At the start of the installation Oracle performs healthcheck test for forward and reverse resolution of the host name so you can fix it by setting properly the DNS or maunally set the host IP address and name in the /etc/hosts file.

5 comments:

  1. thank you for the solution! :)

    ReplyDelete
  2. check your .bash_profile in oracle home. did you set variable setting in your profile for the folders where you are going to install oracle like

    export ORACLE_BASE=/u01/app/oracle
    export GRID_HOME=/u01/app/oracle/product/11.2.0.3/grid
    export ORACLE_HOME=$ORACLE_BASE/product/11.2.0.3/db_1
    export ORACLE_SID=orcl
    export BASE_PATH=/usr/sbin:$PATH
    export PATH=$ORACLE_HOME/bin:$BASE_PATH
    export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
    export ORACLE_HOSTNAME=ol6.localdomain
    export ORACLE_UNQNAME=orcl
    export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

    it should work.

    ReplyDelete
  3. Hi,

    Nice stuff and useful.
    Hope this may also useful for readers.

    https://ora-data.blogspot.in/2017/01/frm-92101-failure-has-occurred-on.html

    Thanks,

    ReplyDelete
  4. Hi Dibask,
    Its useful and helpful. Hope this may also useful here:

    https://ora-data.blogspot.in/2017/05/fixing-prvf-0002-could-not-retrieve.html

    Thanks,

    ReplyDelete