Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle Advanced Security

Re: Oracle Advanced Security

From: Li Li <>
Date: Thu, 16 Mar 2006 12:04:10 -0600
Message-ID: <>

Thanks, George! My database is 10g R1. I finally found out that the same settings actually worked in one of my 10g environments. It didn't work in one 10g R1 environment because the database was automatically installed by an application. There must be something that wasn't installed or configured right in it. How to confirm that Advaced Security was installed?

On 3/16/06, Johnson, George <> wrote:
> I have set it up fine on 9 and 10 kits.
> Couple of things to check.
> Have you tried using AES and DES schemes like AES256,
> AES192 and/or 3DES168, I couldn't get RC4 to work?
> If 9i is involved, make sure the ASO option is installed, I
> believe 10g gets it by default now.
> Try enabling SQL tracing on level 16 during your test
> connections, then scan the logs for "encryption" this should show any errors
> or problems.
> Rgds
> -----Original Message-----
> *From:* [mailto:
>] *On Behalf Of *Li Li
> *Sent:* 16 Mar 2006 14:42
> *To:* oracle-l
> *Subject:* Oracle Advanced Security
> Hi, All,
> Has anybody used Oracle Advanced Security to encrypt all the network
> traffic between client and server?
> I set up the following in sqlnet.ora both on the client and server, but it
> didn't work:
> sqlnet.encryption_server=required
> sqlnet.encryption_client=required
> sqlnet.encryption_types_client=(rc4_128)
> sqlnet.encryption_types_server=(rc4_128)
> sqlnet.crypto_seed=pqowieuryt;laksjdhfgmznxbcv,.s1
> Also where to find documentation about how to set this up? I couldn't find
> anything on otn ;-(
> Any suggestion would be greatly appreciated!
> Thanks,
> -Li
> ****************************************************************************
> This message contains confidential information and is intended only
> for the individual or entity named. If you are not the named addressee
> you should not disseminate, distribute or copy this e-mail.
> Please notify the sender immediately by e-mail if you have received
> this e-mail by mistake and delete this e-mail from your system.
> E-mail transmission cannot be guaranteed to be secure or error-free
> as information could be intercepted, corrupted, lost, destroyed, arrive
> late or incomplete, or contain viruses. The sender therefore does not
> accept liability for any errors or omissions in the contents of this
> message which arise as a result of e-mail transmission.
> If verification is required please request a hard-copy version.
> This message is provided for informational purposes and should not
> be construed as an invitation or offer to buy or sell any securities or
> related financial instruments.
> GAM operates in many jurisdictions and is
> regulated or licensed in those jurisdictions as required.
> ****************************************************************************

Received on Thu Mar 16 2006 - 12:04:10 CST

Original text of this message