Oracle 10g 10.2.0.1 RAC ORA-12520
这个错误非常常见,之前在单机上遇到过一次,处理办法是设置local_listener,这次照样先类似的处理下看看如何。
[oracle@R1 ~]$ sqlplus system/test@RAC
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 3 11:24:31 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12520: TNS:listener could not find available handler for requested type of
server
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[oracle@R1 ~]$ tail /opt/app/product/10.2.0/db_1/network/log/listener_r1.log
03-FEB-2012 11:20:41 * service_update * RAC1 * 0
03-FEB-2012 11:20:46 * service_update * RAC2 * 0
03-FEB-2012 11:21:41 * service_update * RAC1 * 0
03-FEB-2012 11:21:46 * service_update * RAC2 * 0
03-FEB-2012 11:22:44 * service_update * RAC1 * 0
03-FEB-2012 11:22:49 * service_update * RAC2 * 0
03-FEB-2012 11:23:47 * service_update * RAC1 * 0
03-FEB-2012 11:23:52 * service_update * RAC2 * 0
03-FEB-2012 11:24:31 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=RAC)(CID=(PROGRAM=sqlplus@R1)(HOST=R1)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.101.162)(PORT=36591)) * establish * RAC * 12520
TNS-12520: TNS:listener could not find available handler for requested type of server
[oracle@R1 log]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 3 11:54:54 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
sys@RAC> alter system set local_listener ='(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.101.162)(PORT = 1521))' scope=both sid='RAC1';
System altered.
sys@RAC> show parameter listen;
NAME TYPE VALUE
------------------------------------ -------- ------------------------------
local_listener string (ADDRESS = (PROTOCOL = TCP)(HO
ST = 192.168.101.162)(PORT = 1
521))
remote_listener string LISTENERS_RAC
[oracle@R2 bdump]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 3 11:55:12 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
sys@RAC> alter system set local_listener ='(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.101.164)(PORT = 1521))' scope=both sid='RAC2';
System altered.
sys@RAC> shwo parameter liste;
SP2-0734: unknown command beginning "shwo param..." - rest of line ignored.
sys@RAC> show parameter lis;
NAME TYPE VALUE
------------------------------------ -------- ------------------------------
local_listener string (ADDRESS = (PROTOCOL = TCP)(HO
ST = 192.168.101.164)(PORT = 1
521))
recovery_parallelism integer 0
remote_listener string LISTENERS_RAC
sys@RAC>
注意,填写的是VIP的IP地址。
如上设置后问题解决,真要命,这个真不知道什么时候该填什么时候不用填,单机和rac,我都看到有的填有的没填。
-The End-