----- Forwarded message from [EMAIL PROTECTED] -----
Delivered-To: [EMAIL PROTECTED]
Subject: RE: DBI with ORACLE encryption
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
From: [EMAIL PROTECTED]
Date: Thu, 11 Mar 2004 12:06:29 +0530
Hi,
We have an application which gives a corba interaface. We have written a
perl script to pull data out of the interface and dump the same to the
Oracle database. All we do with oracle is to take an database connection
using DBI of the format
$dbh = DBI->connect ('', $user_id, $password, 'Oracle');
All along this was working fine. When the oracle encryption is enabled in
SQLNET.ORA, then we got the problem as follows.
> ORA-12649: Unknown encryption or data integrity algorithm (DBD ERROR:
> OCIServerAttach)
All the related encryption algorithms are installed. We also tried some
other ways of connecting to database using dbi. Still the error persists.
WE are not sure about the advanced security option. Both the Perl script
and the database lie on the same server and the cryptoseed is set on this.
The below are the settings in the sqlnet.ora
*************************************************************************
sqlnet.encryption_server=requested
sqlnet.encryption_types_server=(RC4_128)
sqlnet.crypto_seed="
-kdje83kkep39487dvmlqEPTbxxe9dkl58shgfm673hhl81hsnbvlah2
hglgmlplvhwlot"
sqlnet.encryption_client=accepted
sqlnet.encryption_types_client=(RC4_128)
sqlnet.crypto_seed="
-kdje83kkep39487dvmlqEPTbxxe9dkl58shgfm673hhl81hsnbvlah2
hglgmlplvhwlot"
*************************************************************************
We are able to connect via SQL*Plus . Could you tell us the version of
the DBI , Perl are you using?
Regards
Jayashree
Ability is what you're capable of doing...Motivation determines what you
do...Attitude determines how well you do it.
"Gold, Samuel
(Contractor)" To: [EMAIL PROTECTED]
<[EMAIL PROTECTED] cc: "Tim Bunce ([EMAIL
PROTECTED])"
mil> <[EMAIL PROTECTED]>
Subject: RE: DBI with ORACLE encryption
03/10/2004 06:46
PM
Can you connect using SQL*Plus? I have encryption set up on my database
and
I can connect using perl just fine. Make sure that you can connect using
SQL*Plus, before you assume that it is a DBI issue. Do you have the
Advanced Security Option installed? What country are you in? You may not
be able to use the Advanced Security Option due to export restrictions.
Thanks,
Sam Gold
-----Original Message-----
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 10, 2004 7:59 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: DBI with ORACLE encryption
[moved to [EMAIL PROTECTED]
I can't help unless you, or someone, can indicate what OCI calls the driver
needs to make (assuming that is the problem).
Tim.
On Wed, Mar 10, 2004 at 02:05:49PM +0530, [EMAIL PROTECTED]
wrote:
> Hi,
>
> We are using Oracle version 8.1.7.4 as the database running on the
> solaris 2.8 operating system.
>
> We are trying to connect to the database using a perl script on the
> same solaris server.
>
> With the tnsnames.ora settings, it works fine. The moment we enable
> the oracle encryption using SQLNET.ORA, when we try to connect to the
> database via the perl script using DBI, we get the following error.
>
> ORA-12649: Unknown encryption or data integrity algorithm (DBD ERROR:
> OCIServerAttach)
>
> The version of the perl and the DBI version is
>
> Perl: version 5.005_03 built for sun4-solaris
>
> DBI : DBI.pm,v 10.10
>
> thks
>
>
> Regards
> Jayashree
>
>
> Ability is what you're capable of doing...Motivation determines what
> you do...Attitude determines how well you do it.
>
>
> This e-Mail may contain proprietary and confidential information and
> is sent for the intended recipient(s) only.
> If by an addressing or transmission error this mail has been misdirected
to you, you are requested to delete this mail immediately.
> You are also hereby notified that any use, any form of reproduction,
dissemination, copying, disclosure, modification,
> distribution and/or publication of this e-mail message, contents or its
attachment other than by its intended recipient/s is strictly prohibited.
>
> Visit Us at http://www.polaris.co.in
This e-Mail may contain proprietary and confidential information and is sent for the
intended recipient(s) only.
If by an addressing or transmission error this mail has been misdirected to you, you
are requested to delete this mail immediately.
You are also hereby notified that any use, any form of reproduction, dissemination,
copying, disclosure, modification,
distribution and/or publication of this e-mail message, contents or its attachment
other than by its intended recipient/s is strictly prohibited.
Visit Us at http://www.polaris.co.in
----- End forwarded message -----
