oracle informix gateway

Sachindra Kumar Meshram v · *nix forums Guru Wannabe Joined: 12 May 2005 Posts: 227

Are you an oracle person or an informix person.
I am informix, with light oracle. Used an ancient gateway product once
(pre-IBM purchase of informix).

the only thing i can think of is that perhaps if the install asks for an
oracle bin directory and you didn't give it the right one?

--
Message posted via http://www.dbmonster.com

max · *nix forums beginner Joined: 07 Mar 2005 Posts: 7

Problem Installing transparent Gateway oracle informix

I installed the Oracle Gateway to informix according to the poor
documentations I got from IBM and the manual of oracle.Nr.B10527-01.

My Database is: Oracle 10g 1.x

I run a database called cdrdwh2 freshly installed.

My Informix stuff is installed in /informix/tg4ifmx
This is my profile :

stty istrip
PATH=/usr/bin:/usr/ucb:/usr/local/mozilla:/usr/local/bin:/etc:/opt/Acrobat5/
bin:/usr/local/bin:/oracle/oradb10g/bin:.
export PATH
umask 022
ORACLE_BASE=/oracle
ORACLE_HOME=/oracle/oradb10g
export ORACLE_HOME
export ORACLE_BASE
#
# Informix Parameters
#
HS_FDS_CONNECT_INFO=metrica_performance@myserverwithinformix.com
INFORMIXDIR=/informix/tg4ifmx
export HS_FDS_CONNECT_INFO
export INFORMIXDIR

This is my listener.ora File. One of my tries . I reduced it to a minimum:
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=tg4ifmx)
(ORACLE_HOME=/oracle/oradb10g)
(PROGRAM=tg4ifmx)
(ENVS=LD_LIBRARY_PATH=/informix/tg4ifmx/lib/esql:/oracle/oradb10g/lib:/oracl
e/oradb10g/tg4ifmx/lib32)
)
)

This is my result when I try to start the listener:
LSNRCTL> start
Starting /oracle/oradb10g/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 10.1.0.2.0 - Production
System parameter file is /oracle/oradb10g/network/admin/listener.ora
Log messages written to /oracle/oradb10g/network/log/listener.log
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myoracleserver)(PORT=1521)))
TNS-01201: Listener cannot find executable /oracle/oradb10g/bin/tg4ifmx for
SID
tg4ifmx

I tried several thing.
But it seemed that the following Programm is missing:
/oracle/oradb10g/bin/tg4ifmx

What did I wrong?
Any Help appreciated.

Google