I posted a short message earlier but here is more detail: Current we are having a problem accessing an Oracle 9i database with the Security encryption turned on. We are a client site and have an oracle8i client and are using perl scripts to access the database and generate reports.
Here's the situation. We had our oracle database moved and upgraded to Oracle 9i. This database is in one location and I am worker at another location (where the previous 8i database existed). The reports we use (on unix solaris 9) to contact the database use perl 5.6.0. and use an oracle8i client for the interface. Without ASO, I can contact the database in the new location and get information. However when ASO is activated we get an oracle error ORA-12660: Encryption or crypto-checksumming parameters incompatible (DBD ERROR: OCIServerAttach) We thought perhaps this might be because the older oracle 8i client was not installed with ASO. So we copied binaries from the oracle 9i client to the server and used these. However we still get the same error. Now the thought is that we need to re-install the Perl DBD::Oracle driver as we think it needs to link with the new 9i client. What are your thoughts on this? Do we have to re-make the Perl DBD driver to access this feature? Thanks for your interest. Steve
