Database Security Products (MOSC)

MOSC Banner

Oracle 12c Native network encryption

I am trying to enable oracle 12c native network encryption for a database setup in a RHel 7 environment. I have added these parameter to sqlnet.ora file in $ORACLE_HOME/network/admin on database server side

SQLNET.ENCRYPTION_SERVER = REQUESTED

SQLNET.ENCRYPTION_TYPES_SERVER = (AES256)


I have added this to the client side (testing with sql developer)

SQLNET.ENCRYPTION_CLIENT = REQUESTED

SQLNET.ENCRYPTION_TYPES_ = (AES256)


But when I run this sql

select network_service_banner 

   from v$session_connect_info i, v$session s 

   where 

   i.sid = s.sid and

   i.sid in (select distinct sid from v$mystat) ;

The output is not right

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center