SQL 2008 R2, Oracle 10g Snapshot Publication

• johnwcurry

  SSC Journeyman

  Points: 83

  More actions

  April 4, 2015 at 10:28 am

  #98860

  I have created a distribution agent for Oracle 10G in SQL 2008 R2 Replication. I can add my Oracle 10G as a publisher to the Distributor: it logs in, and I am able to select my tables.

  However, the initial snapshot fails.

  ===================================

  The agent could not be started. (View Snapshot Agent Status)

  ------------------------------

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1&EvtSrc=Microsoft.SqlServer.Management.UI.ReplUtilitiesErrorSR&EvtID=CantStartAgent&LinkId=20476

  ===================================

  An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

  ------------------------------

  Program Location:

  at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

  at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand)

  at Microsoft.SqlServer.Replication.ReplicationObject.ExecCommand(String commandIn)

  at Microsoft.SqlServer.Replication.Publication.StartSnapshotGenerationAgentJob()

  at Microsoft.SqlServer.Management.UI.SnapshotAgentStatus.StartAgent()

  at Microsoft.SqlServer.Management.UI.AgentStatusControl.WorkerThreadProc()

  ===================================

  SQLServerAgent is not currently running so it cannot be notified of this action.

  Changed database context to 'distribution'. (.Net SqlClient Data Provider)

  ------------------------------

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.6000&EvtSrc=MSSQLServer&EvtID=22022&LinkId=20476

  ------------------------------

  Server Name: GW-DEVSQLXFER

  Error Number: 22022

  Severity: 16

  State: 1

  ------------------------------

  Program Location:

  at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)

  at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)