Topic: Oracle on Unix/Linux >> Will The Ssh Security Affects Oracle Users? Correct me if iam wrong
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Will The Ssh Security Affects Oracle Users? Correct me if iam wrong |
| sathy |
Posted: Jan 18, 2006 03:21:24 AM |
Total Post: 2
Joined: Jan, 2006
|
Friends,
We have RHEL AS 3.0 with Oracle 9i database.
We have 5 branches(100 users) connecting to our oracle database which is inside the linux server.
We have to restrict the SSH connection by ipaddress.
We have not enabled the browsing(internet) option in our server.
I just want to disable everyone to access our server except from 3 ip's.
So please go through the following and correct me if im wrong....
Step 1:
/etc/hosts.deny
sshd: ALL
Step 2:
/etc/hosts.allow
sshd: 192.56.3.23 192.56.3.33 152.32.7.13
Step 3:
/etc/ssh/sshd_config
Port 110101010 (if i change the port number will it affects the users who are all connecting to oracle database?)
PasswordAuthentication no
PermitEmptyPassword no
StrictModes yes
Protocol 2
if i have to do any other changes in the step 3 please point out the changes.
Step 4:
i checked in /etc/sysconfig but there is no file called iptables.
there are 2 other files ip6tables-config and iptables-config.
So i thing the iptables are not installed. if its must then advice me the steps.
Also, after doing step1,2,3 the step 4 is not necessary....Am i right?
Finally my question is.....if i do the above changes in my linux box will it affect the oracle database which is inside our linux box?
And also, the users who are all connected to oracle database will be affected....
Please treat this as urgent.....
thanks & Regards
Sathyguy |
|
|
 Vigyan |
| Posted: Jan 18, 2006 09:14:04 PM |  |
|
Total Post: 386
Joined: May, 2001
|
I think only ssh connection on (port 22) should be affected with the change. Database connection is using different ports and that should be fine.
Hope it helps.
Vigyan
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 856 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 281 |
| neeraj sharma | 254 |
| Ramesh Jois | 245 |
| Bishal Khetan | 207 |
|
|
