Oracle9iAS (之三): 系统的关闭,清理, 起动 from cron jobs

[复制链接]
查看11 | 回复5 | 2015-3-27 23:10:30 | 显示全部楼层 |阅读模式
ITPUB 已有不少贴子讲:安装,起动, 。。。
在此贡献一些系统维护,J2EE 部署,FORMS/REPORT 部署等东东,已期锦上添花:
我们的 ORACLE9iAS 是在 SOLARIS 8.0 ( 4 CPU, 6 GB memory) 上跑的。 每周一早上 1:00 am, 系统关闭 (通过 cron JOB), 1:30 am, 系统清理, 2:00 am 系统起动。 所用脚本如下:
(请注意,在系统起动,关闭过程中, SERVER 睡了(sleep) 好多次。)
1. lexus % crontab -l
0 1**1/usr3/home/oracle/Sys_Admin/stop_farm
30 1**1/usr3/home/oracle/Sys_Admin/clean_farm
0 2**1/usr3/home/oracle/Sys_Admin/start_farm
2. stop_farm
#!/bin/sh

# system dependent parameters (lincoln or lexus)
DISK=/usr4;
export DISK
REPORT_SERVER=rep_lexus; export REPORT_SERVER
PASSWD=lexus****;
export PASSWD

# stop the middle tier
ORACLE_BASE=$DISK/app/oracle; export ORACLE_BASE
ORACLE_HOME=$DISK/app/oracle/9ias_rl2;export ORACLE_HOME
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib; export LD_LIBRARY_PATH
PATH=/usr/local/bin:/usr/bin:/usr/ucb

PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$ORACLE_HOME/dcm/bin; export PATH


rwserver.sh server=$REPORT_SERVER shutdown=normal authid=orcladmin/$PASSWD

sleep 30


webcachectl stop

sleep 30

dcmctl stop


sleep 120

# stop the infrastructure
ORACLE_BASE=$DISK/app/oracle; export ORACLE_BASE
ORACLE_HOME=$DISK/app/oracle/9ias_inf;export ORACLE_HOME
ORACLE_SID=iasdb; export ORACLE_SID
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib; export LD_LIBRARY_PATH

PATH=/usr/local/bin:/usr/bin:/usr/ucb

PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$ORACLE_HOME/dcm/bin; export PATH

$ORACLE_HOME/dcm/bin/dcmctl stop

sleep 120

$ORACLE_HOME/bin/oidctl server=oidldapd instance=1 configset=1 stop

sleep 10

$ORACLE_HOME/bin/oidmon stop

sleep 10

$ORACLE_HOME/bin/lsnrctl stop

sleep 10

$ORACLE_HOME/bin/sqlplus /nolog<< ENDSQL
connect / as sysdba
shutdown immediate
quit
ENDSQL

sleep 120

EM_PID_FILE=$ORACLE_HOME/bin/emctl.pid
if test -f $EM_PID_FILE;
then
rm -f $EM_PID_FILE;
fi

HTTP_PID_FILE=$ORACLE_HOME/Apache/Apache/logs/httpd.pid
if test -f $HTTP_PID_FILE;
then
rm -f $HTTP_PID_FILE;
fi

for cpid in `ps -Af | grep oidldapd | awk '{print $2}'`
do
kill -9 $cpid
done

for cpid in `ps -Af | grep opmn | awk '{print $2}'`
do
kill -9 $cpid
done

for cpid in `ps -Af | grep 9ias_inf | awk '{print $2}'`
do
kill -9 $cpid
done

for cpid in `ps -Af | grep 9ias_rl2 | awk '{print $2}'`
do
kill -9 $cpid
done

exit 0

3. clean_farm
#!/bin/sh

# Version 0.1:2002.05.08
# Version 0.2:2002.05.10
# Version 1.0:2003.06.18Copied from challenger2 to lexus5
# Version 2.0:2003.10.23Handle all the log directory in both ORACLE_HOME

# system dependent parameters (lincoln or lexus)
DISK=/usr2;
export DISK

# Clean up

# delete all last week's logs
cd $DISK/app/oracle/9ias_rl2/Apache/Apache/logs/last_week
for name in `ls *`; do
rm -f $name
done

mv -f ../* .

cd $DISK/app/oracle/9ias_inf/Apache/Apache/logs/last_week
for name in `ls *`; do
rm -f $name
done

mv -f ../* .

# Clean the report cache
cd $DISK/app/oracle/9ias_rl2/reports/cache
for name in `ls`; do
rm -f $name
done

# Clean the forms memory dump
cd $DISK/app/oracle/9ias_rl2/forms90
for name in `ls f90webm_dump_*`; do
rm -f $name
done

exit 0

4. start_farm
#!/bin/sh

# system dependent parameters (lincoln or lexus)
DISK=/usr4;
export DISK
REPORT_SERVER=rep_lexus;export REPORT_SERVER
PASSWD=lexus****;
export PASSWD

# start up the infrastructure
ORACLE_BASE=$DISK/app/oracle; export ORACLE_BASE
ORACLE_HOME=$DISK/app/oracle/9ias_inf;export ORACLE_HOME
ORACLE_SID=iasdb; export ORACLE_SID
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib; export LD_LIBRARY_PATH
DISPLAY=:0.0;export DISPLAY

PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$ORACLE_HOME/dcm/bin; export PATH

echo ""
echo "\n1. Start up listner"
$ORACLE_HOME/bin/lsnrctl start

sleep 20

echo "\n2. Start up database"
$ORACLE_HOME/bin/sqlplus /nolog<< ENDSQL

connect / as sysdba

startup

quit
ENDSQL

sleep 120

echo "\n3. Start up oidmon"
$ORACLE_HOME/bin/oidmon start

sleep 50

echo "\n4. Start up oidctl"
$ORACLE_HOME/bin/oidctl server=oidldapd instance=1 configset=1 start

sleep 20

echo "\n5. Start up dcm"
$ORACLE_HOME/dcm/bin/dcmctl start -cl

sleep 120

echo "\n6. Start up Enterprise Manager"
$ORACLE_HOME/bin/emctlstart

sleep 120

ORACLE_BASE=$DISK/app/oracle; export ORACLE_BASE
ORACLE_HOME=$DISK/app/oracle/9ias_rl2; export ORACLE_HOME
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib; export LD_LIBRARY_PATH


PATH=/usr/local/bin:/usr/bin:/usr/ucb:.
PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$ORACLE_HOME/dcm/bin; export PATH


echo "\n7. Start up Mid-tier"
dcmctl start


sleep 120


echo "\n8. Start up Webcache"
webcachectl start

sleep 120

echo "\n7. Start up Report_Server"
rwserver.sh server=$REPORT_SERVERauthid=orcladmin/$PASSWD &

sleep 120

exit 0
回复

使用道具 举报

千问 | 2015-3-27 23:10:30 | 显示全部楼层
好好
回复

使用道具 举报

千问 | 2015-3-27 23:10:30 | 显示全部楼层
顶!好!
回复

使用道具 举报

千问 | 2015-3-27 23:10:30 | 显示全部楼层
你上去吧!
回复

使用道具 举报

千问 | 2015-3-27 23:10:30 | 显示全部楼层
good1
回复

使用道具 举报

千问 | 2015-3-27 23:10:30 | 显示全部楼层
好利害
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行