让人吐血的TNS-01150

原创 2013年12月05日 19:37:00

让人吐血的TNS-01150,将

(

ADDRESS_LIST=

修改成:

(ADDRESS_LIST=

即解决。

另将

 (SID_DESC=

修改为

 (

SID_DESC=

[oracle@even admin]$lsnrctl start

 

LSNRCTL for Linux:Version 10.2.0.1.0 - Production on 19-MAY-2013 23:29:24

 

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

 

Starting/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

 

TNSLSNR for Linux:Version 10.2.0.1.0 - Production

System parameterfile is /app/oracle/product/10.2.0/db_1/network/admin/listener.ora

Log messages writtento /app/oracle/product/10.2.0/db_1/network/log/listener.log

Listening on:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=even)(PORT=1521)))

TNS-01155:Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA

 NL-00303: syntax error in NV string

 

Listener failed tostart. See the error message(s) above...

 

可见Oracle的listener.ora文件的敏感性,同样应用于tnsnames.ora,sqlnet.ora

 

[oracle@even admin]$cat listener.ora

LISTENER =

(

ADDRESS_LIST=

       (ADDRESS=(PROTOCOL=tcp)(HOST=even)(PORT=1521))

)

 

 

SID_LIST_LISTENER =

(SID_LIST=

 (SID_DESC=

             (GLOBAL_DBNAME=prod)

             (SID_NAME=PROD)

            (ORACLE_HOME=/app/oracle/product/10.2.0/db_1)

 )

)

[oracle@even admin]$lsnrctl start

 

LSNRCTL for Linux:Version 10.2.0.1.0 - Production on 19-MAY-2013 23:24:33

 

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

 

Starting/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

 

TNSLSNR for Linux:Version 10.2.0.1.0 - Production

System parameterfile is /app/oracle/product/10.2.0/db_1/network/admin/listener.ora

Log messages writtento /app/oracle/product/10.2.0/db_1/network/log/listener.log

TNS-01150: Theaddress of the specified listener name is incorrect

 

Listener failed tostart. See the error message(s) above...

 

[oracle@even admin]$

[oracle@even admin]$cat listener.ora

LISTENER =

(ADDRESS_LIST=

       (ADDRESS=(PROTOCOL=tcp)(HOST=even)(PORT=1521))

)

 

SID_LIST_LISTENER =

(SID_LIST=

 (SID_DESC=

             (GLOBAL_DBNAME=prod)

             (SID_NAME=PROD)

            (ORACLE_HOME=/app/oracle/product/10.2.0/db_1)

 )

)

[oracle@even admin]$lsnrctl start

 

LSNRCTL for Linux:Version 10.2.0.1.0 - Production on 19-MAY-2013 23:25:00

 

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

 

Starting/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

 

TNSLSNR for Linux:Version 10.2.0.1.0 - Production

System parameterfile is /app/oracle/product/10.2.0/db_1/network/admin/listener.ora

Log messages writtento /app/oracle/product/10.2.0/db_1/network/log/listener.log

Listening on:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=even)(PORT=1521)))

 

Connecting to(ADDRESS=(PROTOCOL=tcp)(HOST=even)(PORT=1521))

STATUS of theLISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version10.2.0.1.0 - Production

Start Date                19-MAY-2013 23:25:00

Uptime                    0 days 0 hr. 0 min. 0 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener ParameterFile  /app/oracle/product/10.2.0/db_1/network/admin/listener.ora

Listener LogFile        /app/oracle/product/10.2.0/db_1/network/log/listener.log

Listening EndpointsSummary...

 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=even)(PORT=1521)))

Services Summary...

Service"prod" has 1 instance(s).

  Instance "PROD", status UNKNOWN,has 1 handler(s) for this service...

The commandcompleted successfully

 

 


相关文章推荐

Oracle常见错误——TNS-01150

# LISTENER.ORA Network Configuration File: /opt/oracle/product/9.2/network/admin/listener.ora# Gener...
  • pyhsky
  • pyhsky
  • 2009年12月19日 23:13
  • 5144

TNS-01155: 在 LISTENER.ORA 中指定的 SID_LIST_LISTENER 参数不正确

1、今天在测试环境上重装oracle,然后就一直出现oracle listener一直假死的状况。2、查看:oracle/product/10.1.0/db_1/network/log/listene...

linux下启动oracle监听提示:TNS-01155,NL-00303

linux下启动oracle监听提示:TNS-01155,NL-00303
  • xm_csdn
  • xm_csdn
  • 2017年03月31日 13:23
  • 896

TNS-01155: 在 LISTENER.ORA 中指定的 SID_LIST_LISTENER 参数不正确

 [转]自INTERNET    近日在配置Oracle 10G的流复制环境时,遇到一个问题,关闭数据库(shutdown immediate)后,通过SQL Plus连接数据库:conn sys/h...

TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA NL-00303: syntax error

1.首先我查看/etc/hosts配置文件和/etc/sysconfig/network配置文件中的主机名是否一致。 2.查看listener.ora配合文件中的配置,是动态注册还是静态注册,如果都...

X64 Linux 无法从本地字符界面登陆

通过局域网使用ssh可以连接上rhel(64bit) 直接在服务器上接键盘、鼠标、显示器,在字符终端登录不进系统,且无提示,但是在图形界面可登录进去。 这很有可能跟 X64 类文件的存放路径有...

linux 下面安装oracle

linux 下面安装oracle http://www.linuxidc.com/Linux/2013-12/94311p6.htm grid安装 http://m.blog.i...

caffe安装吐血总结 opencv的问题,ubuntu版本问题

转自:http://blog.csdn.net/caozhantao/article/details/51479172 这周安装了caffe的windows版本和Linux版本,依赖关系太多,如...
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:让人吐血的TNS-01150
举报原因:
原因补充:

(最多只允许输入30个字)