This discussion is archived
10 Replies Latest reply: Jul 25, 2013 2:59 AM by mkirtley-Oracle RSS

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

AnkitAshokAggarwal Explorer
Currently Being Moderated

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 Guru
    Currently Being Moderated

    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
    AnkitAshokAggarwal Explorer
    Currently Being Moderated

    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 Pro
    Currently Being Moderated

    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 Guru
    Currently Being Moderated

    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
    AnkitAshokAggarwal Explorer
    Currently Being Moderated

    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 Expert
    Currently Being Moderated

    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
    AnkitAshokAggarwal Explorer
    Currently Being Moderated

    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
    AnkitAshokAggarwal Explorer
    Currently Being Moderated

    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 Expert
    Currently Being Moderated

    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.

  • 10. Re: ORA-28546: connection initialization failed, probable Net8 admin error
    AnkitAshokAggarwal Explorer
    Currently Being Moderated

    Thanks Mike/Klaus. You people rocks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points