Solved

Oracle SQL Plus security question

Posted on 2014-03-26
3
538 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 36

Accepted Solution

by:
Geert Gruwez earned 500 total points
Comment Utility
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
Comment Utility
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 36

Expert Comment

by:Geert Gruwez
Comment Utility
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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.

763 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now