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

最新文章

  1. Android核心机制
  2. IIS减少工作线程阻塞的方法
  3. python爬虫之BeautifulSoup
  4. Java 开发 gRPC 服务和客户端
  5. CI系统
  6. oracle OVER(PARTITION BY) 函数
  7. 框架学习笔记:Unity3D的MVC框架——StrangeIoC
  8. 【转】MyBatis学习总结(三)——优化MyBatis配置文件中的配置
  9. 初识Ajax技术
  10. OData语法
  11. HTTPS加密流程超详解(一)前期准备
  12. 4.ES核心慨念
  13. ansys19.0安装破解教程(图文详解)
  14. 2017-2018-2 20165325 实验一《Java开发环境的熟悉》实验报告
  15. C#直接用数字定义背景颜色
  16. python 字典输出键值对
  17. Python——基础数据类型(补充)
  18. react中使用echarts(人物关系图)
  19. 阿里巴巴fastjson 包的使用解析json数据
  20. [git 学习篇] git remote add origin错误

热门文章

  1. Qt 使用大神插件快速创建树状导航栏
  2. Cannot find ./catalina.sh The file is absent or does not have execute permission This file is needed to run this program(问题解决)
  3. MacOS修复TNT和谐软件运行崩溃、闪退问题
  4. [bzoj1305]跳舞
  5. [loj2494]寻宝游戏
  6. SuperEdge再添国产智能加速卡支持,为边缘智能推理再提速10倍
  7. redis可以设置过期key回调实现延时队列
  8. html+css第九篇
  9. 深入理解Redis 数据结构—简单动态字符串sds
  10. BehaviorTree.CPP行为树BT的选择节点(四)