What are the symptoms?

The local_listener parameter has been set, the listener is running, but when attempting to start the instance an ORA-00119 is reported:

SQL> startupORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-00132: syntax error or unresolved network name 'LIST_ANDY'

Why is this happening?

Oracle only checks for listeners running on the default port (1521). It would have to spend all day trying every possible port number otherwise. You'll need to give it some help to find your listener.

How do I fix it?

Simply add an entry to the servers tnsnames.ora pointing at the listener. For example my listener 'LIST_ANDY' is running on port 3801, so I would add the following entry to my tnsnames:

LIST_ANDY = (ADDRESS = (PROTOCOL = TCP)(HOST = fermat)(PORT = 3801))

Test it with tnsping:

tnsping <listener_name>

Then try starting your instance again - it should work now.

Basic thought processes:

- an Oracle database is managed/manipulated by an Oracle INSTANCE;
- an Oracle instance uses the ORACLE_SID as a handle to the memory area;
- to point the instance processes and client to the apropriate instance, set the SID first.

If you used dbca to create all the databases, it will have updated the /etc/oratab file for each database. By sourcing the /usr/local/bin/oraenv file, you will end up with the correct environment variables to point your client to the instance.

Remember to source the file, not execute it (use the dot-space technique, as in ". oraenv")

So

1) cat /etc/oratab (gets a list of the known SIDs)
2) source oraenv (. oraenv) and tell it which valid SID to look up
3) use SQLPLUS to access the database via it's instance

Now each instance needs to be registered with the listener. You have done this manually in the listener.ora file, although I suggest you should have let this happen through automatic registration.

SQL> STARTUP
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name ‘LISTENER_BROKER’

I was struggled with these erros and finally i was fixed this errors.

How ?

My tnsnames file :

BROKER =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ipaddress)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = BROKER)
    )
  )

and My listener.ora file.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\oracle\product\10.2.0\db_2)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ipaddress )(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )

 and now i tired to startup my db, the below error shown.

SQL> STARTUP
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name ‘LISTENER_BROKER’

So i fixed in tnsnames.ora file and then now its working.

LISTENER_BROKER =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ipaddress )(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = BROKER)
    )
  )

After i fixed this listener_broker in tnsnames.ora file, the database up sucessfully.

SQL> STARTUP
ORACLE instance started.

Total System Global Area 1912602624 bytes
Fixed Size                  2005192 bytes
Variable Size             369100600 bytes
Database Buffers         1526726656 bytes
Redo Buffers               14770176 bytes
Database mounted.
Database opened.

SQL> select name from v$database;

NAME
———
BROKER

This mean you use LOCAL_LISTENER=’LISTENER_BROKER’
So, First Step – you have to check LISTENER_BROKER(network name) in tnsnames.ora file

and Syntax…