sqlnet.ora and tcp node checking on issue
- From: "QuijadaReina, Julio C" <QuijadJC@xxxxxxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 14 Jan 2009 14:03:36 -0500
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.
This is happening with Oracle 10g 10.2.0.3 on Red Hat 4.
The listener fails to start with message:
server:ora.server.LISTENER_server.lsnr:
server:ora.server.LISTENER_server.lsnr:LSNRCTL for Linux: Version 10.2.0.3.0 -
Production on 14-JAN-2009 13:54:23
server:ora.server.LISTENER_server.lsnr:
server:ora.server.LISTENER_server.lsnr:Copyright (c) 1991, 2006, Oracle. All
rights reserved.
server:ora.server.LISTENER_server.lsnr:
server:ora.server.LISTENER_server.lsnr:Starting /orapck/oracle/asm/bin/tnslsnr:
please wait...
server:ora.server.LISTENER_server.lsnr:
server:ora.server.LISTENER_server.lsnr:TNSLSNR for Linux: Version 10.2.0.3.0 -
Production
server:ora.server.LISTENER_server.lsnr:System parameter file is
/orapck/oracle/asm/network/admin/listener.ora
server:ora.server.LISTENER_server.lsnr:Log messages written to
/orapck/oracle/asm/network/log/listener_server.log
server:ora.server.LISTENER_server.lsnr:Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
server:ora.server.LISTENER_server.lsnr:Error listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server-vip)(PORT=1521)(IP=FIRST)))
server:ora.server.LISTENER_server.lsnr:TNS-12560: TNS:protocol adapter error
server:ora.server.LISTENER_server.lsnr: TNS-00584: Valid node checking
configuration error
server:ora.server.LISTENER_server.lsnr:
server:ora.server.LISTENER_server.lsnr:
server:ora.server.LISTENER_server.lsnr:Listener failed to start. See the error
message(s) above...
server:ora.server.LISTENER_server.lsnr:
server:ora.server.LISTENER_server.lsnr:
server:ora.server.LISTENER_server.lsnr:LSNRCTL for Linux: Version 10.2.0.3.0 -
Production on 14-JAN-2009 13:54:23
server:ora.server.LISTENER_server.lsnr:
server:ora.server.LISTENER_server.lsnr:Copyright (c) 1991, 2006, Oracle. All
rights reserved.
server:ora.server.LISTENER_server.lsnr:
server:ora.server.LISTENER_server.lsnr:Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
server:ora.server.LISTENER_server.lsnr:TNS-12541: TNS:no listener
server:ora.server.LISTENER_server.lsnr: TNS-12560: TNS:protocol adapter error
server:ora.server.LISTENER_server.lsnr: TNS-00511: No listener
server:ora.server.LISTENER_server.lsnr: Linux Error: 2: No such file or
directory
server:ora.server.LISTENER_server.lsnr:Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server-vip)(PORT=1521)(IP=FIRST)))
server:ora.server.LISTENER_server.lsnr:TNS-12541: TNS:no listener
server:ora.server.LISTENER_server.lsnr: TNS-12560: TNS:protocol adapter error
server:ora.server.LISTENER_server.lsnr: TNS-00511: No listener
server:ora.server.LISTENER_server.lsnr: Linux Error: 111: Connection refused
server:ora.server.LISTENER_server.lsnr:Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=136.224.32.132)(PORT=1521)(IP=FIRST)))
server:ora.server.LISTENER_server.lsnr:TNS-12541: TNS:no listener
server:ora.server.LISTENER_server.lsnr: TNS-12560: TNS:protocol adapter error
server:ora.server.LISTENER_server.lsnr: TNS-00511: No listener
server:ora.server.LISTENER_server.lsnr: Linux Error: 111: Connection refused
CRS-0215: Could not start resource 'ora.server.LISTENER_server.lsnr'.
Thanks,
Julio
--
//www.freelists.org/webpage/oracle-l
Other related posts:
