THE PROCESS COULD NOT CONNECT TO A SUBSCRIBER

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » THE PROCESS COULD NOT CONNECT TO A SUBSCRIBER...

THE PROCESS COULD NOT CONNECT TO A SUBSCRIBER

Rate Topic

Display Mode

Topic Options

Author

Message

Cynthia Bell-281986

Posted Tuesday, December 04, 2007 12:35 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, May 31, 2013 2:45 PM
Points: 7, Visits: 82

I am receiving the following error when I try to replicate from SQL SERVER 2005 to ORACLE 9.2.0.8:

THE PROCESS COULD NOT CONNECT TO A SUBSCRIBER:'MY ORACLE DATABASE'.(Source:MSSQL_REPL,Error number:MSSQL_REPL20084)

Issue resolved after installing the Oracle driver.

Post #429499

Chris Becker

Posted Tuesday, December 04, 2007 12:56 PM

SSC Veteran

Group: General Forum Members
Last Login: Friday, February 22, 2013 11:49 AM
Points: 220, Visits: 216

Another use (dotcomboy) was having similar problem - here is his post:

dotcomboy-

I'm trying to setup a push replication from SQL 2005 to Oracle 10g and I'm getting errors. I've installed the complete 10g client along with OLEDB 10.2. I've granted complete rights to the oracle directory on the SQL server side. I can TNSPing the Oracle DB and I can connect to the DB via the Data Source (ODBC).
I've run out of ideas. Please HELP!

Here is my error from the replication monitor in SQL 2005.

Error messages:
The process could not connect to Subscriber 'TESTREP'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20084)
Get help: http://help/MSSQL_REPL20084
ORA-12154: TNS:could not resolve the connect identifier specified (Source: MSSQL_REPL_ORACLE, Error number: 12154)
Get help: http://help/12154

dotcomboy-

If anyone is interested I figured it out.

it was simply copying over the tnsnames.ora from the original Oracle client install. After I installed the OLEDB it created a new oracle home and this is where sql was looking.

Hope this helps,

ChrisB MCDBA
MSSQLConsutling.com

Post #429503

Cynthia Bell-281986

Posted Tuesday, December 04, 2007 2:02 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, May 31, 2013 2:45 PM
Points: 7, Visits: 82

I have seen this resolution but I am not getting an Oracle error. I only get the MSSQL_REPL20084 error: The process could not connect to Subscriber'RMDRTE'.

Post #429529

timilehin2g

Posted Thursday, February 14, 2008 11:08 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 14, 2008 10:58 AM
Points: 1, Visits: 1

I seem to encounter both issues i.e. the MSSQL error and the ORACLE error but after creating an environmental variable for the ORACLE_HOME, the ORACLE error has disappeared but the MSSQL error:20084 still exists, please who has a solution to this?

timi ASL

Post #455880

Prakash.Bhojegowda

Posted Wednesday, May 14, 2008 10:51 AM

SSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 1:14 PM
Points: 34, Visits: 499

I am having the same issue too. I am trying to replicate data from SQL 2005 to DB2. Gettign an error MSSQL_REPL20084.

Any help would be appreciated.

Post #500729

mark.servidio

Posted Tuesday, September 30, 2008 8:47 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, October 04, 2012 2:08 PM
Points: 4, Visits: 48

I'm having the same issue. I'm trying to replicate to Oracle 10g from a SQL 2000 instance (32 bit) on a W2K3 Server 64 bit.

When I use the OraOLEDB.Oracle Driver, I get this error:
ORA-12154: TNS:could not resolve the connect identifier specified
(Source: OraOLEDB (); Error number: 12154)
---------------------------------------------------------------------------------------------------------------

When I use the Microsoft Oracle Driver i get this error:
ORA-06413: Connection not open.
(Source: Microsoft OLE DB Provider for Oracle (); Error number: 6413)
---------------------------------------------------------------------------------------------------------------

Post #578363

mark.servidio

Posted Tuesday, September 30, 2008 9:11 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, October 04, 2012 2:08 PM
Points: 4, Visits: 48

Here is my error message as well:
The process could not connect to Subscriber 'OracleServer'.

Post #578384

mcssnt

Posted Thursday, October 25, 2012 11:57 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, November 02, 2012 11:00 PM
Points: 1, Visits: 34

Does somebody figured out something? I still having the same issue
Source: MSSQL_REPL, Error number: MSSQL_REPL20084)

Connecting a SQL 2012 in Windows 2008 R2 x64 to Oracle 11g. I have configured the Oracle driver and ODBC, it works fine in sqlplus, linked server, and SSIS.

any idea why it doesn't work in snapshot replication?

~Marcos

Post #1377182

« Prev Topic | Next Topic »

Permissions