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:

LISTENER_ORA11GR1 = (ADDRESS = (PROTOCOL = TCP)(HOST = soleil)(PORT = 1522))

After adding this entry the instance started fine.

1 comment:

Aakash Gupta said...

Thanks,this post saved the day