| 공지 |
실습용 이미지 배포에 대한 공지.
|
나현재 |
2008-01-27 |
22326 |
| 36 |
PL/SQL 사용 기초
|
나현재 |
2008-03-09 |
5262 |
| 35 |
deferred 모드 사용 예.
|
나현재 |
2008-03-09 |
4901 |
| 34 |
oracle Asm start Script
|
나현재 |
2008-02-21 |
3956 |
| 33 |
Partitioned Table example
|
나현재 |
2008-02-13 |
4873 |
| 32 |
Time-Based Recovery Using Rman : Example
|
나현재 |
2008-02-05 |
8644 |
| 31 |
rman channel 문제 해결
|
나현재 |
2008-02-05 |
5198 |
| 30 |
NMO(agnet) Error Solution
1
|
나현재 |
2008-02-01 |
5297 |
 |
오라클(리눅스) 서비스 등록하기.
|
나현재 |
2008-01-31 |
7886 |
| 28 |
Asm Instance rpm
1
|
나현재 |
2008-01-19 |
4571 |
| 27 |
expdp/impdp 사용 예 및 help 사용 법.
|
나현재 |
2008-01-11 |
7203 |
| 26 |
scott(impdp)파일
|
나현재 |
2008-01-11 |
4836 |
| 25 |
iSqlplus에서 dba로 접속하기 위한 셋팅
|
나현재 |
2008-01-07 |
5826 |
| 24 |
OBE사용법.
|
나현재 |
2007-12-30 |
4378 |
| 23 |
value-baseed Auditing
1
|
나현재 |
2007-12-30 |
4259 |
| 22 |
SqlF2-8 Regular Expression Support
|
나현재 |
2007-12-11 |
4757 |
| 21 |
SqlF2-7 Hierarchical Retrieval
1
 |
나현재 |
2007-12-11 |
4294 |
| 20 |
SqlF2-6 Retrieving Data Using Subqueries
1
|
나현재 |
2007-12-11 |
4585 |
| 19 |
SqlF2-5 Managing Data in Different Time Zone
2
|
나현재 |
2007-12-11 |
4924 |
| 18 |
SqlF2-4 Generating Reports by Grouping Related Data
2
|
나현재 |
2007-12-11 |
5077 |
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