Red Gate forums :: View topic - No schemas retrieved for comparison
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Schema Compare for Oracle Beta
Schema Compare for Oracle Beta forum

No schemas retrieved for comparison

Search in Schema Compare for Oracle Beta forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
jcossio



Joined: 10 Dec 2009
Posts: 5
Location: Colombia

PostPosted: Thu Dec 10, 2009 6:23 pm    Post subject: No schemas retrieved for comparison Reply with quote

After I put my servers details via manual connection, the schemas to compare dropdowns do not populate even after a refresh list is issued. I type the schemas manually and hit compare no button and then I get the following error:

Could not load file or assembly 'Oracle.DataAccess, version=2.111.6.0, culture=neutral,...

etc.

Do I need to install something else? how.

Thanks

George
Back to top
View user's profile Send private message
Simon C



Joined: 26 Feb 2008
Posts: 140
Location: Red Gate Software

PostPosted: Thu Dec 10, 2009 6:34 pm    Post subject: Reply with quote

It looks like you haven't installed the ODP.NET assemblies that the program requires. You can have a look here for the required client install settings; you'll need to re-run the oracle client installer and install over the top of your existing install.

SimonC
Back to top
View user's profile Send private message Send e-mail
alice.easey



Joined: 27 Feb 2008
Posts: 93
Location: Red Gate

PostPosted: Wed Dec 16, 2009 9:55 am    Post subject: Reply with quote

The latest build should allow you to connect without requiring the ODP.NET assemblies.

More info and download link here:
http://www.red-gate.com/messageboard/viewtopic.php?t=10147
Back to top
View user's profile Send private message
jcossio



Joined: 10 Dec 2009
Posts: 5
Location: Colombia

PostPosted: Wed Dec 16, 2009 1:50 pm    Post subject: Reply with quote

Thanks Alice. I was struggling to download the 487MB oracle client suggested by Simon (thanks Simon anyway). I downloaded the latest release of SC and now the schemas to compare retrieve information. But when I tell it to compare the following error comes up (after a while on "Registering database one" Populating PL/SQL text objects):

ORA-00904: "P"."OBJECT_TYPE": Invalid Identifier

And then aborts the process.

Thanks

George
Back to top
View user's profile Send private message
alice.easey



Joined: 27 Feb 2008
Posts: 93
Location: Red Gate

PostPosted: Wed Dec 16, 2009 2:14 pm    Post subject: Reply with quote

Hi George,

Thanks for trying out the latest version - I'm glad it's helped with the client issues.

It sounds like there's a malformed query somewhere. Is it possible for you to set up tracing so that it'll log the query on the server? Hopefully that'll help track down what's going on.

We're currently adding logging to the next build, which will make this process a bit easier.

Alice.
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group