7 Replies Latest reply on Jul 4, 2016 8:35 PM by Bashar.

    Automatic Shutdown EBS/DB on Linux 7

    User254377

      Hi All,

       

      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 -mode=allnodes

      adstpall.sh: exiting with status 1

      You are running addbctl.sh version 120.1

      Shutting down database dev ...

      SQL*Plus: Release 12.1.0.2.0 Production on Thu Apr 7 15:12:16 2016

      Copyright (c) 1982, 2014, Oracle. All rights reserved.

      Connected.

      ORA-01092: ORACLE instance terminated. Disconnection forced

      Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

      With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

      addbctl.sh: exiting with status 1

      Logfile: /ebs/dev/u01/12.1.0/appsutil/log/xxx/addlnctl.txt

      You are running addlnctl.sh version 120.4

      Shutting down listener process dev ...

      LSNRCTL for Linux: Version 12.1.0.2.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.

       

      Thanks,