Home > oracle > Oracle 11g Release 2: ORA-00119: invalid specification for system parameter LOCAL_LISTENER

Oracle 11g Release 2: ORA-00119: invalid specification for system parameter LOCAL_LISTENER

I’ve recently installed an Oracle 11g Release 2 database (11.2.0.3) and when I bounce the database (using the shutdown and startup commands), the database is unable to start:


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

This is due to the lack of a LOCAL_LISTENER, that must be defined in the TNSNAMES.ORA, according to the Oracle Database Reference 11gR2:

LOCAL_LISTENER specifies a network name that resolves to an address or address list of Oracle Net local listeners (that is, listeners that are running on the same machine as this instance). The address or address list is specified in the TNSNAMES.ORA file or other address repository as configured for your system.

So, in your TNSNAMES.ORA (not in LISTENER.ORA) you must define this entry for the local listener:


LISTENER_LAB11.WORLD =
 (ADDRESS = (PROTOCOL = TCP)(HOST = toralin1)(PORT = 1523))

And now you can startup the database. Be sure to set the .WORLD if you have the parameter names.default_domain set at sqlnet.ora.

You can learn more about the LOCAL_LISTENER in this excellent post of Ed Stevens: Exploring the LOCAL_LISTENER parameter

About these ads
  1. Robert
    November 8, 2013 at 14:25 | #1

    I found it a bit more flexible to delete the parameter from the SPFILE.

    SQL>Create pfile from spfile;

    –delete the LOCAL_LISTENER parameter from the pfile.

    SQL> Create spfile from pfile;

    Good to know there are other options for dealing with this error though!

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 29 other followers

%d bloggers like this: