Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight

Using DBD::Oracle with Net8 (for encryption)

by BigJoe (Curate)
on Nov 07, 2002 at 17:13 UTC ( #211128=perlquestion: print w/replies, xml ) Need Help??
BigJoe has asked for the wisdom of the Perl Monks concerning the following question:

I am using DBD::Oracle on my webservers to connect my perl scripts from the Apache server to the Oracle 8i databases. The documentation for DBD::Oracle says it uses sqlnet 1 and 2 and it bypasses the tnsnames.ora/sqlnet.ora. So how do I set it up to use net8 instead of sqlnet 1/2 to allow the DBA to encrypt the traffic? Thanks Joe


Learn patience, you must.
Young PerlMonk, craves Not these things.
Use the source Luke.
  • Comment on Using DBD::Oracle with Net8 (for encryption)

Replies are listed 'Best First'.
Re: Using DBD::Oracle with Net8 (for encryption)
by rdfield (Priest) on Nov 08, 2002 at 11:07 UTC
    I believe that the documentation is out of date. Wherever it says SQL*Net 2.x read 'SQL*Net 2.x or later'. DBD::Oracle only bypasses the tnsnames.ora file if you supply a full connect descriptor, e.g. 'T:hostname:sid'. I use DBD::Oracle with a 9i setup and I can assure you that the connect arrives via SQL*Net after looking up the alias in tnsnames.ora and the values in sqlnet.ora. An easy way to check is to add the entry 'TRACE_LEVEL_CLIENT = ADMIN' to your local sqlnet.ora and look for .trc files in your current working directory. Remember to remove the entry before you do any serious processing otherwise it will use copious amounts of disk space.


Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://211128]
Approved by Snuggle
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (5)
As of 2018-06-19 03:55 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (111 votes). Check out past polls.