AIX 5.1平臺下遭遇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 Unix

fact: Oracle Net Services

fact: TNS Listener

symptom: Listener start fails

symptom: Machines memory resources are fine

symptom: TNS-1168: TNS:cannot allocate memory

symptom: TNS-12531 / ORA-12531: TNS:cannot allocate memory

cause: 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