Bruno
I don't believer that many people on this list use the Informix gateway.
Also, I feel that if the subject line of the email is filled in, you stand a
better chance of getting a reply. That said, my experience with a gateway
product is zero, but I'll post the output of oerr on the off chance you
haven't checked it yet.
SQL> !oerr ora 28509
28509, 00000, "unable to establish a connection to non-Oracle system"
// *Cause: Initialization of a database link to a non-Oracle system
// failed to connect to the Heterogeneous Services agent
// process for this non-Oracle system.
// *Action: Check the Net8 service name definition in the following
// places:
// -- the USING clause of the CREATE DATABASE LINK statement
// -- the TNSNAMES.ORA file
// -- the Oracle Names Server
//
// The following are possible reasons for name mismatches:
// -- The USING clause in the CREATE DATABASE LINK statement has
// to match the service name defined in the TNSNAMES.ORA file
// or in the Oracle Names Server.
// -- The protocol-specific information in the service name
// definition must match the protocol-specific definition
// of the responding listener.
// -- The SID=<name> in the service name definition
// (in the TNSNAMES.ORA file or in Oracle Names Server) must
// match the value in the LISTENER.ORA file for the
responding
// listener.
//
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Monday, October 14, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
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).
