PERL, DBI and ORACLE

jayashrees has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: PERL, DBI and ORACLE by ghettofinger (Monk) on Mar 09, 2004 at 16:32 UTC
A simple google search reveals the following. ORA-12649: Unknown encryption or data integrity algorithm: Cause: A SQL*Net list-of-algorithms parameter included an algorithm name that was not recognized. Action: Either remove that algorithm name, correct it if it was misspelled, or install the driver for the missing algorithm. ghettofinger	[reply]
Re: PERL, DBI and ORACLE by dragonchild (Archbishop) on Mar 09, 2004 at 15:11 UTC
What investigation have you done? Have you googled to see if anyone else has run into this? Have you read the DBD::Oracle documentation to see if encryption is supported? ------ We are the carpenters and bricklayers of the Information Age. Please remember that I'm crufty and crochety. All opinions are purely mine and all code is untested, unless otherwise specified.	[reply]
Re: PERL, DBI and ORACLE by UnderMine (Friar) on Mar 09, 2004 at 16:50 UTC
Need more info. What version of Oracle client libraries and server are you running? Is it fully patched? Does TNSping work? Does SQLPlus work or return the same error? What is the SQLNET.ORA contain? etc. If you can answer the above we may be able to help UnderMine	[reply]
Re: Re: PERL, DBI and ORACLE by jayashrees (Initiate) on Mar 10, 2004 at 09:33 UTC
We r trying to connect from Perl to oracle8i using DBI. It worked fine before using the sqlnet.ora with encryption. After enabling the encryption , its giving the following error ORA-12649: Unknown encryption or data integrity algorithm (DBD ERROR: OCIServer8 Couldn't log onto Oracle and the versions r as follows. Oracle: 8.1.7.4.0 Perl: version 5.005_03 built for sun4-solaris DBI : DBI.pm,v 10.10 Tnsping and Sqlplus are working fine. Contents of sqlnet.ora as follows. #===================================== # File : sqlnet.ora # Purpose: Minimal needed sqlnet.ora #====================================== NAMES.DIRECTORY_PATH= (HOSTNAME,TNSNAMES) AUTOMATIC_IPC = OFF # RC 19-APR-2003 because of WebLogic hangovers #TRACE_LEVEL_CLIENT = OFF trace_level_client=16 trace_level_server=16 SQLNET.EXPIRE_TIME = 0 sqlnet.encryption_server=requested sqlnet.encryption_types_server=(RC4_128) sqlnet.crypto_seed="fkdsjfdsjfiowewekjfkjsdkjsdkdsjsdk1234567890" sqlnet.encryption_client=accepted sqlnet.encryption_types_client=(RC4_128)	[reply]