RHEL7 oracle自動起動設定めも

日記 #練習用
■/etc/sysconfig/oracledb.conf
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
ORACLE_SID=ORA11G
■/usr/lib/systemd/system/lsnrctl.service
[Unit]
Description=Oracle Listener
After=network.target

[Service]
Type=forking
EnvironmentFile=/etc/sysconfig/oracledb.conf
ExecStart=/u01/app/oracle/product/11.2.0/dbhome_1/bin/lsnrctl start
ExecStop=/u01/app/oracle/product/11.2.0/dbhome_1/bin/lsnrctl stop
User=oracle

[Install]
WantedBy=multi-user.target
■/usr/lib/systemd/system/oracledb.service
[Unit]
Description=Oracle Database service
After=network.target lsnrctl.service

[Service]
Type=forking
EnvironmentFile=/etc/sysconfig/oracledb.conf
ExecStart=/u01/app/oracle/product/11.2.0/dbhome_1/bin/dbstart $ORACLE_HOME
ExecStop=/u01/app/oracle/product/11.2.0/dbhome_1/bin/dbshut $ORACLE_HOME
User=oracle

[Install]
WantedBy=multi-user.target
■/etc/oratab
ORA11G:/u01/app/oracle/product/11.2.0/dbhome_1:Y
■設定
systemctl daemon-reload
systemctl enable lsnrctl oracledb
■DB起動が間に合わない場合 /etc/systemd/system.conf でタイムアウト変更。反映はOS reboot。
DefaultTimeoutStartSec=180s
■個々のserviceのみでタイムアウトを変更する場合は、以下の「TimeoutStartSec」で指定し、反映する
[root@o12r2 systemd]# cat /usr/lib/systemd/system/oracle.service
[Unit]
Description=Oracle Database service
After=network.target lsnrctl.service

[Service]
Type=forking
EnvironmentFile=/etc/sysconfig/oracle.conf
TimeoutStartSec=180
ExecStart=/home/oracle/app/oracle/product/12.2.0/dbhome_1/bin/dbstart $ORACLE_HOME
ExecStop=/home/oracle/app/oracle/product/12.2.0/dbhome_1/bin/dbshut $ORACLE_HOME
User=oracle

[Install]
WantedBy=multi-user.target
[root@o12r2 systemd]# systemctl daemon-reload
[root@o12r2 systemd]# systemctl show oracle -p TimeoutStartUSec
TimeoutStartUSec=3min
[root@o12r2 systemd]#
参考：タイムアウト制限変更例