Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Fwd: How to shutdown 9i?

Re: Fwd: How to shutdown 9i?

From: Ray Stell <stellr_at_cns.vt.edu>
Date: Tue, 14 Jun 2005 08:10:52 -0400
Message-ID: <20050614121052.GA21795@locust.cns.vt.edu>

YMMV, but calling a shutdown script via sqlplus 'host' and 'su' command works on solaris:


$ sqlplus stellr_at_testdb.vt.edu

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jun 14 07:49:07 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter password:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production With the Partitioning option
JServer Release 9.2.0.4.0 - Production

SQL> host su - oracle -c /db03/app/oracle/product/scripts/stop.testdb.sh Password:

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jun 14 07:52:00 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> Connected.
SQL> Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production With the Partitioning option
JServer Release 9.2.0.4.0 - Production  

On Mon, Jun 13, 2005 at 07:21:46PM -0400, Chris Hoover wrote:
> ---------- Forwarded message ----------
> From: Chris Hoover <revoohc_at_gmail.com>
> Date: Jun 13, 2005 4:08 PM
> Subject: How to shutdown 9i?
> To: Oracle-L_at_freelists.org
>
>
> We are having a very strange problem. Our AIX server is having issues
> and is not allowing shell access from the terminal or from the
> network.
>
> The decision has been made to reboot this server tonight. However, it
> is our Oracle 9i db server. Is there anyway to get Oracle to shutdown
> w/o being able to log onto the box? We can connect to the db fine
> with our application and sql plus, we just can't get a shell on the
> box. We do not have an Enterprise manager server since we only run
> this on copy of Oracle.
>
> thanks for any advice.
>
> Chris
> --
> http://www.freelists.org/webpage/oracle-l

-- 
============================================================
Ray Stell  stellr_at_vt.edu  (540) 231-4109  Tempus fugit  28^D
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jun 14 2005 - 08:16:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US