Oracle Database Discussions

I tried to use to configure heterogenious Services
I create an ODBC-DSN called ADAD for connect to a remote ADABAS D Database.
I can connect to the Database from MSACCESS via this ODBC-DRiver
I create a initADAD.ora in the subdirectory hs/admin of ORACLE_HOME

# This is a sample agent init file that contains the HS parameters that are
# needed for an ODBC Agent.

#
# HS init parameters
#
HS_FDS_CONNECT_INFO = ADAD
HS_FDS_TRACE_LEVEL = 0
#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>

Changed the listener.ora

# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC=
(SID_NAME = ADAD)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM= HSODBC)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = w2ksys15)(PORT = 1521))
)
)



Changed sqlnet.ora

# sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

#SQLNET.AUTHENTICATION_SERVICES= (NTS)
SQLNET.AUTHENTICATION_SERVICES= (NONE)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)



Restarted the Listener

H:\>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 28-MRZ-2006 13:44
:02

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Anmeldung bei (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS des LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Startdatum 28-MRZ-2006 13:32:50
Uptime 0 Tage 0 Std. 11 Min. 13 Sek.
Trace-Ebene off
Sicherheit ON: Local OS Authentication
SNMP OFF
Parameterdatei des Listener C:\oracle\product\10.2.0\db_1\network\admin\listener
.ora
Log-Datei des Listener C:\oracle\product\10.2.0\db_1\network\log\listener.log

Zusammenfassung Listening-Endpunkte...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=w2ksys15)(PORT=1521)))
Services Übersicht...
Dienst "entire" hat 1 Instance(s).
Instance "entire", Status READY, hat 1 Handler für diesen Dienst...
Dienst "entireXDB" hat 1 Instance(s).
Instance "entire", Status READY, hat 1 Handler für diesen Dienst...
Dienst "entire_XPT" hat 1 Instance(s).
Instance "entire", Status READY, hat 1 Handler für diesen Dienst...
Der Befehl wurde erfolgreich ausgeführt.


Changed the tnsnames.ora

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ENTIRE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = w2ksys15)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ENTIRE)
)
)

ADAD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = w2ksys15)(PORT = 1521))
(CONNECT_DATA =
(SID=ADAD)) )
(HS=OK)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)


created a Database Link

Named RLA

create DATABASE LINK RLA connect to "EBSUSER" identified by "EBS" USING 'AD
AD';


When I try to get DATA from the "DATABASE LINK
select * from tablename

I get an error

ORA-28545: Von Net8 bei der Verbindung zu einem Agenten diagnostizierter Fehler
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: vorherige 2 lines von RLA

I found this Error two TIMES in the FORUM:
One Question without an answer
the other with the comment "I solved Problem" but with no solution.

Please help me to solve the problem,
Are there any mistakes in my configuration?
Or is there anything that I have forgotten to do?

TIA Ralf