Synchronous update of database A and database B Tables

First, configure the listener and client so that database A is the client, database B is the server, and B opens the listener for its own IP address,
A opens the customer connection channel for Bip. Www.2cto.com
Aip: 192.168.18.47
B ip Address: 192.168.18.87

Test connection:
Www.2cto.com

B. Create a table with scott

A can see the table created on B.

Grant scott the permission to establish a connection during local Login
Scott establishes a connection

Migrate data

Create a stored procedure
Create procedure pro_insert_t1
As
Begin
Insert into t1 select * from t1 @ db87 where id not in (select id from t1 );
Commit;
End;
/

Create a job to make the stored procedure run on time
One minute

Success
Add data to B and check the changes in A in one minute.

Check table t1 in database A