OraFAQ Forum: Server Administration » ORA-32021: parameter value longer than 255 characters

Home » RDBMS Server » Server Administration » ORA-32021: parameter value longer than 255 characters

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-32021: parameter value longer than 255 characters [message #185380]

Tue, 01 August 2006 08:15

aidi-h
Messages: 45
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

Report message to a moderator

Re: ORA-32021: parameter value longer than 255 characters [message #185407 is a reply to message #185380]

Tue, 01 August 2006 10:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>how do I update the value into this parameter please?
By keeping the length <= 255

Report message to a moderator

Re: ORA-32021: parameter value longer than 255 characters [message #185549 is a reply to message #185380]

Wed, 02 August 2006 05:19

aidi-h
Messages: 45
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.

Report message to a moderator

Re: ORA-32021: parameter value longer than 255 characters [message #424406 is a reply to message #185380]

Fri, 02 October 2009 03:43

jobinau
Messages: 1
Registered: October 2009
Location: Hyderabad

Junior Member

Thank you very much.
it is working perfect.

Report message to a moderator

Previous Topic:	create oracle instance and database without svrmgrl
Next Topic:	coredump by oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 12:37:56 CDT 2024