ERROR :: ORA-00119: invalid specification for system
parameter LOCAL_LISTENER
Issue: ORA-00119: invalid specification for system parameter
LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_DATABASE
NAME'
Couse: 1) You have not made the entry of local listener in TNSNAMES.ora file
and parameter is added in spfile or pfile . In order to avoid the above error
we have two options as per my understanding (if you have plz comment and share
your solution.)
Technique 1:
Step 1: Make an entry in the
tnsnames.ora as mentioned below
LISTENER_<NAME/DATABASE NAME> =
(ADDRESS = (PROTOCOL = TCP)(HOST
= my.host.com)(PORT = 1521))
Where LISTENER_<NAME/DATABASE NAME> is the parameter value for LOCAL_LISTENER
which is mentioned in pfile/spfile
PORT is the listener port you are using.
Also there is no need to modify the pfile/spfile.
Technique 2 :
Step 2:
a)
If you are using a spfile for starting up your
database, create a pfile from it and remove the LOCAL_LISTNER parameter and Create
spfile from the pfile .
b)
Strat the database .
sqlplus
/ as sysdba
startup ;
c)
start the listener lsnrctl start
