10 Replies Latest reply: Jul 25, 2013 4:59 AM by Mkirtley-Oracle RSS

    ORA-28546: connection initialization failed, probable Net8 admin error

    Ankit Ashok Aggarwal

      I am unable to access SQL DB server from Oracle

       

      ERROR at line 1:

      ORA-28546: connection initialization failed, probable Net8 admin error

      ORA-02063: preceding line from ODBC

       

      Please suggest? Details are as follows :

       

      DBlink is

      Create database link ODBC connect to "sa" identified by "orcl" using 'Master';

       

      Folder D:\app\admin\product\11.2.0\dbhome_1\hs\admin has initMaster.ora

      HS_FDS_CONNECT_INFO = Master

      HS_FDS_TRACE_LEVEL = OFF

       

      Folder ORACLE_HOME (D:\app\admin\product\11.2.0\dbhome_1\NETWORK\ADMIN) has listener.ora and tnsnames.ora as follows:

       

      1. tnsnames.ora:

       

      # tnsnames.ora Network Configuration File: D:\app\admin\product\11.2.0\dbhome_1\network\admin\tnsnames.ora

      # Generated by Oracle configuration tools.

       

      LISTENER_ORCL =

        (ADDRESS = (PROTOCOL = TCP)(HOST = FILT137)(PORT = 1521))

       

       

      ORACLR_CONNECTION_DATA =

        (DESCRIPTION =

          (ADDRESS_LIST =

            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

          )

          (CONNECT_DATA =

            (SID = CLRExtProc)

            (PRESENTATION = RO)

          )

        )

       

      ORCL =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = FILT137)(PORT = 1521))

          (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME = orcl)

          )

        )

       

       

      Master =(DESCRIPTION=(ADDRESS=  (PROTOCOL= TCP)(HOST=FILT137)(PORT=1521))(CONNECT_DATA=(SID=master)(HS=)))

       

      #Master =(DESCRIPTION=(ADDRESS=  (PROTOCOL= TCP)(HOST=FILT137)(PORT=1522))(CONNECT_DATA=(SID=Master))(HS=OK))

       

       

      1. Listener.ora:

       

      # listener.ora Network Configuration File: D:\app\admin\product\11.2.0\dbhome_1\network\admin\listener.ora

      # Generated by Oracle configuration tools.

       

      SID_LIST_LISTENER =

        (SID_LIST =

          (SID_DESC =

            (SID_NAME = CLRExtProc)

            (ORACLE_HOME = D:\app\admin\product\11.2.0\dbhome_1)

            (PROGRAM = extproc)

            (ENVS = "EXTPROC_DLLS=ONLY:D:\app\admin\product\11.2.0\dbhome_1\bin\oraclr11.dll")

          )

        )

       

      LISTENER =

        (DESCRIPTION_LIST =

          (DESCRIPTION =

            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

            (ADDRESS = (PROTOCOL = TCP)(HOST = FILT137)(PORT = 1521))

          )

        )

       

      ADR_BASE_LISTENER = D:\app\admin

       

       

      SID_LIST_LISTENER=

        (SID_LIST=

            (SID_DESC=

               (SID_NAME=master)

               (ORACLE_HOME=D:\app\admin\product\11.2.0\dbhome_1)

               (PROGRAM=dg4odbc)

            )

        )

        • 1. Re: ORA-28546: connection initialization failed, probable Net8 admin error
          Kgronau-Oracle

          you have 2 times the SID list listener in your listener.ora file That will now ork. Please merghe both contents so that the listener.ora file might look like:

           

          SID_LIST_LISTENER =

            (SID_LIST =

              (SID_DESC =

                (SID_NAME = CLRExtProc)

                (ORACLE_HOME = D:\app\admin\product\11.2.0\dbhome_1)

                (PROGRAM = extproc)

                (ENVS = "EXTPROC_DLLS=ONLY:D:\app\admin\product\11.2.0\dbhome_1\bin\oraclr11.dll")

              )

                (SID_DESC=

                   (SID_NAME=master)

                   (ORACLE_HOME=D:\app\admin\product\11.2.0\dbhome_1)

                   (PROGRAM=dg4odbc)

                )

            )

           

          LISTENER =

            (DESCRIPTION_LIST =

              (DESCRIPTION =

                (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

                (ADDRESS = (PROTOCOL = TCP)(HOST = FILT137)(PORT = 1521))

              )

            )

           

          ADR_BASE_LISTENER = D:\app\admin

           

           

          O

          nce done, please STOP and START the listener, then retry the select.

          - Klaus

          • 2. Re: ORA-28546: connection initialization failed, probable Net8 admin error
            Ankit Ashok Aggarwal

            Thanks Klaus for the revert.

             

            after making the changes and following steps, it is the output:

             

            SQL> select * from test@ODBC;

            select * from test@ODBC

                               *

            ERROR at line 1:

            ORA-28546: connection initialization failed, probable Net8 admin error

            ORA-02063: preceding line from ODBC

             

            Atleast ORA error code change Please suggest ?

            • 3. Re: ORA-28546: connection initialization failed, probable Net8 admin error
              Dird

              Have you thought about going from SQL to Oracle (pushing the data you want) using a Linked Server? It is much faster & easier to configure.

               

              Mike

              • 4. Re: ORA-28546: connection initialization failed, probable Net8 admin error
                Kgronau-Oracle

                can you please post the output of the following commands executed in a command line window once you have set the ORACLE_HOME correctly:

                set ORACLE_HOME=D:\app\admin\product\11.2.0\dbhome_1

                lsnrctl status

                tnsping master

                D:\app\admin\product\11.2.0\dbhome_1\bin\dg4odbc

                 

                 

                - Klaus

                • 5. Re: ORA-28546: connection initialization failed, probable Net8 admin error
                  Ankit Ashok Aggarwal

                  D:\app\admin\product\11.2.0\dbhome_1\BIN>lsnrctl status

                  LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 25-JUL-2013 12:46:45

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

                  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
                  STATUS of the LISTENER
                  ------------------------
                  Alias                     LISTENER
                  Version                   TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
                  Start Date                24-JUL-2013 16:58:15
                  Uptime                    0 days 19 hr. 48 min. 33 sec
                  Trace Level               off
                  Security                  ON: Local OS Authentication
                  SNMP                      OFF
                  Listener Parameter File   D:\app\admin\product\11.2.0\dbhome_1\network\admin\listener.ora
                  Listener Log File         d:\app\admin\diag\tnslsnr\FILT137\listener\alert\log.xml
                  Listening Endpoints Summary...
                    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
                    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=FILT137)(PORT=1521)))
                  Services Summary...
                  Service "CLRExtProc" has 1 instance(s).
                    Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
                  Service "master" has 1 instance(s).
                    Instance "master", status UNKNOWN, has 1 handler(s) for this service...
                  Service "orcl" has 1 instance(s).
                    Instance "orcl", status READY, has 1 handler(s) for this service...
                  Service "orclXDB" has 1 instance(s).
                    Instance "orcl", status READY, has 1 handler(s) for this service...
                  The command completed successfully

                  D:\app\admin\product\11.2.0\dbhome_1\BIN>tnsping master

                  TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 25-JUL-2013 12:46:57

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

                  Used parameter files:
                  D:\app\admin\product\11.2.0\dbhome_1\network\admin\sqlnet.ora


                  Used TNSNAMES adapter to resolve the alias
                  Attempting to contact (DESCRIPTION=(ADDRESS= (PROTOCOL= TCP)(HOST=FILT137)(PORT=1521))(CONNECT_DATA=(SID=master)(HS=)))
                  OK (60 msec)

                  D:\app\admin\product\11.2.0\dbhome_1\BIN>

                   

                  D:\app\admin\product\11.2.0\dbhome_1\BIN>dir dg4odbc.exe
                  Volume in drive D has no label.
                  Volume Serial Number is 4CA2-580F

                  Directory of D:\app\admin\product\11.2.0\dbhome_1\BIN

                  02-04-2010  AM 08:36           819,200 dg4odbc.exe
                                 1 File(s)        819,200 bytes
                                 0 Dir(s)  302,829,416,448 bytes free

                  D:\app\admin\product\11.2.0\dbhome_1\BIN>

                  • 6. Re: ORA-28546: connection initialization failed, probable Net8 admin error
                    Mkirtley-Oracle

                    Hi,

                      Your tnsnanmes.ora entry isn't correct.

                    It is the format -

                     

                    Master =

                       (DESCRIPTION=

                        (ADDRESS=  (PROTOCOL= TCP)(HOST=FILT137)(PORT=1521))

                          (CONNECT_DATA=

                             (SID=master)

                             (HS=)

                          )

                        )

                     

                    but it should be -

                     

                     

                     

                    Master =

                       (DESCRIPTION=

                        (ADDRESS=  (PROTOCOL= TCP)(HOST=FILT137)(PORT=1521))

                          (CONNECT_DATA=

                             (SID=master)

                          )

                          (HS=)

                        )

                     

                    - the (HS=) should be outside the CONNECT_DATA entry.

                     

                    Regards,

                    Mike

                    • 7. Re: ORA-28546: connection initialization failed, probable Net8 admin error
                      Ankit Ashok Aggarwal

                      Thanks Mike.

                       

                      this is the output after doing said changes:

                       

                      SQL> select * from test@ODBC;

                      select * from test@ODBC

                                         *

                      ERROR at line 1:

                      ORA-28500: connection from ORACLE to a non-Oracle system returned this message:

                      [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture

                      mismatch between the Driver and Application {IM014}

                      ORA-02063: preceding 2 lines from ODBC

                       

                      seems i had messed it duly and it will need due attention of my forum friends duly

                      • 8. Re: ORA-28546: connection initialization failed, probable Net8 admin error
                        Ankit Ashok Aggarwal

                        Problem -

                        ORA-28500: connection from ORACLE to a non-Oracle system returned this message:

                        [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture

                        mismatch between the Driver and Application {IM014}

                         

                        Solution -

                        Made DSN "Master" for 64 bits and 32 bits using following and it resolved.

                        ODBC for 64-bits locates here (c:\windows\system32\odbcad32.exe).

                        ODBC for 32-bits locates here ( c:\windows\sysWOW64\odbcad32.exe)

                        • 9. Re: ORA-28546: connection initialization failed, probable Net8 admin error
                          Mkirtley-Oracle

                          Hi,

                          Okay, the gateway is now making a connection to SQL*Server but you are getting an error from Microsoft.
                          The most likely cause is that you are running on Windows 64-bit but are using a 32-bit driver, or the other way - 32-bit Windows using a 64-bit driver.
                          If you are on Windows 64-bit then you must use a 64-bit ODBC driver with DG4ODBC.
                          If you have access to My Oracle Support have a look at this note -

                           

                          DG4ODBC 11.2 on Windows 64-bit Gives Error ORA-28500 The specified DSN Contains an Architecture Mismatch Between the Driver and Application (Doc ID 1475507.1)


                          Regards,

                          Mike

                           

                          Message was edited by: mkirtley Hi - I see you found the cause yourself. Glad you now have it working.