Home » Infrastructure » Other Operating Systems » accessing remote Oracle DB from OS/390
accessing remote Oracle DB from OS/390 [message #113915] Fri, 16 May 2003 13:24 Go to next message
Peter Vander Woude
Messages: 2
Registered: January 2001
Junior Member
If we want to have jobs running under OS/390 directly accessing an Oracle DB on another box, do I have to have Oracle installed on the mainframe. Or is there some "stub" program(s) that can be on the OS/390 system to provide ODBC access to the remote Oracle instance.

Thanks,
Pete
Re: accessing remote Oracle DB from OS/390 [message #113919 is a reply to message #113915] Wed, 11 June 2003 11:00 Go to previous message
Jim Gillespie
Messages: 23
Registered: January 2001
Junior Member
: If we want to have jobs running under OS/390 directly accessing an Oracle DB on another box, do I have to have Oracle installed on the mainframe. Or is there some "stub" program(s) that can be on the OS/390 system to provide ODBC access to the remote Oracle instance.

: Thanks,
: Pete

I could be wring but I would think you just need TNS(SQLNET) running and a valid tnsnames file in the jcl or proc that has the proper descriptors to get you to the remote db.

Jim Gillespie
Previous Topic: Accessing DB2/400 from Oracle 9i
Next Topic: Oracle 9.2.0.2 CICS Compile JCL
Goto Forum:
  


Current Time: Thu Dec 12 07:27:38 CST 2024