Beefy Boxes and Bandwidth Generously Provided by pair Networks Russ
Perl-Sensitive Sunglasses
 
PerlMonks  

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

--BigJoe

Learn patience, you must.
Young PerlMonk, craves Not these things.
Use the source Luke.

Comment on Using DBD::Oracle with Net8 (for encryption)
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.

    rdfield

[reply]

Back to Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://211128]
Approved by Snuggle
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (20)
As of 2013-05-22 15:33 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best material for plates (tableware) is:









    Results (464 votes), past polls