Set MaxConnections in DataGuard
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 ?