The listenersupports no services

1、

[oracle@oracle11admin]$ sqlplus '/as sysdba'

 

SQL*Plus: Release11.2.0.1.0 Production on Fri Apr 27 18:41:55 2012

 

Copyright (c) 1982,2009, Oracle.  All rights reserved.

 

 

Connected to:

Oracle Database 11gEnterprise Edition Release 11.2.0.1.0 - 64bit Production

With thePartitioning, OLAP, Data Mining and Real Application Testing options

 

SQL> showparameter service_names;

 

NAME                                 TYPE        VALUE

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

service_names                        string      ora11.us.oracle.com

SQL> alter systemregister ora11;

alter systemregister ora11

                      *

ERROR at line 1:

ORA-00933: SQLcommand not properly ended

 

 

SQL> alter systemregister;

 

System altered.

[oracle@oracle11admin]$ lsnrctl status

 

LSNRCTL for Linux:Version 11.2.0.1.0 - Production on 27-APR-2012 18:43:03

 

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

 

Connecting to(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))

STATUS of theLISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version11.2.0.1.0 - Production

Start Date                27-APR-2012 18:35:26

Uptime                    0 days 0 hr. 7 min. 37 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener ParameterFile  /home/oracle/app/product/11.2.0.1/network/admin/listener.ora

Listener LogFile        /home/oracle/app/diag/tnslsnr/oracle11/listener/alert/log.xml

Listening EndpointsSummary...

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

Services Summary...

Service"ora11.us.oracle.com" has 1 instance(s).

  Instance "ora11", status READY, has1 handler(s) for this service...

Service"ora11XDB.us.oracle.com" has 1 instance(s).

  Instance "ora11", status READY, has1 handler(s) for this service...

The commandcompleted successfully

 

这种方式重启监听失效

 

2、修改监听文件
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    )
  )


SID_LIST_LISTENER =
  (SID_LIST =
        (SID_DESC=
                (SID_NAME=ora11)
                (ORACLE_HOME=/home/oracle/app/product/11.2.0.1)
                (SID_NAME=ora11))
        (SID_DESC=
                (SID_NAME=plsextproc)
                (ORACLE_HOME=/home/oracle/app/product/11.2.0.1)
                (PROGRAM=extproc)
        )
  )
增加SID_LIST_LISTENER