本帖最后由 yuanjqiu 于 2012-9-26 12:21 编辑
主题:部分客户端PL/SQL登陆数据库服务器报:ora-03135;ORA-12543: TNS: 无法连接目标主机;ORA-12543
修改listener的inbound_connect_timeout参数的方法 环境:
aix 5.3 +oracle10g R2 10.2.0.3.0 +rac(主、从)
现象:
1、突然出现部分ip(192.168.10.151),不能登录oracle,部分ip(192.168.10.50)可登录oracle,不能登录的clients,改成可登录的ip,又可登录;改回原来的IP,还是不能登录oracle。
2、resource_limit=false(default),改为:resource_limit=true,仍不行。
3、添加sqlnet.ora文件,并添加内容:
sqlnet.expire_time=20
还是不行。
4、查server是否ip及applicatin限制,没有做ip、application限制。
5、server端对oracle instance重启,故障仍在。
6、僵尸的session,也没有。
7、OS serverSID for oracle kill 后,还是不行。
8、tnsping SID均通。tnsping sid 100 均显示ok
9、sessions_highwater=34, 4cpu current_session=27
采用盖老师提供的如下办法方法一:$ lsnrctl LSNRCTL for IBM/AIX RISC System/6000: Version10.2.0.3.0 - Production on 29-OCT-2007 10:00:57 Copyright (c) 1991, 2006, Oracle.All rights reserved. Welcome to LSNRCTL, type "help" forinformation. LSNRCTL> helpThe following operations are availableAn asterisk (*) denotes a modifier or extendedcommand: start
stop
status
services version
reload
save_configtrace
spawn
change_passwordquit
exit
set*
show*
LSNRCTL> showThe following operations are available after showAn asterisk (*) denotes a modifier or extendedcommand: rawmode
displaymode
rules
trc_file
trc_directory
trc_level
log_file
log_directory
log_status
current_listener inbound_connect_timeout startup_waittime snmp_visible
save_config_on_stopdynamic_registration
LSNRCTL> show inbound_connect_timeoutConnecting to(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.125.1)(PORT=1521))LISTENER parameter "inbound_connect_timeout"set to 60The command completed successfully LSNRCTL> set inbound_connect_timeout 0Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.125.1)(PORT=1521))LISTENER parameter "inbound_connect_timeout"set to 0The command completed successfully LSNRCTL> show inbound_connect_timeoutConnecting to(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))LISTENER parameter "inbound_connect_timeout"set to 0The command completed successfully LSNRCTL> set save_config_on_stop on #表示修改参数永久生效,否则只是临时生效,下次重启监听又还原为原来的值了 LSNRCTL> exit方法二:修改listener.ora文件,加入:INBOUND_CONNECT_TIMEOUT_LISTENER_NAME=0
换IP还是不能成功登录数据库。郁闷!看来他的场景与我这情况不一样。
有人建议做如下测试
telnet ip 1521弹出一个黑白的空窗口。
telnet ip:1521提示23关闭。
网络连接信息
OS级:
AIX Version 5
(C) Copyrights by IBM and by others 1982,2006.
login: /dev/pts/1: 3004-038 Login timed outafter 60 seconds.
数据库级:alter_orcl.log内容为:
1、WARNING: inbound connection timed out (ORA-3136)2、Mon Sep 24 18:48:07 2012
Process OS id : 827642 alive after kill
Errors in file /oracle/admin/ybsb/udump/test_ora_434266.trc其中/oracle/admin/ybsb/udump/test_ora_434266.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /oracle/product/10
System name: AIX
Node name: orcl1
Release: 3
Version: 5
Machine: 00CE75DE4C00
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 27
Unix process pid: 434266, image: [url=mailto
racle@orcl]oracle@orcl[/url] (TNS V1-V3)*** 2012-09-24 18:48:02.631
*** SERVICE NAME
SYS$USERS) 2012-09-24 18:48:02.621
*** SESSION ID
112.2370) 2012-09-24 18:48:02.621
----------------------------------------
SO: 70000006f2f5fa0, type: 2, owner: 0, flag: INIT/-/-/0x00
(process) Oracle pid=13, calls cur/top: 0/70000006f439c48, flag: (0) -
int error: 1089, call error: 0, sess error: 0, txn error 0
(post info) last post received: 1089 8 12
last post received-location: ksusig
last process to post me: 70000006f2fcde0 113 0
last post sent: 0 0 24
last post sent-location: ksasnd
last process posted by me: 70000006f2f2880 1 6
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: 70000006f33a7a8
O/S info: user: oracle, term: UNKNOWN, ospid: 507908
OSD pid info: Unix process pid: 507908, image: [url=mailto
racleybsb@orcl]oracleybsb@orcl[/url]
Short stack dump: unable to dump stack due to error 72
Dump of memory from 0x070000006F2DE2F8 to 0x070000006F2DE500
70000006F2DE2F0
00000004 00000000
[........]
70000006F2DE300 07000000 6F93C0F0 00000010 0003139D[....o...........]
70000006F2DE310 07000000 6F439C48 00000003 0003139D[....oC.H........]
70000006F2DE320 07000000 6F5BEB08 0000000B 0003139D[....o[..........]
70000006F2DE330 07000000 6F3E2390 00000004 00031291[....o>#.........]
70000006F2DE340 00000000 00000000 00000000 00000000[................]
Repeat 27 times
----------------------------------------
SO: 70000006f2f6f60, type: 2, owner: 0, flag: INIT/-/-/0x00
(process) Oracle pid=15, calls cur/top: 0/70000006f43afb8, flag: (0) -
int error: 1089, call error: 0, sess error: 0, txn error 0
(post info) last post received: 1089 8 12
last post received-location: ksusig
last process to post me: 70000006f2fcde0 113 0
last post sent: 0 0 0
last post sent-location: No post
last process posted by me: none
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: 70000006f33a7a8
O/S info: user: oracle, term: UNKNOWN, ospid: 843828
OSD pid info: Unix process pid: 843828, image: [url=mailto
racleybsb@orcl6]oracleybsb@orcl[/url]
Short stack dump: unable to dump stack due to error 72
Dump of memory from 0x070000006F2DE708 to 0x070000006F2DE910
70000006F2DE700
00000004 00000000
[........]
70000006F2DE710 07000000 6F93C7D8 00000010 0003139D[....o...........]
70000006F2DE720 07000000 6F43AFB8 00000003 0003139D[....oC..........]
70000006F2DE730 07000000 6F5C0D68 0000000B 0003139D[....o\.h........]
70000006F2DE740 07000000 6F3A80A0 00000004 00031291[....o:..........]
70000006F2DE750 00000000 00000000 00000000 00000000[................]
Repeat 27 times
----------------------------------------
SO: 70000006f2f8700, type: 2, owner: 0, flag: INIT/-/-/0x00
(process) Oracle pid=18, calls cur/top: 0/70000006f43b278, flag: (0) -
int error: 1089, call error: 0, sess error: 0, txn error 0
(post info) last post received: 1089 8 123、TNS-12535: TNS
peration timed out
|