SQL Server Performance

Unable to run SQL*PLUS. Make certain that a current version of the Oracle client code is installed at the distributor.

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Jun 18, 2009.

  1. Anonymous New Member

    The error subject line is caused due to issues with Oracle Client and Networking connection privileges. By default when you have SQL replication setup to an Oracle client then the account under which SQL Server instance runs on the Distributor must be granted read and execute permissions for the directory (and all subdirectories) in which the Oracle client networking software is installed. Few times I have seen that this particular service account also requires REGISTRY permissions too and say if...(<a href="http://sqlserver-qa.net/blogs/replication/archive/2009/06/18/5776.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=5776" width="1" height="1">

Share This Page