我们的目的是:不影响生产系统,移除并重新生成listener.log:
* *
* Welcome to solaris Version 9 *
*
#
#
# su - oracle
$ cd /oracle/product/10.2.0/db_1/network/log/
$ ls -l
total 6136904
-rw-r----- 1 oracle oinstall 3139249490 Jan 20 19:03 listener.log
-rw-r--r-- 1 oracle oinstall 2617857 Jan 17 02:08 sqlnet.log
$
$
$ lsnrctl set log_status off
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 20-1月 -2009 19:10:53
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mes_ora)(PORT=1521)))
LISTENER parameter "log_status" set to OFF
The command completed successfully
$ mv listener.log listener.bak
$ ls -l
total 6137000
-rw-r----- 1 oracle oinstall 3139300680 Jan 20 19:10 listener.bak
-rw-r--r-- 1 oracle oinstall 2617857 Jan 17 02:08 sqlnet.log
$ lsnrctl set log_status on
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 20-1月 -2009 19:11:10
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mes_ora)(PORT=1521)))
LISTENER parameter "log_status" set to ON
The command completed successfully
$ ls -l
total 6137016
-rw-r----- 1 oracle oinstall 3139300680 Jan 20 19:10 listener.bak
-rw-r--r-- 1 oracle oinstall 6416 Jan 20 19:11 listener.log
-rw-r--r-- 1 oracle oinstall 2617857 Jan 17 02:08 sqlnet.log
$ lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 20-1月 -2009 19:11:54
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mes_ora)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
Start Date 29-11月-2008 05:55:53
Uptime 52 days 13 hr. 16 min. 4 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=loopback)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "jnmes" has 1 instance(s).
Instance "jnmes", status READY, has 1 handler(s) for this service...
Service "jnmesXDB" has 1 instance(s).
Instance "jnmes", status READY, has 1 handler(s) for this service...
Service "jnmes_XPT" has 1 instance(s).
Instance "jnmes", status READY, has 1 handler(s) for this service...
The command completed successfully
$
listener.bak 怎么处理就不用多说了吧!
分享到:
相关推荐
配置ORACLE的listener.ora、tnsnames.ora
认识oracle中的sqlnet.ora tnsnames.ora listener.ora三个文件
查看listener.log? find / -name listener.log 经查看,竟然高达2G得日志数据,由于一些老旧的OS不支持2GB以上的文件,故当listener.log文件 超过2GB时,会出现无法处理新的连接,新的操作系统虽然不会出现这个...
oracleRAC监听文件详解
/oracle/app/oracle/product/11.2.0/db_1/bin/lsnrctl start LISTENER Listener Control complete. Listener started successfully. Listener configuration complete. Oracle ...
event_listener.jsx PS事件监听脚本
event_listener.jsx PS事件监听脚本 1、修改脚本监听数据本地化语言显示 ---0.02-01 2、函数增加注释当前历史记录名称 ---0.02-02 https://blog.csdn.net/greless/article/details/105811358
$cp $ORACLE_HOME/network/log/listener.log $ORACLE_BACKUP/network/log/listener_1.log $cp /dev/null $ORACLE_HOME/network/log/listener.log 文件操作完成后,打开listener记日志的工作: $lsnrctl ...
Servlet中的八大Listener.docServlet中的八大Listener.docServlet中的八大Listener.docServlet中的八大Listener.docServlet中的八大Listener.docServlet中的八大Listener.docServlet中的八大Listener.docServlet中的...
Listener.doc Listener.doc
我电脑就是这样的配置,能够正常用PL/SQL工具!
oracle中的sqlnet.ora+tnsnames.ora+listener.ora三个文件的说明,对于初学者来说非常实用
主要跟大家分享了关于Oracle listener日志解析利器的使用方法,文中通过示例代码介绍的非常详细,需要的朋友可以参考借鉴,下面来一起看看吧。
功能包learning_communation的源码,包括talker.cpp和listener.cpp两个源代码,注释详细,供参考
Oracle_client_win32安装手册和配置tnsnames.ora文和listener.ora件
oracle
One of the most misunderstood security issues with the Oracle Database is the security of the Listener. Generally, DBAs are not aware that an attacker can easily remotely manage the Listener and ...
Ajax-log-listener.zip,使用jquery(php和mysql)的大数据日志监听器,ajax代表异步javascript和xml。它是多种web技术的集合,包括html、css、json、xml和javascript。它用于创建动态网页,其中网页的小部分在不重新...
专门解决Oracle数据库listener报1067错误,简洁有效的解决这个问题,非常实用。