Problem Description -------------------
There are two or more oracle instances in two seperate oracle homes. Both listeners need to run concurrently. When starting a second listener, a TNS-01106 "Listener using listener name %s has already been started" error is received. Solution Description -------------------- Verify IPC addresses or TCP port numbers are not duplicated
#listener.ora file for the first listener
LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY= ORCL))
(ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
(ADDRESS= (PROTOCOL= TCP)(Host= jumbo)(Port= 1521)) ) #listener.ora file for the second listener
LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)
(KEY= ORCL))
(ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
(ADDRESS= (PROTOCOL= TCP)(Host= jumbo)(Port= 1521)) ) The listener.ora file for the 2nd listener example must have different IPC keys from the first listener.ora file and the port number for the TCP address must be different between any other listener definitions. Implement the changes and restart the listeners Explanation -----------
A second listener process attempted to start with the same IPC key, port address as that of an listener already running. ●龙飞虎○)
There are two or more oracle instances in two seperate oracle homes. Both listeners need to run concurrently. When starting a second listener, a TNS-01106 "Listener using listener name %s has already been started" error is received. Solution Description -------------------- Verify IPC addresses or TCP port numbers are not duplicated
#listener.ora file for the first listener
LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY= ORCL))
(ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
(ADDRESS= (PROTOCOL= TCP)(Host= jumbo)(Port= 1521)) ) #listener.ora file for the second listener
LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)
(KEY= ORCL))
(ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
(ADDRESS= (PROTOCOL= TCP)(Host= jumbo)(Port= 1521)) ) The listener.ora file for the 2nd listener example must have different IPC keys from the first listener.ora file and the port number for the TCP address must be different between any other listener definitions. Implement the changes and restart the listeners Explanation -----------
A second listener process attempted to start with the same IPC key, port address as that of an listener already running. ●龙飞虎○)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货