Knowledgebase

Oracle - starting and shutting down


to shut down or start up database, log in as oracle user and execute
$ORACLE_HOME/bin/sqlplus /nolog
(in verion 8.0: $ORACLE_HOME/bin/svrmgrl)
then type: connect internal
If you are logged in as oracle it should not ask you for password.

Shutting down:
shutdown option
options:
NORMAL - waits until everybody disconnects from database
IMMEDIATE - stops any connections (after they finished with current query) rollnacks any uncomitted changes
TRANSACTIONAL - waits unitl any transactions are finished (commit or rollback) and breaks connection
ABORT - imidiatly stops responding to any queries and shuts down, after that db requires recovery
(done automaticly during start up)

if the database server is used by web server with connection pooling you
do not want to use normal as option. Instead use transactional. (and shut down the web server if you can, before shutting down database)

Starting up:
startup datbase_name

More information:
http://oradoc.photo.net/ora8doc/DOC/server803/A54641_01/ch3.htm#279