Ora 00119 Error Solved

Asked By 30 points N/A Posted on -

Starting my database with DBCA displays the following error message:


ORA-00119: Invalid system parameter specification LOCAL_LISTENER

For troubleshooting, I checked the listener.ora file and the tnsnames.ora file, but I did not find an error. In the file ‘initsane.ora’ settings: LOCAL_LISTENER = MYD. How can I get through this?

Answered By 0 points N/A #319951

Ora 00119 Error Solved


You have only one listener, which is LISTENER, where MYD is your service. Since you only use a standard listener, you do not have to set local_listener. Therefore, local_listener can be removed by you by deleting its entry from the initialization of your pfile or spfile anf then finally rebooting the listener.

Login/Register to Answer

Related Questions