{"id":1463,"date":"2021-11-29T12:25:00","date_gmt":"2021-11-29T15:25:00","guid":{"rendered":"https:\/\/rodrigosilvaesilva.com.br\/?p=1463"},"modified":"2021-11-29T12:25:00","modified_gmt":"2021-11-29T15:25:00","slug":"how-to-drop-database-in-oracle-11g-12c-18c-19c-21c-without-using-dbca","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2021\/11\/29\/how-to-drop-database-in-oracle-11g-12c-18c-19c-21c-without-using-dbca\/","title":{"rendered":"How to drop database In oracle 11g\/12c \/18c\/19c\/21c Without Using DBCA"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<p class=\"has-medium-font-size\"><strong>Export SID instance droped<\/strong><\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:sh decode:true \" >export ORACLE_SID=database\n<\/pre><\/div>\n\n\n\n<p><\/p>\n\n\n\n<p class=\"has-medium-font-size\"><strong>Connect database as sysdba<\/strong><\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:plsql decode:true \" >\n\n[oracle@SRV-BD-HOMOLOG ~]$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 12.1.0.2.0 Production on Mon Nov 29 12:09:16 2021\n\nCopyright (c) 1982, 2014, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\nWith the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics\nand Real Application Testing options<\/pre><\/div>\n\n\n\n<p><\/p>\n\n\n\n<p class=\"has-medium-font-size\"><strong> <strong>Check status instance<\/strong> <\/strong><\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:plsql decode:true \" >\n\nSQL&gt; select instance_name, status from v$instance;\n\nINSTANCE STATUS\n-------- --------------------\nhomolog    OPEN\n\n<\/pre><\/div>\n\n\n\n<p>Shutdown the database<\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:plsql decode:true \" >\nSQL&gt; shutdown immediate;\nDatabase closed.\nDatabase dismounted.\nORACLE instance shut down.<\/pre><\/div>\n\n\n\n<p><\/p>\n\n\n\n<p class=\"has-medium-font-size\"><strong>startup in exclusive mode restrict<\/strong><\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:plsql decode:true \" >\nSQL&gt; startup mount exclusive restrict\nORACLE instance started<\/pre><\/div>\n\n\n\n<p><\/p>\n\n\n\n<p class=\"has-medium-font-size\"><strong>Check status instance<\/strong><\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:plsql decode:true \" >\n\nSQL&gt; select instance_name, status from v$instance;\n\nINSTANCE STATUS\n-------- --------------------\nMOUNTED    OPEN<\/pre><\/div>\n\n\n\n<p><\/p>\n\n\n\n<p class=\"has-medium-font-size\"><strong>Drop database<\/strong><\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:plsql decode:true \" >\nSQL&gt; drop database;\n\nDatabase dropped.\n<\/pre><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Export SID instance droped Connect database as sysdba Check status instance Shutdown the database startup in exclusive mode restrict Check status instance Drop database<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"aside","meta":{"footnotes":""},"categories":[8],"tags":[420,421,419,422,423,418],"class_list":["post-1463","post","type-post","status-publish","format-aside","hentry","category-oracle","tag-11g","tag-12c","tag-18c","tag-19c","tag-21c","tag-drop-database","post_format-post-format-aside"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1463","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=1463"}],"version-history":[{"count":2,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1463\/revisions"}],"predecessor-version":[{"id":1465,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1463\/revisions\/1465"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=1463"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=1463"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=1463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}