jueves, 14 de enero de 2016

Cómo resolver ORA-32021: parameter value longer than 255 characters ?


Si tienes problemas a la hora de configurar o cambiar el valor de un parámetro en un base de datos utilizando SPFILE, cuando el valor requerido supera los 255 caracteres; aquí tienes la solución.

Separa la hilera que debe ser ingresada, en porciones menores a los 255 caracteres concatenando los valores con ','

Una vez hecho esto, no tendrás problemas a la hora de setear el valor.

Mira el ejemplo de a continuación.

/opt/oracle/product/11.2.0.4/rdbms/admin
[oracle@lab1 admin]$ /opt/oracle/product/11.2.0.4/rdbms/admin
-bash: /opt/oracle/product/11.2.0.4/rdbms/admin: is a directory
[oracle@lab1 admin]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 14 11:56:27 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> connect / as sysdba
Connected.
SQL> show parameter utl_file_dir

NAME                                 TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
utl_file_dir                         string

SQL> alter system set utl_file_dir='/opt/oracle/product/11.2.0.4/rdbms/admin,/opt/oracle/product/11.2.0.4/rdbms/admin,/opt/oracle/product/11.2.0.4/rdbms/admin,/opt/oracle/product/11.2.0.4/rdbms/admin,/opt/oracle/product/11.2.0.4/rdbms/admin,/opt/oracle/product/11.2.0.4/rdbms/admin,/opt/oracle/product/11.2.0.4/rdbms/admin' scope=spfile;
alter system set utl_file_dir='/opt/oracle/product/11.2.0.4/rdbms/admin,/opt/oracle/product/11.2.0.4/rdbms/admin,/opt/oracle/product/11.2.0.4/rdbms/admin,/opt/oracle/product/11.2.0.4/rdbms/admin,/opt/oracle/product/11.2.0.4/rdbms/admin,/opt/oracle/product/11.2.0.4/rdbms/admin,/opt/oracle/product/11.2.0.4/rdbms/admin' scope=spfile
*
ERROR at line 1:
ORA-32021: parameter value longer than 255 characters


SQL> alter system set utl_file_dir='/opt/oracle/product/11.2.0.4/rdbms/admin,/opt/oracle/product/11.2.0.4/rdbms/admin,','/opt/oracle/product/11.2.0.4/rdbms/admin,/opt/oracle/product/11.2.0.4/rdbms/admin,/opt/oracle/product/11.2.0.4/rdbms/admin,','/opt/oracle/product/11.2.0.4/rdbms/admin,/opt/oracle/product/11.2.0.4/rdbms/admin' scope=spfile;

System altered.

SQL> show parameter utl_file_dir

NAME                                 TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
utl_file_dir                         string

SQL> startup force
ORACLE instance started.

Total System Global Area  680607744 bytes
Fixed Size                  2256352 bytes
Variable Size             247464480 bytes
Database Buffers          427819008 bytes
Redo Buffers                3067904 bytes
Database mounted.
Database opened.
SQL> show parameter utl_file_dir

NAME                                 TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
utl_file_dir                         string
/opt/oracle/product/11.2.0.4/r
dbms/admin,/opt/oracle/product
/11.2.0.4/rdbms/admin,, /opt/o
racle/product/11.2.0.4/rdbms/a
dmin,/opt/oracle/product/11.2.
0.4/rdbms/admin,/opt/oracle/pr
oduct/11.2.0.4/rdbms/admin,, /
opt/oracle/product/11.2.0.4/rd

NAME                                 TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
bms/admin,/opt/oracle/product/
11.2.0.4/rdbms/admin
SQL>

No hay comentarios:

Publicar un comentario en la entrada

Te agradezco tus comentarios. Te esperamos de vuelta.