verifying network encryption on 11gR2?
- From: Adric Norris <landstander668@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 17 Jan 2014 20:41:59 -0600
Is there a good way to check, from within the database, whether or not
database sessions are utilizing network encryption? I know you can look at
the *network_service_banner* column of *v$session_connect_info*, but the
text format makes it difficult to parse effectively... not to mention that
I'm not certain that it's always populated (thinking of JDBC thin clients
here). The databases in question are all 11.2.0.3/11.2.0.4, running under
a combination of Linux X86-64 and Solaris SPARC 64-bit.
We're thinking of enabling opportunistic network encryption in the near
future, with the goal of it eventually becoming mandatory. I'd therefore
like to be able to identify plaintext sessions from within the database, so
that we have an idea of which applications / groups will need to make
configuration changes.
Thanx!
--
Awk! Pieces of eight. Pieces of eight. Pieces of seven... ERROR: kernel
panic [parroty error]
Other related posts:
