We help IT Professionals succeed at work.

Shutdown Oracle Processes

sikyala
sikyala asked
on
Medium Priority
2,651 Views
Last Modified: 2013-12-27
I need to shutdown all of the Oracle processes before upgrading from oracle 9.2.0.1 to 9.2.0.6. 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!
Comment
Watch Question

Commented:
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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
sikyalaSenior Database Administrator

Author

Commented:
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

Thanks!
sikyalaSenior Database Administrator

Author

Commented:
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:

DefaultCluster_ClientHandler

How do I shutdown this process?

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

Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.