Oracle server instance cannot be enabled as a Publisher

Question

sqlserver 2005 sp4 ,use replication function to publisher oracle database ,meet some error ,sqlserver run on window 2003 64bit ,i have installed oracle client 64bit ,and sqlserve can use link to  access oracle ,why ?

Oracle server instance 'webdb2' cannot be enabled as a Publisher because of the following error: (Distributor Properties)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server+Management+Studio&ProdVer=9.00.5000.00&EvtSrc=Microsoft.SqlServer.Management.UI.ConfigureWizardErrorSR&EvtID=OraclePublisherValidateFailed&LinkId=20476

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

OLE DB provider 'OraOLEDB.ORACLE' for linked server '(null)' returned data that does not match expected data length for column '[OraOLEDB.ORACLE].'ALL''. The (maximum) expected data length is 64, while the returned data length is 6. (.Net SqlClient Data Provider)

---

houbin

Answer 1

Did you follow steps listed under 'Configuring an Oracle Publisher' in books online? Oracle version should be 8.0.5 or above, and need enterprise edition of sql2k5.

Answer 2

thank you for reply .  oracle client version is 10.2.0.1 sqlserver 2k5 is    enterprise edition .

it  can connect oracleserver use sqlplus tools .

 

---

houbin

Answer 3

You followed all steps listed under 'Configuring an Oracle Publisher' in books online?

Answer 4

您好，

请参考：如何在 SQL 服务器中设置到 Oracle 的链接服务器并进行故障排除.

 

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.