在增加节点完后，用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_<SID>=
(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_<SID> scope=both sid='<ORACLE_SID>';
SQL> alter system register;

ITPub博客

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

最新文章