Oracle 10g 10.2.0.1 RAC ORA-12520

Oracle 10g 10.2.0.1 RAC ORA-12520
This error is very common. I have encountered it once on a single machine. The solution is to set local_listener. This time, I will try to see how it works.
 
[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,200 5, Oracle. All rights reserved.
 
ERROR:
ORA-12520: TNS: listener cocould not find available handler for requested type
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 cocould 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,200 5, Oracle. All rights reserved.
 
 
Connected:
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,200 5, Oracle. All rights reserved.
 
 
Connected:
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>
Note that the IP address of the VIP is entered.
After the above settings, the problem is solved. I don't know when to fill it out. I can see that some of them are not filled in for standalone and rac.
-The End-
 
By Gtlions