Oracle-L: (no subject)

From: Bruno Vanters <bruno.vanters_at_tietoenator.com>
Date: Mon, 14 Oct 2002 07:14:04 -0800
Message-ID: <F001.004E8047.20021014071404@fatcity.com>

Hello,

Could you explain me how to deal with folowing error:

select * from "sysaudit"@tg.big

*
ERROR at line 1:
ORA-28509: unable to establish a connection to non-Oracle system ORA-02063: preceding line from TG.BIG

(HP-UX 11, Oracle 8.1.6, tg4ifmx 8.1.6, Informix 9.2)

Tnsnames.ora:
tg.big.lv =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bigboy.konts.lv)(PORT = 1521))
    )
    (CONNECT_DATA =
(SID = tg4ifmx)

    )
    (HS=OK)
  )

Listener.ora:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )


      (ADDRESS_LIST =

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

)
(DESCRIPTION =
(PROTOCOL_STACK =

        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )


      (ADDRESS = (PROTOCOL = TCP)(HOST = bigboy)(PORT = 2481))

)
)

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = tg4ifmx)
(ORACLE_HOME = /app/oracle/gateway/901)
(PROGRAM = /app/oracle/parex_gateway/bin/tg.sh)
    )
  )

tg.sh:
#!/bin/sh

export ORACLE_HOME=/app/oracle/parex_gateway
export GATEWAY_SID=tg4ifmx
export INFORMIXDIR=/d11/informix/parex_informix

export INFORMIXSERVER=informix
export
LD_LIBRARY_PATH=/usr/lib:/app/oracle/parex_gateway/lib:/d11/informix/parex_i nformix/lib:/d11/informix/parex_informix/lib/esql export
SHLIB_PATH=/app/oracle/parex_gateway/lib:/usr/lib:/d11/informix/parex_inform ix/lib:/d11/informix/parex_informix/lib/esql export
PATH=/app/oracle/parex_gateway/bin:/bin:/usr/bin:/usr/ccs/bin:/usr/local/bin echo "" >> /app/oracle/parex_gateway/tg4ifmx/log/testtrace.out chmod 777 /app/oracle/parex_gateway/tg4ifmx/log/testtrace.out exec /app/oracle/parex_gateway/bin/tg4ifmx $* 2> /app/oracle/parex_gateway/tg4ifmx/log/testtrace.out

inittg4ifmx.ora:
HS_FDS_CONNECT_INFO=sysmaster_at_informix
HS_FDS_TRACE_LEVEL=5
#HS_FDS_RECOVERY_ACCOUNT=RECOVER
#HS_FDS_RECOVERY_PWD=RECOVER

HS_FDS_TRANSACTION_MODEL=READ_ONLY
HS_DB_NAME=TG
HS_DB_DOMAIN=BIG

set INFORMIXDIR=/d11/informix/parex_informix set INFORMIXSERVER=informix
set DELIMIDENT=y

testtrace.out is empty

tg4ifmx_agt_4470.trc:
hoagprd(2); Entered.
[Transparent gateway for INFORMIX] version: 2.0.4.0.0009 connect string is:
YEAR2000_POLICY=-1;CTL_DEBUG=T;CONSUMER_API=1;SESSION_BEHAVIOR_FLAGS=4;PARSE R_-
DEPTH=2000;EXEC_FLAGS =
131080;defTdpName=tg4ifmx;binding=(tg4ifmx,INFORMIX,"sysmaster_at_informix"); ORACLE INFORMIX GATEWAY Log File Started at 14-Oct-02 14:41:05 Class version: 73

hoagprd(2); Exited with retcode = 0.
hoainit(3); Entered.
hoainit(3); Exited with retcode = 0.
hoalgon(7); Entered. name = informix.

Silent DB Function!!
(Last message occurred 2 times)

hoalgon(7); Exited with retcode = 0.
hoaulcp(4); Entered.
hoaulcp(4); Exited with retcode = 0.
hoauldt(5); Entered.
hoauldt(5); Exited with retcode = 0.
hoabegn(9); Entered. formatID = 306206, hoagttid

=TST.BIGBOY.KONTS.LV.80278506.1.5.36, hoagtbid = ., tflag = 0, initial = 1 DB_INF EXECUTE_IMMEDIATE:
BEGIN WORK
SET ISOLATION TO COMMITTED READ
SET LOCK MODE TO NOT WAIT
(Last message occurred 3 times)
hoabegn(9); Exited with retcode = 0.
hoadtab(26); Entered.
Silent DB Function!!

Listener.log:
14-OCT-2002 14:41:05 * (CONNECT_DATA=(SID=tg4ifmx)) * (ADDRESS=(PROTOCOL=tcp)(HOST=159.148.42.8)(PORT=52994)) * establish * tg4ifmx * 0

Bruno Vanters
Junior DBA
TietoEnator Financial Solutions
41 Lacplesa str., Riga, LV-1011, Latvia
phone: +371 7286660, fax: +371 7243000
Mob. phone: +371 6337831
www.tietoenator.lv

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bruno Vanters
  INET: bruno.vanters_at_tietoenator.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Oct 14 2002 - 10:14:04 CDT