Start and stop the database using SRVCTL utility

Stop and start db using SRVCTL

Start the DB with SRVCTL commands

-- SYNTAX FOR START DB
srvctl start database -d db_name [-o start_options] 
where start_option is nomount/mount/open(default)
e.g
srvctl start database -d PRODB -o nomount
srvctl start database -d PRODB -o mount
srvctl start database -d PRODB -o open

Stop the DB with SRVCTL Commands

-- SYNTAX FOR STOP DB
srvctl stop database -d db_name [-o stop_options] 
where stop_options is normal/immediate(default)/transactional/abort
e.g
srvctl stop database -d PRODB -o normal
srvctl stop database -d PRODB -o immediate
srvctl stop database -d PRODB -o transactional
srvctl stop database -d PRODB -o abort

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply