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. August 29, 2014 at 0:21

    Your suggestion was interesting; but, it was not the solution for me. I also checked the spfile and the parameter wasn’t there. Then I built a skinny pfile and tried to startup the DB, same error… and then I remembered. I had spun up a new instance (on AWS) and I had a new IP address… making the changes in the tnsnames.ora and listener.ora file was not enough. I totally forgot about /etc/hosts. Once this hosts IP address was changed there, the database started up normally.

    • August 29, 2014 at 17:47

      Thanks for your comment David. I’m sure it will be useful to other people.

  2. FK
    July 30, 2014 at 22:02

    hi Miquel,

    Thanks for sharing; your blog solved a riddle for me ! God bless you!

    regards,
    FK

  3. Peter
    July 1, 2014 at 9:14

    Miquel – You saved me. Dunno how many blogs and posts i browsed. Making the entry of listener in tnsnames.ora solved my problem. God bless you.!!! :)

  4. Robert
    November 8, 2013 at 14:25

    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 33 other followers

%d bloggers like this: