Skip to content
Home » Oracle Database » How to Resolve PRVF-0002 Error Message

How to Resolve PRVF-0002 Error Message

PRVF-0002 could not retrieve local node name

First of all, I need to clarify the error codes for you. The error code PRVF-0002 (three zeros and a two) showed in OUI installation screen is actually equivalent to PRVF-00002 (four zeros and a two). And I think PRVF-0002 is a shorthand for PRVF-00002.

PRVF-0002: could not retrieve local node name
PRVF-0002: could not retrieve local node name

Reference: Oracle Database Release 12.2 Error Messages: PRVF-00001 to PRVF-10409

Let's see the content of PRVF-0002.

  • Description
  • PRVF-0002: could not retrieve local node name

  • Cause
  • The local node name could not be determined because the Java networking support functions failed to return a value.

  • Action
  • Ensure that host name is defined correctly using the 'hostname' command. On Linux machines, examine the files '/etc/sysconfig/network' and '/etc/resolv.conf' and ensure that the command 'hostname -f' succeeds.

It seems a name resolution problem, let's do some tests.

[root@ora12c-server ~]# ping $(hostname -s)
ping: unknown host ora12c-server

Oh? The DNS server failed to resolve the hostname. Let's do it by ourselves, we add an entry in /etc/hosts to solve the problem.

[root@ora12c-server ~]# vi /etc/hosts
...
10.10.10.10 ora12c-server ora12c-server.example.com

We can ping it again.

[root@ora12c-server ~]# ping $(hostname -s)
PING ora12c-server (10.10.10.10) 56(84) bytes of data.
64 bytes from ora12c-server (10.10.10.10): icmp_seq=1 ttl=64 time=0.050 ms
64 bytes from ora12c-server (10.10.10.10): icmp_seq=2 ttl=64 time=0.052 ms
...

Although we solved PRVF-0002, there're still some possible causes should be noticed:

  1. The DNS server has no record of this hostname.
  2. The DNS server is dysfunctional, maybe it's down.
  3. The network is poor or down.
  4. The DNS server is healthy but unreachable due to the wrong gateway.

Leave a Reply

Your email address will not be published. Required fields are marked *