Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to use OCI program access remote oracle db?

Re: how to use OCI program access remote oracle db?

From: Tony Young (ty) <acmy_blahau_at_yahoo.com.au>
Date: Tue, 29 Apr 2003 03:51:29 GMT
Message-ID: <5Fmra.30$Su1.2369@news.optus.net.au>


Xie Haifeng wrote:

>>I believe it needs TNSADMIN files as well to find out where the listener

>
> is (I
>
>>could be wrong).
>>Try copying your listener.ora and tnsnames.ora files over and set

>
> TNS_ADMIN to
>
>>point to the directory you put them in before trying to run the program

>
> again.
>
>>I've never tried this myself (remote access without a local server), but I
>>think ORA-12545 is a 'could not resolve TNS name error'.
>>
>>hth
>>ty
>>

>
>
> Thanks for your reply. For I'm a newer in use oracle and I lack many
> concepts about oracle.
> I have copy listener.ora and tnsnames.ora to the 2nd machine. Does "set
> TNS_ADMIN to
> point to the directory" means set a environment variable called "TNS_ADMIN".
> If so I
> have already set it ,but it doesn't work. Error msg is still "ORA-12545".
> I want to know if I install oracle on the 2nd machine could easy resolve
> this problem?
> Does there have some general or extra setting?
> Thanks again.
>
> xie.
>
>

If that didn't work then I can't help - I don't know alot about how the OCI connections REALLY work myself.
Installing oracle on the 2nd machine will most certainly help - but is that what you really want to do? Doesn't sound like it.

ty Received on Mon Apr 28 2003 - 22:51:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US