Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Set MaxConnections in DataGuard

ChristianMay 27 2011 — edited May 27 2011
I try to update the database parameter max_connections (see view v$archive_dest)

I am able to set the parameter in data guard:
EDIT DATABASE 'database' SET PROPERTY 'MaxConnections'=2;

But my database does not take over this parameter.

I stop dataguard, stopped the db and tried different scenarios. But at startup the log_archive_dest is still set with the old parameter max_connections=1;

Whats the correct way of modyfing this values ?

I can“t update it by: alter system set - because the strings contains more than 255 characters.

Also I tried to create a pfile from spfile - modified the log_archive_dest_x - -started the db using this pfile and created a new spfile.
Shutdown - startup --> old value;

So, how to change this parameter ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 24 2011
Added on May 27 2011
4 comments
917 views