Mani's Blog

October 24, 2012

ORA-32021: parameter value longer than 255 characters

Filed under: Oracle — mani @ 7:29 pm

I was trying to set service_names, which was really long due to more number of services we needed.   Used ‘,’ as concatenation between multiple values, then worked.

SQL> @enable_services
ALTER SYSTEM SET SERVICE_NAMES=’xno_db_proc.xno.ningops.net, xno_db_membership.xno.ningops.net, xno_db_core_search.xno.ningops.net, xno_db_core_cache.xno.ningops.net,    xno_db_opensocial.xno.ningops.net, xno_db_core_batch.xno.ningops.net, xno_db_core_audit.xno.ningops.net, xno_db_core.xno.ningops.net, xno_db_admin.xno.ningops.net,  xno_core.xno.ningops.net, XNODBCOR’
*
ERROR at line 1:
ORA-32021: parameter value longer than 255 characters

Fix:  Used ‘,’ as concatenation between multiple values, then worked.

[oracle@xnodb911 ~]$ cat enable_services.sql
ALTER SYSTEM SET SERVICE_NAMES=’xno_db_proc.xno.ningops.net, xno_db_membership.xno.ningops.net, xno_db_core_search.xno.ningops.net, xno_db_core_cache.xno.ningops.net,‘,’ xno_db_opensocial.xno.ningops.net, xno_db_core_batch.xno.ningops.net, xno_db_core_audit.xno.ningops.net, xno_db_core.xno.ningops.net, xno_db_admin.xno.ningops.net,‘,’xno_core.xno.ningops.net, XNODBCOR’;

SQL> @enable_services.sql

System altered.

SQL> show parameter service_names

NAME                     TYPE
———————————— ——————————–
VALUE
——————————
service_names                 string
xno_db_proc.xno.ningops.net, x
no_db_membership.xno.ningops.n
et, xno_db_core_search.xno.nin
gops.net, xno_db_core_cache.xn
o.ningops.net,,  xno_db_openso
cial.xno.ningops.net, xno_db_c
ore_batch.xno.ningops.net, xno
_db_core_audit.xno.ningops.net

NAME                     TYPE
———————————— ——————————–
VALUE
——————————
, xno_db_core.xno.ningops.net,
xno_db_admin.xno.ningops.net,
, xno_core.xno.ningops.net, XN
ODBCOR
SQL>

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: