ORA-00119

最新推荐文章于 2025-12-07 08:11:00 发布

转载最新推荐文章于 2025-12-07 08:11:00 发布 · 2.5k 阅读

文章标签：

#list #system #network #sql #tcp

oracle 专栏收录该内容

59 篇文章

订阅专栏

本文介绍了解决Oracle数据库启动时遇到的ORA-00119错误的方法。该错误通常发生在已设置local_listener参数但实例启动失败的情况。文章提供了检查监听器配置及如何正确设置tnsnames.ora文件的步骤。

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

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> startup

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

ORA-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.