RE: sqlnet.ora and tcp node checking on issue
- From: "QuijadaReina, Julio C" <QuijadJC@xxxxxxxxxxxxxxx>
- To: "Newman, Christopher" <cjnewman@xxxxxxxxxxxxx>, Jared Still <jkstill@xxxxxxxxx>
- Date: Wed, 14 Jan 2009 20:41:41 -0500
Thanks Chris,
That indeed is the case here. Just a few clients access the database this way.
Most come through an app server. Perhaps the fix here is to use a firewall or a
fixed IP.
I just can't believe that not resolving or finding a node on the network would
cause such an important component as the listener not to start. It would seem
more logical to just ignore the node or client that can't be found. Or maybe
Oracle means by "node" - a cluster node that is supposed/expected to be present
in order for the cluster to work properly. To me a node means just another
computer on the network.
Julio
________________________________________
From: Newman, Christopher [cjnewman@xxxxxxxxxxxxx]
Sent: Wednesday, January 14, 2009 8:20 PM
To: QuijadaReina, Julio C; Jared Still
Cc: oracle-l@xxxxxxxxxxxxx
Subject: 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
--
//www.freelists.org/webpage/oracle-l--
//www.freelists.org/webpage/oracle-l
Other related posts:
