www.Orasql.Com
 
用户名: 密码:  验证码: 注册|找回密码 oracleawen's blog  
 
         当前位置 >> 技术论坛  发表帖子     论坛版块     查找帖子
监听日志中的异常情况12505,12528,12519-技术论坛||Oracle高手之路—Orasql.Com!
            监听日志中的异常情况12505,12528,12519
 
发贴人:oracle_awen
oracleawen@gmail.com448315233127.0.0.1
用户级别:管理员
发贴总数:1245
注册时间:2011-05-05 09:23:03
2011-06-01 08:15:45
监听日志中的异常情况12505,12528,12519 症状外部应用java的连接池的连接经常失效。极偶尔情况下tnslistener服务还会停掉。应用程序中报出过异常oracle-12571tns包写入失败。 贴出listener.log和alert.log,请大家帮忙分析一下。 listener.log(部分) tnslsnr for 32-bit windows version 10.2.0.1.0 - production on 08-12月-2010 031838 copyright (c) 1991, 2005, oracle. all rights reserved. 系统参数文件为d\oracle\product\10.2.0\db_1\network\admin\listener.ora 写入d\oracle\product\10.2.0\db_1\network\log\listener.log的日志信息 写入d\oracle\product\10.2.0\db_1\network\trace\listener.trc的跟踪信息 跟踪级别当前为0 以 pid=1536 开始 监听 (description=(address=(protocol=tcp)(host=jndd_web_2)(port=1521))) listener completed notification to crs on start timestamp connect data [ protocol info] event [ sid] return code 08-12月-2010 031841 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=4899)) establish orcl137 12505 tns-12505 tns 监听程序当前无法识别连接描述符中所给出的 sid 08-12月-2010 031841 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=4900)) establish orcl137 12505 tns-12505 tns 监听程序当前无法识别连接描述符中所给出的 sid 08-12月-2010 031841 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=4901)) establish orcl137 12505 tns-12505 tns 监听程序当前无法识别连接描述符中所给出的 sid 08-12月-2010 031841 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=4902)) establish orcl137 12505 tns-12505 tns 监听程序当前无法识别连接描述符中所给出的 sid 。。。。 08-12月-2010 031848 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=1594)) establish orcl137 12505 tns-12505 tns 监听程序当前无法识别连接描述符中所给出的 sid 08-12月-2010 031848 service_register orcl137 0(请问这里有个register是不是说明监听重启过?) 08-12月-2010 031848 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=1595)) establish orcl137 12528 tns-12528 tns 监听程序 所有适用例程都无法建立新连接 08-12月-2010 031848 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=1596)) establish orcl137 12528 tns-12528 tns 监听程序 所有适用例程都无法建立新连接 08-12月-2010 031848 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=1597)) establish orcl137 12528 tns-12528 tns 监听程序 所有适用例程都无法建立新连接 08-12月-2010 031848 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=1598)) establish orcl137 12528 tns-12528 tns 监听程序 所有适用例程都无法建立新连接 08-12月-2010 031848 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=1599)) establish orcl137 12528 tns-12528 tns 监听程序 所有适用例程都无法建立新连接 。。。。 08-12月-2010 031854 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=2160)) establish orcl137 12528 tns-12528 tns 监听程序 所有适用例程都无法建立新连接 08-12月-2010 031854 service_update orcl137 0 08-12月-2010 031854 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=2161)) establish orcl137 0 08-12月-2010 031854 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=2162)) establish orcl137 0 08-12月-2010 031854 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=2163)) establish orcl137 0 。。。。 08-12月-2010 031856 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=2287)) establish orcl137 0 08-12月-2010 031856 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=2288)) establish orcl137 12519 tns-12519 tns 没有找到适用的服务处理程序 08-12月-2010 031856 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=2289)) establish orcl137 12519 tns-12519 tns 没有找到适用的服务处理程序 08-12月-2010 031856 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=2290)) establish orcl137 12519 tns-12519 tns 没有找到适用的服务处理程序 08-12月-2010 031856 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=2291)) establish orcl137 12519 tns-12519 tns 没有找到适用的服务处理程序 。。。。 08-12月-2010 031857 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=2397)) establish orcl137 12519 tns-12519 tns 没有找到适用的服务处理程序 08-12月-2010 031857 service_update orcl137 0 08-12月-2010 031857 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=2398)) establish orcl137 0 08-12月-2010 031857 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=2399)) establish orcl137 0 08-12月-2010 031857 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=2401)) establish orcl137 0 。。。。 08-12月-2010 031859 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=2545)) establish orcl137 0 08-12月-2010 031859 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=2546)) establish orcl137 12519 tns-12519 tns 没有找到适用的服务处理程序 08-12月-2010 031859 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=2547)) establish orcl137 12519 tns-12519 tns 没有找到适用的服务处理程序 08-12月-2010 031859 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=2548)) establish orcl137 12519 tns-12519 tns 没有找到适用的服务处理程序 。。。。 tns-12519 tns 没有找到适用的服务处理程序 08-12月-2010 031903 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=2945)) establish orcl137 12519 tns-12519 tns 没有找到适用的服务处理程序 08-12月-2010 031903 service_update orcl137 0 08-12月-2010 031903 (connect_data=(sid=orcl137)(cid=(program=)(host=__jdbc__)(user=))) (address=(protocol=tcp)(host=10.150.53.136)(port=2946)) establish orcl137 0 08-12月-2010 031905 (connect_data=(cid=(program=)(host=__jdbc__)(user=))(service_name=orcl137)) (address=(protocol=tcp)(host=10.150.53.137)(port=1038)) establish orcl137 0 08-12月-2010 031906 (connect_data=(cid=(program=)(host=__jdbc__)(user=))(service_name=orcl137)) (address=(protocol=tcp)(host=10.150.53.137)(port=1039)) establish orcl137 0 08-12月-2010 031906 (connect_data=(cid=(program=)(host=__jdbc__)(user=))(service_name=orcl137)) (address=(protocol=tcp)(host=10.150.53.137)(port=1041)) establish orcl137 0 08-12月-2010 031906 (connect_data=(cid=(program=)(host=__jdbc__)(user=))(service_name=orcl137)) (address=(protocol=tcp)(host=10.150.53.137)(port=1040)) establish orcl137 0 08-12月-2010 031906 (connect_data=(cid=(program=)(host=__jdbc__)(user=))(service_name=orcl137)) (address=(protocol=tcp)(host=10.150.53.137)(port=1042)) establish orcl137 0 08-12月-2010 031906 (connect_data=(cid=(program=)(host=__jdbc__)(user=))(service_name=orcl137)) (address=(protocol=tcp)(host=10.150.53.137)(port=1043)) establish orcl137 0 08-12月-2010 031906 service_update orcl137 0 alert_orcl137.log starting up oracle rdbms version 10.2.0.1.0. system parameters with non-default values processes = 150 __shared_pool_size = 150994944 __large_pool_size = 4194304 __java_pool_size = 4194304 __streams_pool_size = 0 spfile = d\oracle\product\10.2.0\db_1\dbs\spfileorcl137.ora sga_target = 612368384 control_files = d\oracle\product\10.2.0\oradata\orcl137\control01.ctl, d\oracle\product\10.2.0\oradata\orcl137\control02.ctl, d\oracle\product\10.2.0\oradata\orcl137\control03.ctl db_block_size = 8192 __db_cache_size = 444596224 compatible = 10.2.0.1.0 db_file_multiblock_read_count= 16 db_recovery_file_dest = d\oracle\product\10.2.0/flash_recovery_area db_recovery_file_dest_size= 2147483648 undo_management = auto undo_tablespace = undotbs1 remote_login_passwordfile= exclusive db_domain = dispatchers = (protocol=tcp) (service=orcl137xdb) job_queue_processes = 10 audit_file_dest = d\oracle\product\10.2.0\admin\orcl137\adump background_dump_dest = d\oracle\product\10.2.0\admin\orcl137\bdump user_dump_dest = d\oracle\product\10.2.0\admin\orcl137\udump core_dump_dest = d\oracle\product\10.2.0\admin\orcl137\cdump db_name = orcl137 open_cursors = 300 pga_aggregate_target = 203423744 pmon started with pid=2, os id=3652 mman started with pid=4, os id=3660 dbw0 started with pid=5, os id=3800 lgwr started with pid=6, os id=3804 ckpt started with pid=7, os id=3808 smon started with pid=8, os id=3812 reco started with pid=9, os id=3816 cjq0 started with pid=10, os id=3820 mmon started with pid=11, os id=3824 wed dec 08 031848 2010 starting up 1 dispatcher(s) for network address '(address=(partial=yes)(protocol=tcp))'... mmnl started with pid=12, os id=3828 wed dec 08 031848 2010 starting up 1 shared server(s) ... wed dec 08 031849 2010 alter database mount exclusive psp0 started with pid=3, os id=3656 wed dec 08 031853 2010 setting recovery target incarnation to 2 wed dec 08 031853 2010 successful mount of redo thread 1, with mount id 26559321 wed dec 08 031853 2010 database mounted in exclusive mode completed alter database mount exclusive wed dec 08 031853 2010 alter database open wed dec 08 031853 2010 beginning crash recovery of 1 threads parallel recovery started with 7 processes wed dec 08 031854 2010 started redo scan wed dec 08 031854 2010 completed redo scan 4465 redo blocks read, 207 data blocks need recovery wed dec 08 031854 2010 started redo application at thread 1 logseq 8441, block 72919 wed dec 08 031854 2010 recovery of online redo log thread 1 group 1 seq 8441 reading mem 0 mem# 0 errs 0 d\oracle\product\10.2.0\oradata\orcl137\redo01.log wed dec 08 031854 2010 completed redo application wed dec 08 031854 2010 completed crash recovery at thread 1 logseq 8441, block 77384, scn 10191857167300 207 data blocks read, 207 data blocks written, 4465 redo blocks read wed dec 08 031855 2010 thread 1 advanced to log sequence 8442 thread 1 opened at log sequence 8442 current log# 2 seq# 8442 mem# 0 d\oracle\product\10.2.0\oradata\orcl137\redo02.log successful open of redo thread 1 wed dec 08 031855 2010 mttr advisory is disabled because fast_start_mttr_target is not set wed dec 08 031855 2010 smon enabling cache recovery wed dec 08 031857 2010 successfully onlined undo tablespace 1. wed dec 08 031857 2010 smon enabling tx recovery wed dec 08 031857 2010 database characterset is zhs16gbk replication_dependency_tracking turned off (no async multimaster replication found)

      
 
  
 Orasql.Com|E-Mail:oracleawen@gmail.com|Phone:15271942915|Copyright © 2011|All Rights Reserved|