Error while configuring SQL 2012 DB as a Subscriber to a Oracle Publisher.

When Configuring the Subscription for Oracle as a publisher, we receive the following error message.

Msg 18757, Level 16, State 4, Procedure sp_replpostcmd, Line 1
Unable to execute procedure. The database is not published. Execute the procedure in a database that is published for replication.
The Subscriber was dropped.

"

Same message is received if add the subscription through script or through SQL Management studio.


However Oracle as a publisher has been configured successfully on a SQL 2012 DB server, Which is also the  Distribution server

using the following links. 

https://msdn.microsoft.com/en-us/library/ms151243(v=sql.110).aspx

https://msdn.microsoft.com/en-us/library/ms152481(v=sql.110).aspx

Note: Same Steps successfully work from a SQL 2008 Machine. i.e If i use SQL 2008 machine to configure Oracle as a Publisher and then subscribe to SQL 2012 machine as Subscriber.

Is there a known issue? or some extra steps for 2012 that are not documented. Any help will be much appreciated.

Client Oracle Version:9i

Subscriber DB Version: SQL Server 2012 SP2

April 16th, 2015 3:41am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics