ORA-00119: Invalid Specification For System Parameter LOCAL_LISTENER

Question

OracleDba · Accepted Answer

I was getting ORA-00119 and ORA-00132 error while startup database in nomount mode

SQL> startup nomount

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

ORA-00132: syntax error or unresolved network name 'LISTENER_PRIM'

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_PRIM which contains hostname and port number.

cat tnsnames.ora

LISTENER_PRIM =

(ADDRESS = (PROTOCOL = TCP)(HOST = node1.learnomate.org)(PORT = 1521))

Now , You can start database in nomount mode

SQL> startup nomount;

ORACLE instance started.

Total System Global Area 1744828000 bytes

Fixed Size                  9135712 bytes

Variable Size             452984832 bytes

Database Buffers         1275068416 bytes

Redo Buffers                7639040 bytes

SQL>

Solutions(1)