lsnrctl status 中没有相应数据库的instance , 数据库运行却正常，奇怪吗？

moonlit

各位好，
我有个问题，请各位帮忙看看，
我有个数据库kumaspc, 我认为lsnrctl status 结果中如果看不到这个名字的service , 数据库应该是没有启动，也不应该能连接，
而事实是，没有kumaspc的service , 数据库也能连接。 为lsnrctl status 结果如下，这是为什么呢？
还有就是因为没有这个service 使得startup总是不成功，conn  user/password as sysdba后，总出现：Connected to an idle instance 这又是为什么呢？

[oracle@RFIDB dbs]$ lsnrctl status

LSNRCTL for Linux: Version 10.1.0.3.0 - Production on 12-JUN-2007 06:41:07

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.1.30)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.1.0.3.0 - Production
Start Date                12-JUN-2007 05:27:47
Uptime                    0 days 1 hr. 13 min. 20 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /home/oracle/product/10.1.0/Db_1/network/admin/listener.ora
Listener Log File         /home/oracle/product/10.1.0/Db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.1.30)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=RFIDB)(PORT=8080))(Presentation=HTTP)(Session=RAW))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=RFIDB)(PORT=2100))(Presentation=FTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "kumaocf.tmsdomain" has 1 instance(s).
  Instance "kumaocf", status READY, has 1 handler(s) for this service...
Service "kumaocfXDB.tmsdomain" has 1 instance(s).
  Instance "kumaocf", status READY, has 1 handler(s) for this service...
The command completed successfully

ados_luo

请把你的listener.ora和tnsnames.ora文件内容贴上来看看

beking1627

一点也不奇怪。不用看了，正常。就是个动态注册和静态注册的关系。

moonlit

楼上，你好，
要是正常的话，为什么startup 起不来呢？也没说已经起来。请指教！！！

SQL> conn kumamoto/tamana as sysdba
Connected to an idle instance.
SQL> startup
ORA-00371: not enough shared pool memory, should be atleast 52132659 bytes




# listener.ora Network Configuration File: /home/oracle/product/10.1.0/Db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
#      (SID_NAME = ITEMID)
#      (SID_NAME = KUMAOCF)
      (ORACLE_HOME = /home/oracle/product/10.1.0/Db_1)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.30)(PORT = 1521))
      )
    )
  )





# tnsnames.ora Network Configuration File: /home/oracle/product/10.1.0/Db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

PERL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.30)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = perl.tmsdomain)
    )
  )

ITEMID =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.30)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ITEMID.tmsdomain)
    )
  )

AKEI =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.30)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = akei)
    )
  )

KUMAOCF =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.30)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = kumaocf.tmsdomain)
    )
  )

moonlit

各位，

我看出毛病了，是我自己不好，长期不用这个数据库了，记错了oracle_id了，见笑见笑！

正确的如下：

[oracle@RFIDB dbs]$ ORACLE_SID=kumaocf      这里写错了SID 为 kumaspc
[oracle@RFIDB dbs]$ export ORACLE_SID
[oracle@RFIDB dbs]$ sqlplus /nolog

SQL*Plus: Release 10.1.0.3.0 - Production on Tue Jun 12 09:37:09 2007

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

SQL> conn kumamoto/tamana as sysdba
Connected.
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first

ados_luo

(1) 去掉注释 #      (SID_NAME = KUMAOCF), 重启监听
(2) 增大shared_pool_size参数值，要大于52132659bytes
(3) sqlplus /nolog -> conn user/passwd@kumaocf as sysdba -> startup
    或 sqlplus /nolog -> set instance kumaocf  -> conn user/passwd as sysdba -> startup

[ 本帖最后由 ados_luo 于 2007-6-12 12:55 编辑 ]