--- Shane Presley <shane.presley@gmail.com> wrote:
So I am considering moving my syslog-ng entries into Oracle. I've found the scripts to do that, but still working with our DBAs on it. One question I had, do we need an Oracle client on the syslog-ng server?
With MySQL you can connect to a remote SQL server using the script directly. The Oracle scripts also seem to reference an Oracle Server and port. But my Oracle DBA's seem to think they have to install the Oracle client.
Anyone done this before to a remote Oracle server?
Thanks Shane _______________________________________________ syslog-ng maillist - syslog-ng@lists.balabit.hu https://lists.balabit.hu/mailman/listinfo/syslog-ng Frequently asked questions at http://www.campin.net/syslog-ng/faq.html
You will need the libclntsh.so client library at a minimum. If these scripts you are referring to are perl, you will also need the DBD-Oracle module (and this module will require linking against the oracle library). (I assume since it works with mysql that you are using perl since the mysql perl modules normally come default with linux now days) Personally I use just a plain simple bash script that calls sqlplus (using sqlplus will require a larger oracle client installation) to load my logs into oracle. Perl and its cludge or modules has gotten so sloppy these days I tend to use it as a last resort for anything. CC