Home » RDBMS Server » Server Administration » network encryption (10.2.0.4)
network encryption [message #474916] Thu, 09 September 2010 12:03 Go to next message
faq_dba
Messages: 8
Registered: April 2009
Junior Member
Hi,

I am trying to set-up network encryption.

I have added following parameters to my server side sqlnet.ora file:
SQLNET.ENCRYPTION_SERVER = REQUIRED
SQLNET.ENCRYPTION_CLIENT = REQUIRED
SQLNET.ENCRYPTION_TYPES_SERVER =RC4_256
SQLNET.ENCRYPTION_TYPES_CLIENT =RC4_256
SQLNET.CRYPTO_CHECKSUM_SERVER = REQUIRED
SQLNET.CRYPTO_CHECKSUM_CLIENT = REQUIRED
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER = (MD5)
SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT = (MD5)

As per my understanding connections should start to fail from client side after addition of these parameter on server side sqlnet.ora (no changes to client side sqlnet.ora).
I am still able to connect to this server without connections getting failed.
Am i missing something else?
I already checked aso is installed on this database.
Just to add it is a RAC database with 2 nodes.
Thanks ..
Re: network encryption [message #474928 is a reply to message #474916] Thu, 09 September 2010 12:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If it is server sqlnet.ora then first remove all CLIENT parameters.

Regards
Michel
Re: network encryption [message #474932 is a reply to message #474928] Thu, 09 September 2010 12:55 Go to previous messageGo to next message
faq_dba
Messages: 8
Registered: April 2009
Junior Member
Done.
My sqlnet.ora on both server nodes look like this:
SQLNET.CRYPTO_SEED ="fsdfsdfsdfsdfsdfsdfsdfsdfwrewrwerwerwesdfsdfsdfsd"
SQLNET.ENCRYPTION_SERVER = REQUIRED
SQLNET.ENCRYPTION_TYPES_SERVER =RC4_256
SQLNET.CRYPTO_CHECKSUM_SERVER = REQUIRED
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER = (MD5)

Still able to connect from client..
Re: network encryption [message #474934 is a reply to message #474932] Thu, 09 September 2010 13:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is your Oracle edition?
select * from v$version;


Regards
Michel
Re: network encryption [message #474935 is a reply to message #474934] Thu, 09 September 2010 13:11 Go to previous message
faq_dba
Messages: 8
Registered: April 2009
Junior Member
10.2.0.3

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.3.0 - Productio
NLSRTL Version 10.2.0.3.0 - Production
Previous Topic: tablespace
Next Topic: ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
Goto Forum:
  


Current Time: Sun May 19 19:49:17 CDT 2024