Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Restrictions to access RAC database via scan listeners

truptipanJun 20 2017 — edited Jun 21 2017

Hello,

I have setup a two node RAC database and would like to have some restrictions in granting access to certain clients.

I have scan listeners being used to connect to the database.

I would like to have clients only on hosts fihecdpp073 and fihecdpp074 to be able to access the RAC database setup on fihecdpp075 and fihecdpp076

So, I used the following as grid user on fihecdpp075

srvctl modify scan_listener -update -invitednodes "fihecdpp073,fihecdpp074"

followed by

srvctl stop scan_listener

srvctl start scan_listener

However, I can still connect to the database from other clients.

Please advise how I can fix this issue.

Thank you

Trupti

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 19 2017
Added on Jun 20 2017
10 comments
800 views