11-14-2008 10:11 AM - edited 03-15-2019 02:33 PM
Anyone know what this means and how to resolve.
Ran this on the Pub Server
admin:utils dbreplication status
****************************************************************************************************
This command reads and writes database information from all machines and will take quite some time...please be patient.
****************************************************************************************************
-------------------- utils dbreplication status --------------------
Status cannot be performed when replication is down on the publisher, or on a cluster with a single active node; aborting replication status check operation
Output is in file cm/trace/dbl/sdi/ReplicationStatus.110814.out
admin:
All the required services are started on the PUB and the SUB but replication status shows
0 - Initializing for both servers.
HELP
11-14-2008 10:33 AM
there is a post on the very same page just 3 rows below yours with the same issue, please look at previous posts.
IP Telephony: DBreplication Fail - Replicate_State=0
HTH
java
if this helps, please rate
11-14-2008 10:37 AM
I've already looked at that post. All of the utils dbreplication commands like repair and reset return the same error as above about replictation being down on the publisher.
How do get replication up on the publisher so that the utils debreplication commands can actually fix something?
11-14-2008 10:40 AM
start by making sure all services are running
HTH
java
if this helps, please rate
11-14-2008 10:40 AM
Hi Dave,
The only time I have seen this problem (after an upgrade) on these forums, the problem was solved by re-installing the Sub :)
Hope this helps!
Rob
11-14-2008 10:50 AM
I agree. I had these kind of problems after upgrades and basically after hours and hours on TAC, we reloaded the subscriber... and magically it worked fine then. Takes about an hour to load up the subscriber again right? easy fix.
Take note though, once you do the initial publisher install, do not change ANYTHING on the publisher until the subscriber comes up. That includes IP address, names, anything in the system.
11-14-2008 10:56 AM
Thanks for the advice. I'll try that and post back my results.
Dave
11-17-2008 10:56 AM
Just Wanted to report back the results of this problem.
Re-installing the subscriber servers DID NOT reslove this issue.
Opened a TAC Case.
Had tac use root access to clean up the following 4 files. /etc/hosts, /etc/services
the sqlhosts and rhosts files too.
After cleaning all four files of miscellaneous information, they did a UTILS DBREPLICATION STOP on each server starting with the 2 subs and then the pub. After this command ran succussfully they did a UTILS DBREPLICATION CLUSTERREST.
This process took 1.5 hours to complete. After this completed they rebooted the pub, waited 15 minutes and then rebooted sub1, waited 15 minutes and rebooted sub2.
Finally, all three servers sync'd up and now show 2 (good) for DB Replication.
Hope this will help someone else in this situation.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide