Ora 00119 Error Solved

Asked By 30 points N/A Posted on -
qa-featured

Starting my database with DBCA displays the following error message:

DBCA_PROGRESS: 2%

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?

SHARE
Answered By 0 points N/A #319951

Ora 00119 Error Solved

qa-featured

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.

Related Questions