HTMLDB and Advanced Security Option
557616Feb 2 2007 — edited Feb 8 2007I installed HTMLDB and the Apex upgrade. Now I'm trying to secure everything.
I got SSL encryption turned on in the httpd daemon.
Now I'm trying to turn on sqlnet encryption using the advanced security networking features. We've licensed advanced security and use it on all of our servers and clients. I've set encryption to required on the server side and restarted the listener. Then I copied my sqlnet.ora file to the HTMLDB Oracle_home/network/admin. When I try to run an appex connection I get:
[Thu Feb 1 20:40:58 2007] [notice] [client xxx.xxx.xxx.28] [ecid: 1170384058:207.160.154.29:6568:0:1,0] mod_plsql: ORA-12599 Execute ORA-12599: TNS:cryptographic checksum mismatch
[Thu Feb 1 20:40:58 2007] [alert] [client xxx.xxx.xxx.28] [ecid: 1170384058:207.160.154.29:6568:0:1,0] mod_plsql: Unable to issue alter session : alter session set nls_language= "AMERICAN" nls_territory= "AMERICA"
[Thu Feb 1 20:40:58 2007] [notice] [client xxx.xxx.xxx.28] [ecid: 1170384058:207.160.154.29:6568:0:1,0] mod_plsql: ORA-3114 Execute ORA-03114: not connected to ORACLE
When I turn off sqlnet encryption everything works.
So basically it looks as if the HTMLDB install doesn't include the Advanced Security option. Oh, and the HTMLDB oracle home seems to have a 10.1.0.x sqlnet client.
Two questions: Is it possible to install a 10.2.0.1 client over the top of the HTMLDB home so that I can get the advanced encryption option working? I've already tried applying the 10.2.0.3 patch to the HTMLDB ORACLE_HOME, and it worked, yet all the components seem to still be outdated.
Is there some other way to get the advanced encryption working between HTMLDB and the back-end 10gr2 database?