Chat now with support
Chat with Support

Toad Data Point 5.0 - User Guide

Troubleshoot Oracle Issues

Review the following solutions to help troubleshoot Oracle connection issues pertaining to database connections and missing functionality and object information in Toad.

Connection Issues

Issue Cause/Solution

Attempting to connect when Oracle Instant Client is installed results in a System.NullReferenceException error

Solution:

In order to connect using the Oracle Instant Client, the directory for the Instant Client must be included in the environmental path, or you must copy the client files for the instance to the root install directory of Toad Data Point.

You can also connect to the database without using an Oracle client or TNSNames file by selecting the Direct tab in the Create New Connection window.

An error occurs when attempting to connect to Oracle Rdb using an ODBC driver Toad does not support Oracle Rdb at this time.
Attempting to connect to Oracle 18c results in the error ORA-28040: No matching authentication protocol SQLNET.ALLOWED_LOGON_VERSION has been deprecated. Upgrade your Oracle client or set the parameter value to 12c.

Missing Functionality and Object Information

Issue Cause/Solution

Some schemas are not available from the Schema drop-down list in the Object Explorer.

The Oracle ODBC driver cannot display schemas that do not have any tables.

Unable to view table data on the Data tab; SQLFetch generates an access violation.

The Oracle ODBC driver is accessing unallocated memory.

Solution:

Update the Oracle ODBC driver:

  • For 9i drivers, update to 9.2.0.7.0 or later.

  • For 10g drivers, update to 10.1.0.3.0 or later.

 

Related Topics

Create Oracle Connections

Manage Connections

Connection/Navigation Manager 

 

Related Documents