Re: How to stop oracle service in AIX

From: Hans Forbrich <news.hans_at_telus.net>
Date: Tue, 28 Sep 2004 00:33:51 GMT
Message-ID: <Pj26d.166251$XP3.54427@edtnps84>

Roy wrote:

> How to stop oracle service in AIX

(Assuming you refer to the Oracle database service, and not other services such as 'listener', 'application server', oc4j', 'oracle http server powered by apache', etc.) ...

One of several ways is:

on the AIX box, logged in as the Oracle owner (usually oracle)

---

export ORACLE_SID=sid # assuming it's not set

sqlplus "/ as sysdba"
  shutdown
  exit

---

shutdown may be modified using 'normal', 'immediate', 'abort', and (depending on version) 'transactional' parameter to accmplish different shutdown styles based on different "in progress transaction handling" requirements.

More info available in the Oracle Database Administrator's Guide found at http://docs.oracle.com Received on Mon Sep 27 2004 - 19:33:51 CDT