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.
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)
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)
0