1 2 Previous Next 20 Replies Latest reply on Aug 18, 2010 6:05 AM by user12059246

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

    383789
      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
        • 1. Re: ORA-28545: .Unable to retrieve text of NETWORK/NCR message 65535...ORA-2063
          505053
          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 sathyananda.jayaram@qsoftindia.com
          please help me its very urgent

          I hope you will revert back to this mail

          Thank you

          Regards
          Sathyananda
          • 2. Re: ORA-28545: .Unable to retrieve text of NETWORK/NCR message 65535...ORA-
            383789
            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
            • 3. Re: ORA-28545: .Unable to retrieve text of NETWORK/NCR message 65535...ORA-2063
              522112
              Hi Ralf,
              I have some problem as yours. Do you have any solution for that?
              My email address is mxu@hdsrna.com

              Thanks,
              Ming
              • 4. Re: ORA-28545: .Unable to retrieve text of NETWORK/NCR message 65535...ORA-2063
                522489
                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
                • 5. Re: ORA-28545: .Unable to retrieve text of NETWORK/NCR message 65535...ORA-2063
                  461778
                  Same problem here...

                  Any news, please, let me know...

                  natriea@diebold.com

                  Thanks!
                  Alessandra
                  • 6. Re: ORA-28545: .Unable to retrieve text of NETWORK/NCR message 65535...ORA-2063
                    532720
                    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.
                    • 7. Re: ORA-28545: .Unable to retrieve text of NETWORK/NCR message 65535...ORA-2063
                      461778
                      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
                      • 8. Re: ORA-28545: .Unable to retrieve text of NETWORK/NCR message 65535...ORA-2063
                        539609
                        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
                        • 9. Re: ORA-28545: .Unable to retrieve text of NETWORK/NCR message 65535...ORA-
                          17736
                          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.
                          • 10. Re: ORA-28545: .Unable to retrieve text of NETWORK/NCR message 65535...ORA-
                            522489
                            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
                            • 11. Re: ORA-28545: .Unable to retrieve text of NETWORK/NCR message 65535...ORA-
                              17736
                              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
                              • 12. Re: ORA-28545: .Unable to retrieve text of NETWORK/NCR message 65535...ORA-
                                354515
                                Hi Alessandra,

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

                                Andrew
                                tantra71@gmail.com
                                • 13. Re: ORA-28545: .Unable to retrieve text of NETWORK/NCR message 65535...ORA-
                                  461778
                                  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
                                  • 14. Re: ORA-28545: .Unable to retrieve text of NETWORK/NCR message 65535...ORA-
                                    525777
                                    see metalink Note:364369.1

                                    ... install latest software / patchset 10.2.02 ... should help
                                    1 2 Previous Next