티스토리 뷰
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
- Managing Schema Objects
- Backup
- oracle
- 인덱스
- 리눅스
- tablespace
- 아이폰4
- PostgreSQL
- MS-SQL
- linux
- Flashback
- parameter
- 한글
- iOS5
- 컬럼정보
- 테이블정보
- 투싼
- PL/SQL
- postgresql.conf
- 갤럭시S
- 오라클
- 독도
- recovery
- SQLPlus
- iPhone
- index
- 아이폰
- 출시일
- 윈도우
- mysql
일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | |||
5 | 6 | 7 | 8 | 9 | 10 | 11 |
12 | 13 | 14 | 15 | 16 | 17 | 18 |
19 | 20 | 21 | 22 | 23 | 24 | 25 |
26 | 27 | 28 | 29 | 30 | 31 |