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