Search This Blog

Total Pageviews

Sunday 5 October 2014

PRVF-0002 Could not retrieve local nodename

PRVF-0002 Could not retrieve local nodename




Oracle Database: PRVF-0002 Could not retrieve local nodename

Cause: Unable to determine local host name using Java network functions. 
Action: Ensure hostname is defined correctly using the 'hostname' command.


Change your hosts file as following , restart your network services and try installer again 


[root@ora-gold1 ~]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.0.27 ora-gold1 ora-gold1



ORA-21561: OID generation failed

ORA-21561: OID generation failed


[oracle@ora-golden2 admin]$ sqlplus 'sys/vihaan@stdy as sysdba'

SQL*Plus: Release 12.1.0.2.0 Production on Sun Oct 5 12:49:22 2014

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

ERROR:
ORA-21561: OID generation failed

I have no idea why I am getting above error ..


on Oracle linux 6.5 , work around is restart network services and try again 


as a root ......

[root@ora-golden2 ~]# service network restart
Shutting down interface eth0:  Device state: 3 (disconnected)
                                                           [  OK  ]
Shutting down loopback interface:                          [  OK  ]
Bringing up loopback interface:                            [  OK  ]
Bringing up interface eth0:  Active connection state: activating
Active connection path: /org/freedesktop/NetworkManager/ActiveConnection/3
state: activated
Connection activated
                                                           [  OK  ]


[root@ora-golden2 ~]# su - oracle
[oracle@ora-golden2 ~]$ sqlplus 'sys/vihaan@stdy as sysdba'

SQL*Plus: Release 12.1.0.2.0 Production on Sun Oct 5 12:49:49 2014

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

Connected to an idle instance.





Oracle DBA

anuj blog Archive