RMAN-04014: startup failed: ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network name 'LISTENER_PROD'
Problem:
connected to auxiliary database (not started)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 02/21/2020 13:56:36
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-04014: startup failed: ORA-00119: invalid specification for system parameter LOCAL_LIST ENER
ORA-00132: syntax error or unresolved network name 'LISTENER_PROD'
RMAN> **end-of-file**
RMAN> exit
Reason :
Oracle only checks for listeners running on the default port (1521). It would have to spend all day trying every possible port number otherwise. You’ll need to give it some help to find your listener.
Solution:
Simply add an entry to the servers tnsnames.ora pointing at the listener. As mention below
TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.81)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = TEST)
)
)
TEST_STBY =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.10)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = TEST)
)
)
LISTENER_PROD =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.10)(PORT = 1521))