DBD:Oracle on Client Server

[MikeL_4]

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 ????

[H.Merijn Brand (procura]

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

[MikeL_4]

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