|
-
Originally posted by priyamvada
I see entries in deftran. I wait for 10 ,20, 30 minutes, but the propogation does not take place.
It sounds like you did a good job setting up replication but perhaps the trouble is with either 1. the dB links and/or 2. the dbms jobs.
If your database links are not perfect then replication will not work!
1. Make certain SYSTEM has a PUBLIC dB link
2. Make certain there is a private dB link for repadmin and that you specified the CONNECT TO....IDENTIFIED BY. I used other types of connect methods and it failed me (connect user and current user do NOT work).
3. test the dB links with sqlplus
4. If links are working try and manual push!!!
5. What is the next_date in dba_jobs for repl jobs????
6. Make certain the jobs are owned by repadmin.
7. Why are you waiting 10, 20, 30 minutes if your interval is 10 seconds?????? If it dows not work in 10 seconds, it's not working!!! Try making your interval 60 or 30 seconds if the biz supports it.
------
My problems with replication began with dB links. When I was certian my links were okay, my problems moved onto the dbms_jobs but I eventually saw propogation with the manual push and purge.
-------
I can tell that you are on your way to success. Repl is a pain in the a#%! but once it is working it basically works really well.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|