N/APosted on - 07/08/2019
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?
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.