freemode.net

Oracle startup/shutdown    [ Software ]

More notes on Oracle startup/shutdown from a sysadmin's perspective:

STARTUP

Make sure there's an ORACLE_SID and ORACLE_HOME present:
$ env | grep ORACLE

Start up database with 'svrmgrl':
$ svrmgrl
SVRMGR> connect internal
SVRMGR> startup

Start listener:
$ lsnrctl start

Test connection:
$ tnsping ${ORACLE_SID}

SHUTDOWN

Stop listener:
$ lsnrctl stop

Shut down database:
$ svrmgrl
SVRMGR> connect internal
SVRMGR> shutdown immediate

And that should do it.