设置linux下oracle开机自启动
2024-09-04 08:32:17
1.修改配置文件,vi /etc/oratab
orcl:/u01/app/oracle/product/11.2.0/db_1:Y
2.创建启动文件,/etc/init.d/
#!/bin/sh
# chkconfig: 35 80 10
# description: Oracle auto start-stop script.
#
# Set ORA_HOME to be equivalent to the $ORACLE_HOME
# from which you wish to execute dbstart and dbshut;
#
# Set ORA_OWNER to the user id of the owner of the
# Oracle database in ORA_HOME.
ORA_HOME=/u01/app/oracle/product/11.2.0/db_1
ORA_OWNER=oracle
if [ ! -f $ORA_HOME/bin/dbstart ]
then
echo "Oracle startup: cannot start"
exit
fi
case "$1" in
'start')
# Start the Oracle databases:
echo "Starting Oracle Databases ... "
echo "-------------------------------------------------" >> /var/log/oracle
date +"%Y-%m-%d %H:%M:%S : Starting Oracle Databases as part of system up." >> /var/log/oracle
echo "-------------------------------------------------" >> /var/log/oracle
su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart $ORACLE_HOME" >>/var/log/oracle
echo "Done"
# Start the Listener:
echo "Starting Oracle Listeners ... "
echo "-------------------------------------------------" >> /var/log/oracle
date +"%Y-%m-%d %H:%M:%S : Starting Oracle Listeners as part of system up." >> /var/log/oracle
echo "-------------------------------------------------" >> /var/log/oracle
su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start" >>/var/log/oracle
echo "Done."
echo "-------------------------------------------------" >> /var/log/oracle
date +"%Y-%m-%d %H:%M:%S : Finished." >> /var/log/oracle
echo "-------------------------------------------------" >> /var/log/oracle
touch /var/lock/subsys/oracle 'stop')
# Stop the Oracle Listener:
echo "Stoping Oracle Listeners ... "
echo "-------------------------------------------------" >> /var/log/oracle
date +"%Y-%m-%d %H:%M:%S : Stoping Oracle Listener as part of system down." >> /var/log/oracle
echo "-------------------------------------------------" >> /var/log/oracle
su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop" >>/var/log/oracle
echo "Done."
rm -f /var/lock/subsys/oracle
# Stop the Oracle Database:
echo "Stoping Oracle Databases ... "
echo "-------------------------------------------------" >> /var/log/oracle
date +"%Y-%m-%d %H:%M:%S : Stoping Oracle Databases as part of system down." >> /var/log/oracle
echo "-------------------------------------------------" >> /var/log/oracle
su - $ORA_OWNER -c "$ORA_HOME/bin/dbshut $ORACLE_HOME" >>/var/log/oracle
echo "Done."
echo ""
echo "-------------------------------------------------" >> /var/log/oracle
date +"%Y-%m-%d %H:%M:%S : Finished." >> /var/log/oracle
echo "-------------------------------------------------" >> /var/log/oracle 'restart')
$0 stop
$0 start esac
3.给刚建的脚本赋予可执行权限
chmod a+x oracle
4.添加oracle服务
chkconfig --level 35 oracle on
5.创建软连接
#关机时关闭数据库
ln -s /etc/init.d/oracle /etc/rc0.d/K01oracle #重启时关闭数据库
ln -s /etc/init.d/oracle /etc/rc6.d/K01oracle
6.使用方法
#启动oracle
service oracle start #关闭oracle
service oracle stop #重启oracle
service oracle restart
最新文章
- Android核心机制
- IIS减少工作线程阻塞的方法
- python爬虫之BeautifulSoup
- Java 开发 gRPC 服务和客户端
- CI系统
- oracle OVER(PARTITION BY) 函数
- 框架学习笔记:Unity3D的MVC框架——StrangeIoC
- 【转】MyBatis学习总结(三)——优化MyBatis配置文件中的配置
- 初识Ajax技术
- OData语法
- HTTPS加密流程超详解(一)前期准备
- 4.ES核心慨念
- ansys19.0安装破解教程(图文详解)
- 2017-2018-2 20165325 实验一《Java开发环境的熟悉》实验报告
- C#直接用数字定义背景颜色
- python 字典输出键值对
- Python——基础数据类型(补充)
- react中使用echarts(人物关系图)
- 阿里巴巴fastjson 包的使用解析json数据
- [git 学习篇] git remote add origin错误
热门文章
- Qt 使用大神插件快速创建树状导航栏
- Cannot find ./catalina.sh The file is absent or does not have execute permission This file is needed to run this program(问题解决)
- MacOS修复TNT和谐软件运行崩溃、闪退问题
- [bzoj1305]跳舞
- [loj2494]寻宝游戏
- SuperEdge再添国产智能加速卡支持,为边缘智能推理再提速10倍
- redis可以设置过期key回调实现延时队列
- html+css第九篇
- 深入理解Redis 数据结构—简单动态字符串sds
- BehaviorTree.CPP行为树BT的选择节点(四)