Error when comparing databases

Early Access Program for Schema Compare for Oracle

Moderators: David Atkinson, eddie davis, richardjm, alice.easey, Tom Harris

Error when comparing databases

Postby jspibey » Thu Jan 07, 2010 1:21 pm

I'm comparing two schemas on the same database server. The server is running Oracle 10.1.0.3.0, the client is Windows 7 x64.

I am connecting to the database using a 'Manual Connection' using the same username and password for both source and target.

After pressing 'Compare now' I get an error after a few seconds (During the 'Reading object dependencies' phase which states ORA-03113: end of file on communication channel

Any ideas what might be wrong?
jspibey
 
Posts: 15
Joined: Thu Sep 28, 2006 2:25 pm

Postby alice.easey » Tue Jan 12, 2010 12:21 pm

Hello,

Thanks for your post.

We've just released a new build that includes a 'direct connection' option that connects via TCP/IP instead of through the Oracle client.

The option is in the Application Options, called "Use direct connection".

Can you give it a try and let us know if it helps with the ORA-03113?

Thanks,

Alice.
alice.easey
 
Posts: 94
Joined: Wed Feb 27, 2008 12:56 pm
Location: Red Gate

Postby jspibey » Tue Jan 12, 2010 2:19 pm

Thanks, I gave that a try and I get a little further but I still get an error

ORA-00904: "P"."OBJECT_TYPE": invalid identifier
jspibey
 
Posts: 15
Joined: Thu Sep 28, 2006 2:25 pm

Postby alice.easey » Tue Jan 12, 2010 2:34 pm

To help us track down what's going on, can you turn on logging and send us the log file?

This help file explains how to turn on logging:
http://www.red-gate.com/supportcenter/C ... ta_Compare\\knowledgebase\\logging_and_log_files.htm

If you send the log to me at alice.easey@red-gate.com, that'd be great.

Thanks,

Alice.
alice.easey
 
Posts: 94
Joined: Wed Feb 27, 2008 12:56 pm
Location: Red Gate

Postby jspibey » Tue Jan 12, 2010 2:46 pm

I've sent you the log file via email

Thanks
jspibey
 
Posts: 15
Joined: Thu Sep 28, 2006 2:25 pm

Postby jspibey » Tue Jan 12, 2010 3:28 pm

1.0.0.475 - I only downloaded it an hour or two ago but it was an upgrade of a previous version
jspibey
 
Posts: 15
Joined: Thu Sep 28, 2006 2:25 pm

Postby alice.easey » Tue Jan 12, 2010 3:46 pm

Thanks for sending the logs across.

We've identified the issue as being a problem with the way we're handling PL/SQL objects in dependent schemas not included for comparison.

We've got a fix for this that will be in the next EAP build (unfortunately we don't have any timescales for that yet).

In the meantime, a workaround would be to make sure your comparison includes all the schemas that are referenced by the objects you want to compare (so, if you're comparing a table in SchemaA that references a procedure in SchemaB, make sure you include SchemaB for comparison).

Hopefully that should fix the problem - please let us know if it doesn't or if you have any other feedback for us.

Thanks,

Alice.
alice.easey
 
Posts: 94
Joined: Wed Feb 27, 2008 12:56 pm
Location: Red Gate

Postby jspibey » Wed Jan 13, 2010 10:54 am

Thanks for the quick reply. I tried adding in the other schemas which were referenced but couldn't get any further. I'll wait for the next build before I look at it again
jspibey
 
Posts: 15
Joined: Thu Sep 28, 2006 2:25 pm

Postby jcossio » Mon Feb 08, 2010 3:02 pm

Same problem here with "P"."OBJECT_TYPE". Will also wait for the newest build to see if we can come across. Thanks
jcossio
 
Posts: 5
Joined: Thu Dec 10, 2009 6:16 pm
Location: Colombia

Postby Michelle Taylor » Tue Feb 09, 2010 12:25 pm

jcossio - is 'P' an actual schema in your database, or a synonym for that schema?
Michelle Taylor
 
Posts: 529
Joined: Mon Oct 30, 2006 12:45 pm
Location: Red Gate Software

Postby jcossio » Tue Feb 09, 2010 2:04 pm

We do not have a schema or synonym called P on our database. It would be strange if I had the same stuff as jspibey that also pointed out this same issue ("P"."OBJECT_TYPE") at the beginning of this thread.
Thanks anyway.
jcossio
 
Posts: 5
Joined: Thu Dec 10, 2009 6:16 pm
Location: Colombia

Postby alice.easey » Wed Mar 10, 2010 6:03 pm

We've just released our new early access build.

We've made a lot of improvements around dependencies and general stability, and would hugely appreciate it if you could give it a try and let us know if it resolves your issues.

You can download the new build here.

Thanks,

Alice.
alice.easey
 
Posts: 94
Joined: Wed Feb 27, 2008 12:56 pm
Location: Red Gate

Postby jcossio » Wed Mar 10, 2010 9:20 pm

Gave it a try and got an error on the fourth step "Comparing Databases". it says "An item with the same key has already been added." and aborts the process. Logs have been sent to Alice
jcossio
 
Posts: 5
Joined: Thu Dec 10, 2009 6:16 pm
Location: Colombia

Postby alice.easey » Tue Mar 16, 2010 5:49 pm

We've tracked this down to an error registering the WMSYS schema which we've fixed in the latest build (1.0.0.681).

Can you give this new build a try and let us know if it fixes the problem?

Thanks,

Alice.
alice.easey
 
Posts: 94
Joined: Wed Feb 27, 2008 12:56 pm
Location: Red Gate


Return to Schema Compare for Oracle Beta

Who is online

Users browsing this forum: No registered users and 0 guests