Getting started

Compares and synchronizes Oracle data

Moderators: eddie davis, richardjm, Michael Christofides, neil.anderson

Getting started

Postby pshros » Wed Mar 27, 2013 12:34 pm

Hi,

I am new to Oracle, and have an application that uses the managed .NET provider (Oracle.ManagedDataAccess.dll v4.112.3.50). My connection string is User ID=student;Password=******;Data Source=***.***.***.**:****/ASYDB;Pooling=false;

I am trying to use Data Compare for Oracle but can get neither the TNS nor the Manual modes to connect. I get the following error below. Clearly I need to install or configure something. Any pointers?

---------------------------
Connection Initialization Error
---------------------------
Unable to connect to database ***.***.***.**(ASYDB):

Unable to load d:\\app\\Peter\\product\\11.2.0\\client_1\\oci.dll. Please check that you use 64x version of Oracle client with 64x application.



Please check you are using the correct architecture version of Data Compare, and that you are using a 9i client version or above.

If these problems persist, please enable direct connection mode in Application Options and retry.
---------------------------
OK
---------------------------
pshros
 
Posts: 1
Joined: Wed Mar 27, 2013 12:29 pm

Postby Michael Christofides » Thu Mar 28, 2013 5:10 pm

Hi,

It's possible you installed the 32-bit client on a 64-bit machine, which is fine, but requires you to use our "Data Compare for Oracle 2 (32-bit)" executable.

If not, then it would be good if you could try going to "Tools->Application Options..." in the menu, and checking the box for "Prefer direct connection". Restart the application and try again.

Let us know how you get on!

Michael Christofides
Product Manager - Oracle tools
Michael Christofides
 
Posts: 95
Joined: Wed Apr 20, 2011 6:37 pm
Location: Red Gate Software

Re: Getting started

Postby syedshah20 » Tue Sep 30, 2014 1:34 pm

I am trying to use Data Compare for Oracle but can get neither the TNS nor the Manual modes to connect. I get the following error below. Clearly I need to install or configure something. Any pointers?
sultan
syedshah20
 
Posts: 1
Joined: Tue Sep 30, 2014 1:29 pm

Re: Getting started

Postby Michael Christofides » Tue Sep 30, 2014 7:02 pm

Hi, I afraid can't see the error message you've posted.

Could you submit a support request and perhaps attach it as an image?
https://redgatesupport.zendesk.com/home

Many thanks,
Michael
Michael Christofides
 
Posts: 95
Joined: Wed Apr 20, 2011 6:37 pm
Location: Red Gate Software


Return to Data Compare for Oracle

Who is online

Users browsing this forum: No registered users and 1 guest