ERROR :: ORA-00119: invalid specification for system parameter LOCAL_LISTENER

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