AIX 5.1平台Oracle下遭遇TNS-12531错误
环境 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