We're running EBS 12.2.5 with 12c DB on RedHat Linux 7.
We're working on an automatic startup/shutdown script. For example, when there's power outage, UPS will sends a shutdown signal to the server and it shuts down the EBS and DB gracefully first before it shuts down the server.
I used and modified the script, "https://oracle-base.com/articles/linux/automating-database-startup-and-shutdown-on-linux" and startup works fine. However automatic shutdown doesn't work. When the server shuts down, it looks like the DB shuts down even before the automatic shutdown scripts runs. I guess Linux terminated DB process right away. Therefore the alert.log shows Shutting down instance (abort).
A log when the shut down script runs is as below
You are running adstpall.sh version 120.22.12020000.7
adstpall.sh: Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong.
USAGE: adstpall.sh <appsusername/appspassword> [-skipNM] [-skipAdmin] [-nothreading]
adstpall.sh <applications_username/applications_password> -secureapps [-skipNM] [-skipAdmin]
adstpall.sh -nodbchk [-skipNM] [-skipAdmin]
adstpall.sh: exiting with status 1
You are running addbctl.sh version 120.1
Shutting down database dev ...
SQL*Plus: Release 18.104.22.168.0 Production on Thu Apr 7 15:12:16 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ORA-01092: ORACLE instance terminated. Disconnection forced
Disconnected from Oracle Database 12c Enterprise Edition Release 22.214.171.124.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
addbctl.sh: exiting with status 1
You are running addlnctl.sh version 120.4
Shutting down listener process dev ...
LSNRCTL for Linux: Version 126.96.36.199.0 - Production on 07-APR-2016 15:12:16
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx)(PORT=1530)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
addlnctl.sh: exiting with status 1
addlnctl.sh: check the logfile /ebs/dev/u01/12.1.0/appsutil/log/xxx/addlnctl.txt for more information ...
I'm wondering if there's anyone who successfully created an automatic startup/shutdown script for EBS on Linux 7.