EBS R12.1 FOR linux 数据库监听很慢的一个解决方法
作者: zhulch(http://zhulch.itpub.net)发表于: 2009.11.25 11:22
分类: ERP(Oracle/SAP)
出处: http://zhulch.itpub.net/post/17395/494074
---------------------------------------------------------------
环境:
- Oracle EBS R12.1.1
- Linux 5.3
详细内容请看如下
故障现象:
- tnsping VIS 延时很长,不能忍受的地步
- 应用层面启动不成功
分析过程:
- 检查/etc/hosts, 把IP6的相关内容注释掉,因为根本没用到IP6
- ping localhost 很快
- ping hostname 很快,并且能够解析
- cd $ORACLE_HOME/nework/context_name/admin/tnsnames.ora,sqlnet.ora,lisenter.ora 文件检查,试图把hostname 换成IP,结果还是不理想
- telent hostname 1521 速度很快
- server 上sqlplus "/as sysdba"速度很快
- server sqlplus system/oracle@VIS速度很慢
%100 确定监听出了问题
- tracerouter hostname 就一跳 ,,应该没问题
- metlink上查找相关文件,怀疑有BUG存在..
- 找到类似的 What was changed between the two is the way Oracle resolves hostnames to IPs, more specifically the system call used to do that.
Oracle 11g use now getaddrinfo() while 10g used gethostbyname().
These system functions requires different configuration in /etc/nsswitch.conf.
gethostbyname() require the use of keyword "hosts" while getaddrinfo() the use the keyword "ipnodes"
This happens even if Name Server Switch configuration (nsswitch) specifies the hosts file prior to dns lookups:
/etc/nsswitch.conf
hosts: files [NOTFOUND=continue] dns
or only:
hosts: files 这样的DOC..
- 看来是因为Server 本身的DNS起作用了,DNS一起作用,hosts就有问题了
- /etc/resolv.conf
;generated by /usr/sbin/oraclevm-template
#search hostname
#options timeout:15
#options timeout:15
#nameserver hostname
全去掉,或者干脆把resolv.conf move 掉
- 最后把/etc/sysconfig/network中IP6相关的东西都去掉了
再测试,就OK了
