ORA-00119: invalid specification for system parameter LOCAL_LISTENER

I was practicing in virtual machines a hardware/OS upgrade for an Oracle 10G RAC and when I was starting up the database I got this error:

SQL> startup nomount
ORA-01078: failure in processing system parameters
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_RAC1'

Fixing this error is actually quite easy, the problem is that by the time I started up the database I didn’t have the tnsnames.ora

If you have a tnsnames.oraΒ  simply add one entry to it with the name in the error ORA-00132 (LISTENER_RAC1), if you are in a RAC add one line per node.
This is my final tnsnames.ora, note the LISTENER_RAC* entries, please note that the DBNAME is RAC and the instances SIDs are RAC1 and RAC2:

RAC =
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = rh5_node1-vip.virtualservers.net)(PORT = 1521))
 (ADDRESS = (PROTOCOL = TCP)(HOST = rh5_node2-vip.virtualservers.net)(PORT = 1521))
 (LOAD_BALANCE = yes)
 (CONNECT_DATA =
 (SERVER = DEDICATED)
 (SERVICE_NAME = rac.virtualservers.net)
 )
 )
LISTENERS_RAC =
 (ADDRESS_LIST =
 (ADDRESS = (PROTOCOL = TCP)(HOST = rh5_node1-vip.virtualservers.net)(PORT = 1521))
 (ADDRESS = (PROTOCOL = TCP)(HOST = rh5_node2-vip.virtualservers.net)(PORT = 1521))
 )

LISTENER_RAC1 = (ADDRESS = (PROTOCOL = TCP)(HOST = rh5_node1-vip.virtualservers.net)(PORT = 1521))

LISTENER_RAC2 =
 (ADDRESS = (PROTOCOL = TCP)(HOST = rh5_node2-vip.virtualservers.net)(PORT = 1521))

then try again to start the database

Good luck

Advertisements
This entry was posted in High-Availability, Linux/Unix, Oracle Server and tagged , , , , , , . Bookmark the permalink.

8 Responses to ORA-00119: invalid specification for system parameter LOCAL_LISTENER

  1. tekaya says:

    Thank’s a lot , this solution resolves my problem!!!!

  2. radot says:

    Mr. Carlos,
    After wandering several days to seek for a solution, I found you.
    You’re the answer.
    Thanks a lot.

  3. This is the correct answer. I changed the following:
    listener.ora:
    LISTENER –> LISTENER_
    tnsnames.ora:
    .WORLD –> LISTENER_.WORLD

    And it worked fine. Thank you so much.
    Bhagirath

  4. Ina says:

    Thanks a lot, I had the error during DB-Creation using dbca.
    It was realy easy πŸ™‚

  5. bioshark says:

    Thanks a lot.
    Old post, but apparently it still helps people πŸ™‚

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