ORA-32021: parameter value longer than 255 characters 解決方法
在增加節點完後,用dbca 新增資料庫例項時 報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;
- 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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Special Characters in Initialization Parameter Files
- 異常解決——The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than oneServerZed
- java.sql.SQLException: Prepared or callable statement has more than 2000 parameter markers及解決方案JavaSQLException
- 使用DBMS_UTILITY.get_parameter_value檢視session的parameterSession
- 緩解 SQL Server has encountered 727 occurrence(s) of I/O requests taking longer than 15 secondsSQLServer
- ORA-00600: [kcratr_nab_less_than_odr]報錯解決方法
- ORA-8103 "object no longer exists" 診斷與解決Object
- The value (30) of MAXTRANS parameter ignored. 問題分析
- Actions Speak Louder than Words: Trillion-Parameter Sequential Transducers for Generative Recommendations
- java.sql.SQLException: No value specified for parameter 1 異常分析JavaSQLException
- Variable 'character_set_client' can't be set to the value of Null的解決方法clientNull
- JDBC:The server time zone value '�й���ʱ��' is unrecognized or represents more than one time zone.JDBCServerZed
- 452 Error writing file: A file cannot be larger than the value set by ulimit.ErrorMIT
- ORA-31600: invalid input value INDEX PARTITION for parameterIndex
- PHP中的Malformed UTF-8 characters錯誤解決PHPORM
- Caused by: org.apache.ibatis.binding.BindingException: Parameter 'parameter' not found.解決ApacheBATException
- Warning: count(): Parameter must be an array or an object that implements Countable in line 302解決方法Object
- java.sql.SQLException: Parameter index out of range (3 > number of parameters, which is 2)的解決方法JavaSQLExceptionIndex
- MySQL 5.7 Invalid default value for 'CREATE_TIME'報錯的解決方法MySql
- ORA-29707: inconsistent value 2 for initialization parameter cluster_database_Database
- mysql執行報The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one tim......MySqlServerZed
- pyhton3解決”tuple parameter unpacking is not supported”問題
- 使用spring 的註解 @value使用方法Spring
- @AllArgsConstructor與@Value共用的問題解決Struct
- 錯誤解決:Attempting to use uninitialized value VariableZed
- ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
- Oledb操作Excel時欄位最大值255的問題解決方案Excel
- redis 報Operation against a key holding the wrong kind of value警告的解決方法RedisAI
- 前端如何設定背景顏色的透明度 css中的 rgba() 函式詳解 :background-color: rgba(255,255,255,0)前端CSS函式
- 解決Parameter '__frch_item_0' not found. Available parameters 問題AI
- Oracle 11G安裝報錯"ORA-00401: the value for parameter compatible"Oracle
- pymysql KeyError:255MySqlError
- [20210113]SP2-0232 Input too long. Must be less than 241 characters.txt
- Mysql:Variable 'XXXt' can't be set to the value of 'NULL'解決MySqlNull
- 解決問題:Variable 'time_zone' can't be set to the value of 'NULL'Null
- mysql:Variable 'character_set_client' can't be set to the value of 'NULL'解決MySqlclientNull
- 出現The valid characters are defined in RFC 7230 and RFC 3986的原因及解決方式
- "Got a packet bigger than 'max_allowed_packet' bytes"錯誤解決辦法Go