Home > Oracle > ORA-00119: invalid specification for system parameter LOCAL_LISTENER

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

The local_listener parameter has been set, the listener is running, but when attempting to start the instance an ORA-00119 is reported:
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name ‘LISTENER_NEXWPLTS’

Oracle only checks for listeners running on the default port (1521). So you have to tell it somehow to find the listener  and the way to do this is to enter the details in the tnsnames.ora. If you have mutliple oracle homes make sure the details are entered in the correct
tnsnames.ora file.

LISTENER_NEXWPLTS.ncs.local =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.110.52.51)(PORT = 50635))
  )

Test it with tnsping:
tnsping <listener_name>

Advertisements
Categories: Oracle
  1. No comments yet.
  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

%d bloggers like this: