{"id":1016,"date":"2012-08-15T15:42:31","date_gmt":"2012-08-15T07:42:31","guid":{"rendered":"http:\/\/rmohan.com\/?p=1016"},"modified":"2012-08-15T15:42:31","modified_gmt":"2012-08-15T07:42:31","slug":"oracle-db-startup-scripts","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=1016","title":{"rendered":"Oracle DB startup Scripts"},"content":{"rendered":"<div>Starting oracle listener<\/div>\n<p>$ lsnrctl start<\/p>\n<div>Start the database<\/div>\n<p>$ dbstart<\/p>\n<p>Starting oracle Enterprise manager<br \/>\n$ emctl start dbconsole<\/p>\n<p>Shutting down the database<br \/>\n$ dbshut<\/p>\n<p>Stopping the listener<br \/>\n$ lsnrctl stop<\/p>\n<p>Stopping oracle Enterprise manager<br \/>\n$ emctl stop dbconsole<\/p>\n<p>Starts sqlplus without logging in to a database<br \/>\n# su \u00ad oracle<br \/>\n$ sqlplus \/nolog<\/p>\n<p>Logging into default oracle db<br \/>\n$ sqlplus system\/oracle11@pfdb<\/p>\n<p>The automatic startup and shutdown of the Oracle database can be achieved with the files dbstart and dbshut both provided by Oracle. These files rely on the existance of the file \/etc\/oratab to work<\/p>\n<p>$ cat \/etc\/oratab<br \/>\norcl:\/u01\/app\/oracle\/product\/10.2.0\/db_1:Y<\/p>\n<p>The first field is the name of my database (orcl), the second one is my home directory<br \/>\n(\/u01\/app\/oracle\/product\/10.2.0\/db_1), and the third indicates to the dbstart utility whether the database should, or should not be brough up at the system boot time with &#8220;Y&#8221; or &#8220;N&#8221; parameters respectively. As root user, we&#8217;ll change last field of this line from &#8220;N&#8221; to &#8220;Y&#8221; to let dbstart utility start this database when it runs.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Starting oracle listener <\/p>\n<p>$ lsnrctl start<\/p>\n<p> Start the database <\/p>\n<p>$ dbstart<\/p>\n<p>Starting oracle Enterprise manager $ emctl start dbconsole<\/p>\n<p>Shutting down the database $ dbshut<\/p>\n<p>Stopping the listener $ lsnrctl stop<\/p>\n<p>Stopping oracle Enterprise manager $ emctl stop dbconsole<\/p>\n<p>Starts sqlplus without logging in to a database # su \u00ad oracle $ sqlplus \/nolog<\/p>\n<p>Logging [&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/1016"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1016"}],"version-history":[{"count":1,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/1016\/revisions"}],"predecessor-version":[{"id":1017,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/1016\/revisions\/1017"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1016"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1016"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1016"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}