How do I connect to Oracle shema with Schema Compare?

DHolt

I am trying to connect to Oracle shemas with Shema Compare and get an error: "ORA-03113: end-of-file on communication channel".  I have no problem connecting from Oracle SQL Developer using the same credentials.  I am kind of new to Oracle.  In the past, I have used RG Compare for SQL Server.

DHolt

I am new to Oracle and didn't relaize I needed to install an Oracale connecter.  Once I diod this, I was able to connect.  Doh!

Dan B

Hi DHolt,

Thanks for posting on the Redgate forums.

The following documentation lists the permissions you'll need to use Schema Compare for Oracle, can you make sure you have all of these?
https://documentation.red-gate.com/sco5/requirements/permissions-required-to-use-schema-compare-for-oracle

If that doesn't help, could you increase the minimum logging level to verbose, repeat your steps and send the log files to support@red-gate.com?  
https://documentation.red-gate.com/sco5/troubleshooting/logging-and-log-files

DHolt

I do not have DBA permissions.  But, from what I read, that should only prevent me from deploying using Schema Compare for Oracle.  We plan to create SQL scripts using Schema Compare that we weill submit to a DBA to run.