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

paulyibinyi發表於2016-10-08
在增加節點完後，用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部落格 ” ，連結：http://blog.itpub.net/7199859/viewspace-2125926/，如需轉載，請註明出處，否則將追究法律責任。

相關文章