Search This Blog

Total Pageviews

Sunday, 5 October 2014

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.





No comments:

Oracle DBA

anuj blog Archive