Skip to main content

Oracle Shutdown immediate waiting on active process.

Hi,

Usually whenever we try to shutdown an oracle database with immediate option it will wait for some active process to get terminate. This may take long time and it also depends on the number of processes.

use below command to find out the active sessions on database:



bash-3.00$ ps -ef | grep LOCAL=NO
ora11g 17862     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17882     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17854     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17890     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17906     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17848     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17978     1   0   Jun 13 ?           0:03 oracletest (LOCAL=NO)
ora11g 17908     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17918     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17910     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17852     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 18235     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g   252     1  13   Jun 14 ?          51:48 oracletest (LOCAL=NO)
ora11g 15268 15152   0 11:34:20 pts/2       0:00 grep LOCAL=NO
ora11g 17922     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17982     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17970     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17866     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17930     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17914     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17874     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17932     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17986     1   0   Jun 13 ?           0:03 oracletest (LOCAL=NO)
ora11g 17952     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17936     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17836     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17944     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17974     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17948     1   0   Jun 13 ?           0:05 oracletest (LOCAL=NO)
ora11g 17898     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17878     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17876     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17900     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17924     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17902     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17892     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17894     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17956     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17966     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17940     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17834     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17960     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17934     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17884     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17916     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17860     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17868     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)
ora11g 17856     1   0   Jun 13 ?           0:00 oracletest (LOCAL=NO)



we need to kill the process only with option LOCAL=NO. The below is the handy UNIX command which can be used for killing these idle active session on database which are avoiding the database to shutdown with immediate option.




ps -ef|grep 'oracletest (LOCAL=NO)'|grep -v grep|awk '{print$2}'|xargs -i kill -9 {}



Now verify the processes again with ps -ef | grep LOCAL=NO it should not return any list.

If these processes killed then the database will shutdown.

Happy reading :)

Comments

Post a Comment

Popular posts from this blog

Disable Firewall on Oracle Linux 8

In this blogpost we will see how we can stop/disable the firewall on Oracle Linux 8, the firewall command is same in both linux 7 an linux 8. The below listed is the procedure for stopping and disabling the  firewall on Oracle Linux 8. - Here we can see the firewall deamon in active state - Here when we stop the firewall in previous command, now the firewall daemon is dead - For permanent disabling the firewall on server, we can use "disable" option The following commands will be helpful: #systemctl status firewalld #systemctl stop firewalld #systemctl disable firewalld #systemctl enable firewalld #systemctl start firewalld Hope it helps !! Thanks for reading :) regards, X A H E E R
2 comments
Read more

Enable Desktop on Oracle Solaris 11.4

Oracle Solaris 11 installation has multiple options to choose for installation of an Operating Environment, but mostly Oracle Solaris text install media is used and this installation media doesn't offer the GUI Desktop Environment by default after the installation. This blog post will explain how we can enable the desktop for Oracle Solaris 11.4 operating system, after the completion of installation. We have to install "solaris-desktop" package and reboot the machine and GUI desktop will be enabled for the Operating System. In this blog post my virtual machine is connected to the internet and hence I am able to use available pupblic repository for package installation, if in case internet is not available for the server/machine then we have configure the local/Server  repository for the installation. Follow the below steps for desktop package installation: After installation of dekstop package we are now able to login with GUI desktop environment
1 comment
Read more

Oracle Applications R12.2 Installation on Linux using virtual box

Oracle E-Business suite R12.2 is released a month ago. I received too many requests from my followers to demonstrate this Installation. This is a step by step detailed article for Installing Oracle E-business suite R12,2 on Oracle Enterprise Linux 5.7 (64-bit). I've used oracle virtual box for Installing Linux. Note:  This Installation is demonstrated on virtual machine with 8GB RAM and Installation completed in 7 hours. I am not sure whether this Installation will work with less than this .  My Virtual Machine configuration: CPU    = 1 core RAM   = 8 GB HDD   =  380 GB Software's Required: 1) Oracle Virtual Box 2) Oracle Enterprise Linux 5.7 (64-bit) 3) Oracle E-Business suite R12.2 for LinuxX86-64-bit Installation Steps: Hardware requirements Create virtual machine and Install operating system Operating System pre-requisites Prepare Stage Area Install Oracle EBS R12.2 software Verify Installation 1. Hardware Requirement
12 comments
Read more