Tuesday, February 24, 2009

Starting 11g Database gives ORA-00119 and ORA-00132

I recently installed a new Oracle11g database on my Linux server. I noticed
when starting it for the first time I got the following two messages:

ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_ORA11GR1'

After a bit of research I found that Oracle needs an entry in the tnsnames.ora
for the listener where you are using a non-default port number (1522 in my case).

The new entry will look like:


After adding this entry the instance started fine.