SHUTDOWN: waiting for active calls to complete.


When I shutdown databse, I can see waiting for arctice calls to compleed in alert log.
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Stopping background process QMNC
Tue Apr 14 15:52:00 2015
Stopping background process CJQ0
Stopping background process MMNL
Stopping background process MMON
License high water mark = 181
Tue Apr 14 15:57:02 2015
Active call for process 7658 user 'oracle' program 'oracle@bakudbtstora1'
SHUTDOWN: waiting for active calls to complete.
Solution:
View OS top, find a process ID 7658 Oracle job is running. 
kill -9 15693 
db or not stop. View oracle log, or before and kill job.

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1.2831E+10 bytes
Fixed Size 2171296 bytes
Variable Size 4529856096 bytes
Database Buffers 8254390272 bytes
Redo Buffers 44785664 bytes
Database mounted.
Database opened.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: