Replication Push Job To New Db - Results In ORA-12012; ORA-23305
(Doc ID 264002.1)
Last updated on AUGUST 27, 2021
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.1 to 10.2.0.4 [Release 9.2 to 10.2]Information in this document applies to any platform.
This problem can occur on any platform.
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
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
Symptoms |
Changes |
Cause |
Solution |
References |