This content has been marked as final. Show 3 replies
If you are using Oracle Advanced Security (an extra-cost option on top of the enterprise edition license), you can specify on the client and on the server file whether each side accepts, requires, or rejects encryption and which encryption algorithms each side supports. When a client connects, a negotiation will take place and the connection will be encrypted appropriately (i.e. if the client supports encryption and the server requires encryption then the connection will be encrypted).
Thanks for the reply Justin, but I was looking for an easy solution that did not include an extra purchase and client-side work.
That's the Oracle-supported method to encrypt the data sent over the network.
You could, obviously, configure something like a VPN or secure port forwarding on each client machine and require that the clients connect to the VPN in order to access the database. That's probably cheaper but generally more work to deal with and harder to audit/ monitor since you can't just tell the database to require an encrypted connection.