Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to use OCI program access remote oracle db?
Xie Haifeng wrote:
> Hi,everyone
> I have wrote a little program with OCI to operator local oracle db, and it
> done well.
> but now I want to run this program on another machine which have no oracle
> installed. I want to use it to access remote oracle db. I have copied the
> lib that program required to another machine(include oracle lib). And it can
> run but only get "Error while trying to retrieve text for error ORA-12545".
> Does there are some extra set? Or I must install oracle on another
> machine? and after install does there are somethings to set?
> The two machine are all Turbo Linux, and oracle is oracle 8.1.7.0
>
> thanks a lot.
>
> xie.
>
>
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
Received on Mon Apr 28 2003 - 21:46:37 CDT
![]() |
![]() |