RE: sqlnet.ora and tcp node checking on issue

node checking doesn't allow wildcards, so if you have clients using DHCP, 
better to use a firewall instead.  The built in mechanism is more appropriate 
for database which are only accessed by a few application nodes.

- Chris


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of QuijadaReina, Julio C
Sent: Wed 1/14/2009 7:17 PM
To: Jared Still
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: sqlnet.ora and tcp node checking on issue
 
Jared,
This particular client uses DHCP. Our Systems guys would be able to reserve the 
IP for this machine, but I was most interested on whether Oracle has a fix for 
it. I have not been able to find anything on ML site nor on the web.

Thanks,
Julio
________________________________
From: Jared Still [jkstill@xxxxxxxxx]
Sent: Wednesday, January 14, 2009 5:37 PM
To: QuijadaReina, Julio C
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: sqlnet.ora and tcp node checking on issue


On Wed, Jan 14, 2009 at 11:03 AM, QuijadaReina, Julio C 
<QuijadJC@xxxxxxxxxxxxxxx<mailto:QuijadJC@xxxxxxxxxxxxxxx>> wrote:
Hello,

Has anyone run into issues with the listener not starting when sqlnet.ora 
includes tcp node checking? It appears that the problem is a computer name that 
is not resolvable through DNS - or that it just happens to be turned off at the 
time. I am using this setting as part of a security strategy to only allow 
certain clients direct access to the database servers.



If you're concerned enough to use tcp node checking, you should probably
consider using IP addresses rather than server names.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l


Other related posts: