SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


THE PROCESS COULD NOT CONNECT TO A SUBSCRIBER


THE PROCESS COULD NOT CONNECT TO A SUBSCRIBER

Author
Message
Cynthia Bell-281986
Cynthia Bell-281986
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 97
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.
Chris Becker
Chris Becker
SSC-Addicted
SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)

Group: General Forum Members
Points: 404 Visits: 268
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



Cynthia Bell-281986
Cynthia Bell-281986
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 97
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'.
timilehin2g
timilehin2g
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 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
SQL ADMIN 79
SQL ADMIN 79
SSC Veteran
SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)

Group: General Forum Members
Points: 259 Visits: 638
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.

[font=Arial]Prakash Bhojegowda MCSE, MCSA (SQL2012)[/font]
mark.servidio
mark.servidio
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 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)
---------------------------------------------------------------------------------------------------------------
mark.servidio
mark.servidio
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 48
Here is my error message as well:
The process could not connect to Subscriber 'OracleServer'.
mcssnt
mcssnt
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 66
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search