I'm running 12c, and I'm trying to tune TNS time outs.
I was trying to modify the listener, and I discovered something.
My basic environment settings:
ORACLE_BASE=/oracle/12cbase
ORACLE_SID=ford
ORACLE_OWNER=oracle
ORACLE_HOME=/oracle/12c
ORAENV_ASK=NO
When I run lsnrctl status, I get the following:
LSNRCTL for Solaris: Version 12.1.0.2.0 - Production on 03-JAN-2017 14:04:00
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 12.1.0.2.0 - Production
Start Date 03-JAN-2017 13:48:12
Uptime 0 days 0 hr. 15 min. 47 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/12c/network/admin/listener.ora
Listener Log File /oracle/12cbase/diag/tnslsnr/solftden01/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XXX.XXX.com)(PORT=1521)))
Services Summary...
Service "ford" has 1 instance(s).
Instance "ford", status READY, has 1 handler(s) for this service...
The command completed successfully
When I edit the listener.ora file, THIS is what is in there.
{solftden01:ford:}/oracle/12c/network/admin> pwd
/oracle/12c/network/admin
{solftden01:ford:}/oracle/12c/network/admin> vi listener.ora
# listener.ora Network Configuration File: /oracle/12c/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER_12C =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXX)(PORT = 1621))
(ADDRESS = (PROTOCOL = IPC)(KEY = ford))
)
)
SID_LIST_LISTENER_12C =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME=/oracle/12c)
(SID_NAME = ford)
)
)
INBOUND_CONNECT_TIMEOUT_LISTENER_12C= 240
Am I crazy? When I look at the lsnrctl status, it points TO the file that is being called.
HOWEVER, when I look at the listener name and port being used in the status, it doesn't match what is in the file.
I'm making the changes to the listener.ora file, then running lstnrctl status, and it states LISTENER and port 1521