In this topic I would show simple
steps of starting & stopping of EBS R12 database and application.
Environment details :-
|
Application Version
|
R12.1.3
|
|
Database Version
|
11.2.0.4
|
|
OS
|
RHEL 7.7
|
|
DB SID
|
PRODTEST
|
|
Application OS User
|
Prodtestappl
|
|
Database OS User
|
prodtestdb
|
|
R12 install base
|
/backup/prodtest
|
Important facts to remember: -
To start up R12 instance, first
start the database services i.e database and listener and then start the
application.
To shutdown R12 instance, first
shutdown the application then shutdown the listener and database.
While starting the application, the
database and listener must be running. Because the during the start up process
of application it logs into the database and starts up other components/services
related to application.
Also, during the shutdown of
application the database and listener must be up and running for the same above
reason.
Start Database Tier
First
login to Database os user.(prodtestdb)
Now
set environment file from the following path
cd
/backup/prodtest/db/tech_st/11.2.0.4 [Here /backup/prodtest
is the install base of R12 instance]
[prodtestdb@ccuine23 11.2.0.4]$ .
PRODTEST_ccuine23.env
[prodtestdb@ccuine23 PRODTEST_ccuine23]$ sqlplus /
as sysdba
SQL>startup
The
database can be started in another way..
cd
$ORACLE_HOME/appsutil/scripts/PRODTEST_ccuine23
[prodtestdb@ccuine23 PRODTEST_ccuine23]$ ./addbctl.sh start
You are running addbctl.sh version 120.1
Starting the database PRODTEST ...
SQL*Plus: Release 11.2.0.4.0 Production on Wed Dec 2 09:44:40 2020
Copyright (c) 1982, 2013, Oracle.
All rights reserved.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area 6.4137E+10 bytes
Fixed Size 2269072
bytes
Variable Size 1.2080E+10
bytes
Database Buffers 5.1942E+10
bytes
Redo Buffers 112762880
bytes
Database mounted.
Database opened.
Disconnected from Oracle Database 11g Enterprise Edition Release
11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options
addbctl.sh:
exiting with status 0
Now
start the listener
[prodtestdb@ccuine23
PRODTEST_ccuine23]$ lsnrctl start PRODTEST
Or
[prodtestdb@ccuine23
PRODTEST_ccuine23]$ ./addlnctl.sh start prodtest
Now lets verify if the database is running
SQL> select name,open_mode,database_role from v$database,v$instance;
NAME OPEN_MODE DATABASE_ROLE
--------- --------------------
----------------
PRODTEST READ WRITE PRIMARY
Start Application Tier
First login to Application OS user.(prodtestappl)
Now
set environment file from the following path
[prodtestappl@ccuine23 appl]$ cd
/backup/prodtest/apps/apps_st/appl4 [Here /backup/prodtest
is the install base of R12 instance]
[prodtestappl@ccuine23 11.2.0.4]$ . APPSPRODTEST_ccuine23.env
[prodtestappl@ccuine23 appl]$ cd
$ADMIN_SCRIPTS_HOME
[prodtestappl@ccuine23 scripts]$ adstrtal.sh
You are running adstrtal.sh version 120.15.12010000.3
Enter the APPS username: apps
Enter the APPS password:
The logfile for this session is located at
/backup/prodtest/inst/apps/PRODTEST_ccuine23/logs/appl/admin/log/adstrtal.log
Executing service control script:
/backup/prodtest/inst/apps/PRODTEST_ccuine23/admin/scripts/adopmnctl.sh
start
script returned:
****************************************************
You are running adopmnctl.sh version 120.6.12010000.5
Starting Oracle Process Manager (OPMN) ...
opmnctl: opmn started.
adopmnctl.sh: exiting with status 0
adopmnctl.sh: check the logfile
/backup/prodtest/inst/apps/PRODTEST_ccuine23/logs/appl/admin/log/adopmnctl.txt
for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/backup/prodtest/inst/apps/PRODTEST_ccuine23/admin/scripts/adalnctl.sh
start
script returned:
****************************************************
adalnctl.sh version 120.3
Checking for FNDFS executable.
Starting listener process APPS_PRODTEST.
adalnctl.sh: exiting with status 0
adalnctl.sh: check the logfile
/backup/prodtest/inst/apps/PRODTEST_ccuine23/logs/appl/admin/log/adalnctl.txt
for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/backup/prodtest/inst/apps/PRODTEST_ccuine23/admin/scripts/adapcctl.sh
start
script returned:
****************************************************
You are running adapcctl.sh version 120.7.12010000.2
Starting OPMN managed Oracle HTTP Server (OHS) instance ...
opmnctl: opmn is already running.
opmnctl: starting opmn managed processes...
adapcctl.sh: exiting with status 0
adapcctl.sh: check the logfile
/backup/prodtest/inst/apps/PRODTEST_ccuine23/logs/appl/admin/log/adapcctl.txt
for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/backup/prodtest/inst/apps/PRODTEST_ccuine23/admin/scripts/adoacorectl.sh
start
script returned:
****************************************************
You are running adoacorectl.sh version 120.13
Starting OPMN managed OACORE OC4J instance ...
adoacorectl.sh: exiting with status 0
adoacorectl.sh: check the logfile /backup/prodtest/inst/apps/PRODTEST_ccuine23/logs/appl/admin/log/adoacorectl.txt
for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/backup/prodtest/inst/apps/PRODTEST_ccuine23/admin/scripts/adformsctl.sh
start
script returned:
****************************************************
You are running adformsctl.sh
version 120.16.12010000.3
Starting OPMN managed FORMS OC4J instance
...
Calling txkChkFormsDeployment.pl to check whether latest FORMSAPP.EAR is
deployed...
Program :
/backup/prodtest/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl
started @ Wed Dec 2 10:23:47 2020
*** Log File = /backup/prodtest/inst/apps/PRODTEST_ccuine23/logs/appl/rgf/TXK/txkChkFormsDeployment_Wed_Dec_2_10_23_47_2020/txkChkFormsDeployment_Wed_Dec_2_10_23_47_2020.log
File
"/backup/prodtest/apps/tech_st/10.1.3/j2ee/forms/applications/forms/formsweb/WEB-INF/lib/frmsrv.jar"
exists. Proceeding to check the size...
=============================================
*** Latest formsapp.ear has been deployed ***
=============================================
Program :
/backup/prodtest/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl
completed @ Wed Dec 2 10:23:47 2020
Perl script txkChkFormsDeployment.pl got executed successfully
adformsctl.sh: exiting with status 0
adformsctl.sh: check the logfile
/backup/prodtest/inst/apps/PRODTEST_ccuine23/logs/appl/admin/log/adformsctl.txt
for more information ...
.end std out.
*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
*** Log File =
/backup/prodtest/inst/apps/PRODTEST_ccuine23/logs/appl/rgf/TXK/txkChkFormsDeployment_Wed_Dec_2_10_23_47_2020/txkChkFormsDeployment_Wed_Dec_2_10_23_47_2020.log
.end err out.
****************************************************
Executing service control script:
/backup/prodtest/inst/apps/PRODTEST_ccuine23/admin/scripts/adoafmctl.sh
start
script returned:
****************************************************
You are running adoafmctl.sh version 120.8
Starting OPMN managed OAFM OC4J instance
...
adoafmctl.sh: exiting with status 0
adoafmctl.sh: check the logfile
/backup/prodtest/inst/apps/PRODTEST_ccuine23/logs/appl/admin/log/adoafmctl.txt
for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/backup/prodtest/inst/apps/PRODTEST_ccuine23/admin/scripts/adcmctl.sh start
script returned:
****************************************************
You are running adcmctl.sh version 120.17.12010000.5
Starting concurrent manager for PRODTEST ...
Starting PRODTEST_1202@PRODTEST Internal Concurrent Manager
Default printer is noprint
adcmctl.sh: exiting with status 0
adcmctl.sh: check the logfile
/backup/prodtest/inst/apps/PRODTEST_ccuine23/logs/appl/admin/log/adcmctl.txt
for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/backup/prodtest/inst/apps/PRODTEST_ccuine23/admin/scripts/jtffmctl.sh
start
script returned:
****************************************************
You are running jtffmctl.sh version 120.3
Validating Fulfillment patch level via
/backup/prodtest/apps/apps_st/comn/java/classes
Fulfillment patch level validated.
Starting Fulfillment Server for PRODTEST on port 9321 ...
jtffmctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
All enabled services for this node are started.
adstrtal.sh: Exiting with status 0
adstrtal.sh:
check the logfile
/backup/prodtest/inst/apps/PRODTEST_ccuine23/logs/appl/admin/log/adstrtal.log
for more information ...
Note:
It is important to make sure that all sciprts are executed with status 0. Generally,
the status 0 ensures the services are started properly.
Shutdown Application
Tier
Login
to Application OS User.(prodtestappl)
Now
set environment file from the following path
[prodtestappl@ccuine23 appl]$ cd
/backup/prodtest/apps/apps_st/appl4 [Here /backup/prodtest
is the install base of R12 instance]
[prodtestappl@ccuine23 11.2.0.4]$ . APPSPRODTEST_ccuine23.env
[prodtestappl@ccuine23 appl]$ cd
$ADMIN_SCRIPTS_HOME
[prodtestappl@ccuine23 scripts]$ adstpal.sh
Note: It is important to make sure
all processes related to application are down.
To make sure no process is alive
from application end
ps –ef | grep FND | grep
prodtestappl
Make sure no output is shown from the above command
Once no process are shown we can
go ahead with the database shutdown process.
Shutdown Database Tier
Login
to Database os user.(prodtestdb)
Now
set environment file from the following path
cd
/backup/prodtest/db/tech_st/11.2.0.4 [Here /backup/prodtest
is the install base of R12 instance]
[prodtestdb@ccuine23 11.2.0.4]$ .
PRODTEST_ccuine23.env
[prodtestdb@ccuine23 PRODTEST_ccuine23]$ sqlplus /
as sysdba
SQL> shut immediate
Or
cd
$ORACLE_HOME/appsutil/scripts/PRODTEST_ccuine23
[prodtestdb@ccuine23 PRODTEST_ccuine23]$ ./addbctl.sh stop immediate
Now stop the listener service
[prodtestdb@ccuine23 PRODTEST_ccuine23]$ lsnrctl stop PRODTEST
Or
[prodtestdb@ccuine23 PRODTEST_ccuine23]$ ./addbctl.sh stop immediate
[prodtestdb@ccuine23
PRODTEST_ccuine23]$ ./addlnctl.sh stop PRODTEST
So this concludes the overall process of startup and shutdown of EBS R12 instance!
