Trying to launch Schema Browser, but getting ORA-03113 End-of-file on communication channel. After this Toad may continue to work normally or connectivity is lost and the user must do a Session | Test Connection (Reconnect) in the Toad menu for it to continue. It may also lead up to other error messages.
This error is likely caused by a network connectivity issue between Toad and the Database. Be sure to note all network layers between Toad and the Database, such as Virtual Private Networks, Anti-Virus, Firewalls, and other network settings such as idle time out.
RESOLUTIONS:
Please discuss the issue with your company's network administrator. It is likely there is a firewall or some other communication issue preventing the queries to be executed correctly. Check if there are network time out or idle settings or packet size limitations.
Test the issue on other computers on the network. Temporarly disable local and network firewalls to see if it resolves the issue. There maybe a specific command on the firewall called 'inspect sqlnet'. This is known to cause significant connection issues with Oracle. The network and systems need to be configured to allow Toad.exe to pass SQL statements to and from the Oracle database.
Upgrade to the latest version of Toad for Oracle. Make sure your database is updated with the latest patches from Oracle. Make sure your Oracle client is current. It is advised to use the same client version as the server version. Try testing with different Oracle logins, SYS, SYSTEM, User with DBA privileges, User without DBA privileges.
