Re: Will Oracle 7.1 run on a mainframe (mvs operating system)?
Date: 23 Nov 1994 03:10:17 GMT
Message-ID: <3aubqp$emf_at_dcsun4.us.oracle.com>
I'll chime in here since Dave is incommunicado for a few days.
tekennel_at_VNET.IBM.COM wrote:
[...]
>Thanks for your response Dave. May I ask a few more questions. Suppose
>the application running on the Sun Server makes RPC requests of an
>Oracle database on another Sun Server (logic server to data server).
>Can Oracle on the mainframe accept RPC's from the Sun Servers (with
>application logic running on them). If so how does it occur. Does
>the rpc occur on a particular socket address (tcpip addr + port #).
>Is Oracle so good (I hope) that it would be transparent to the Sun
>Server (running business logic) that the database and its stored
>procedures could be moved to a mainframe without application changes?
Yes, it is transparent.
It is possible to come up with SQL or PL/SQL constructs that produce
different results on EBCDIC vs. ASCII servers, e.g.
...WHERE CHAR_COL BETWEEN '0' AND 'Z'
but these are harder to invent than to avoid.
Procedure calls from one Oracle to another use SQL*Net connections just like Oracle<->Oracle distributed SQL. Just to clarify, this has no relationship at all to Sun's native RPC mechanism (which I believe works only over TCP/IP). SQL*Net is designed to be protocol-independent.
In general, the SQL*Net TCP/IP products are configured to listen on a particular IP address and port; client (calling) systems maintain that information in a configuration file. Note that on MVS and some other platforms, SQL*Net APPC (SNA LU6.2) is a viable alternative.
>Also, note that our mainframe already has tcpip installed (using
>a 3172 as a gateway between the host and an ethernet). Besides
>waiting for 7.14 is there anything else that is needed on the mainframe
>to run an Oracle database (like IBM's C, C++....).
In addition to the database product you will need the correct flavor of MVS SQL*Net TCP/IP V2, presumably for IBM's TCP/IP. (We support several vendors' offerings.) You don't need a C compiler nor a C runtime library.
/b
Bill Manry
Oracle Corp. / Mainframe & Integration Technologies / BManry_at_us.oracle.com #include <disclaimer.usual> Received on Wed Nov 23 1994 - 04:10:17 CET