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) <acmay_blahau_at_yahoo.com.au>
Date: Tue, 29 Apr 2003 02:46:37 GMT
Message-ID: <hIlra.24$Su1.2421@news.optus.net.au>


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

Original text of this message

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