Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Using DBD::Oracle with Net8 (for encryption)

by BigJoe (Curate)
on Nov 07, 2002 at 17:13 UTC ( [id://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.

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.

    rdfield

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
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?Last hourOther CB clients
Other Users?
Others learning in the Monastery: (7)
As of 2024-03-28 22:00 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found