Database Networking (MOSC)

MOSC Banner

ORA-21561: OID generation failed

Hello !
I have an issue on windows 2016 with Oracle 12.2. 
We are using sys_guid() function and retrieves the error ORA-21561: OID generation failed. All my 12c databases behaves the same, I have several. 

SQL> select sys_guid() from dual;
select sys_guid() from dual
*
ERROR at line 1:
ORA-21561: OID generation failed

I also have a 19.12 cdb with many pdbs, it all works well there.

Sunday I changed the listener from one 19c home to another. Same version.
We had issues with the old home so we decided to move to a new home.
No change of listener/tnsnames file for 12c databases. (assuming it is network related)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center