(ADDRESS=(PROTOCOL=tcp)(HOST=my_host)(PORT= 2961 )) * establish * IB *  12505 
TNS- 12505 : TNS:listener could not resolve SID given in connect descriptor

HS_FDS_CONNECT_INFO = IB
HS_FDS_TRACE_LEVEL=ON
HS_FDS_TRACE_FILE_NAME=d:\_o\ibtrace.log

LISTENER =
   (ADDRESS_LIST =
      (ADDRESS= (PROTOCOL=tcp)
                (HOST = my_host)
                (PORT =  1521 )
      )
  )

SID_LIST_MY_HOST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = OEMREP)
      (ORACLE_HOME = d:\oracle9)
      (SID_NAME = OEMREP)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = MyDB)
      (ORACLE_HOME = d:\oracle9)
      (SID_NAME = MyDB)
    )
    (SID_DESC =
        (PROGRAM = hsodbc)
        (ORACLE_HOME = d:\oracle9)
        (SID_NAME = IB)
    )
  )

OEMREP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = my_host)(PORT =  1521 ))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = OEMREP)
    )
  )

MyDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = my_host)(PORT =  1521 ))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = MyDB)
    )
  )

IB =
(DESCRIPTION =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = my_host)(PORT =  1521 ))
  )
  (CONNECT_DATA =
     (SID = IB)
  )
  (HS = OK)
)

SQL> connect sys as sysdba
Enter password:
Connected.
SQL> create public database link STAT using 'STAT';

Database link created.

SQL> select * from LOG@STAT;
select * from LOG@STAT
                  *
ERROR at line  1 :
ORA- 00604 : error occurred at recursive SQL level  1 
ORA- 00942 : table or view does not exist

SQL> create public database link STAT connect to sysdba identified by  "masterkey
"  using 'STAT';

Database link created.

SQL> select * from LOG@STAT;
select * from LOG@STAT
                  *
ERROR at line  1 :
ORA- 28536 : error in processing Heterogeneous Services initialization parameters
ORA- 28507 : error in data dictionary view sys.hs$_class_init
ORA- 02063 : preceding  2  lines from STAT
ORA- 00604 : error occurred at recursive SQL level  1 
ORA- 00942 : table or view does not exist

SQL> select * from sys.hs$_class_init;
select * from sys.hs$_class_init
                  *
ERROR at line  1 :
ORA- 00942 : table or view does not exist

SQL> select * from v$hs_agent;

no rows selected

O:\>tnsping stat

TNS Ping Utility for  32 -bit Windows: Version  9 . 0 . 1 . 1 . 1  - Production on  24 -APR- 20 
 03   14 : 14 : 43 

Copyright (c)  1997  Oracle Corporation.  All rights reserved.

Used parameter files:
d:\oracle9\network\admin\sqlnet.ora
d:\oracle9\network\admin\tnsnames.ora

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

O:\>

SQL> select * from sys.hs$_class_init;
select * from sys.hs$_class_init
                  *
ERROR at line  1 :
ORA- 00942 : table or view does not exist

SQL> select * from v$hs_agent;

no rows selected

Oracle Corporation  --- THURSDAY  APR 24 2003 14:42:08.260
 

Heterogeneous Agent Release 
 9 . 0 . 1 . 1 . 1  

( 0 ) [Generic Connectivity Using ODBC] version:  2 . 0 . 4 . 0 . 0030 
( 0 ) connect string is:
( 0 ) YEAR2000_POLICY=- 1 ;CONSUMER_API= 1 ;SESSION_BEHAVIOR_FLAGS= 4 ;PARSER_DEPTH= 2000 ;E-
( 0 ) XEC_FLAGS =  131592 ;defTdpName=STAT;binding=(STAT,ODBC, "STAT" );
( 0 ) ORACLE GENERIC GATEWAY Log File Started at  24 -Apr- 03   14 : 42 : 08 
Remote HO Agent received unexpected RPC disconnect

status  1003 :  ncrorpi_recv_procid, called from hotk.c, proc uid DBA7E63607BB-5B47-E000-72701B6A6FF0