How restart Oracle Database with OL8 Server Reboot

[dba_senior]

Hi,
I'd like to Know how the Oracle database and listener can automatically shutdown and startup when the server reboots.

#ORATAB
[oracle@ ~]# cat /etc/oratab

ORCL:/u01/app/oracle/product/19c/dbhome_1:Y

#Oracle Version (Single Instance)
Oracle Database 19c Enterprise Edition Version 19.12.0.0.0

#OS Version
[oracle@ ~]$ cat /etc/os-release
NAME="Oracle Linux Server"
VERSION="8.6"
PRETTY_NAME="Oracle Linux Server 8.6"


What are the steps to restart automatically Oracle Database when the server reboots?

Thanks in Advance!

[mbobak]

Well, particulerly since you're on Linux, I recommend using ASM to mnage the disks, becuase when you install ASM/Grid, you get Oracle Restart included, which is essentially the single instance version of clusterware.

There may be a bit of a learning curve, but you get the advantages of Oracle Restart, and the benefits of ASM/ASM Filter Driver.

If you *really* are determined to not use ASM, it is possible to use Oracle Restart without ASM. I have never done it, so I can't really speak to how it works, but I found this blog about how to do it:
https://asanga-pradeep.blogspot.com/...thout-asm.html

I've never done it, so I can't recommend it, but it is apparently possible.

I recommend using ASM.

Hope that helps,

-Mark