Distributor on SQL2005 Using Oracle Publisher

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Replication (2005)

Distributor on SQL2005 Using Oracle Publisher

Author

Topic

derrickgh
Starting Member

3 Posts

Posted - 2007-06-26 : 11:46:58

I AM TRYING TO SET UP A DISTRIBUTOR ON SQL SERVER 2005.

THE LAST STEP WHEN I AM TRING TO CONNECT I GET THE ERROR BELOW:

“ORACLE SERVER INSTANCE 'FOOBAR' CANNOT BE ENABLED AS A PUBLISHER BECAUSE OF THE FOLLOWING ERROR:

ADDITIONAL INFORMATION:
UNABLE TO RUN SQL*PLUS. MAKE CERTAIN THAT A CURRENT VERSION OF THE ORACLE CLIENT CODE IS INSTALLED AT THE DISTRIBUTOR. FOR ADDITIONAL INFORMATION, SEE SQL SERVER ERROR 21617 IN TROUBLESHOOTING ORACLE PUBLISHERS IN SQL SERVER BOOKS ONLINE. (MICROSOFT SQL SERVER, ERROR: 21617)”

RESEARCHING THE ERROR IT STATES TO MAKE SURE SQLPLUS IS SET UP CORRECTLY IN THE PATH. THE PATH IS CORRECT. TESTING SQL PLUS IT WORKS; AND I CAN ALSO CONNECT TO THE ORACLE DB IN BUSINESS INTELLIGENCE.

ANY HELP WOULD BE APPRECIATED.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-26 : 13:40:14

Is it on sql server? Which version of sqlplus did you install?