The full text of the error reported to us was:
ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535
You may get this error if:
This article lists some possible solutions for this problem. You may need to try more than one solution.
If you are using Oracle® 10g, check that your Oracle® distribution includes the Heterogeneous Services agent (HSODBC) and that it is installed. To do this, log on as your Oracle® user and run:
cd $ORACLE_HOME/bin file HSODBC
On a Linux machine, you will see something similar to the following if HSODBC is installed:
hsoodbc: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.2.5, not stripped
If you get HSODBC: empty
, your version of Oracle® does not include HSODBC. Ask your Oracle® supplier about installing the Oracle® 11g Database Gateway for ODBC (DG4ODBC). This gateway (which transparently connects Oracle® to non-Oracle databases for which an ODBC driver is available) also supports Oracle® 10g.
Check your init<sid>.ora
, tnsnames.ora
and listener.ora
files. Make sure that the <sid>
part of the init<sid>.ora
file is referenced in the listener.ora
attribute SID_NAME
and the tnsnames.ora
attribute SID
.
If you are not sure how to configure these files, refer to the appropriate Easysoft tutorial:
Note that these tutorials describe how to configure Oracle® for use with DG40DBC/HSODBC. Additional Oracle® configuration is beyond the scope of the tutorials and what our Support team can offer assistance with.
Note that although these tutorials were based around the Easysoft ODBC-ODBC Bridge and Easysoft ODBC-SQL Server Driver, the process is the same for all Easysoft ODBC drivers. If you need help configuring DGODBC/HSODBC with another Easysoft product, please contact the Easysoft support team (). We will then create a tutorial based around your set up.
You may have installed the wrong version of the Easysoft software. For example:
If you are not sure whether to use a 32-bit or 64-bit Easysoft driver, please contact the Easysoft support team (). Supply the team with this information:
<installation_dir>/easysoft/product_install.info
, where <installation_dir>
is the directory where the Easysoft ODBC driver is installed, by default, /usr/local
.To enable HSODBC logging, in init<sid>.ora
, set HS_FDS_TRACE_LEVEL
to 4
, and specify a log file with HS_FDS_TRACE_FILE_NAME
. For example:
HS_FDS_TRACE_LEVEL = 4 HS_FDS_TRACE_FILE_NAME = /tmp/hsodbcsql.trc
To enable DG4ODBC logging, in init<sid>.ora
, set HS_FDS_TRACE_LEVEL
to Debug
. For example:
HS_FDS_TRACE_LEVEL = Debug
The log output will be written to a file in the $ORACLE_HOME/hs/log
directory.
After you have made these changes to init<sid>.ora
, restart the Oracle® Listener. For example:
cd $ORACLE_HOME/bin ./lsnrclt stop ./lsnrclt start
If a log file is not generated, either your Oracle® configuration files have not been set up correctly or HSODBC/DG4ODBC is not installed. For help with Oracle® configuration, contact your Oracle® DBA or Oracle® support team.
If a log file is generated and you see the following error, refer to Why do I get error "Generic Connectivity Using ODBC][C077] Could not find symbol 'SQLAllocConnect' in dynamic library"?
ERROR : Could not find symbol 'SQLAllocConnect' in dynamic library
If you get an error that contains the text Could not load library libodbc
, on the machine where the Easysoft ODBC driver is installed, you need to ensure the library search path includes the Easysoft driver directories. The environment variable you use to set the library search path varies:
Platform | Environment variable |
---|---|
AIX | LIBPATH |
HP-UX | SHLIB_PATH |
Linux. Solaris. Other System V based operating systems. | LD_LIBRARY_PATH |
Set the appropriate variable for your platform in your Oracle® user’s .profile
file. For example:
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:<installation_dir>/easysoft/lib:<installation_dir>/easysoft/unixODBC/lib export LD_LIBRARY_PATH
where <installation_dir>
is the directory where the Easysoft ODBC driver is installed, by default, /usr/local
.
Stop and start your Oracle® listener before trying to connect again.
If you get another error, try searching for the error text on the Eaysoft web site. Make sure that you have checked the "Easysoft.com", "Documentation" and "Knowledge Base" search options.
If you are still having a problem with your Easysoft ODBC driver/HSODBC or DG4ODBC set up, send the following information to :
cd $ORACLE_HOME/bin file hsodbc ./hsodbc tnsping <listener name>
where <listener name>
is the listener you have configured to listen for HSODBC.
–Or–
cd $ORACLE_HOME/bin file dg4odbc ./ dg4odbc tnsping <listener name>
where <listener name>
is the listener you have configured to listen for DG4ODBC.
<installation_dir>/easysoft/<product>_install.info
, where <installation_dir>
is the directory where the Easysoft ODBC driver is installed, by default, /usr/local
.init<sid>.ora
, listener.ora
and tnsnames.ora
.odbc.ini
file. If you do not know where to find this file, run:
cd <installation_dir>/easysoft/unixODBC/bin ./odbcinst -j
If you would like to contribute to this document, please email .
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.