| Title: | DEC Rdb against the World |
| Moderator: | HERON::GODFRIND |
| Created: | Fri Jun 12 1987 |
| Last Modified: | Thu Feb 23 1995 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 1348 |
| Total number of notes: | 5438 |
Hi, I'm looking for an information about Oracle distributed capabilities. I know that SQL*STAR is supposed to make possible access to different databases on different machines with different operating system over a net... In particular I would like to know if SQL*STAR makes possible for an Oracle application to access simultaneously an Oracle db on a VAX and an Oracle db on a SUN workstation. Is this possible today with V6? If yes, does anybody know sites where this has been implemented? Thanks in advance for any help, Carla
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 690.1 | Yes and No ... depending | MAIL::DUNCANG | Oracle... the one-line database | Fri Jul 20 1990 17:35 | 28 |
SQL*star is a marketing concept not a product. The individual products
are typically SQL*net (operating system specific) and a protocol
(operating system specific AND protocol specific). For example,
for a VMS Oracle database to talk to another VMS Oracle database the
customer would buy two copies of SQL*net for VMS and two copies of
DECnet protocol for SQL*net.
Under the same guidelines, for a VMS Oracle datbase to talk to a Sun
Oracle database, I would speculate that one would order SQL*net for VMS
and the TCP/IP protocol for VMS AND TCP/IP protocol for SunOS and the
SQL*net layer for SunOS.
"Simultaneously" is a vague term because depending on the programming
interface, the answer is yes and no. You should (and probably will
HAVE) to talk to an Oracle technician to get the "real" answer. I know
that with interactive SQL (SQL*plus) you can touch two databases at the
same time. However, I don't believe you could use a C program with
embedded SQL and touch two databases at the same time.
You're going to have to get by Oracle's marketing hype and ask some
very specific questions. I would start by asking the customer what HE
NEEDS to do and then talk to the Oracle folks. That way you don't have
the Oracle salesman telling the customer what is needed.
Hope this helps ....
-- gerry
| |||||
| 690.2 | TRNAF1::DELMONTE | Carla Delmonte,SWS Turin (Italy) | Tue Jul 24 1990 13:12 | 10 | |
Thanks Gerry for your reply. The customer isn't indeed a Digital customer because he has only a TCP/IP-SUN-ORACLE configuration. Unfortunately, at this moment the only way to push a Vax machine into his net is to be sure that Oracle on a mixed environment DEC/SUN has no limitations in comparison with Oracle on a SUN-only environment. I'll ask the customer to be more specific about the functionalities he needs. Carla | |||||