Get the App
SLTechnology News&Howtos  ›  Database  › 

SHUTDOWN: waiting for active calls to complete

Shulou Source: shulou.com Published: 2022-06-01 07:22:42 09月30日 Update

Shut down the database, alert log:

Active call for process 36176016 user 'oracle' program' oracle@aix'

Active call for process 23789646 user 'zed' program' oracle@aix (TNS V1-V3)'

Active call for process 38011128 user 'oracle' program' oracle@aix'

Active call for process 18481304 user 'zed' program' oracle@aix (TNS V1-V3)'

Active call for process 23855274 user 'oracle' program' oracle@aix'

Active call for process 12976232 user 'zed' program' oracle@aix (TNS V1-V3)'

Active call for process 54722614 user 'oracle' program' oracle@aix'

Active call for process 46924016 user 'oracle' program' oracle@aix'

Active call for process 50135144 user 'zed' program' oracle@aix (TNS V1-V3)'

Active call for process 49020980 user 'zed' program' oracle@aix (TNS V1-V3)'

Active call for process 58196174 user 'oracle' program' oracle@aix'

Active call for process 16580722 user 'oracle' program' oracle@aix'

SHUTDOWN: waiting for active calls to complete.

Explanation:=The database is waiting for pmon toclean up processes, but pmon is unable toclean them. The client connections to the server are causing the shutdownimmediate or normal to hang. Killing them allows pmon to clean up and releasethe associated Oracle processes and resources.

Kill killed the above process

Tags: Data databases logs processes Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno macOS Xiaomi Microsoft OPPO Reno MySQL