Status message unchanged after canceling a reorg job while on waiting for approval step (4257634)

Canceling a LiveReorg job which is already on waiting approval status, does not update the status message in the Job Monitor even after clicking refresh. Also, restarting the QSA changes the status message to the following error:

The following Oracle option needs to be added to the sqlnet.ora file:

BEQUEATH_DETACH=YES

The sqlnet.ora file should exist in the $ORACLE_HOME/netwok/admin directory for the Oracle instance that QSA is installed onto.

If the TNS_ADMIN environment variable is being used. The sqlnet.ora file that needs to be changed will be in the directory pointed to by the TNS_ADMIN environment variable.

Once the sqlnet.ora file is changed, stop and start QSA.

Stopping and starting QSA takes a couple of seconds when a system is not busy.

setting BEQUEATH_DETACH=YES in the sqlnet.ora file, is required for the QSA scheduler to work correctly.

QSAStop.sh will do the following:

1) execute a Unix kill SIGTERM command on the qexecd process.
2) sleep 1 second
3) execute a Unix kill SIGKILL command on the qexecd process.
4) read QSA configuration file qexecd.conf
5) connect to the Oracle database
6) remove the Oracle dbms_pipe named 'QUEST_EXEC'
7) disconnect from Oracle
8) terminate

QSAStop.sh is the fastest way to stop QSA. It should complete in a minute or less. What could take a long time is removing the pipe. If your system uses dbms_pipes, then this can be a problem. If your system does not use dbms_pipes, then your system is very very busy doing something.

Stopping, or restarting QSA from Space Manager is different and can take a long time to stop and start.