How to solve Oracle Database Error 21561 (ora-21561)

Oracle Error Code
   ora-21561

Description
   OID generation failed

Cause
   The handles passed in may not be valid
How to Solve
   Check the validity of the env, svc handles
Posts About Oracle Database Error ORA-21602
Neha Aggarwal:
I am facing error :-ORA-21561: OID generation failed , 
while running any script on the server(aix , n orcale10g) 
whereas no issue is coming in accessing database.

James Baxter:
I am facing the same problem. Instance crashes at random

Jone Rever:
Did you resolve this issue? I'm facing this issue too. Thanks

James:
yes, it was the client problem server was fine

Jude:
There is new type of issue we are facing here.
This first time  when i connect from my application server i am getting this error.
BUt the second when i give directly the user name and password i am able to connnect to the server.

Think there is a problem in connection through the listener.

jsh Globus /shared/opt/globus/package4/bnk/bnk.run -->echo $ORACLE_SID
fbnkglb
jsh Globus /shared/opt/globus/package4/bnk/bnk.run -->echo $ORACLE_HOME
/shared/db/app/oracle/product/10.2.0
jsh Globus /shared/opt/globus/package4/bnk/bnk.run -->sqlplus xmluser/xmluser@fbnkglb

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Jan 11 17:52:15 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

ERROR:
ORA-21561: OID generation failed


Enter user-name: xmluser
Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

Only the 2nd time I give the user name and password I am able to connect


Do you have question or do you know about solution ?

Share with us. (No registration required)
  
Your Name
Question, comment or solution
Similar Errors
  ORA-21500    ORA-21501    ORA-21503    ORA-21561    ORA-21600    ORA-21601    ORA-21602  Others

Main Page      Contact Us      Tools & Softwares      Server Monitoring Softwares