Oracle Database Discussions

Oracle 11.1
OS Windows XP

I am trying to configure HS for Excel file. I am getting following

SQL> create public database link testlink connect to "nkesana" identified by "k*ssddwwgg" using 'excl';

Database link created.

SQL> select * from all_tables@testlink;
select * from all_tables@testlink
                         *
ERROR at line 1:
ORA-28513: internal error in heterogeneous remote agent
ORA-02063: preceding line from TESTLINK

i did following steps for HS configuration..

create a DNS with name EXCL

ODBC connection-->SYS DNS->Excel ODBC-->create-->EXCL

Gateway..................initEXCL.ora

# Important parameters

HS_FDS_CONNECT_INFO = excl

#HS_AUTOREGISTER = TRUE
# Possible parameters
#HS_DB_NAME = Employe

HS_FDS_TRACE_LEVEL = 0

My listener file

LISTENER =
 (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
     (ADDRESS = (PROTOCOL = TCP)(HOST = aba3br102iba.corp.ads.vl.net)(PORT = 1521))
   )
  )

SID_LIST_LISTENER=
   (SID_LIST=
      (SID_DESC= 
         (SID_NAME=EXCL)
         (ORACLE_HOME=D:\app\nkesana\product\11.1.0\db_1)
         (PROGRAM=dg4odbc)
      )
   )

TNS file

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = aba3br102iba.corp.ads.vl.net)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )


EXCL=
   (DESCRIPTION=
      (ADDRESS=
         (PROTOCOL=TCP)
         (HOST=localhost)
         (PORT=1521)
      )
      (CONNECT_DATA=
         (SID=EXCL))
      (HS=OK))

Output of listner status

LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 26-APR-2012 15:23:15

Copyright (c) 1991, 2007, 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.1.0.6.0 - Production
Start Date                26-APR-2012 14:46:21
Uptime                    0 days 0 hr. 36 min. 54 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   D:\app\nkesana\product\11.1.0\db_1\network\admin\listener.ora
Listener Log File         d:\app\nkesana\diag\tnslsnr\aba3br102iba\listener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=aba3br102iba.corp.ads.vl.net)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=aba3br102iba.corp.ads.vl.net)(PORT=8080))(Presentation=HTTP)(Session=RAW)
Services Summary...
Service "EXCL" has 1 instance(s).
  Instance "EXCL", 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...
Service "orcl_XPT" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully

output of tnsping

TNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - Production on 26-APR-2012 15:23:49

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

Used parameter files:
D:\app\nkesana\product\11.1.0\db_1\network\admin\sqlnet.ora


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

Please help.

Thanks,
Hesh.

Edited by: Hesh on Apr 26, 2012 3:56 AM