请问ORA-03113错误,有监听,tnsping 能ping通，怎么解决

腻水的飞鱼

SQL> conn sys/manager@officedb as sysdba
ERROR:
ORA-03113: end-of-file on communication channel


SQL> !lsnrctl status

LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.1.0 - Production on 28-AUG-2006 13:44:52

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=s7a)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.1.0 - Production
Start Date                28-AUG-2006 13:44:10
Uptime                    0 days 0 hr. 0 min. 42 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /oracle_base/oracle/product/9.2.01/network/admin/listener.ora
Listener Log File         /oracle_base/oracle/product/9.2.01/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=s7a)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Services Summary...
Service "officedb" has 1 instance(s).
  Instance "officedb", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

SQL> tnsping officedb
SP2-0734: unknown command beginning "tnsping of..." - rest of line ignored.
SQL> !tnsping officedb

TNS Ping Utility for IBM/AIX RISC System/6000: Version 9.2.0.1.0 - Production on 28-AUG-2006 13:45:19

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:
/oracle_base/oracle/product/9.2.01/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.4.2.9)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = officedb)))
OK (30 msec)

SQL>

blue_stone

listener.ora放上来看看
看样子的的数据库没有启动啊