PRVF-0002: could not retrieve local node name

Hi DBA-Mates,

Today, I have come back with some issue and solution which may useful and helpful for those people who are learning oracle.

Many people ask about issue and solution regarding Installation, Patching, Cloning, Upgrade etc… So, I thought let’s start the issue and solution which I have faced in my real time experiences.

I promise you people very soon we will be back with some database patching common issues and solutions. So, let’s start for todays.

We can face this issue during the installation of oracle12c database. Actually, recently while I was installing latest 12c oracle database, I got this below error.

PRVF-0002: could not retrieve local node name

You can see it in below screen shot.

Firstly, I though as what is this new error as which I never faced in installing the oracle database either in 11g or 12c database.

For kind information, I was installing 4^th time but during the 4^th time I got this error. So, I though may be it will be useful here for others also.

It’s a very easy solution but if the people not knowing a simple thing also it is very hard to fix it.

By Default:

#hostname

Ora-data-linux

#cat /etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4

::1           localhost localhost.localdomain localhost6 localhost6.localdomain6

Make Changes as shown below:

#cat /etc/hosts

127.0.0.1   ora-data-linux ora-data-linux.localdomain localhost4 localhost4.localdomain4

::1           localhost localhost.localdomain localhost6 localhost6.localdomain6

As we observe in above solution, we just check the hostname which was not included in /etc/hosts file.

It is very simple but if not knowing or never faced it, then it will be time wasted and mind stuffy. :D means bina matlab ka dimag kharab karega :P

Here, I would like share one more issue which I found during same time. It may helpful for the people who is installing fresh oracledatabase 12c.

Especially for freshers or beginning learners, it will be very useful to fix or learning troubleshooting errors:

Please find the below screen shot:

See, here during installation of oracle database 12c, 

if in “Prerequisite Check” tab getting an error such as 

“Hard Limit:maximum open file descriptors” as FAILED 

then Click on button “Fix & Check Again” you will get a pop up as shown above screen shot.

Just need to follow the steps as shown above screen shot as:

1. Login as ROOT

2.  Run the script as

/tmp/CVU_122.1.0.2.0_SKU/runfixup.sh << this name will be changed as per your installation

3. Then Click on “Fix & check Again”. It will be fixed.

Some more useful links:

Oracle Database 12cInstallation Steps

Tablespace Concepts and Details

Crontab Concepts and Details with Example

R12.2 Concepts and Architecture

Important Scripts

Hope this may useful and helpful. For any Concerns or suggestions, Please either comment below or contact us @ora-data.blogspot.com

Thanks,