I'm trying to stop a database server in my mirror system. I connect with Interactive SQL to primary server and execute
ALTER DATABASE SET PARTNER FAILOVER
I've an error message:
Request start/stop database denied.
I've set the -gk option to ALL.
asked 19 Apr '12, 05:49
You must connect to the database on the server that is acting has primary and have DBA authority on that database in order to force the failover.
Note that the setting of -gk only controls who is allowed to connect to the utility_db on the server. Since you mentioned this I am going to assume that you connected to the utility_db and not the database that you are trying to force a failover.
For reference, here is the documentation section on how to initiate failover.
answered 19 Apr '12, 08:35
Thanks you for your quickly answer.
I've solved this issue. Problem was this:
OPTIONS="-c500m -cl500m -dt/dev/shm -gkALL -gp4096 -n$SERVERNAME -o$LOG -oe$ERRORLOG -susptnkx -ud -x$PROTOCOL"
OPTIONS="-c 500m -cl 500m -dt /dev/shm -gk ALL -gp 4096 -n $SERVERNAME -o $LOG -oe $ERRORLOG -su sptnkx -ud -x $PROTOCOL"
I have seen that nothing happens. I expected that the DB went into read-only mode.
The last sentence of the documentation says that this operation is controlled by the -gk option, that's what I have to specify.
answered 19 Apr '12, 10:02