oracle informix gateway
Date: Tue, 1 Mar 2005 10:58:52 +0100
Message-ID: <1109671133.546154_at_ftpgate>
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_at_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.
Received on Tue Mar 01 2005 - 10:58:52 CET