Home » RDBMS Server » Server Administration » ORA-32021: parameter value longer than 255 characters
ORA-32021: parameter value longer than 255 characters [message #185380] Tue, 01 August 2006 08:15 Go to next message
aidi-h
Messages: 44
Registered: November 2005
Member
ORA-32021: parameter value longer than 255 characters error

I am trying to amend the log_archive_dest_2 setting but get the following message. how do I update the value into this parameter please?


alter system set LOG_ARCHIVE_DEST_2='service="(DESCRIPTION=(ADDRESS_LIST=(ADDRES
S=(PROTOCOL=tcp)(HOST=apmentorme031)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=MEN
TOR02_XPT)(INSTANCE_NAME=MENTOR01)(SERVER=dedicated)))", LGWR SYNC AFFIRM delay=
480 OPTIONAL max_failure=0 max_connections=1 reopen=300 db_unique_name="MENTOR02
" register net_timeout=180 valid_for=(online_logfile,primary_role)'
*
ERROR at line 1:
ORA-32021: parameter value longer than 255 characters

Re: ORA-32021: parameter value longer than 255 characters [message #185407 is a reply to message #185380] Tue, 01 August 2006 10:24 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>how do I update the value into this parameter please?
By keeping the length <= 255
Re: ORA-32021: parameter value longer than 255 characters [message #185549 is a reply to message #185380] Wed, 02 August 2006 05:19 Go to previous messageGo to next message
aidi-h
Messages: 44
Registered: November 2005
Member
Thanks for that.
I have also found that you can make the same amendment by 'splitting' the line in two with ','.

alter system set log_archive_dest_2 = 'service="... service definition ..."',' LGWR ...rest of string'

It effectivly splits the string into two.
Re: ORA-32021: parameter value longer than 255 characters [message #424406 is a reply to message #185380] Fri, 02 October 2009 03:43 Go to previous message
jobinau
Messages: 1
Registered: October 2009
Location: Hyderabad
Junior Member
Thank you very much.
it is working perfect.
Previous Topic: create oracle instance and database without svrmgrl
Next Topic: coredump by oracle
Goto Forum:
  


Current Time: Sat Dec 10 08:41:37 CST 2016

Total time taken to generate the page: 0.15117 seconds