1 2 Previous Next 21 Replies Latest reply: Jun 24, 2012 6:21 AM by 943956 RSS

    ORA-28545: error diagnosed by Net8 when connecting to an agent

    943956
      Hello Team,

      When i tried to connect to the sql server it Throw below error message

      i'm not sure what i'm missing here

      Any input on this is highly appreciated.

      SQL> select * from all_users@testing
      2 /
      select * from all_users@testlink1
      *
      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 TESTLINK1

      Below are the configuration details:

      C:\Users\aorenstein>tnsping qqest:

      TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 18-JUN-2
      012 08:19:55

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

      Used parameter files:
      C:\Oracle\Product\11.2.0\db_1\NETWORK\ADMIN\sqlnet.ora


      Used TNSNAMES adapter to resolve the alias
      Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
      (HOST = 5.5.5.5)(PORT = 1521))) (CONNECT_DATA = (SID = QQEST)) (HS=OK))
      OK (20 msec)


      initQQEST.ora (hs parmater file)*

      # 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 = QQEST
      HS_FDS_TRACE_LEVEL = Debug


      Listener.ora*
      # Environment variables required for the non-Oracle system
      #
      #set <envvar>=<value>

      Listener:
      (SID_DESC =
      (SID_NAME = QQEST)
      (ORACLE_HOME = C:\oracle\product\11.2.0\db_1)
      (PROGRAM = dg4odbc)
      )
      tnsora file*

      Tnsora:

      QQEST =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP) (HOST = 5.5.5.5(PORT = 1521))
      )
      (CONNECT_DATA = (SID = QQEST))
      (HS=OK)
      )


      Thanks and regards
      sankar
        • 1. Re: ORA-28545: error diagnosed by Net8 when connecting to an agent
          943956
          like to add one more thing

          opering system :windows 2008 r2 server 64 bit
          database : 64 bit
          • 2. Re: ORA-28545: error diagnosed by Net8 when connecting to an agent
            Kgronau-Oracle
            Zje 28545 error is a generic configuration issue.
            Could you please post your listener status (lsnrctl status <listener name>)?
            • 3. Re: ORA-28545: error diagnosed by Net8 when connecting to an agent
              943956
              Hello ,

              Please find the listener status

              C:\Users\Administrator>LSNRCTL STATUS

              LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 19-JUN-2012 03:58:50

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

              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DBSERVER3)(PORT=1521)))
              STATUS of the LISTENER
              ------------------------
              Alias LISTENER
              Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
              Start Date 19-JUN-2012 03:58:21
              Uptime 0 days 0 hr. 0 min. 33 sec
              Trace Level off
              Security ON: Local OS Authentication
              SNMP OFF
              Listener Parameter File C:\Oracle\Product\11.2.0\db_1\NETWORK\ADMIN\listener.ora
              Listener Log File d:\oraadmin\rt\base\diag\tnslsnr\DBServer3\listener\alert\log.xml
              Listening Endpoints Summary...
              (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DBServer3.sts.local)(PORT=1521)))
              (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
              Services Summary...
              Service "QQEST" has 1 instance(s).
              Instance "QQEST", status UNKNOWN, has 1 handler(s) for this service...
              Service "rt" has 1 instance(s).
              Instance "rt", status UNKNOWN, has 1 handler(s) for this service...
              Service "testdb" has 1 instance(s).
              Instance "testdb", status UNKNOWN, has 1 handler(s) for this service...
              The command completed successfully


              Thanks
              sankar
              • 4. Re: ORA-28545: error diagnosed by Net8 when connecting to an agent
                Kgronau-Oracle
                You've just started the listener: Uptime 0 days 0 hr. 0 min. 33 sec

                Do you still have the same error message?

                If yes, then please post the output of: "dir C:\oracle\product\11.2.0\db_1\bin\dg4*" executed in a command line window.
                • 5. Re: ORA-28545: error diagnosed by Net8 when connecting to an agent
                  943956
                  Hello,
                  output from the command line:_
                  C:\Users\aorenstein>dir C:\oracle\product\11.2.0\db_1\bin\dg4*"
                  Volume in drive C has no label.
                  Volume Serial Number is F818-5A92

                  Directory of C:\oracle\product\11.2.0\db_1\bin

                  03/30/2010 06:28 AM 949,760 dg4odbc.exe
                  03/30/2010 06:28 AM 37,888 dg4pwd.exe
                  2 File(s) 987,648 bytes
                  0 Dir(s) 32,760,053,760 bytes free

                  C:\Users\aorenstein>

                  Many Thanks
                  sankar
                  • 6. Re: ORA-28545: error diagnosed by Net8 when connecting to an agent
                    Kgronau-Oracle
                    Unfortunately you didn't reply to my first question:"Do you still have the same error message?"

                    As the listener was started shortly before you checked the listener status,the service summary migtnow hae displayed the d4odbc SID and it was missing earlier.
                    • 7. Re: ORA-28545: error diagnosed by Net8 when connecting to an agent
                      943956
                      sorry i missed to answer it.

                      Yes Stilll we are facing this issue.We tried by restarting the listener but still we are getting the same error message.

                      Many Thanks
                      sankar
                      • 8. Re: ORA-28545: error diagnosed by Net8 when connecting to an agent
                        Kgronau-Oracle
                        Sankar,
                        one issue I found is the tnsnames.ora entry
                        (ADDRESS = (PROTOCOL = TCP) (HOST = 5.5.5.5(PORT = 1521))
                        after the host string a closing bracket is missing - but I think it looks like it is just a typo when you removed the original value as the tnsping works correctly.

                        Can you please verify again that the host in your tnsnames.ora file matches the host in the listener.ora file and confirm that they match - just to make sure you connect to the correct Oracle listener which also has the dg4odbc SID entry?

                        Can you also please provide the output of:C:\oracle\product\11.2.0\db_1\bin\dg4odbc

                        Edited by: kgronau on Jun 20, 2012 6:44 AM

                        Maybe it would also make sense to post the whole listener.ora file.
                        • 9. Re: ORA-28545: error diagnosed by Net8 when connecting to an agent
                          943956
                          Hello,

                          Not sure what i'm missing here but still we are not able to connect.

                          Please find the requested details

                          output from the command line:*
                          C:\Users\aorenstein>dir C:\oracle\product\11.2.0\db_1\bin\dg4*"
                          Volume in drive C has no label.
                          Volume Serial Number is F818-5A92

                          Directory of C:\oracle\product\11.2.0\db_1\bin

                          03/30/2010 06:28 AM 949,760 dg4odbc.exe
                          03/30/2010 06:28 AM 37,888 dg4pwd.exe
                          2 File(s) 987,648 bytes
                          0 Dir(s) 32,760,053,760 bytes free

                          C:\Users\aorenstein>

                          _*Listener.ora*_

                          # listener.ora Network Configuration File: C:\Oracle\Product\11.2.0\db_1\NETWORK\ADMIN\listener.ora
                          # Generated by Oracle configuration tools.

                          SID_LIST_LISTENER =
                          (SID_LIST =
                          (SID_DESC =
                          (GLOBAL_DBNAME = R2)
                          (ORACLE_HOME = C:\oracle\product\11.2.0\db_1)
                          (SID_NAME = R2)
                          )
                          (SID_DESC =
                          (GLOBAL_DBNAME = testdb)
                          (ORACLE_HOME = C:\oracle\product\11.2.0\db_1)
                          (SID_NAME = testdb)
                          )
                          (SID_DESC =
                          (SID_NAME = QQEST)
                          (ORACLE_HOME = C:\oracle\product\11.2.0\db_1)
                          (PROGRAM = dg4odbc)
                          )
                          )

                          LISTENER =
                          (DESCRIPTION_LIST =
                          (DESCRIPTION =
                          (ADDRESS = (PROTOCOL = TCP)(HOST = DBSERVER3)(PORT = 1521))
                          )
                          (DESCRIPTION =
                          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
                          )

                          )
                               
                          )

                          ADR_BASE_LISTENER = D:\Oraadmin\R2\Base
                          • 10. Re: ORA-28545: error diagnosed by Net8 when connecting to an agent
                            943956
                            Hi,

                            We tried by connecting to different SID but still no luck

                            details as below

                            Command Line output:
                            --------------------------------

                            C:\Users\aorenstein>C:\oracle\product\11.2.0\db_1\bin\dg4odbc


                            Oracle Corporation --- WEDNESDAY JUN 20 2012 10:20:54.308

                            Heterogeneous Agent Release 11.2.0.1.0 - 64bit Production Built with
                            Oracle Database Gateway for ODBC



                            C:\Users\aorenstein>

                            C:\Users\aorenstein>dir C:\oracle\product\11.2.0\db_1\bin\dg4*"
                            Volume in drive C has no label.
                            Volume Serial Number is F818-5A92

                            Directory of C:\oracle\product\11.2.0\db_1\bin

                            03/30/2010 06:28 AM 949,760 dg4odbc.exe
                            03/30/2010 06:28 AM 37,888 dg4pwd.exe
                            2 File(s) 987,648 bytes
                            0 Dir(s) 32,826,232,832 bytes free

                            C:\Users\aorenstein>


                            _*Listener status:*_

                            C:\Users\aorenstein>lsnrctl status

                            LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 20-JUN-2012 10:28:01

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

                            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DBSERVER3)(PORT=1521)))
                            STATUS of the LISTENER
                            ------------------------
                            Alias LISTENER
                            Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
                            Start Date 20-JUN-2012 04:01:14
                            Uptime 0 days 6 hr. 26 min. 50 sec
                            Trace Level off
                            Security ON: Local OS Authentication
                            SNMP OFF
                            Listener Parameter File C:\Oracle\Product\11.2.0\db_1\NETWORK\ADMIN\listener.ora
                            Listener Log File d:\oraadmin\r2\base\diag\tnslsnr\DBServer3\listener\alert\log.xml
                            Listening Endpoints Summary...
                            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DBServer3.ctna.local)(PORT=1521)))
                            (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
                            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= 5.5.5.5)(PORT=1521)))
                            Services Summary...
                            Service "R2" has 1 instance(s).
                            Instance "R2", status UNKNOWN, has 1 handler(s) for this service...
                            Service "Timeforce" has 1 instance(s).
                            Instance "Timeforce", 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...
                            The command completed successfully



                            _*C:\Users\aorenstein>tnsping Timeforce*_

                            TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 20-JUN-2012 10:28:51

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

                            Used parameter files:
                            C:\Oracle\Product\11.2.0\db_1\NETWORK\ADMIN\sqlnet.ora


                            Used TNSNAMES adapter to resolve the alias
                            Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 5.5.5.5)(PORT =
                            1521))) (CONNECT_DATA = (SID = Timeforce)) (HS=OK))
                            OK (0 msec)


                            _*File : initTimeforce.ora :*_

                            # 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 = Timeforce
                            HS_FDS_TRACE_LEVEL = Debug


                            #
                            # Environment variables required for the non-Oracle system
                            #
                            #set <envvar>=<value>



                            _*File :listener.ora*_


                            # listener.ora Network Configuration File: C:\Oracle\Product\11.2.0\db_1\NETWORK\ADMIN\listener.ora
                            # Generated by Oracle configuration tools.

                            SID_LIST_LISTENER =
                            (SID_LIST =
                            (SID_DESC =
                            (GLOBAL_DBNAME = R2)
                            (ORACLE_HOME = C:\oracle\product\11.2.0\db_1)
                            (SID_NAME = R2)
                            )
                            (SID_DESC =
                            (GLOBAL_DBNAME = testdb)
                            (ORACLE_HOME = C:\oracle\product\11.2.0\db_1)
                            (SID_NAME = testdb)
                            )
                            (SID_DESC =
                            (SID_NAME = Timeforce)
                            (ORACLE_HOME = C:\oracle\product\11.2.0\db_1)
                            (PROGRAM = dg4odbc)
                            )
                            )

                            LISTENER =
                            (DESCRIPTION_LIST =
                            (DESCRIPTION =
                            (ADDRESS = (PROTOCOL = TCP)(HOST = DBSERVER3)(PORT = 1521))
                            )
                            (DESCRIPTION =
                            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
                            )

                            )
                                 
                            )

                            ADR_BASE_LISTENER = D:\Oraadmin\R2\Base




                            *_File tnsnames.ora:_*



                            # tnsnames.ora Network Configuration File: C:\Oracle\Product\11.2.0\db_1\NETWORK\ADMIN\tnsnames.ora
                            # Generated by Oracle configuration tools.

                            LISTENER_TESTDB =
                            (ADDRESS = (PROTOCOL = TCP)(HOST = 5.5.5.5)(PORT = 1521))


                            R2SERVICE =
                            (DESCRIPTION =
                            (ADDRESS_LIST =
                            (ADDRESS = (PROTOCOL = TCP)(HOST = 5.5.5.50)(PORT = 1521))
                            )
                            (CONNECT_DATA =
                            (SERVICE_NAME = R2)
                            )
                            )

                            4SPL =
                            (DESCRIPTION =
                            (ADDRESS_LIST =
                            (ADDRESS = (PROTOCOL = TCP)(HOST = 5.5.5.5)(PORT = 1521))
                            )
                            (CONNECT_DATA =
                            (SERVICE_NAME = testdb)
                            )
                            )

                            STANDBYTOPROD =
                            (DESCRIPTION =
                            (ADDRESS_LIST =
                            (ADDRESS = (PROTOCOL = TCP)(HOST = 5.5.5.50)(PORT = 1521))
                            )
                            (CONNECT_DATA =
                            (SERVICE_NAME = r2)
                            )
                            )

                            TESTDB =
                            (DESCRIPTION =
                            (ADDRESS_LIST =
                            (ADDRESS = (PROTOCOL = TCP)(HOST = 5.5.5.5)(PORT = 1521))
                            )
                            (CONNECT_DATA =
                            (SERVER = DEDICATED)
                            (SERVICE_NAME = testdb)
                            )
                            )



                            Insight1 =
                            (DESCRIPTION =
                            (ADDRESS_LIST =
                            (ADDRESS = (PROTOCOL = TCP)(HOST = 5.5.5.5)(PORT = 1521))
                            )
                            (CONNECT_DATA =
                            (SERVER = DEDICATED)
                            (SERVICE_NAME = testdb)
                            )
                            )


                            Insight2 =
                            (DESCRIPTION =
                            (ADDRESS_LIST =
                            (ADDRESS = (PROTOCOL = TCP)(HOST = 5.5.5.5)(PORT = 1521))
                            )
                            (CONNECT_DATA =
                            (SERVER = DEDICATED)
                            (SERVICE_NAME = testdb)
                            )
                            )


                            InsightTest =
                            (DESCRIPTION =
                            (ADDRESS_LIST =
                            (ADDRESS = (PROTOCOL = TCP)(HOST = 5.5.5.5)(PORT = 1521))
                            )
                            (CONNECT_DATA =
                            (SERVER = DEDICATED)
                            (SERVICE_NAME = testdb)
                            )
                            )

                            Insight     =
                            (DESCRIPTION =
                            (ADDRESS_LIST =
                            (ADDRESS = (PROTOCOL = TCP)(HOST = 5.5.5.5)(PORT = 1521))
                            )
                            (CONNECT_DATA =
                            (SERVER = DEDICATED)
                            (SERVICE_NAME = testdb)
                            )
                            )

                            Timeforce =
                            (DESCRIPTION =
                            (ADDRESS_LIST =
                            (ADDRESS = (PROTOCOL = TCP) (HOST = 5.5.5.5)(PORT = 1521))
                            )
                            (CONNECT_DATA = (SID = Timeforce))
                            (HS=OK)
                            )


                            Thanks
                            sankar
                            • 11. Re: ORA-28545: error diagnosed by Net8 when connecting to an agent
                              Kgronau-Oracle
                              I don't see an issue in the config files.
                              Can you confirm that (HOST = DBSERVER3) and (HOST = 5.5.5.5) are the same?

                              If both hostname and IP Address match, please get from sysinternals.com the Process Monitor utility and start it without a filter. Then try to connect again to the DG4ODBC SID using SQL*Plus. Once you got again the error, please stop the Process Monitor and upload the file to a public file hosting server and provide the link.
                              • 12. Re: ORA-28545: error diagnosed by Net8 when connecting to an agent,
                                943956
                                Hello kgronau,

                                I think you need there details from the oracle data base server.please correct me if i'm wrong.

                                sysinternals.com is new to me, but still i will do some google and get these details.


                                Thanks & regards
                                sankar

                                Edited by: 940953 on Jun 20, 2012 10:38 PM
                                • 13. Re: ORA-28545: error diagnosed by Net8 when connecting to an agent,
                                  Kgronau-Oracle
                                  Commonly ping -a <hostname/IP Address> should give us the details:
                                  ping -a 5.5.5.5
                                  ping -a DBSERVER3
                                  • 14. Re: ORA-28545: error diagnosed by Net8 when connecting to an agent,
                                    943956
                                    Please find the process monitor output

                                    http://www.keepandshare.com/doc/embed_folder.php?i=2169255&da=y&cat=1

                                    Thansk
                                    sankar
                                    1 2 Previous Next