{"id":9884,"date":"2019-02-26T11:43:14","date_gmt":"2019-02-26T11:43:14","guid":{"rendered":"https:\/\/dbtut.com\/?p=9884"},"modified":"2019-02-26T11:43:14","modified_gmt":"2019-02-26T11:43:14","slug":"oracle-database-startup-and-shutdown-modes","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/","title":{"rendered":"Oracle Database Startup and Shutdown Modes"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>In this article, I will explain the startup and shutdown modes of Oracle database.<\/p>\n<p id=\"EmpNrHr\"><img loading=\"lazy\" decoding=\"async\" width=\"213\" height=\"305\" class=\"size-full wp-image-9885  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c7519e43afdd.png\" alt=\"\" \/><\/p>\n<h3>Oracle Database Startup Modes<\/h3>\n<p>A closed Oracle database opens in 3 stages. The best summarizing image is as follows. We will review these steps one by one.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/10\/startup-modes.gif\" alt=\"Startup modes\" \/><\/p>\n<p id=\"iwEmSZw\"><strong>Nomount Mode:<\/strong> The instance and background processes start when we open the Oracle database in Nomount mode. Oracle reads the parameter files (spfile or pfile) in this step. In this mode, the database is closed to other users. Only instance and background processes are open.<\/p>\n<pre class=\"\">bash-4.1$ ps -ef | grep smon\r\noracle\u00a0\u00a0 20114 19577\u00a0 0 14:15 pts\/0\u00a0\u00a0\u00a0 00:00:00 grep smon\r\nbash-4.1$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.3.0 Production on Mon Oct 7 14:15:10 2013\r\n\r\nCopyright (c) 1982, 2011, Oracle.\u00a0 All rights reserved.\r\n\r\nConnected to an idle instance.\r\n\r\nSQL&gt; startup nomount\r\nORACLE instance started.\r\n\r\nTotal System Global Area\u00a0 534462464 bytes\r\nFixed Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2230072 bytes\r\nVariable Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 339740872 bytes\r\nDatabase Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 184549376 bytes\r\nRedo Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7942144 bytes\r\nSQL&gt; exit\r\nDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\nbash-4.1$ ps -ef | grep smon\r\noracle\u00a0\u00a0 20143\u00a0\u00a0\u00a0\u00a0 1\u00a0 0 14:15 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 ora_smon_TESTDB\r\noracle\u00a0\u00a0 20160 19577\u00a0 0 14:15 pts\/0\u00a0\u00a0\u00a0 00:00:00 grep smon\r\nbash-4.1$ ps -ef | grep ckpt\r\noracle\u00a0\u00a0 20141\u00a0\u00a0\u00a0\u00a0 1\u00a0 0 14:15 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 ora_ckpt_TESTDB\r\noracle\u00a0\u00a0 20162 19577\u00a0 0 14:15 pts\/0\u00a0\u00a0\u00a0 00:00:00 grep ckpt\r\nbash-4.1$ ps -ef | grep lgwr\r\noracle\u00a0\u00a0 20139\u00a0\u00a0\u00a0\u00a0 1\u00a0 0 14:15 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 ora_lgwr_TESTDB\r\noracle\u00a0\u00a0 20166 19577\u00a0 0 14:16 pts\/0\u00a0\u00a0\u00a0 00:00:00 grep lgwr<\/pre>\n<p><strong>Mount Mode:<\/strong> The Control file opens in this step. When the database opens and reads control file, it will know where the datafiles and archive files are. However, in this step, users still cannot access the database. Only system views and performance views are accessible.<\/p>\n<p>We can mount a database in Nomount mode as follows.<\/p>\n<pre class=\"\">bash-4.1$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.3.0 Production on Mon Oct 7 14:24:15 2013\r\n\r\nCopyright (c) 1982, 2011, Oracle.\u00a0 All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\n\r\nSQL&gt; select open_mode from v$database;\r\nselect open_mode from v$database\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 *\r\nERROR at line 1:\r\nORA-01507: database not mounted\r\n\r\nSQL&gt; alter database mount;\r\n\r\nDatabase altered.\r\nSQL&gt; select open_mode from v$database;\r\n\r\nOPEN_MODE\r\n--------------------\r\nMOUNTED<\/pre>\n<p>Or we can mount a closed database directly as follows.<\/p>\n<pre class=\"\">bash-4.1$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.3.0 Production on Mon Oct 7 15:06:58 2013\r\n\r\nCopyright (c) 1982, 2011, Oracle.\u00a0 All rights reserved.\r\n\r\nConnected to an idle instance.\r\n\r\nSQL&gt; startup mount\r\nORACLE instance started.\r\n\r\nTotal System Global Area\u00a0 534462464 bytes\r\nFixed Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2230072 bytes\r\nVariable Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 339740872 bytes\r\nDatabase Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 184549376 bytes\r\nRedo Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7942144 bytes\r\nDatabase mounted.\r\nSQL&gt;<\/pre>\n<p><strong>Open Mode:<\/strong> In this mode, the database opens normally and can be accessed by other users. We can start a closed database directly in Open mode as follows.<\/p>\n<pre class=\"\">bash-4.1$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.3.0 Production on Mon Oct 7 14:29:41 2013\r\n\r\nCopyright (c) 1982, 2011, Oracle.\u00a0 All rights reserved.\r\n\r\nConnected to an idle instance.\r\n\r\nSQL&gt; startup\r\nORACLE instance started.\r\n\r\nTotal System Global Area\u00a0 534462464 bytes\r\nFixed Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2230072 bytes\r\nVariable Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 339740872 bytes\r\nDatabase Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 184549376 bytes\r\nRedo Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7942144 bytes\r\nDatabase mounted.\r\nDatabase opened.\r\nSQL&gt;<\/pre>\n<p>Even if we open a closed database directly in open mode, the above operations take place in the background. That is, the database is first opened in nomount mode, then brought to mount mode, and then opened. This happens very quickly.<\/p>\n<p>We can bring a database in Mount mode to Open mode as follows.<\/p>\n<pre class=\"\">bash-4.1$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.3.0 Production on Mon Oct 7 14:32:06 2013\r\n\r\nCopyright (c) 1982, 2011, Oracle.\u00a0 All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\n\r\nSQL&gt; select open_mode from v$database;\r\n\r\nOPEN_MODE\r\n--------------------\r\nMOUNTED\r\n\r\nSQL&gt; alter database open;\r\n\r\nDatabase altered.<\/pre>\n<h3>Oracle Database Shutdown Modes<\/h3>\n<p>Oracle offers us 5 different methods for shutting down the database. As each method has different functions, we will examine they separately below.<\/p>\n<p id=\"KznLSfi\"><img loading=\"lazy\" decoding=\"async\" width=\"432\" height=\"286\" class=\"size-full wp-image-9887  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c751e8c40812.png\" alt=\"\" \/><\/p>\n<p><strong>Shutdown immediate:<\/strong> This method is the most preferred method. Because the database is closed in a healthy and consistent way. When this command is executed, oracle rollbacks uncommitted transactions and executes the shutdown procedures. The use of the command is as follows.<\/p>\n<pre class=\"\">bash-4.1$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.3.0 Production on Mon Oct 7 14:50:17 2013\r\n\r\nCopyright (c) 1982, 2011, Oracle.\u00a0 All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\n\r\nSQL&gt; shutdown immediate\r\nDatabase closed.\r\nDatabase dismounted.\r\nORACLE instance shut down.\r\nSQL&gt;<\/pre>\n<p><strong>Shutdown Normal:<\/strong> This method is not preferred, but sometimes it may be needed. When we try to close the database with this method, Oracle waits all users connected to the database to finish their jobs and close their sessions. The database will not close even if a single session is open. The use of the command is as follows.<\/p>\n<pre class=\"\">bash-4.1$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.3.0 Production on Mon Oct 7 14:50:17 2013\r\n\r\nCopyright (c) 1982, 2011, Oracle.\u00a0 All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\n\r\nSQL&gt; shutdown immediate\r\nDatabase closed.\r\nDatabase dismounted.\r\nORACLE instance shut down.\r\nSQL&gt;<\/pre>\n<p><strong>Shutdown Transactional:<\/strong> In this method, Oracle waits all users to commit their transactions. After the Commit process is complete, Oracle kills that session and continue to shutdown process. This method has zero data loss guarantee. The use of the command is as follows.<\/p>\n<pre class=\"\">bash-4.1$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.3.0 Production on Mon Oct 7 14:59:47 2013\r\n\r\nCopyright (c) 1982, 2011, Oracle.\u00a0 All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\n\r\nSQL&gt; shutdown transactional;\r\nDatabase closed.\r\nDatabase dismounted.\r\nORACLE instance shut down.\r\nSQL&gt;<\/pre>\n<p><strong>Shutdown abort:<\/strong> This method is like unplugging the database. All transactions are suddenly stopped and the database is closed inconsistently. Although this method is not preferred, it is sometimes very necessary. For example, you are doing a very critical operation and time is very important for you and you need to close or restart the database. If it will take too long to shutdown the database in a consistent manner, this method can be used. The use of the command is as follows.<\/p>\n<pre class=\"\">bash-4.1$ ps -ef | grep smon\r\noracle\u00a0\u00a0 20376\u00a0\u00a0\u00a0\u00a0 1\u00a0 0 14:31 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 ora_smon_TESTDB\r\noracle\u00a0\u00a0 20486 19577\u00a0 0 14:45 pts\/0\u00a0\u00a0\u00a0 00:00:00 grep smon\r\nbash-4.1$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.3.0 Production on Mon Oct 7 14:46:02 2013\r\n\r\nCopyright (c) 1982, 2011, Oracle.\u00a0 All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\n\r\nSQL&gt; shutdown abort\r\nORACLE instance shut down.\r\nSQL&gt; exit\r\nDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\nbash-4.1$ ps -ef | grep smon\r\noracle\u00a0\u00a0 20490 19577\u00a0 0 14:46 pts\/0\u00a0\u00a0\u00a0 00:00:00 grep smon\r\nbash-4.1$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.3.0 Production on Mon Oct 7 14:46:23 2013\r\n\r\nCopyright (c) 1982, 2011, Oracle.\u00a0 All rights reserved.\r\n\r\nConnected to an idle instance.\r\n\r\nSQL&gt;<\/pre>\n<p>In addition, there is a force restart command. Lastly, I will explain this command.<\/p>\n<p><strong>Startup Force:<\/strong> This command runs the Shutdown abort + Startup command in the background. So with Shutdown abort, the database is suddenly closed, and then startup and the database are opened in a normal format. The use of the command is as follows.<\/p>\n<pre class=\"\">bash-4.1$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.3.0 Production on Mon Oct 7 15:03:47 2013\r\n\r\nCopyright (c) 1982, 2011, Oracle.\u00a0 All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\n\r\nSQL&gt; startup force\r\nORACLE instance started.\r\n\r\nTotal System Global Area\u00a0 534462464 bytes\r\nFixed Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2230072 bytes\r\nVariable Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 339740872 bytes\r\nDatabase Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 184549376 bytes\r\nRedo Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7942144 bytes\r\nDatabase mounted.\r\nDatabase opened.\r\nSQL&gt;<\/pre>\n<p>&nbsp;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_9884\" class=\"pvc_stats all  \" data-element-id=\"9884\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; In this article, I will explain the startup and shutdown modes of Oracle database. Oracle Database Startup Modes A closed Oracle database opens in 3 stages. The best summarizing image is as follows. We will review these steps one by one. Nomount Mode: The instance and background processes start when we open the Oracle &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_9884\" class=\"pvc_stats all  \" data-element-id=\"9884\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":472,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[2175,2182,2181,2183,2179,2180,2167,2168,2169,2176,2170,780,781,2178,2177,2172,2184,2185,2186,2173,2171,2174,779],"class_list":["post-9884","post","type-post","status-publish","format-standard","","category-oracle","tag-force-start-oracle","tag-mount-mode","tag-nomount-mode","tag-open-mode","tag-oracle-database-shutdown-modes","tag-oracle-database-startup-modes","tag-oracle-database-startup-shutdown","tag-oracle-shutdown","tag-oracle-startup","tag-oracle-startup-force","tag-oracle-support","tag-shutdown-abort","tag-shutdown-immediate","tag-shutdown-normal","tag-shutdown-transactional","tag-shutting-down-a-database","tag-start-database-mount-mode","tag-start-database-nomount-mode","tag-start-database-open-mode","tag-starting-up-a-database","tag-startup","tag-startup-force","tag-startup-mount"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Oracle Database Startup and Shutdown Modes - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Oracle Database Startup and Shutdown Modes\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Database Startup and Shutdown Modes - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Oracle Database Startup and Shutdown Modes\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-26T11:43:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c7519e43afdd.png\" \/>\n<meta name=\"author\" content=\"Mehmet Salih DEVEC\u0130\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mehmet Salih DEVEC\u0130\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/\"},\"author\":{\"name\":\"Mehmet Salih DEVEC\u0130\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/bbdc56d959b34d47d81999c7af91a2fa\"},\"headline\":\"Oracle Database Startup and Shutdown Modes\",\"datePublished\":\"2019-02-26T11:43:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/\"},\"wordCount\":549,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c7519e43afdd.png\",\"keywords\":[\"force start oracle\",\"mount mode\",\"nomount mode\",\"open mode\",\"Oracle Database Shutdown Modes\",\"Oracle Database Startup Modes\",\"oracle database startup shutdown\",\"oracle shutdown\",\"oracle startup\",\"oracle startup force\",\"Oracle Support\",\"shutdown abort\",\"shutdown immediate\",\"Shutdown Normal\",\"Shutdown Transactional\",\"shutting down a database\",\"start database mount mode\",\"start database nomount mode\",\"start database open mode\",\"starting up a database\",\"startup\",\"Startup Force\",\"Startup mount\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/\",\"name\":\"Oracle Database Startup and Shutdown Modes - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c7519e43afdd.png\",\"datePublished\":\"2019-02-26T11:43:14+00:00\",\"description\":\"Oracle Database Startup and Shutdown Modes\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c7519e43afdd.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c7519e43afdd.png\",\"width\":213,\"height\":305},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Database Startup and Shutdown Modes\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/bbdc56d959b34d47d81999c7af91a2fa\",\"name\":\"Mehmet Salih DEVEC\u0130\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/adcbb5bfb748dc6f31a1196c490f93fdbc20e6584b62d850570545f39c910c41?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/adcbb5bfb748dc6f31a1196c490f93fdbc20e6584b62d850570545f39c910c41?s=96&d=mm&r=g\",\"caption\":\"Mehmet Salih DEVEC\u0130\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/salihdeveci\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Database Startup and Shutdown Modes - Database Tutorials","description":"Oracle Database Startup and Shutdown Modes","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Database Startup and Shutdown Modes - Database Tutorials","og_description":"Oracle Database Startup and Shutdown Modes","og_url":"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/","og_site_name":"Database Tutorials","article_published_time":"2019-02-26T11:43:14+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c7519e43afdd.png","type":"","width":"","height":""}],"author":"Mehmet Salih DEVEC\u0130","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Mehmet Salih DEVEC\u0130","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/"},"author":{"name":"Mehmet Salih DEVEC\u0130","@id":"https:\/\/dbtut.com\/#\/schema\/person\/bbdc56d959b34d47d81999c7af91a2fa"},"headline":"Oracle Database Startup and Shutdown Modes","datePublished":"2019-02-26T11:43:14+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/"},"wordCount":549,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c7519e43afdd.png","keywords":["force start oracle","mount mode","nomount mode","open mode","Oracle Database Shutdown Modes","Oracle Database Startup Modes","oracle database startup shutdown","oracle shutdown","oracle startup","oracle startup force","Oracle Support","shutdown abort","shutdown immediate","Shutdown Normal","Shutdown Transactional","shutting down a database","start database mount mode","start database nomount mode","start database open mode","starting up a database","startup","Startup Force","Startup mount"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/","url":"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/","name":"Oracle Database Startup and Shutdown Modes - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c7519e43afdd.png","datePublished":"2019-02-26T11:43:14+00:00","description":"Oracle Database Startup and Shutdown Modes","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c7519e43afdd.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c7519e43afdd.png","width":213,"height":305},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/oracle-database-startup-and-shutdown-modes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Oracle Database Startup and Shutdown Modes"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/bbdc56d959b34d47d81999c7af91a2fa","name":"Mehmet Salih DEVEC\u0130","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/adcbb5bfb748dc6f31a1196c490f93fdbc20e6584b62d850570545f39c910c41?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/adcbb5bfb748dc6f31a1196c490f93fdbc20e6584b62d850570545f39c910c41?s=96&d=mm&r=g","caption":"Mehmet Salih DEVEC\u0130"},"url":"https:\/\/dbtut.com\/index.php\/author\/salihdeveci\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9884","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/472"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=9884"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9884\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=9884"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=9884"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=9884"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}