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