I have two db. One is local and other is hosted in remote server. I have same table data in both db. As i want to sync the both db, means if one table in local affeced by DDL/DNL it should automatically reflect to others.
I tried to acheive this on triggers. but throwing some error. Belo is the error.
Error starting at line : 29 in command -
insert into test_order_remote values('12345900', 'sss','iii','kkk')
Error at Command Line : 29 Column : 13
Error report -
SQL Error: ORA-12518: TNS:listener could not hand off client connection
ORA-06512: at "IQMS.TRG_TEST_ORDER_LOCAL", line 6
ORA-04088: error during execution of trigger 'IQMS.TRG_TEST_ORDER_LOCAL'
ORA-02063: preceding 3 lines from TEST_LOCAL1
ORA-06512: at "IQMS.TRG_TEST_ORDER_REMOTE", line 6
ORA-04088: error during execution of trigger 'IQMS.TRG_TEST_ORDER_REMOTE'
12518. 00000 - "TNS:listener could not hand off client connection"
*Cause: The process of handing off a client connection to another process
failed.
*Action: Turn on listener tracing and re-execute the operation. Verify
that the listener and database instance are properly configured for
direct handoff. If problem persists, call Oracle Support.
*Comment: The problem can be worked around by configuring dispatcher(s)
to specifically handle the desired presentation(s), and connecting
directly to the dispatcher, bypassing the listener.
Please provide solution to resolve this.