{"id":4138,"date":"2025-06-08T02:05:02","date_gmt":"2025-06-08T02:05:02","guid":{"rendered":"https:\/\/w3buddy.com\/?post_type=cposts&#038;p=4138"},"modified":"2025-06-09T15:35:10","modified_gmt":"2025-06-09T15:35:10","slug":"oracle-database-start-and-stop","status":"publish","type":"cposts","link":"https:\/\/w3buddy.com\/blog\/notes\/oracle-dba-d2d-tasks\/oracle-database-start-and-stop\/","title":{"rendered":"Oracle Database Start and Stop"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">This quick reference provides clean, consistent commands to <strong>start and stop an Oracle Database<\/strong> \u2014 for <strong>single instance<\/strong>, <strong>Oracle Restart<\/strong>, and <strong>RAC<\/strong> environments using both <strong>SQL*Plus<\/strong> and <strong>SRVCTL<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Stop Oracle Database<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code><code># -----------------------------------------------\n# Set environment variables if not already set\nexport ORACLE_HOME=\/path\/to\/oracle\/home\nexport ORACLE_SID=your_sid\n\n# -----------------------------------------------\n# Shutdown commands from SQL*Plus (connect as sysdba)\n\nsqlplus \/ as sysdba\n\n-- 1. Normal Shutdown: waits for all connected users to disconnect\nSHUTDOWN NORMAL;\n\n-- 2. Immediate Shutdown: rolls back uncommitted transactions, disconnects users immediately\nSHUTDOWN IMMEDIATE;\n\n-- 3. Transactional Shutdown: waits for active transactions to complete, then shuts down\nSHUTDOWN TRANSACTIONAL;\n\n-- 4. Abort Shutdown: forces immediate stop without cleanup (requires instance recovery)\nSHUTDOWN ABORT;\n\nEXIT;\n\n# -----------------------------------------------\n# Using SRVCTL (Oracle Restart or RAC environments)\n\n# Stop entire database (default shutdown mode: normal)\n# Syntax: srvctl stop database -d &lt;db_unique_name&gt;\nsrvctl stop database -d your_db_unique_name\n\n# Stop instance with shutdown mode\n# Syntax: srvctl stop instance -d &lt;db_unique_name&gt; -i &lt;instance_sid&gt; -o &lt;normal|immediate|transactional|abort&gt;\nsrvctl stop instance -d your_db_unique_name -i your_sid -o immediate<\/code><\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Start Oracle Database<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code><code># -----------------------------------------------\n# Set environment variables if not already set\nexport ORACLE_HOME=\/path\/to\/oracle\/home\nexport ORACLE_SID=your_sid\n\n# -----------------------------------------------\n# Startup commands from SQL*Plus (connect as sysdba)\n\nsqlplus \/ as sysdba\n\n-- 1. Start and open the database\nSTARTUP;\n\n-- 2. Start in mount mode (used for recovery, backup, etc.)\nSTARTUP MOUNT;\n\n-- 3. Start in nomount mode (used to create control files or restore spfile)\nSTARTUP NOMOUNT;\n\nEXIT;\n\n# -----------------------------------------------\n# Using SRVCTL (Oracle Restart or RAC environments)\n\n# Start entire database (default mode: open)\n# Syntax: srvctl start database -d &lt;db_unique_name>\nsrvctl start database -d your_db_unique_name\n\n# Start specific instance with open mode\n# Syntax: srvctl start instance -d &lt;db_unique_name> -i &lt;instance_sid> -o &lt;open|mount|nomount>\nsrvctl start instance -d your_db_unique_name -i your_sid -o open\n<\/code><\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udccc Notes<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>your_sid<\/code> \u2192 Refers to <strong><code>ORACLE_SID<\/code><\/strong> (used to identify a specific instance locally).<\/li>\n\n\n\n<li><code>your_db_unique_name<\/code> \u2192 Refers to <strong><code>DB_UNIQUE_NAME<\/code><\/strong> (globally unique identifier across the cluster, visible via <code>srvctl config database<\/code> or <code>spfile<\/code>).<\/li>\n\n\n\n<li>Use <code>srvctl start\/stop instance<\/code> <strong>only<\/strong> in <strong>RAC<\/strong> or <strong>Oracle Restart<\/strong> environments.<\/li>\n\n\n\n<li><code>srvctl start database<\/code> auto-starts <strong>all configured instances<\/strong> in a cluster if Oracle Clusterware is managing them.<\/li>\n\n\n\n<li>For <strong>non-RAC standalone databases<\/strong>, SQL*Plus commands are sufficient and preferred for start\/stop operations.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>This quick reference provides clean, consistent commands to start and stop an Oracle Database \u2014 for single instance, Oracle Restart, and RAC environments using both SQL*Plus and SRVCTL. Stop Oracle Database Start Oracle Database \ud83d\udccc Notes<\/p>\n","protected":false},"template":"","meta":{"googlesitekit_rrm_CAowu461DA:productID":""},"categories":[952,984],"class_list":["post-4138","cposts","type-cposts","status-publish","hentry","category-notes","category-oracle-dba-d2d-tasks"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts\/4138","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/cposts"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=4138"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=4138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}