LOCAL_LISTENER specifies a network name that resolves to an address or address list of Oracle Net local listeners (that is, listeners that are running on the same machine as this instance). The address or address list is specified in the TNSNAMES.ORA file or other address repository as configured for your system.

So, in your TNSNAMES.ORA (not in LISTENER.ORA) you must define this entry for the local listener:

Related

Let me start by saying, I’m not really a beginner at all this, but by no means an expert. I have Oracle 12c enterprise set up on a Oracle Enterprise Linux ver 7 box.
This has always worked fine, start Linux, from a terminal window
[oracle@oradev ~]$ sqlplus /nologSQL> conn SYS as SYSDBA
Enter password: xxxxx
startup
lsnrctl start

All was well. I have this running on VMware® Workstation 12 Pro, 12.5.0 build-4352439. I recently updated VMware…now when I get to
startup I get:
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address ‘(ADDRESS=(PROTOCOL=TCP)(HOST=oradev.attlocal.net)(PORT=1522))’
SQL>

Hi James, excuse me for the late reply.
Have you checked hosts file and firewall?
Could you post your listener.ora, tnsnames.ora and sqlnet.ora (if present)?
From your linux guest, are you able to ping to the gust name (te one from the hosts file)?

Your suggestion was interesting; but, it was not the solution for me. I also checked the spfile and the parameter wasn’t there. Then I built a skinny pfile and tried to startup the DB, same error… and then I remembered. I had spun up a new instance (on AWS) and I had a new IP address… making the changes in the tnsnames.ora and listener.ora file was not enough. I totally forgot about /etc/hosts. Once this hosts IP address was changed there, the database started up normally.