升級Oracle RAC後出現ORA-12520錯誤

現象：

Oracle10gR2.0.0.1升級後，現在用戶端串連時報ORA-12520錯誤

12520, 00000, "TNS:listener could not find available handler for requested type of server"
// *Cause: None of the known and available service handlers for requested type
// of server (dedicated or shared) are appropriate for the client connection.
// *Action: Run "lsnrctl services" to ensure that the instance(s) have
// registered with the listener and that the appropriate handlers are
// accepting connections.

解決：

在網上找了資料後修改了下面的參數後正常：

SQL> alter system set local_listener = '(ADDRESS=(PROTOCOL=TCP)(HOST=172.0.2.62)(PORT=1521))'
2 scope = spfile sid = 'rac11g1';
系統已更改。
SQL> alter system set local_listener = '(ADDRESS=(PROTOCOL=TCP)(HOST=172.0.2.63)(PORT=1521))'
2 scope = spfile sid = 'rac11g2';
系統已更改。
SQL> shutdown immediate資料庫已經關閉。已經卸載資料庫。
ORACLE 常式已經關閉。

SQL> startup
ORACLE 常式已經啟動。
Total System Global Area 1.7108E+10 bytes
Fixed Size 2101632 bytes
Variable Size 3814182528 bytes
Database Buffers 1.3288E+10 bytes
Redo Buffers 4431872 bytes資料庫裝載完畢。資料庫已經開啟。
另外的節點也重啟資料庫伺服器。
SQL> conn system/test@rac已串連。

問題解決。

另外：在打資料庫補丁後，在啟動資料庫時遇到了下面的錯誤：

SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_GE02'

解決方案如下：
1、關閉資料庫；
SQL> shutdown abort
ORACLE instance shut down.

2、然後在修改/opt/oracle/product/10.2.0/network/admin/tnsnames.ora檔案，添加下面的語句：
LISTENER_GE02 =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
3、然後重新啟動資料庫
SQL> startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 92276304 bytes
Database Buffers 188743680 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.