Re: How to make OCI client communicate its server through network?

You need to set up ORACLE_HOME, tnsnames.ora for connection string definitions, and all message files if you need error messages that make sense.

On Thu, 6 Nov 1997, Rich Tsui wrote:

> Hi Oracle gurus:
>
> Is it possible that an OCI client talks to its oracle server through
> netwrok without setting up an oracle server on the client side?
> In other words, an OCI code running on machine A (solaris 2.5) without
> any
> oracle server tries to connect to an oracle server on machine B (solaris
> 2.5).
>
> What I found is my OCI code can not connect to Oracle server on
> different
> machine. The following is the procedures I did.
>
> 1) compile an OCI code on an oracle server machine, i.e., machine B.
> (it can query table without any trouble.)
> 2) copy the binary code to machine A (running the same OS, Solaris 2.5).
>
> However, it failed to connect to server from machine A.
>
> Can anyone tell me how to make connection between the client and server
> on different machine? I know it would work if you also install another
> oracle
> server on the client machine but I don't want that way. Is there any
> alternative
> way to do it? I guess somehow the sql*net on client side must be set
> up.
>
> Thank you very much.
>
> Rich Tsui
> University of Pittsburgh
>
>
>

Max Chern, Unix Software Engineer     |  Voice: 818-296-5014
EarthLink Network, Inc.               |  Fax:   818-296-5113
maxchern_at_earthlink.net                |  3100 New York Dr., Ste 201
http://www.earthlink.net/             |  Pasadena, CA 91107