Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Shutdown Oracle Processes

Posted on 2006-03-30
Medium Priority
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
  • 2
LVL 18

Accepted Solution

liddler earned 2000 total points
ID: 16332933
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

ID: 16344490
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

ID: 16344770
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.


Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My previous tech tip, Installing the Solaris OS From the Flash Archive On a Tape (http://www.experts-exchange.com/articles/OS/Unix/Solaris/Installing-the-Solaris-OS-From-the-Flash-Archive-on-a-Tape.html), discussed installing the Solaris Operating S…
Why Shell Scripting? Shell scripting is a powerful method of accessing UNIX systems and it is very flexible. Shell scripts are required when we want to execute a sequence of commands in Unix flavored operating systems. “Shell” is the command line i…
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…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

564 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