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

From: Xie Haifeng <xiehaifeng_at_hotmail.com>
Date: Tue, 29 Apr 2003 11:42:35 +0800
Message-ID: <b8ksd2$b04dj$1@ID-179281.news.dfncis.de>

> 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. Received on Mon Apr 28 2003 - 22:42:35 CDT