Hello,
I'm quite new to Oracle world. I set up two oracle 11g servers for learning purposes for 1Z0-05[1-2] exams.
I have two Oracle 11g nodes. Let them be:
- node1 - where problem resides
- node2 - this one works fine (sits here for output comparison)
Both nodes are in private LAN (192.168.1.0/24). Firewall (iptables) and SELinux are disabled. Listeners ports are forwarded and reachable from outside network. Listener port for Node1 has been moved to 1522, while listener port for Node2 was unchanged.
First thing I noticed, that listener commands on Node1 are quite slow:
Output of strace -r lsnrctl status (truncated to most interesting lines)
Node1:
0.000109 write(6, "\0\303\0\0\1\0\0\0\1:\1,\0\201 \0\177\377s\10\0\0\1\0\0\211\0:\0\0\7\370\f\f\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0(DESCRIPTION=(CONNECT_DATA=(CID=(PROGRAM=)(HOST=node1)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)))", 195) = 195
0.000347 read(6, "\0=\0\0\5\0\0\0\0003(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=#1509.2)))", 8208) = 61
63.001481 close(6)
Node2:
0.000106 write(6, "\0\303\0\0\1\0\0\0\1:\1,\0\201 \0\177\377s\10\0\0\1\0\0\211\0:\0\0\7\370\f\f\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0(DESCRIPTION=(CONNECT_DATA=(CID=(PROGRAM=)(HOST=node2)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)))", 195) = 195
0.000710 read(6, "\0>\0\0\5\0\0\0\0004(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=#28347.2)))", 8208) = 62
0.000197 close(6)
I started looking through google, and found that running commands like tnsping or trcroute might be useful, so:
Node1:
[oracle@node1 ~]$ trcroute node1
Node: Client Time and address of entry into node:
-------------------------------------------------------------
26-MAY-2015 11:15:20 ADDRESS= PROTOCOL=TCP HOST=192.168.1.202 PORT=1521
TNS-12224: TNS:no listener
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-03601: Failed in route information collection
Node2:
[oracle@node2 ~]$ trcroute node2
Node: Client Time and address of entry into node:
-------------------------------------------------------------
26-MAY-2015 11:15:15 ADDRESS= PROTOCOL=TCP HOST=192.168.1.201 PORT=1521
Node: Server Time and address of entry into node:
-------------------------------------------------------------
26-MAY-2015 11:15:15 ADDRESS= PROTOCOL=TCP HOST=192.168.1.201 PORT=1521
First thing to notice, why listener on Node1 is on 1521 ? It's supposed to be on 1522.
So, checking Node1:
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=node1)(PORT=1522))
[root@node1 ~]# cat /opt/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /opt/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_ORCL =(ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1522))
ORCL = (DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = orcl)))
[root@node1 ~]# cat /opt/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# listener.ora Network Configuration File: /opt/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))(ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1522))))
ADR_BASE_LISTENER = /opt/u01/app/oracle
And I almost forgot, status of listener on Node1:
[oracle@node1 ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 26-MAY-2015 12:58:08
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 26-MAY-2015 11:27:56
Uptime 0 days 1 hr. 31 min. 15 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /opt/u01/app/oracle/diag/tnslsnr/node1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node1)(PORT=1522)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
My questions are:
- did I messed (or forgot) something while changing listener port on Node1 ?
- or the problems lies somewhere else ?
Big thanks for any hint.
BR
S.