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@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@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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).