Hello,
It is cruel to post a question on Friday evening.. But, after my internet search, I couldn't find an answer and I think this issue is fun.
So, here is some background:
I installed oracle database using OUI. During oracle installation, for some reasons, listener was assigned port number 1539. The VM was pretty new.. So, there was no way that 1521 port was busy. I am not sure why this happened.
Then, I changed the listener.ora file to as shown below. Since then, netca also stopped working.. I assume I corrupted something by changing the listener.ora file.
I am not sure why listener is still listening on port 1539. This port is definetely not listed in listener.ora file. Could you please suggest why?
Thanks in advance for your help. I wish you guys a safe weekend.
Best regards,
Chinnu
lsnrctl status listener
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 03-APR-2020 18:53:09
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle03)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 03-APR-2020 13:22:06
Uptime 0 days 5 hr. 31 min. 3 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/grid/product/12.1.0/grid/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/oracle03/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.19.X1.X2)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.19.X1.X2)(PORT=1539)))
Services Summary...
Service
Service
Service
The command completed successfully
cat /u01/app/grid/product/12.1.0/grid/network/admin/listener.ora
# listener.ora Network Configuration File: /u01/app/grid/product/12.1.0/grid/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle03)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = <GLOBAL_DBNAME>)
(ORACLE_HOME = /u01/app/oracle/product/12.1.0/dbhome_1)
(SID_NAME = <SID_NAME>)
)
)
ADR_BASE_LISTENER = /u01/app/oracle
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER=SUBNET # line added by Agent