- 论坛徽章:
- 0
|
一、我如何设置实现将ORACLE中长期不操作用户剔除ORACLE
二、我如何设置在不启动服务的情况下,能定时清理临时表空间?
三、为什么我的监听服务启动过程报出SID服务状态为unknown?
我将listener.ora改为以下文件(没有SID设置部分),过两天又显示正常了?显示状态挺好的,你说奇怪不?
/------------------------------
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.72.96.11)(PORT = 1521))
)
)
)
------------------------------------/
显示状态为
/-----------------
# lsnrctl status
LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 19-JUN-2006 13:38:59
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.72.96.11)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 9.2.0.1.0 - Production
Start Date 16-JUN-2006 13:52:13
Uptime 2 days 23 hr. 46 min. 45 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /oracle/app/oracle/product/9.0.1/network/admin/listener.ora
Listener Log File /oracle/app/oracle/product/9.0.1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.72.96.11)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bkqsun880)(PORT=8080))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bkqsun880)(PORT=2100))(Presentation=FTP)(Session=RAW))
Services Summary...
Service "ora8" has 1 instance(s).
Instance "ora8", status READY, has 2 handler(s) for this service...
The command completed successfully
------------------------------/ |
|