- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: SHUTDOWN: waiting for active calls to complete
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-02-2002 05:10 AM
тАО08-02-2002 05:10 AM
SHUTDOWN: waiting for active calls to complete
SHUTDOWN: waiting for active calls to complete
I was wondering what it is actually waiting for?
Please help with the above interpretation.
Thanks in advance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-02-2002 05:17 AM
тАО08-02-2002 05:17 AM
Re: SHUTDOWN: waiting for active calls to complete
mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-02-2002 05:21 AM
тАО08-02-2002 05:21 AM
Re: SHUTDOWN: waiting for active calls to complete
Memory: 64108K (32216K) real, 128476K (96324K) virtual, 261388K free Page# 1/8
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-02-2002 05:22 AM
тАО08-02-2002 05:22 AM
Re: SHUTDOWN: waiting for active calls to complete
I guess that the DB is waiting for active remote SQL's to drop tcp/ip connections.
While you are shutting down the DB, on another window try this command below:
# ps -ef | grep oracle | grep -i local
If you see some displayed, it means that there are still active connections to the DB.
Hai
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-02-2002 06:16 AM
тАО08-02-2002 06:16 AM
Re: SHUTDOWN: waiting for active calls to complete
If you have a GUI took such as OEM (DBA studio), you can easily look at the current sessions and see their status (and most likely also who it belongs to and what sql command is actually being executed).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-02-2002 06:21 AM
тАО08-02-2002 06:21 AM
Re: SHUTDOWN: waiting for active calls to complete
Hello,
This can hapen when others users are conected to your system, in this case to the database.
Please check if others users were login when you try to shutdown.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-02-2002 06:40 AM
тАО08-02-2002 06:40 AM
Re: SHUTDOWN: waiting for active calls to complete
You may have to kill these remaining client processes.
If you face a long transaction, this has to rollback (so how long took that transaction so far ?).
Shutdown abort will stop surely shut down the DB but you will have to re-start + shutdown the database to be in a clean situation.
Again if you have a long transaction , this will take a long time to rollback.
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-02-2002 10:19 PM
тАО08-02-2002 10:19 PM
Re: SHUTDOWN: waiting for active calls to complete
rollback long running transactions on the database.
Also the SMON process has to clean up the extents.
when the shutdown is given the extents are removed from the used extents tables and put on the free extents table
you can query the fet$ and uet$ to check whether fet$ is increasing and uet$ is decreasing.
select count(block#) from fet$
select count(block#) from uet$
If the value of uet$ is decreasing then it is the SMON cleaning up the extents.
If this is the case avoid creation of more temporary extents by increasing the value of
initial and next values of the extent size on the temporary tablespaces.
Also query your v$session to check the processes run by the user.
Might be any batch job is crarried on.
Is this happening regularly or on rare occasions?
Thanks