Oracle To SQL 2005 Replication

[kgreer]

I am having issues setting up a replication to a Oracle Database. Here is the steps I do:

Attached is a video of the steps I am running.

 

[mrdenny]

You'll want to post the video on a webserver, and give it a URL to the file. The attach file box doesn't upload the file to the server.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[kgreer]

Sorry try this link

 

[kgreer]

A third time is a charm.

 

[kgreer]

Here is the error:
===================================

SQL Server could not configure 'uswnd-s-atwork2' as a Distributor. (New Publication Wizard)

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

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.ReplicationServer.InstallDistributor(String password, DistributionDatabase distributionDB)
at Microsoft.SqlServer.Management.UI.ReplicationSqlConnection.InstallDistributor(WizardInputs inputs, Boolean bScripting)
at Microsoft.SqlServer.Management.UI.PageCreatePubOraclePublisher.InstallDistributorThread()

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

Only replication jobs or job schedules can be added, modified, dropped or viewed through replication stored procedures.
Changed database context to 'master'. (.Net SqlClient Data Provider)

------------------------------
For help, click:

http://go.microsoft.com/fwlink?Prod...2&EvtSrc=MSSQLServer&EvtID=22538&LinkId=20476

------------------------------
Server Name: uswnd-s-atwork2
Error Number: 22538
Severity: 16
State: 1
Procedure: sp_MSrepl_check_job_access
Line Number: 155


------------------------------
Program Location:

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

 

[mrdenny]

I believe that the problem is that you are trying to setup the Oracle server as the distributor. The distributor needs to be a SQL Server (I'm like 99% sure on this one, I don't have an Oracle server to test with) so it'll need to be setup ahead of time.

Right click on Replication and setup the distributor on the local SQL Server. When you run through the Oracle Publication wizard select the local server as the distributor.

When you setup the local distributor make sure that you configure it to allow the Oracle server as a publisher.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[kgreer]

We have already checked this problem and everything is ok. We are following the instructions on Microsofts site. We were able to do this same configuration on our Test server.