- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: TNS Configuration In ORACLE
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-22-2000 10:11 PM
тАО09-22-2000 10:11 PM
TNS Configuration In ORACLE
I am having 8 server running different databases and are in LAN.
We can access the database of one server from other server throuh SQL*net.
How can I restrict the access to database from perticular Server(node).
Is it possible to restrict it at user level.
thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-22-2000 10:25 PM
тАО09-22-2000 10:25 PM
Re: TNS Configuration In ORACLE
You want to disable a paticular server
contacting the particular database....
Remove the that database alias entry
from that server tnsnames.ora file.
Thanks
R.Suresh.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-23-2000 12:02 AM
тАО09-23-2000 12:02 AM
Re: TNS Configuration In ORACLE
If you want to restrict it by user then best to use the /var/adm/inetd.sec file which allows you to allow/disallow by IP - as long as each user is using a different PC/IP. Check which tcp port sqlnet is using (1521?) and thats all you need to start adding entries into inetd.sec
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-24-2000 04:17 AM
тАО09-24-2000 04:17 AM
Re: TNS Configuration In ORACLE
Yes,you can restrict the user from SAM too.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2000 08:36 AM
тАО09-27-2000 08:36 AM
Re: TNS Configuration In ORACLE
There is a file you can create to specify which machines (IP addresses) can access via SQL*Net your database (this works for Oracle 7.3.4, I don't know at later releases).
# su - oracle7
# cd $ORACLE_HOME/network/admin
# vi protocol.ora
tcp.validnode_checking = yes
ipc.validnode_checking = yes
tcp.invited_nodes = (IPaddress1, ... IPaddressN)
icp.invited_nodes = (IPaddress1, ... IPaddressN)
# chmod 644 protocol.ora
# lsnrctl // restart the listener to take this file into account
LSNRCTL> stop cgc
LSNRCTL> start cgc
LSNRCTL> quit
Hope this helps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-18-2000 06:02 AM
тАО12-18-2000 06:02 AM
Re: TNS Configuration In ORACLE
create protocol.ora in $TNS_ADMIN directory with
tcp.excluded_nodes= (144.25.5.25,144.25.5.26,) (examples of IPs)
tcp.validnode_checking=yes
Stop and restart listener.ora
Rgds
Thomas
PS: feedback (and points ;-) appreciated.