oracle11g 32021,ORA-32021: parameter value longer than 255 characters 解决方法

在增加节点完后，用dbca 添加数据库实例时  报ORA-32021: parameter value longer than 255 characters 错误

oraagent log

2011-10-24 09:18:32.724: [ USRTHRD][3389032768] {1:47226:28141} Value of

LOCAL_LISTENER is

2011-10-24 09:18:32.724: [ USRTHRD][3389032768] {1:47226:28141} sqlStmt =

ALTER SYSTEM SET

LOCAL_LISTENER='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.239.

17.22)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.239.17.22)(PORT=1531))(ADDRES

S=(PROTOCOL=TCP)(HOST=10.239.17.22)(PORT=1535))(ADDRESS=(PROTOCOL=TCP)(HOST=10.2

39.17.22)(PORT=1529))(ADDRESS=(PROTOCOL=TCP)(HOST=10.239.17.22)(PORT=1532))(ADD

RESS=(PROTOCOL=TCP)(HOST=10.239.17.22)(PORT=1542))(ADDRESS=(PROTOCOL=TCP)(HOST=

10.239.17.22)(PORT=1530))))' SCOPE=MEMORY SID='racdb1' /* db agent *//*

{1:47226:28141} */

2011-10-24 09:18:32.725: [ USRTHRD][3389032768] {1:47226:28141} ORA-32021:

parameter value longer than 255 characters

sqlplus output

SQL> ALTER SYSTEM SET

LOCAL_LISTENER='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.239.17.22)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.239.17.22)(PORT=1531))(ADDRESS=(PROTOCOL=TCP)(HOST=10.239.17.22)(PORT=1535))(ADDRESS=(PROTOCOL=TCP)(HOST=10.239.17.22)(PORT=1529))(ADDRESS=(PROTOCOL=TCP)(HOST=10.239.17.22)(PORT=1532))(ADDRESS=(PROTOCOL=TCP)(HOST=10.239.17.22)(PORT=1542))(ADDRESS=(PROTOCOL=TCP)(HOST=10.239.17.22)(PORT=1530))))'

SCOPE=MEMORY SID='racdb1';

*

ERROR at line 1:

ORA-32021: parameter value longer than 255 characters

解决方法:

Create a tnsnames.ora entry for LOCAL_LISTENER and register, i.e.

LISTENER_=

(DESCRIPTION=(ADDRESS_LIST=

(ADDRESS=(PROTOCOL=TCP)(HOST=10.239.17.22)(PORT=1521))

(ADDRESS=(PROTOCOL=TCP)(HOST=10.239.17.22)(PORT=1531))

(ADDRESS=(PROTOCOL=TCP)(HOST=10.239.17.22)(PORT=1535))

(ADDRESS=(PROTOCOL=TCP)(HOST=10.239.17.22)(PORT=1529))

(ADDRESS=(PROTOCOL=TCP)(HOST=10.239.17.22)(PORT=1532))

(ADDRESS=(PROTOCOL=TCP)(HOST=10.239.17.22)(PORT=1542))

(ADDRESS=(PROTOCOL=TCP)(HOST=10.239.17.22)(PORT=1530))

))

SQL> alter system set local_listener=LISTENER_ scope=both sid='';

SQL> alter system register;