时间戳

首页 > 解决方案 > 如何解决 oracle tnslsnr 错误 NL-00280、NL-00278、SNL-00016？

oracle11g - 如何解决 oracle tnslsnr 错误 NL-00280、NL-00278、SNL-00016？

问题描述

目标：启动 lsnrctl

命令： lsnrctl start "/u01/app/oracle/product/11.2.0/test/network/admin/listener.ora"

预期： lsnrctl 成功启动

实际的： 

[oracle@srvr0 root]$ lsnrctl start "/u01/app/oracle/product/11.2.0/test/network/admin/listener.ora"

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 10-APR-2020 05:53:00

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/11.2.0/test/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.2.0 - Production
NL-00280: error creating log stream /u01/app/oracle/product/11.2.0/test/network/admin/listener.ora
 NL-00278: cannot open log file
  SNL-00016: snlfohd: error opening file
   Linux Error: 13: Permission denied

Listener failed to start. See the error message(s) above...

listener.ora 的内容：

test_lsnr=
    (DESCRIPTION-LIST=
        (DESCRIPTION=
            (ADDRESS_LIST=
                (LOAD_BALANCE=OFF)
                (FAILOVER=OFF)
                (ADDRESS=(PROTOCOL=TCP)(HOST=srvr0)(PORT=1600))
            )
            (CONNECT_DATA=
                (SERVER=DEDICATED)
                (SERVICE_NAME=test)
            )
        )
    )
STARTUP_WAIT_TIME_test_lsnr=5
CONNECT_TIMEOUT_test_lsnr=10
LOG_DIRECTORY_test_lsnr=/u01/app/oracle/product/11.2.0/test/network/log
LOG_FILE_test_lsnr=test_lsnr.log
TRACE_LEVEL_test_lsnr=OFF
TRACE_DIRECTORY_test_lsnr=/u01/app/oracle/product/11.2.0/test/network/trace
TRACE_FILE_test_lsnr=test_lsnr.trc
SID_LIST_test_lsnr=
    (SID_LIST=
        (SID_DESC=
            (GLOBAL_DB_NAME=test)
            (SID_NAME=test)
            (ORACLE_HOME=/u01/app/oracle/product/11.2.0/test)
        )
    )

请帮助我解决上述 oracle tnslsnr 问题！

标签： oracle11g

解决方案

推荐阅读