oracle shutdown

unix

manually

$ORACLE_HOME/bin/dbshut

[oracle@www oracle]$ /home/u01/bin/dbshut

SQL*Plus: Release 9.2.0.1.0 - Production on Fri Feb 21 13:05:03 2003

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.1.0 - Production
With the Partitioning and OLAP options
JServer Release 9.2.0.1.0 - Production
Database "db2" shut down.

from inside sqlplus

for general sqlplus see sqlplus.htm.

SQL> connect sys/sys as sysdba
Connected.
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup

these could be placed in shutdwon scripts
SHUTDOWN NORMAL
waits for all users to disconnect first
PMON shuts down user processes
SHUTDOWN IMMEDIATE
PMON shuts down user processes
SHUTDOWN ABORT
will require a recover upon restart

terminating user processes
kill -9 PID
alter system kill session




	
Leave a Reply
	

	 
	Your Name:     anonymous 

	Your Email: 

    Website:   

	
  Comments:  
 
	
 
	
    The author will be notified of your reply.

	
	
	
	
	
return to top
 
24078 [ 483 MB ] of Articles and Code Samples    
5897 pages in the directory #!/bin/sh sys=0; rec=0; for i in `ls *.pagecount`; do sys=$(cat $i);  rec=$(( $rec + $sys)); done; echo $rec; 
849 Users
Online Since Mar 3 2002

design help and support from mynd4rent design
Don't Worry!  The Material on Sirfsup.com is Your Copyright as the Author