DB Alert Log: “Shutdown Waiting for Active Calls to Complete”

DESCRIPTION:

When  attempting to shut down database, the database hangs and the

alert log contains the below messages.

“SHUTDOWN: Waiting for active calls to complete”

CAUSES:

Database is waiting for PMON to clean up associated Oracle processes and resources processes.

The processes and resources waiting for the following activity to complete:

1.  Any Non committed transactions must be rolled back
2.  Any temporary space (sort segments / lobs / session temporary tables) must be freed
3. The session itself and any associated memory consumed by the session.
4.  Internal locks / enqueues must be cleaned up

Check and kill any client connections to the database at OS level.

SOLUTION:

• Check any client connections to the database the following command

ps -ef | grep ora*

• Check the processes that include a ‘Local=No’ designation.

prddbXXX+ 25499  1  0 Aug17 ?  00:00:07 oracleXXX (LOCAL=NO)

• Kill the process with the ‘Local=No’ designation.

Kill -9 25499

CONCLUSION:

To Avoid this Error in E-Business Environments, make sure the concurrent manager properly stops before shutdown the database.