Re: Accessing Multiple Oracle Homes from One Client PC

Hi,

    Your TNSNAMES.ORA file on your PCs can address multiple instances of Oracle on the same or different machines. When your users log in they can specify the machine they wish to connect to. (To make it easier for the users you can even assign aliases such as "A/R" to the system used for Accounts Receivable and "PR" for the system used for Payroll).

regards

Jerry Gitomer

Jane Bonney wrote:

> We have two Oracle applications, each located on separate NT servers running
> on the same network (single domain on a LAN), using TCP/IP network protocol
> and SQLnet. The Windows 95 client PC's need to access both ORACLE
> applications, although not necessarily simultaneously. Our suppliers
> believe that it is only possible to have a Windows 95 client reference a
> single ORACLE home and so consequently our client PC's reference one Oracle
> Home directory on only one of the servers, but this means that in the event
> of a problem with this server, both applications will fail.
>
> Is there any way of referencing multiple Oracle Homes from one client to
> circumvent this situation?
>
> Jane Bonney
> Business Services Analyst
> mailto:JaneB_at_cheltenham.gov.uk

--
Jerry Gitomer
Computers were made for selling, not for using. They don't give you any grief until you try to use them. Received on Tue Mar 09 1999 - 23:33:09 CST