{"id":1174,"date":"2013-03-12T14:41:30","date_gmt":"2013-03-12T05:41:30","guid":{"rendered":"http:\/\/www.whoocus.com\/blog\/?p=1174"},"modified":"2013-03-12T14:41:56","modified_gmt":"2013-03-12T05:41:56","slug":"oracle%e8%87%aa%e5%8b%95%e8%b5%b7%e5%8b%95%e3%82%b9%e3%82%af%e3%83%aa%e3%83%97%e3%83%88","status":"publish","type":"post","link":"https:\/\/www.blowfish.co.jp\/?p=1174","title":{"rendered":"Oracle\u81ea\u52d5\u8d77\u52d5\u30b9\u30af\u30ea\u30d7\u30c8"},"content":{"rendered":"

[bash]
\n#! \/bin\/bash
\n#
\n# oracle: Starting Oracle database 11g
\n#
\n# chkconfig: 345 95 94
\n# description: Oracle Database Server
\n# processname: ora_<\/p>\n

. \/etc\/rc.d\/init.d\/functions<\/p>\n

lockfile=\/var\/lock\/subsys\/dbora
\nORATAB=\/etc\/oratab
\nORACLE_HOME=\/u01\/app\/oracle\/product\/11.2.0\/dbhome_1\/
\n#ORACLE_HOME=`awk -F: ‘\/^[^#:]+:.+:[Y]$\/ { print $2; exit}’ $ORATAB`
\nif [ x$ORACLE_HOME = "x" ]; then
\n echo "There is not Y entry in $ORATAB."
\n exit 1
\nfi
\nORACLE=`ls -l $ORACLE_HOME\/bin\/dbstart | awk ‘{print $3}’`<\/p>\n

case "$1" in
\n‘start’)
\n if [ -f $lockfile ]; then
\n echo $0 already started.
\n exit 1
\n fi
\n echo -n $"Starting Oracle Database:"
\n su – $ORACLE -c "$ORACLE_HOME\/bin\/lsnrctl start"
\n su – $ORACLE -c "$ORACLE_HOME\/bin\/dbstart $ORACLE_HOME"
\n su – $ORACLE -c "$ORACLE_HOME\/bin\/emctl start dbconsole"
\n touch $lockfile
\n ;;
\n‘stop’)
\n if [ ! -f $lockfile ]; then
\n echo $0 already stopped.
\n exit 1
\n fi
\n echo -n $"Stopping Oracle Database:"
\n su – $ORACLE -c "$ORACLE_HOME\/bin\/lsnrctl stop"
\n su – $ORACLE -c "$ORACLE_HOME\/bin\/dbshut"
\n su – $ORACLE -c "$ORACLE_HOME\/bin\/emctl stop dbconsole"
\n rm -f $lockfile
\n ;;
\n‘restart’)
\n $0 stop
\n $0 start
\n ;;
\n‘status’)
\n if [ -f $lockfile ]; then
\n echo $0 started.
\n else
\n echo $0 stopped.
\n fi
\n ;;
\n*)
\n echo "Usage: $0 [start|stop|status]"
\n exit 1
\nesac<\/p>\n

exit 0
\n[\/bash]<\/p>\n","protected":false},"excerpt":{"rendered":"

[bash] #! \/bin\/bash # # oracle: Starting Oracle database 11g # # chkconfig: 345 95 94 # description: Oracle Da […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"saved_in_kubio":false,"footnotes":""},"categories":[5,12,4],"tags":[],"class_list":["post-1174","post","type-post","status-publish","format-standard","hentry","category-centos","category-oracle","category-tech"],"_links":{"self":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/1174","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1174"}],"version-history":[{"count":2,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/1174\/revisions"}],"predecessor-version":[{"id":1176,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/1174\/revisions\/1176"}],"wp:attachment":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1174"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1174"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}