Oracle 12C Windows TLS traffic encryption

How to identify if server/client use TLS 1.2?
Const ChumakAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

btanExec ConsultantCommented:
Should reference this to minimally reach the console to list out the cipher string
https://docs.oracle.com/database/121/DBSEG/asossl.htm#CBHIGGHJ
... and on the server, those cipher entries should be available in the server (e.g."$ORACLE_HOME/network/admin/sqlnet.ora") file and in listener (e.g. $ORACLE_HOME/network/admin/listener.ora")  to accept SSL/TLS encrypted connections
https://oracle-base.com/articles/misc/configure-tcpip-with-ssl-and-tls-for-database-connections#server-network-configuration
...best is to sniff the actual traffic - has to look at protocol version for TLS 1.2 like in this snapshot
https://jimshaver.net/wp-content/uploads/2015/02/2015-02-11-22_29_11-.png
...and to drill into pcap raw packet content you will see the version as 0303 as per rfc 5246, for TLS1.0 it is as stated
the first three fields of an "Application Data" record are:
•Content Type (0x17 to indicate Application Data)
•Protocol Version (0x0301 for TLS1.0, et al)
•Record Length (length in Bytes of encrypted content)
http://security.stackexchange.com/questions/54466/in-ssl-tls-what-part-of-a-data-packet-is-encrypted-and-authenticated
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2012

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.