AIX 5.1平台Oracle下遭遇TNS-12531错误

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:35

环境 AIX 5.1+ORACLE 9.2.0.7

今天中午给客户的数据库做维护,发现processes进程参数值是默认值,就建议用户修改,
中午休息时间,修改参数后,正常停监听和数据库,启动数据库正常,但启动监听时则一直hang在那里
TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.7.0 – Production
System parameter file is /u01/oracle/product/9.2/network/admin/listener.ora
Log messages written to /u01/oracle/product/9.2/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.168.1)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))

同时监听日志listener.log 报以下错误
TNS-12531: TNS:cannot allocate memory
6-JUl-2010 12:53:10 * 12531

不断的报
然后通过查metalink文档 文档ID 219206.1
fact: Generic Unixfact: Oracle Net Servicesfact: TNS Listenersymptom: Listener start failssymptom: Machines memory resources are finesymptom: TNS-1168: TNS:cannot allocate memorysymptom: TNS-12531 / ORA-12531: TNS:cannot allocate memorycause: Network configuration is not setup correctly and the Oracle TNS
Listener is unable to find the hostname of the machine.
fix:

1. Check the machine network settings and ensure the hostname in the listener.ora
file matches the hostname of the server.

2. Check the operating system account that owns the Oracle Software has permission
to read the local host file

3. Ensure the /etc/hosts file and DNS has the correct information for the hostname/ipaddress

/etc/hosts中的值是正确的
但在主机中输入hostname命令时,没有任何值出来,可以看出主机名被人修改为空了
重新设置主机名后,启动监听正常。
下面这篇是windows环境下同样的问题
http://space.itpub.net/7199859/viewspace-591585

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】