Setting LOCAL_LISTENER
Hi,
Here is how the files looks like
Listener.ora
LISTENER_FP =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.58)(PORT = 1523))
)
)
SID_LIST_LISTENER_FP =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORCL)
(ORACLE_HOME = DKB0:[10GINSTALL])
)
)
Tnsnames.ora
LISTENER_FP=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.58)(PORT=1523))
)
SQL> alter system set local_listener='LISTENER_FP';
alter system set local_listener='LISTENER_FP'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_FP'
0