让人吐血的TNS-01150

让人吐血的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