I was getting ORA-00119 and ORA-00132 error while startup nomount a new db.


SQL> startup nomount
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_PROD'


This is because LOCAL_LISTENER parameter was used in the init file and not defined in the tnsnames.ora file.

So in the TNSNAMES.ORA file, added LISTENER_PROD which contains hostname and port number.


cat tnsnames.ora

  (ADDRESS = (PROTOCOL = TCP)(HOST = prodhost.com)(PORT = 1529))


Now do startup nomount, you won’t get any error.

SQL> startup nomount
ORACLE instance started.
Total System Global Area 5.3447E+10 bytes
Fixed Size                  2240984 bytes
Variable Size            2.5636E+10 bytes
Database Buffers         2.7783E+10 bytes
Redo Buffers               26505216 bytes