티스토리 뷰
root에서 아래 부분 복사해서 붙이면 됨
rm -f /etc/init.d/oracle
cat >> /etc/init.d/oracle<<EOF
#!/bin/bash
#/etc/rc.d/init.d/oracle
# chkconfig: 2345 20 80
# description: Oracle10g Service Starting
# isqlplus,oracleInstance,emctl,lsnr.
# made by nowage@gmail.com
start() {
echo -n "Starting Oracle 10g services"
su - oracle -c "/u01/app/oracle/product/10.2.0/db_1/bin/lsnrctl start">>/u01/app/oracle/product/10.2.0/db_1/log/Log.oracleStartAll.log
su - oracle -c "/u01/app/oracle/product/10.2.0/db_1/bin/sqlplus / as sysdba<<EOF
startup
quit
EOF
exit">>/u01/app/oracle/product/10.2.0/db_1/log/Log.oracleStartAll.log
su - oracle -c "/u01/app/oracle/product/10.2.0/db_1/bin/emctl start dbconsole">>/u01/app/oracle/product/10.2.0/db_1/log/Log.oracleStartAll.log
su - oracle -c "/u01/app/oracle/product/10.2.0/db_1/bin/isqlplusctl start">>/u01/app/oracle/product/10.2.0/db_1/log/Log.oracleStartAll.log
echo "done"
}
stop() {
echo -n "Stopping Oracle 10g services"
su - oracle -c "/u01/app/oracle/product/10.2.0/db_1/bin/lsnrctl stop">>/u01/app/oracle/product/10.2.0/db_1/log/Log.oracleStopAll.log
su - oracle -c "/u01/app/oracle/product/10.2.0/db_1/bin/sqlplus / as sysdba<<EOF
shutdown immediate
quit
EOF
exit">>/u01/app/oracle/product/10.2.0/db_1/log/Log.oracleStopAll.log
su - oracle -c "/u01/app/oracle/product/10.2.0/db_1/bin/emctl stop dbconsole">>/u01/app/oracle/product/10.2.0/db_1/log/Log.oracleStopAll.log
su - oracle -c "/u01/app/oracle/product/10.2.0/db_1/bin/isqlplusctl stop" >>/u01/app/oracle/product/10.2.0/db_1/log/Log.oracleStopAll.log
echo "done"
}
case "$1" in
start)
start
;;
stop)
stop
;;
restart|reload)
stop
start
;;
*)
echo "Usage: oracle {start|stop|restart}"
exit 1
;;
esac
exit $?
EOF
chmod 755 /etc/init.d/oracle
/usr/bin/system-config-services
'DataBase > Oracle' 카테고리의 다른 글
스크립트파일 (0) | 2012.10.17 |
---|---|
oracle user 생성 (0) | 2012.10.17 |
오라클 스크립트 oracle.sh (0) | 2012.10.17 |
Archive mode 끄고 켜기 (0) | 2012.10.17 |
잡다한 쿼리구문- 쉬운데 자주 깜박하는 것들 검색용 (0) | 2012.07.23 |
- Total
- Today
- Yesterday
- Flashback
- 독도
- iPhone
- linux
- 갤럭시S
- oracle
- postgresql jsonb
- Managing Schema Objects
- MS-SQL
- postgresql pg_stat_activity
- 오라클
- parameter
- index
- SQLPlus
- 한글
- 출시일
- PostgreSQL
- tablespace
- 윈도우
- recovery
- query 잘림
- iOS5
- postgresql jsonb index
- 인덱스
- Backup
- 리눅스
- 투싼
- 아이폰
- PL/SQL
- 아이폰4