• <ins id="pjuwb"></ins>
    <blockquote id="pjuwb"><pre id="pjuwb"></pre></blockquote>
    <noscript id="pjuwb"></noscript>
          <sup id="pjuwb"><pre id="pjuwb"></pre></sup>
            <dd id="pjuwb"></dd>
            <abbr id="pjuwb"></abbr>

            tbwshc

            tbw

              C++博客 :: 首頁 :: 聯系 :: 聚合  :: 管理
              95 Posts :: 8 Stories :: 3 Comments :: 0 Trackbacks

            常用鏈接

            留言簿(4)

            我參與的團隊

            搜索

            •  

            最新評論

            閱讀排行榜

            評論排行榜

            最近一臺新上線的Oracle10gR2數據庫在警告日志文件中(alert.log)持續出現如下錯誤:

              Tue Jul 18 23:09:22 2006

              WARNING: inbound connection timed out (ORA-3136)

              Tue Jul 18 23:09:23 2006

              WARNING: inbound connection timed out (ORA-3136)

              Tue Jul 18 23:09:25 2006

              WARNING: inbound connection timed out (ORA-3136)

              Tue Jul 18 23:09:30 2006

              WARNING: inbound connection timed out (ORA-3136)

              Tue Jul 18 23:12:15 2006

              WARNING: inbound connection timed out (ORA-3136)

              同時在sqlnet.log中記錄了如下錯誤:

              Fatal NI connect error 12170.

              VERSION INFORMATION:

              TNS for Linux: Version 10.2.0.2.0 - Production

              Oracle Bequeath NT Protocol tb Adapter for Linux: Version 10.2.0.2.0 - Production

              TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.2.0 - Production

              Time: 19-JUL-2006 11:25:26

              Tracing not turned on.

              Tns error struct:

              ns main err code: 12535

              TNS-12535: TNS:operation timed out

              ns secondary err code: 12606

              nt main err code: 0

              nt secondary err code: 0

              nt OS err code: 0

              Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.123)(PORT=58147))

              這是和網絡連接相關的一個錯誤,Metalink上給出了如下的解決方案:

              1.set INBOUND_CONNECT_TIMEOUT_ =0 in listener.ora

              2. set SQLNET.INBOUND_CONNECT_TIMEOUT = 0 in sqlnet.ora of server.

              3. stop and start both listener and database.

              4. Now try to connect to DB and observe the behaviour

              這里重起數據庫和Listener我認為是沒有必要的,我們reload一下Listner應該就可以了.

              [oracle@order admin]$ lsnrctl

              LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 19-JUL-2006 15:26:33

              Copyright (c) 1991, 2005, Oracle. All rights reserved.

              Welcome to LSNRCTL, type "help" for information.

              LSNRCTL> reload

              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.9.11)(PORT=1521)))

              The command completed successfully

              LSNRCTL> services

              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.9.11)(PORT=1521)))

              Services Summary...

              Service "order" has 2 instance(s).

              Instance "order", status UNKNOWN, has 1 handler(s) for this service...

              Handler(s):

              "DEDICATED" established:0 refused:0

              LOCAL SERVER

              Instance "order", status READY, has 1 handler(s) for this service...

              Handler(s):

              "DEDICATED" established:0 refused:0 state:ready

              LOCAL SERVER

              The command completed successfully

              LSNRCTL> show inbound_connect_timeout

              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.9.11)(PORT=1521)))

              LISTENER parameter "inbound_connect_timeout" set to 0

              The command completed successfully

              LSNRCTL> exit

              修改之后,觀察了一段時間,目前正常.

              關于SQLNET.INBOUND_CONNECT_TIMEOUT參數,Oracle建議修改該參數,以避免denial-of-service攻擊.

            .item-area{width:578px;margin:15px auto;border-top:1px solid #ddd;color:#666} .item-area a,.item-area a:link,.item-area a:visited{color:#666;text-decoration:none} .item-area a:hover{color:#3a7ad9;text-decoration:underline;} a img{border:none;vertical-align:middle} .item-area h2,.item-area h3{float:none;font-size:100%;font-weight:normal;} .item-area .h2{height:25px;margin:10px 0;padding-left:35px;*float:left;font:bold 14px/25px "宋體";background:url(http://sns.thea.cn/module/images/icos.png) no-repeat 0 0} .item-area span.more{float:right;font:normal 12px/25px "宋體"} .item-area a.more{float:right;font:normal 12px/25px "宋體"} .item-a{margin-bottom:15px} .item-a .h-ksrm{background-position:0 0} .item-a li{*display:inline;overflow:hidden;zoom:1;line-height:2em;padding-left:35px;font-size:14px;background: url(http://sns.thea.cn/module/images/btns.png) no-repeat -1px -28px;} .item-a li a{float:left;} .item-a .testBtn{float:right;width:58px;height:21px;line-height:21px;font-size:12px;margin-top:5px;margin-top:3px;text-align:center;background:url(http://sns.thea.cn/module/images/btns.png) no-repeat -1px -1px; color:#FFFFFF;} .item-a a.freeBtn{width:20px;margin:0 0 0 6px;line-height:28px;color:#fff;font-size:12px;text-indent:-9999px;background: url(http://sns.thea.cn/module/images/icos.png) no-repeat 0 -131px;} .item-a li.hots a.freeBtn{background-position:0 -105px} .item-a a.examnum em{font-style:normal;color:red;font-weight:bold;} .item-b {padding:5px 0 20px;border-top:1px dashed #ddd;border-bottom:1px dashed #ddd} .xsjl-list-col3s li{display:table-cell;*display:inline;zoom:1;vertical-align:top;width:182px;padding-right:10px;line-height:150%;font-size:12px;} .item-b .h-xsjl{background-position:0 -26px} .item-b .pic{float:left;margin:3px 10px 0 0;} .item-b em{font-style:normal;color:#dc2c2c} .item-b a.join{display:inline-block;padding-left:20px;background:url(http://sns.thea.cn/module/images/icos.png) no-repeat 0 -160px} .item-b .xsjl-list-col3s h3 a{display:inline-block;width:120px;overflow:hidden;white-space:nowrap;color:#3a7ad9} .item-b .xsjl-list-col3s h3{text-align:left;line-height:150%;font-family:"宋體","微軟雅黑"}
            posted on 2012-10-22 14:16 tbwshc 閱讀(1006) 評論(0)  編輯 收藏 引用
            亚洲精品无码成人片久久| 一本色道久久综合狠狠躁| 久久青青草原精品影院| 精品无码久久久久久久动漫| 久久国产视屏| 色妞色综合久久夜夜| 成人资源影音先锋久久资源网| 99久久国产综合精品网成人影院| 久久无码一区二区三区少妇| 久久久噜噜噜久久中文福利| 免费观看久久精彩视频| 久久精品国产清自在天天线| 国产精品免费久久久久影院| 久久久精品国产免大香伊 | 色综合久久无码中文字幕| 99久久国产综合精品五月天喷水| 日韩欧美亚洲综合久久| 久久综合综合久久狠狠狠97色88| 中文字幕精品久久| 久久久久久青草大香综合精品| 天天躁日日躁狠狠久久| 久久亚洲高清观看| 久久久无码精品亚洲日韩京东传媒| 久久精品人人做人人爽电影| 久久久久波多野结衣高潮| 精品久久久久久久久久中文字幕 | 日产精品99久久久久久| 最新久久免费视频| 亚洲AV伊人久久青青草原| 97久久精品人人澡人人爽| 精品一区二区久久| 精品免费tv久久久久久久| 久久99国产乱子伦精品免费| 性欧美大战久久久久久久久| 久久久一本精品99久久精品88| 午夜福利91久久福利| 久久久久女教师免费一区| 久久久久亚洲av毛片大| 久久夜色精品国产| 国产A三级久久精品| 久久综合香蕉国产蜜臀AV|