topic Re: DBD:Oracle on Client Server in Operating System - Linux

DBD:Oracle on Client Server

MikeL_4 — Tue, 27 Sep 2005 10:29:03 GMT

I'm installing DBD::Oracle on a Client server and the Database of course is on a Remote server.

How do I code the ORACLE_SID in the .setup_oracle_env file ??

ORACLE_SID=remoteserver:databasesid ????

Re: DBD:Oracle on Client Server

H.Merijn Brand (procura — Tue, 27 Sep 2005 10:41:34 GMT

I don't think you can, unless you have the same Oracle installed on the client as what you have installed on the server, since DBD-Oracle will have to link to the Oracle libraries, and even then I don't know if DBD-Oracle supports remote connections.

If you start the listener on the server side (if that's not already running), you can probably do what you want with DBD::ODBC

Enjoy, Have FUN! H.Merijn

Re: DBD:Oracle on Client Server

MikeL_4 — Tue, 27 Sep 2005 12:44:17 GMT

I got a hold of a DBA that said I just need to add parameters:

TWO_TASK=dummy
TNS_ADMIN=/opt/oracle/admin/network

Thanks