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"
*************************************************************************
thks
Regards
Jayashree
Ability is what you're capable of doing...Motivation determines what you
do...Attitude determines how well you do it.
Kevin Moore
<[EMAIL PROTECTED] To: Tim Bunce <[EMAIL
PROTECTED]>
com> cc: [EMAIL PROTECTED],
[EMAIL PROTECTED]
03/11/2004 06:28 Subject: Re: DBI with ORACLE encryption
AM
I assume you have enabled Oracle Advanced Security. There are client and
server specific settings as well as the CRYPTO SEED which must be the
same on both. I'm sure you can find this on google or the free Oracle
forums. Hope it helps.
Kevin
Tim Bunce wrote:
>[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
