Ora 00119 Error Solved

Asked By Judith Fowler 30 points N/A Posted on - 07/08/2019

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?

• Status: Open
• Question Views: 68
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database
• Question Tags: Oracle

Answered By James A Check 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.

About James A Check

Questions
5

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/08/2019
• Question Category: Oracle Database