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

Last updated on AUGUST 27, 2021

Applies to:

Symptoms

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

Changes

Cause

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