| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Informix gateway error
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.
dwilliams_at_lifetouch.com
-----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))
)
(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_informixexport INFORMIXSERVER=informix
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
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.
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:
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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.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 - 16:14:25 CDT
 |
 |