PROGRAM (agent) for HetConn to Interbase?
388693Mar 3 2003 — edited Mar 13 2003I have installed 9i on XP (all seems well except that OMS will not run - tips on that accepted, too) and need to move data from an Interbase db on a Unix machine, to a 9i db on the XP.
I have successfully configured, and am using, an ODBC connection to the Interbase db - using Power Designer to reverse engineer the Ibase db and generate scripts for 9i.
I do not seem to be able to get an Oracle heterog. connection established from 9i to Ibase. I've tried the NetMgr, as well as directly editing listener.ora, tnsnames.ora, and the .ora file needed in the ORACLE_HOME/hs directory.
I am guessing that part of my problem is not knowing, with any assurance, what should go in these fields in the NetMgr:
for listener.ora - what is the agent executable here:
SID is pretty clear
ORACLE_HOME - it wants the OraHome of the agent exe?
PROGRAM - specify the name of the agent exe?
for tnsnames.ora:
seems to want the SERVICE_NAME = SID, above
(HS-ok)
the ADDRESS descriptor - it's tcp, but are PORT
and HOST 1521 and the XP (yes?)?
Testing the connection in NetManager fails. I'm assuming that the OMS problem is unrelated.
please respond here or to sriley@veic.org -- thanks!
Sara R.