Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Oracle SQL Plus security question

Posted on 2014-03-26
3
Medium Priority
?
572 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.

661 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