oracle 监听问题求助！！！！！

BearDrinkbeer

操作系统 centos 5.5 32bit oracle 10g r2
监听启动  
[oracle@zs21 ~]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 08-JUN-2013 13:48:20

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

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

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /data/app/oracle/product/10.2.0/network/admin/listener.ora
Log messages written to /data/app/oracle/product/10.2.0/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
TNS-01150: The address of the specified listener name is incorrect
TNS-01153: Failed to process string: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zs21)(PORT=null)))

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

查看监听状态
[oracle@zs21 ~]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 08-JUN-2013 13:40:21

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zs21)(PORT=null)))
TNS-12535: TNSperation timed out
TNS-12560: TNS:protocol adapter error
  TNS-00505: Operation timed out
   Linux Error: 110: Connection timed out
listener.ora文件配置
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /data/app/oracle/product/10.2.0)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = tsadb)
      (ORACLE_HOME = /data/app/oracle/product/10.2.0)
      (SID_NAME = tsadb)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = zs21)(PORT = null))
    )
  )
刚刚接触，不太明白，网上查的解决不了

liuxiaoyin666

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /data/app/oracle/product/10.2.0)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = zs21)(PORT = 1521))
    )
  )

BearDrinkbeer

[oracle@zs21 dbs]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 08-JUN-2013 16:59:39

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zs21)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                08-JUN-2013 16:40:10
Uptime                    0 days 0 hr. 19 min. 29 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /data/app/oracle/product/10.2.0/network/admin/listener.ora
Listener Log File         /data/app/oracle/product/10.2.0/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zs21)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
  监听起来了  可是找不到实例
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/data/app/oracle/product/10.2.0/dbs/inittsadb.ora'

kellyseeme123

inittsadb.ora这个文件不存在