5 Replies Latest reply: Apr 7, 2013 11:42 PM by Kgronau-Oracle RSS

    cannot get a new HS connection working

    user11968137
      Hello, I have several HS connections set up on the Oracle server and they function fine. I am trying to create another, a very similar one.
      I created a new ODBC connection, the new init file in hs\admin directory, updated tnslistener.ora and tnsnames.ora and restarted the listener. However, I cannot get the dblink working.

      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 BIS.BISMHT


      Is there something else that I am missing here?

      tnsnames.ora

      BISMHT =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = tcp)(HOST = dph-oracle-10g)(PORT = 1522))
      (CONNECT_DATA =
      (SID = bismht)
      )
      (HS = OK)
      )


      listener.ora
      (SID_DESC =
      (SID_NAME = bismht)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (PROGRAM = hsodbc)
      )

      initbismht.ora

      HS_FDS_CONNECT_INFO = bismht
      HS_FDS_TRACE_LEVEL = 0

      Any suggestions?
        • 1. Re: cannot get a new HS connection working
          Kgronau-Oracle
          ORA-28545 us a configuration issue.
          What's the word size of your Windows operating system (32/64bit)?
          Please post the listener status (lsnrctl status <hsodbc listener>) output for the listener that spawns the HSODBC process and also a tnsping output (tnsping BISMHT).

          - Klaus
          • 2. Re: cannot get a new HS connection working
            user11968137
            Is's 32 bit Windows 2003, herre is lsnrctl status:

            LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 04-APR-2013 09:52
            :07

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

            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC2)))
            STATUS of the LISTENER
            ------------------------
            Alias LISTENER
            Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
            ction
            Start Date 03-APR-2013 16:05:55
            Uptime 0 days 17 hr. 46 min. 13 sec
            Trace Level off
            Security ON: Local OS Authentication
            SNMP OFF
            Listener Parameter File C:\oracle\product\10.2.0\db_1\network\admin\listener.o
            ra
            Listener Log File C:\oracle\product\10.2.0\db_1\network\log\listener.log

            Listening Endpoints Summary...
            (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC2ipc)))
            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=IN-ORACLE-DB1.in.sfdph.net)(PORT=152
            2)))
            Services Summary...
            Service "PLSExtProc" has 1 instance(s).
            Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
            Service "avatar" has 1 instance(s).
            Instance "avatar", status UNKNOWN, has 1 handler(s) for this service...
            Service "bismht" has 1 instance(s).
            Instance "bismht", status UNKNOWN, has 1 handler(s) for this service...
            Service "case" has 1 instance(s).
            Instance "case", status UNKNOWN, has 1 handler(s) for this service...
            Service "foxdb" has 1 instance(s).
            Instance "foxdb", status UNKNOWN, has 1 handler(s) for this service...
            Service "foxdb1" has 1 instance(s).
            Instance "foxdb1", status UNKNOWN, has 1 handler(s) for this service...
            Service "inv_test" has 1 instance(s).
            Instance "inv_test", status UNKNOWN, has 1 handler(s) for this service...
            Service "invision" has 1 instance(s).
            Instance "invision", status UNKNOWN, has 1 handler(s) for this service...
            Service "mhdw" has 1 instance(s).
            Instance "mhdw", status UNKNOWN, has 1 handler(s) for this service...
            Service "mhdw_my" has 1 instance(s).
            Instance "mhdw_my", status UNKNOWN, has 1 handler(s) for this service...
            Service "onlvi" has 1 instance(s).
            Instance "onlvi", status UNKNOWN, has 1 handler(s) for this service...
            Service "pes" has 1 instance(s).
            Instance "pes", status UNKNOWN, has 1 handler(s) for this service...
            Service "sadw" has 1 instance(s).
            Instance "sadw", status UNKNOWN, has 1 handler(s) for this service...
            Service "testdb" has 2 instance(s).
            Instance "testdb", status UNKNOWN, has 1 handler(s) for this service...
            Instance "testdb", status READY, has 1 handler(s) for this service...
            Service "testdbXDB" has 1 instance(s).
            Instance "testdb", status READY, has 1 handler(s) for this service...
            Service "testdb_XPT" has 1 instance(s).
            Instance "testdb", status READY, has 1 handler(s) for this service...
            The command completed successfully


            What puuzzles me is that the other hs connections work fine, only this new one causes problems.

            Thank you
            • 3. Re: cannot get a new HS connection working
              Kgronau-Oracle
              could you also please post the tnsping output (tnsping BISMHT) ?

              Thanks,
              Klaus
              • 4. Re: cannot get a new HS connection working
                user11968137
                Here it is:

                tnsping bismht

                TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 05-APR-2
                013 10:02:24

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

                Used parameter files:
                C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora


                Used TNSNAMES adapter to resolve the alias
                Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp)(HOST = dph-orac
                le-10g)(PORT = 1522)) (CONNECT_DATA = (SID = bismht)) (HS = OK))
                OK (0 msec)

                Thanks!!
                • 5. Re: cannot get a new HS connection working
                  Kgronau-Oracle
                  Just wondering about the hostnames:
                  TNSPING uses the hostname from the tnsnames.ora file which is (HOST = dph-oracle-10g) but the listener status shows: (HOST=IN-ORACLE-DB1.in.sfdph.net)

                  Commonly the hostname in the tnsnames.ora must match the one in the listener.ora. What happens when you correct it in the tnsnames.ora so that it points to the name that matches your listener hostname (IN-ORACLE-DB1.in.sfdph.net)?

                  - Klaus