Shutdown Oracle Processes

Posted on 2006-03-30
Last Modified: 2013-12-27
I need to shutdown all of the Oracle processes before upgrading from oracle to I stopped the listener and shutdown the database. I typed ps -ef | grep ora to see what processes were running. But I don't know how to stop them before starting the upgrade. Could someone provide instructions? Thanks!
Question by:sikyala
    LVL 18

    Accepted Solution

    depends on the process.  
    the full list of oracle processes would be
    ps -fu oracle
    Assuming you are logged in as oracle, you will have at least one shell process (sh, ksh, csh etc) and you may see the grep process.
    If you can print the list here, we may be able to help you decide which processes need stopping, however, stopping the listener and database should be enough.

    in Solaris 8 / 9 you can use
    pkill -U oracle
    to kill all of oracle's processes, but this may not be necessary

    Author Comment

    I didn't realize that the other processes that I saw was due to there being 2 databases. When I shut down the second database I only saw the two processes that you mentioned:

     oracle  1200  1189  0 12:25:48 pts/6    0:00 ps -ef
      oracle  1189  1186  0 12:21:14 pts/6    0:00 -ksh


    Author Comment

    I thought everything was fine but when I run the Universal installer to upgrade Oracle I get an error:

    The following processes needs to be shutdown before continuing:


    How do I shutdown this process?

    I issued the command pkill -U oracle
    However, it did not kill the above mentioned process.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Suggested Solutions

    A metadevice consists of one or more devices (slices). It can be expanded by adding slices. Then, it can be grown to fill a larger space while the file system is in use. However, not all UNIX file systems (UFS) can be expanded this way. The conca…
    I promised to write further about my project, and here I am.  First, I needed to setup the Primary Server.  You can read how in this article: Setup FreeBSD Server with full HDD encryption (…
    Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
    Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now