- 17 Aug, 2023
- 0 Comments
- 35 Secs Read
ORA-00119: Invalid Specification For System Parameter LOCAL_LISTENER
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>