I have installed a 11g database on my windows computer, configured listener called LISTENER (port 1521) and created a database db11g1. Additionally I installed 12c software.
Now I stopped the 11g listener first and configured 12c listener also called LISTENER and same port 1521. Since 11g listener is already stopped this did not create any conflict.
My intent is to use the 12c listener for both 11g and 12g databases.My 11g and 12c listener.ora files are as below.
Knowing that listener configuration is dynamic, how do I update 12c listener.ora file with the 11g connection details. I will be creating a 12c database in its own home.
I have already read this https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:9527209900346397635 and still had some questions-
*********************
For database db11g1 @ c:\oraclebase\product\11.2.0\dbhome_1\network\admin\listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\oraclebase\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\oraclebase\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = myserver.abc.def.net)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = C:\oraclebase
*********************
For 12C @ C:\Oraclebase\product\12.1.0\dbhome_1\NETWORK\ADMIN\listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\oraclebase\product\12.1.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\oraclebase\product\12.1.0\dbhome_1\bin\oraclr12.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = myserver.abc.def.net)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
******************