以下是内容,防火墙我也关掉了,那个agent的补丁我也打了..实在不知道是为啥子原因了........已经折腾了2天了....
=====================================================================
[oracle@localhost tmp]$ lsnrctl startLSNRCTL for Linux: Version 9.2.0.4.0 - Production on 16-JAN-2009 15:46:24Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.Starting /home/oracle/OraHome1/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Log messages written to /home/oracle/OraHome1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date 16-JAN-2009 15:46:24
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Log File /home/oracle/OraHome1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@localhost tmp]$ sqlplus /nologSQL*Plus: Release 9.2.0.4.0 - Production on Fri Jan 16 15:46:35 2009Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.SQL> conn sys/kreo@nms as sysdba
ERROR:
ORA-12535: TNS:operation timed out
=====================================================================
[oracle@localhost tmp]$ lsnrctl startLSNRCTL for Linux: Version 9.2.0.4.0 - Production on 16-JAN-2009 15:46:24Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.Starting /home/oracle/OraHome1/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Log messages written to /home/oracle/OraHome1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date 16-JAN-2009 15:46:24
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Log File /home/oracle/OraHome1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@localhost tmp]$ sqlplus /nologSQL*Plus: Release 9.2.0.4.0 - Production on Fri Jan 16 15:46:35 2009Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.SQL> conn sys/kreo@nms as sysdba
ERROR:
ORA-12535: TNS:operation timed out
=====================================
看一下listener.ora,配置是否正确。
本地登录 sqlplus "/ as sysdba" 通常不使用 listener,试一下本地 sqlplus "/ as sysdba" 登录,如果可以说明数据库服务没有问题。
添加的格式网上多得是,
还有,看看listener.ora文件中的把主机名改为IP试试