Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Oracle SQL Plus security question

Posted on 2014-03-26
3
Medium Priority
?
574 Views
Last Modified: 2014-03-26
Greeting,

I use SQL plus worksheet and SQL plus 10 to connect to my remote oracle database.
I'm wondering if the password and data are encrypted when I making the connection.

Thanks.
0
Comment
Question by:mrong
  • 2
3 Comments
 
LVL 38

Accepted Solution

by:
Geert Gruwez earned 2000 total points
ID: 39955865
by default only the password is not sent as plaintext

to setup encryption between an oracle instance and the clients
follow this:
http://kb.berkeley.edu/page.php?id=23274

the doc also contains a verification process to check if the current traffic is encrypted
0
 

Author Comment

by:mrong
ID: 39955882
Geert Gruwez,

The link you provided shows how to set up encryption on the client side.
Does encryption settings need to be done on the server side?
Thanks.
0
 
LVL 38

Expert Comment

by:Geert Gruwez
ID: 39956239
yes, on the server side, things need to be done as well
it's stated on the site, but it's not very clear

Your DBA must have installed the Oracle server software with the Advanced Security option, and the DBA must have configured the database listener to at least allow encrypted sessions and checksumming. Your DBA will need to provide you with the available encryption and checksum algorithms for your instance.

Advanced Security option allows the database to setup encryption

you could check via view dba_registry if any encryption component is active
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to install Selenium IDE and loops for quick automated testing. Get Selenium IDE from http://seleniumhq.org Go to that link and select download selenium in the right hand column That will then direct you to their download page. From that p…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…
Suggested Courses

824 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question