{"id":5610,"date":"2016-03-31T12:53:47","date_gmt":"2016-03-31T04:53:47","guid":{"rendered":"http:\/\/rmohan.com\/?p=5610"},"modified":"2016-03-31T12:53:47","modified_gmt":"2016-03-31T04:53:47","slug":"how-to-startstop-oracle-database-from-linux-command-prompt","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=5610","title":{"rendered":"How to start\/stop oracle database from linux command prompt"},"content":{"rendered":"

How to start\/stop oracle database from linux command prompt<\/h3>\n
<\/div>\n
\n
How to start\/stop oracle database from linux command prompt:-
\n[oracle@configsrv1 ~]$vi \/etc\/oratab
\n#<\/p>\n

# This file is used by ORACLE utilities. \u00a0It is created by root.sh
\n# and updated by the Database Configuration Assistant when creating
\n# a database.<\/p>\n

# A colon, ‘:’, is used as the field terminator. \u00a0A new line terminates
\n# the entry. \u00a0Lines beginning with a pound sign, ‘#’, are comments.
\n#
\n# Entries are of the form:
\n# \u00a0 $ORACLE_SID:$ORACLE_HOME:<N|Y>:
\n#
\n# The first and second fields are the system identifier and home
\n# directory of the database respectively. \u00a0The third filed indicates
\n# to the dbstart utility that the database should , “Y”, or should not,
\n# “N”, be brought up at system boot time.
\n#
\n# Multiple entries with the same $ORACLE_SID are not allowed.
\n#
\n#
\nprim:\/u01\/app\/oracle\/product\/11.2.0\/db_1:N<\/p>\n

change the entry to this<\/p>\n

prim:\/u01\/app\/oracle\/product\/11.2.0\/db_1:Y<\/p>\n

and save the file.<\/p>\n

For starting db
\n[oracle@configsrv1 ~] dbstart
\nORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener
\nUsage: \/u01\/app\/oracle\/product\/11.2.0\/db_1\/bin\/dbstart ORACLE_HOME
\nProcessing Database instance “prim”: log file \/u01\/app\/oracle\/product\/11.2.0\/db_1\/startup.log<\/p>\n

To fix the above error;<\/p>\n

[oracle@configsrv1 ~]export ORACLE_HOME_LISTNER=$ORACLE_HOME
\n[oracle@configsrv1 ~]dbstart $ORACLE_HOME
\nThen start the db again
\n[oracle@configsrv1 bin]$ dbstart $ORACLE_HOME
\nProcessing Database instance “prim”: log file \/u01\/app\/oracle\/product\/11.2.0\/db_1\/startup.log<\/p>\n

For stopping db
\n[oracle@configsrv1 ~] dbshut<\/p><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

How to start\/stop oracle database from linux command prompt How to start\/stop oracle database from linux command prompt:- [oracle@configsrv1 ~]$vi \/etc\/oratab #<\/p>\n

# This file is used by ORACLE utilities. It is created by root.sh # and updated by the Database Configuration Assistant when creating # a database.<\/p>\n

# A colon, ‘:’, is used as […]<\/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\/5610"}],"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=5610"}],"version-history":[{"count":1,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/5610\/revisions"}],"predecessor-version":[{"id":5611,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/5610\/revisions\/5611"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5610"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5610"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}