Hello,
I need to change the listener port of my 12c Oracle home from 1522 to 1521. I have multiple homes on one server. I am upgrading from 11g to 12c.
I know I can go into listener.ora and change the port from 1522 to 1521. From what I've read, I leave the "KEY = EXTPROC1522" value alone, if I have that right.
But, in the tnsnames.ora file in the 12c home, I see the following entry:
***************************************************
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
*************************************************
I don't know how that got into the file, though I've looked up what it is. Do I need to change the "KEY = EXTPROC1522" value to "KEY = EXTPROC1521" in the tnsnames.ora file after I change listener port in the listener.ora file?
My apologies if this is a bonehead question.
Thanks