My Oracle Support Banner

Replication Push Job To New Db - Results In ORA-12012; ORA-23305 (Doc ID 264002.1)

Last updated on MARCH 15, 2021

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 9.2 to 10.2]
Information in this document applies to any platform.
This problem can occur on any platform.


connect repadmin/@"DBLINK-NAME"
1 declare
2 rc binary_integer;
3 begin
4 rc := sys.dbms_defer_sys.push(
5 destination=>'DATABASE-NAME'
6 , stop_on_error=>FALSE
7 , delay_seconds=>0, parallelism=>0);
8* end;
SQL> /

Here "DATABASE-NAME" is destination site and "DBLINK-NAME" is the site where you are
pushing the job.

ORA-12012: error on auto execute of job 91
ORA-23305: internal deferred RPC error: Error from shared lock release: 4
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_DEFER_SYS", line 1720
ORA-06512: at "SYS.DBMS_DEFER_SYS", line 1804
ORA-06512: at line 1




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.