How stop application and shutdown oracle Database in R12.2 ?

 To Stop the Application Services:

 
In Application Server Source the environment file (ie, EBSapps.env )
[applmgr@visebsapp VIS]$ . EBSapps.env
  E-Business Suite Environment Information
  —————————————-
  RUN File System           : /visapp/VIS/fs2/EBSapps/appl
  PATCH File System         : /visapp/VIS/fs1/EBSapps/appl
  Non-Editioned File System : /visapp/VIS/fs_ne
  DB Host: ebs-db.xxx.com  Service/SID: VIS
  E-Business Suite Environment Setting
  ————————————
  – Enter [R/r] for sourcing Run File System Environment file, or
  – Enter [P/p] for sourcing Patch File System Environment file, or
  – Enter anything else to exit
  Please choose the environment file you wish to source [R/P]:R
  Sourcing the RUN File System …

The Application Tier control scripts available in $ADMIN_SCRIPTS_HOME

[applmgr@visebsapp VIS]$ cd $ADMIN_SCRIPTS_HOME
[applmgr@visebsapp scripts]$ ls
03292126.log      adautocfg.sh        adnodemgrctl.sh  cz64bitengine.pl    jtffmctl.sh        shtiloglib.pl
05052013.log      adcmctl.sh          adopmnctl.sh     EBSProvisioner.log  msc
adadminsrvctl.sh  adexecsql.pl        adpreclone.pl    gsmstart.sh         mwactl.sh
adalnctl.sh       adformsrvctl.sh     adstpall.sh      ieo                 mwactlwrpr.sh
adapcctl.sh       admanagedsrvctl.sh  adstrtal.sh      java.sh             pon64bitengine.pl
To stop the Application Server script is
[applmgr@visebsapp scripts]$ adstpall.sh
You are running adstpall.sh version 120.22.12020000.7
Enter the APPS username: apps
Enter the APPS password: *****
Enter the WebLogic Server password: *********
The logfile for this session is located at /visapp/VIS/fs2/inst/apps/VIS_visebsapp/logs/appl/admin/log/adstpall.log
Executing service control script:
/visapp/VIS/fs2/inst/apps/VIS_visebsapp/admin/scripts/adcmctl.sh stop
Timeout specified in context file: 1000 second(s)
script returned:
****************************************************
You are running adcmctl.sh version 120.19.12020000.7
Shutting down concurrent managers for DEV …
ORACLE Password:
Submitted request 569420 for CONCURRENT FND SHUTDOWN
adcmctl.sh: exiting with status 0
adcmctl.sh: check the logfile /visapp/VIS/fs2/inst/apps/VIS_visebsapp/logs/appl/admin/log/adcmctl.txt for more information …
.end std out.
.end err out.
****************************************************
Executing service control script:
/visapp/VIS/fs2/inst/apps/VIS_visebsapp/admin/scripts/adapcctl.sh stop
Timeout specified in context file: 100 second(s)
script returned:
****************************************************
You are running adapcctl.sh version 120.0.12020000.6
Stopping OPMN managed Oracle HTTP Server (OHS) instance …
adapcctl.sh: exiting with status 0
adapcctl.sh: check the logfile /visapp/VIS/fs2/inst/apps/VIS_visebsapp/logs/appl/admin/log/adapcctl.txt for more information …
.end std out.
.end err out.
****************************************************
Executing service control script:
/visapp/VIS/fs2/inst/apps/VIS_visebsapp/admin/scripts/jtffmctl.sh stop
Timeout specified in context file: 100 second(s)
script returned:
****************************************************
You are running jtffmctl.sh version 120.3.12020000.4
Shutting down Fulfillment Server for DEV on port 9306 …
jtffmctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/visapp/VIS/fs2/inst/apps/VIS_visebsapp/admin/scripts/adopmnctl.sh stop
Timeout specified in context file: 100 second(s)
script returned:
****************************************************
You are running adopmnctl.sh version 120.0.12020000.2
Stopping Oracle Process Manager (OPMN)  and the managed processes …
opmnctl stopall: stopping opmn and all managed processes…
adopmnctl.sh: exiting with status 0
adopmnctl.sh: check the logfile /visapp/VIS/fs2/inst/apps/VIS_visebsapp/logs/appl/admin/log/adopmnctl.txt for more information …
.end std out.
.end err out.
****************************************************
Executing service control script:
/visapp/VIS/fs2/inst/apps/VIS_visebsapp/admin/scripts/admanagedsrvctl.sh abort oafm_server1 -nopromptmsg
Timeout specified in context file: -1 second(s)
script returned:
****************************************************
You are running admanagedsrvctl.sh version 120.14.12020000.12
Stopping oafm_server1…
Refer /visapp/VIS/fs2/inst/apps/VIS_visebsapp/logs/appl/admin/log/adoafmctl.txt for details
Server specific logs are located at /visapp/VIS/fs2/FMW_Home/user_projects/domains/EBS_domain/servers/oafm_server1/logs
admanagedsrvctl.sh: exiting with status 0
admanagedsrvctl.sh: check the logfile /visapp/VIS/fs2/inst/apps/VIS_visebsapp/logs/appl/admin/log/adoafmctl.txt for more information …
.end std out.
.end err out.
****************************************************
Executing service control script:
/visapp/VIS/fs2/inst/apps/VIS_visebsapp/admin/scripts/admanagedsrvctl.sh abort forms_server1 -nopromptmsg
Timeout specified in context file: -1 second(s)
script returned:
****************************************************
You are running admanagedsrvctl.sh version 120.14.12020000.12
Stopping forms_server1…
Refer /visapp/VIS/fs2/inst/apps/VIS_visebsapp/logs/appl/admin/log/adformsctl.txt for details
Server specific logs are located at /visapp/VIS/fs2/FMW_Home/user_projects/domains/EBS_domain/servers/forms_server1/logs
admanagedsrvctl.sh: exiting with status 0
admanagedsrvctl.sh: check the logfile /visapp/VIS/fs2/inst/apps/VIS_visebsapp/logs/appl/admin/log/adformsctl.txt for more information …
.end std out.
.end err out.
****************************************************
Executing service control script:
/visapp/VIS/fs2/inst/apps/VIS_visebsapp/admin/scripts/admanagedsrvctl.sh abort oacore_server1 -nopromptmsg
Timeout specified in context file: -1 second(s)
script returned:
****************************************************
You are running admanagedsrvctl.sh version 120.14.12020000.12
Stopping oacore_server1…
Refer /visapp/VIS/fs2/inst/apps/VIS_visebsapp/logs/appl/admin/log/adoacorectl.txt for details
Server specific logs are located at /visapp/VIS/fs2/FMW_Home/user_projects/domains/EBS_domain/servers/oacore_server1/logs
admanagedsrvctl.sh: exiting with status 0
admanagedsrvctl.sh: check the logfile /visapp/VIS/fs2/inst/apps/VIS_visebsapp/logs/appl/admin/log/adoacorectl.txt for more information …
.end std out.
.end err out.
****************************************************
Executing service control script:
/visapp/VIS/fs2/inst/apps/VIS_visebsapp/admin/scripts/adalnctl.sh stop
Timeout specified in context file: 100 second(s)
script returned:
****************************************************
adalnctl.sh version 120.3.12020000.4
Shutting down listener process APPS_DEV.
adalnctl.sh: exiting with status 0
adalnctl.sh: check the logfile /visapp/VIS/fs2/inst/apps/VIS_visebsapp/logs/appl/admin/log/adalnctl.txt for more information …
.end std out.
.end err out.
****************************************************
Executing service control script:
/visapp/VIS/fs2/inst/apps/VIS_visebsapp/admin/scripts/adadminsrvctl.sh stop -nopromptmsg
Timeout specified in context file: -1 second(s)
script returned:
****************************************************
You are running adadminsrvctl.sh version 120.10.12020000.11
Stopping WLS Admin Server…
Refer /visapp/VIS/fs2/inst/apps/VIS_visebsapp/logs/appl/admin/log/adadminsrvctl.txt for details
AdminServer logs are located at /visapp/VIS/fs2/FMW_Home/user_projects/domains/EBS_domain/servers/AdminServer/logs
adadminsrvctl.sh: exiting with status 0
adadminsrvctl.sh: check the logfile /visapp/VIS/fs2/inst/apps/VIS_visebsapp/logs/appl/admin/log/adadminsrvctl.txt for more information …
.end std out.
.end err out.
****************************************************
Executing service control script:
/visapp/VIS/fs2/inst/apps/VIS_visebsapp/admin/scripts/adnodemgrctl.sh stop -nopromptmsg
Timeout specified in context file: -1 second(s)
script returned:
****************************************************
You are running adnodemgrctl.sh version 120.11.12020000.12
NodeManager log is located at /visapp/VIS/fs2/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1
adnodemgrctl.sh: exiting with status 0
adnodemgrctl.sh: check the logfile /visapp/VIS/fs2/inst/apps/VIS_visebsapp/logs/appl/admin/log/adnodemgrctl.txt for more information …
.end std out.
.end err out.
****************************************************
All enabled services on this node are stopped.
adstpall.sh:Exiting with status 0
adstpall.sh: check the logfile /visapp/VIS/fs2/inst/apps/VIS_visebsapp/logs/appl/admin/log/adstpall.log for more information …
[applmgr@visebsapp scripts]$

To Shutdown the oracle database (12c) :

In the ORACLE_HOME source the environment file (ie VIS_ebs-db.env)
[oracle@visebsdb 12.1.0]$ . VIS_ebs-db.env

To Connect the SQLPLUS

[oracle@visebsdb 12.1.0]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Sun Aug 8 22:52:21 2021
Copyright (c) 1982, 2014, Oracle.  All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

To Shut down the Database

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
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
[oracle@visebsdb 12.1.0]$ lsnrctl stop VIS
LSNRCTL for Linux: Version 12.1.0.2.0 – Production on 08-AUG-2021 22:53:37
Copyright (c) 1991, 2014, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ebs-db.xxx.com)(PORT=1526)))
The command completed successfully
[oracle@visebsdb 12.1.0]$

Leave a Comment

Your email address will not be published.