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.
Comments
3 comments
-
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
-
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.
-
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!
Add comment
Please sign in to leave a comment.