一、修改oracle配置文件/etc/oratab

vi /etc/oratab  
#将状态从N改为Y  
orcl:/u01/app/oracle/product/19.0.0/db_1:Y  
orcl1:/u01/app/oracle/product/19.0.0/db_1:Y 

复制

二、在/etc/rc.d/rc.local中加入如下语句即可实现实例与系统一起启动

vi /etc/rc.d/rc.local  
su - oracle -c "lsnrctl start"  
su - oracle -c "dbstart"  
 

复制

三、在/etc/init.d目录下新建oracle文件

cd /etc/init.d  
vi oracle  
  
#!/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根据oracle实际安装路径进行修改  
ORA_HOME=/u01/app/oracle/product/19.0.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 +" %T %a %D : Starting Oracle Databases as part of system up." >> /var/log/oracle  
echo "-------------------------------------------------" >> /var/log/oracle  
su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart" >>/var/log/oracle  
echo "Done"  
  
# Start the Listener:  
echo "Starting Oracle Listeners ... "  
echo "-------------------------------------------------" >> /var/log/oracle  
date +" %T %a %D : 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 +" %T %a %D : 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 +" %T %a %D : 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 +" %T %a %D : Stoping Oracle Databases as part of system down." >> /var/log/oracle  
echo "-------------------------------------------------" >> /var/log/oracle  
su - $ORA_OWNER -c "$ORA_HOME/bin/dbshut" >>/var/log/oracle  
echo "Done."  
echo ""  
echo "-------------------------------------------------" >> /var/log/oracle  
date +" %T %a %D : Finished." >> /var/log/oracle  
echo "-------------------------------------------------" >> /var/log/oracle  
;;  
  
'restart')  
$0 stop  
$0 start  
;;  
esac  

复制

四、设置开机自启动

systemctl enable oracle  
systemctl start oracle  

复制

五、重启生效

reboot  

复制

六、注意

所有步骤都需要在root用户下操作，不然权限不足，会导致设置失败。