Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

failure startup oracle at bootup

hello,

Could you give me some advice on the systemd service and the script it starts which in turn run oracle. I hv no idea why the systemd service will ruin the oracle listener. whenever I start the listener this way, it shows "support no service." if i run the 'lsnrctl start' and 'dbstart' manually, it has no problem. i can query the db from local or remote. the following are the scripts. Thanks

oracle.sh

! /bin/bash

script used by oracle.service

export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1; export ORACLE_SID=orcl; export ORACLE_BASE=/home/oracle/app/oracle/product/11.2.0; $ORACLE_HOME/bin/dbstart $ORACLE_HOME; $ORACLE_HOME/bin/lsnrctl start LISTENER;

oracle.service

[Unit] Description=Oracle database server After=syslog.target After=network.target

[Service] Type=simple User=oracle Group=oinstall ExecStart=/bin/oracle.sh

[Install] WantedBy=multi-user.target

failure startup oracle at bootup

hello,

Could you give me some advice advices on the systemd service and the script it starts which in turn run oracle. I hv no idea why the systemd service will ruin the oracle listener. whenever I start the listener this way, it shows "support no service." if i run the 'lsnrctl start' and 'dbstart' manually, it has no problem. i can query the db from local or remote. the following are the scripts. Thanks

oracle.sh

! /bin/bash

  

#! /bin/bash # script used by oracle.service

oracle.service export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1 export ORACLE_SID=orcl export ORACLE_BASE=/home/oracle/app/oracle/product/11.2.0

export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1; export ORACLE_SID=orcl; export ORACLE_BASE=/home/oracle/app/oracle/product/11.2.0; $ORACLE_HOME/bin/dbstart $ORACLE_HOME; $ORACLE_HOME/bin/lsnrctl start LISTENER;

LISTENER;

oracle.service

 [Unit]
Description=Oracle database server
After=syslog.target
After=network.target

After=network.target

[Service] Type=simple User=oracle Group=oinstall ExecStart=/bin/oracle.sh

ExecStart=/bin/oracle.sh

[Install] WantedBy=multi-user.target

WantedBy=multi-user.target