Forum Stats

  • 3,734,368 Users
  • 2,246,957 Discussions
  • 7,857,248 Comments

Discussions

ORA-28545: .Unable to retrieve text of NETWORK/NCR message 65535...ORA-2063

383789
383789 Member Posts: 21
edited Aug 18, 2010 2:05AM in Heterogeneous Connectivity
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
User430630

Comments

  • 505053
    505053 Member Posts: 1
    Hi

    I am getting the ORA-28545: .Unable to retrieve text of NETWORK/NCR message 65535...ORA-2063 when I am trying to connect Ingres DB through transparent gateway
    if you got the solution plese mail me to my id [email protected]
    please help me its very urgent

    I hope you will revert back to this mail

    Thank you

    Regards
    Sathyananda
  • 383789
    383789 Member Posts: 21
    Hello

    I was out of office, and the we have an completely different solution ( The programm ist connecting to the different Databases, two Database connections instead of one)
    The priority of this problem is low. so I haven't done any more research on it.
    But there is also no response to this thread.
    Sorry I haven't got the solution yet.

    If you found some solution, please tell me.

    Regards Ralf
  • 522112
    522112 Member Posts: 1
    Hi Ralf,
    I have some problem as yours. Do you have any solution for that?
    My email address is [email protected]

    Thanks,
    Ming
  • 522489
    522489 Member Posts: 10
    edited Aug 2, 2006 10:02PM
    I Have also run into this error. I am trying to use oracle 10.2 to talk to an unixodbc text data source on Red Hat Linux X86-64. This is only an interim step to prove it the oracle HS is working however it is turning into a nightmare.

    Like the others above I ask has anyone found an answer?

    Thanks,
    James
  • 461778
    461778 Member Posts: 19
    Same problem here...

    Any news, please, let me know...

    [email protected]

    Thanks!
    Alessandra
  • 532720
    532720 Member Posts: 1
    I was able to setup HSODBC to sql server that runs on separate server than Oracle. You have to use a separate listener for the sql server connection. Add another listener definition to the listener.ora file

    In addition to setting up the inithsodbc.ora file for your connection, and your system dsn connection, you need to do the following:

    Example:

    LISTENER = -- This is your existing Listener
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracle.server.com)(PORT = 1521))
    )
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = oraclesid))
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = oraclesid
    (ORACLE_HOME = c:\oracle\ora92)
    (SID_NAME = oraclesid)
    )
    (SID_DESC =
    (PROGRAM = extproc)
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = c:\oracle\ora92)
    )
    )

    HSODBC_LISTENER = -- This is your new listener
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = sqlserver.com)(PORT = 1522))
    )
    )
    SID_LIST_HSODBC_LISTENER =
    (SID_LIST=
    (SID_DESC=
    (SID_NAME=mydsnservicename)
    (ORACLE_HOME=c:\oracle\ora92)
    (PROGRAM=hsodbc)
    )
    )


    this is the tnsnames.ora entry for this example:

    hsodbcconnect =
    (DESCRIPTION=
    (ADDRESS=(PROTOCOL=tcp)(HOST=oracle.server.com)(PORT=1522))
    (CONNECT_DATA=(SID=mydsnservicename))
    (HS=OK)
    )

    Startup this listener: lsnrctl start hsodbc_listener

    After you create, you should be able to get the external data.
  • 461778
    461778 Member Posts: 19
    Thanks for the info!!

    Could you tell me if your database is 32 or 64-bit?

    It looks like 64-bit doesn't support ODBC connections...

    Thanks!!
    Alessandra
  • 539609
    539609 Member Posts: 1
    I too have been attempting to get the HSODBC connection to work on 10g (10.2.0.1.0) and finally had success. What I found was that the syntax of the listener.ora file must be perfect (dah!). I have found that the brackets are pretty confusing, so focus your time on this file. Then try using the command line start of the listener (lsnrctl start listener) and you must see that your ODBC instance has a handler. Once I got this step working, the rest fell into place by creating the database link as normal.

    Other things to check:
    Set the intialization parameter HS_AUTOREGISTER to true to and check the SYS.HS$_FDS_CLASS table to ensure that the Oracle ODBC driver gets registered.
    If you don't have an entry in this table for your Oracle version's ODBC driver, then it is likely that the listener is not function correctly

    Hope this helps

    Doug

    Output from the (lsnrctl start listener) command...


    LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 14-OCT-2006 13:3
    :23

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

    Starting tnslsnr: please wait...

    TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
    System parameter file is D:\oracle\product\10.2.0\db_1\network\admin\listener.o
    a
    Log messages written to D:\oracle\product\10.2.0\db_1\network\log\listener.log
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dscaife1.ingrca.com)(PO
    T=1521)))

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dscaife1.ingrca.com)(PO
    T=1521)))
    STATUS of the LISTENER
    ------------------------
    Alias listener
    Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Prod
    ction
    Start Date 14-OCT-2006 13:32:26
    Uptime 0 days 0 hr. 0 min. 3 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File D:\oracle\product\10.2.0\db_1\network\admin\listener.
    ra
    Listener Log File D:\oracle\product\10.2.0\db_1\network\log\listener.lo

    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dscaife1.ingrca.com)(PORT=1521)))
    Services Summary...
    Service "MSACCESS" has 1 instance(s).
    Instance "MSACCESS", status UNKNOWN, has 1 handler(s) for this service...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully
  • 17736
    17736 Member Posts: 13
    James

    You would do well to read DocID 264567.1 - How to setup Generic Connectivity HSODBC on Linux. Almost the first sentence reads: "Please pay attention: Currently (up to 10gR2) HDOSBC is only ported to Linux x86; Not to Linux x86-64 bit."

    I've just instantiated an SR that addresses this issue. The response was:

    "Only sugesstion I have is to enter an enhancemnet request and it will be answered by our development. Currently our development think that it is not feasable for them to port it in 64bit platforms such Itanium and linux 86-64"

    My response was that this is an unacceptable answer from oracle, especially given their public position of fully supporting Linux x86-64.

    You might consider an enhancement request - I am.
  • 522489
    522489 Member Posts: 10
    edited Oct 25, 2006 8:22PM
    Thanks for the link. We also came to the conclusion that 32bit for our only viable way forward. We wasted alot of time and effort on this under the assurance that Oracle was fully 64bit ready.

    OWB does not make it easy to import non-oracle DBs in any other way than flat files and HS was really a last resort. I don't really buy into the argument that a data warehouse will only ever use Oracle DBs as the whole point is to integrate legacy systems!

    Still the solution on 32-bit works well enough just painful to get there. In our case we have OWB pointing to HSODBC pointing to Attunity Connect (a rather good ODBC connector/driver for legacy systems) pointing to the COBOL source system. Slightly convoluted but once setup fast and easy to develop from.

    Cheers,
    James
  • 17736
    17736 Member Posts: 13
    James

    Our situation is exactly a data warehouse using 10gR2 on a 64bit box that must access legacy systems - NONE of which are Oracle! Oracle has its head in the sand if it believes that data warehouses built with its 64bit products will never access data from any source other than oracle.

    Something I'm considering: Creating an additional instance on the 64bit machine, but installing the entire software stream as 32bit (using setarch i386). Then, have that 32bit environment talk through HSODBC to the legacy non-oracle systems. Inside the 32bit environment I would use DBMS_SCHEDULER to run jobs that would pull legacy data into the 32bit environment. Then I would use a dblink from our 64bit -> 32bit environment and do the normal DML. Its a thought!

    Steve
  • 354515
    354515 Member Posts: 7
    Hi Alessandra,

    I have the same problem... Have you covered it? If so, ple let me know.

    Andrew
    [email protected]
  • 461778
    461778 Member Posts: 19
    Hi Andrew,

    Well, since not all the transparent gateways are certified for linux x86-64-bit and Oracle DB 64-bit... (e.g. SQL Server).

    We have decided having a separated server only for a Oracle Standalone Gateways in a Windows 2003 Server OS.

    My infra team is currently setting up this server.

    I am a little concerned about performance... I will let you know when I further test.

    Ale
  • 525777
    525777 Member Posts: 31
    see metalink Note:364369.1

    ... install latest software / patchset 10.2.02 ... should help
  • 683562
    683562 Member Posts: 26
    Hello,

    I have configured heterogeneous Connectivity for use mySql from Apex ( Oracle ).
    now I have this message ( see below ).In metalink Note:364369.1 say to update dataase to 10.2.0.2

    Is this note valid too for Oracle XE ?
    Can I use other way ?

    Thanks.



    +$sqlplus / as sysdba"+
    +SQL*Plus: Release 10.2.0.1.0 - Production on Mon Apr 13 18:04:38 2009+
    +Copyright (c) 1982, 2005, Oracle. All rights reserved.+
    +Connected to:+
    +Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production+

    +SQL> select * from [email protected];+
    +*+
    +ERROR at line 1:+
    +ORA-28545: error diagnosed by Net8 when connecting to an agent+
    +Unable to retrieve text of NETWORK/NCR message 65535+
    +ORA-02063: preceding 2 lines from MYODBC5+
  • 67389
    67389 Member Posts: 3
    I just got this on our HP-UX 11.11 / 10g 10.2.0.2 installation. I had SHLIB_PATH set to the /usr/odbc/lib:$ORACLE_HOME/lib:$ORACLE_HOME/lib32. I removed $ORACLE_HOME/lib from the SHLIB_PATH, (leaving only the odbc/lib and lib32 in the path), then restarted the listener. That seemed to fix things for me.
  • 719775
    719775 Member Posts: 2
    Hi,

    are you sure that this part is correct?

    <<
    HSODBC_LISTENER = -- This is your new listener
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = sqlserver.com)(PORT = 1522))
    )
    >>

    If I put the SQL server name as host I cannot start the listener; only if I put Oracle server name there it gets started, but started service doesn't solve the problem.

    any idea?
    thnx.
    SM.
  • Kgronau-Oracle
    Kgronau-Oracle Posts: 2,550 Employee
    you have to use the hostname where you've configured the Oracle Gateway Listener. If you configure it on the Oracle server, then specify the oracle server hostname. If you run a gateway on the SQL Server machine, you need to specify the SQL Server hostname. If you configured the gateway on a 3rd machine you need to specify this hostname.
  • I had this same error after installing MiddleTier, the problem was that the MiddleTier listener substituted the default listener so I couldn't connect to the HS. I started the default listener and it worked!!!
  • Hello,
    I had the same error and was able to solve it.
    My WRONG listener.ora was:

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = c:\oracle\ora10)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (SID_NAME =srv2008)
    (ORACLE_HOME = c:\oracle\db10)
    (PROGRAM =hsodbc)
    )
    )

    The error message was:
    ORA-28545: ...
    Unable to retrieve text of NETWORK/NCR message 65535
    ORA-02063: ...

    What was the error: I mistyped the path to hsodbc, so after changing the line
    (ORACLE_HOME = c:\oracle\db10)
    to
    (ORACLE_HOME = c:\oracle\ora10)
    (because my right oracle-home was c:\oracle\ORA10 not DB10) it worked.
    User430630
This discussion has been closed.