How to Start Database and Application in ORACLE EBS R12.2

 

 To Start the Database(12c) :

In the ORACLE_HOME source the environment file (ie VIS_ebs-db.env)
 
 
 
[oracle@ebs-db 12.1.0]$ . VIS_ebs-db.env 
 
To connect the SQLPLUS :
 
[oracle@ebs-db 12.1.0]$ sqlplus / as sysdba
 
SQL*Plus: Release 12.1.0.2.0 Production on Mon Jul 1 11:25:09 2021
 
Copyright (c) 1982, 2014, Oracle.  All rights reserved.
 
Connected to an idle instance.
 
To startup the Database :
 
SQL> startup;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
 
Total System Global Area 2147483648 bytes
Fixed Size     2926472 bytes
Variable Size   520095864 bytes
Database Buffers 1610612736 bytes
Redo Buffers    13848576 bytes
Database mounted.
Database opened.
 
To check the status of the Database:
 
SQL> select name,open_mode from v$database;
 
NAME   OPEN_MODE
——— ——————–
VIS   READ WRITE
 
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
 
To start the Listener :
 
[oracle@ebs-db 12.1.0]$ lsnrctl start VIS
 
LSNRCTL for Linux: Version 12.1.0.2.0 – Production on 01-JUL-2021 11:28:09
 
Copyright (c) 1991, 2014, Oracle.  All rights reserved.
 
Starting /visdb/VIS/db/tech_st/12.1.0/bin/tnslsnr: please wait…
 
TNSLSNR for Linux: Version 12.1.0.2.0 – Production
System parameter file is /visdb/VIS/db/tech_st/12.1.0/network/admin/VIS_ebs-db/listener.ora
Log messages written to /visdb/VIS/db/tech_st/12.1.0/admin/VIS_ebs-db/diag/tnslsnr/ebs-db/sit/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebs-db.xxx.com)(PORT=1531)))
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ebs-db.xxx.com)(PORT=1531)))
STATUS of the LISTENER
————————
Alias                     VIS
Version                   TNSLSNR for Linux: Version 12.1.0.2.0 – Production
Start Date                01-JUL-2021 11:28:09
Uptime                    4 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /visdb/VIS/db/tech_st/12.1.0/network/admin/VIS_ebs-db/listener.ora
Listener Log File         /visdb/VIS/db/tech_st/12.1.0/admin/VIS_ebs-db/diag/tnslsnr/ebs-db/sit/alert/log.xml
 
 
 
 
To start the Application Service :
 
In Application Server Source the environment file (ie , EBSapps.env )
 
[applmgr@ebs-app VIS]$ . EBSapps.env 
 
  E-Business Suite Environment Information
  —————————————-
  RUN File System           : /visapp/VIS/fs1/EBSapps/appl
  PATCH File System         : /visapp/VIS/fs2/EBSapps/appl
  Non-Editioned File System : /visapp/VIS/fs_ne
 
 
  DB Host: ebs-db.bescom.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@ebs-app VIS]$ cd $ADMIN_SCRIPTS_HOME
[applmgr@ebs-app scripts]$ ls
adadminsrvctl.sh  adcmctl.sh          adnodemgrctl.sh  adstrtal.sh       java.sh      mwactlwrpr.sh
adalnctl.sh       adexecsql.pl        adopmnctl.sh     cz64bitengine.pl  jtffmctl.sh  pon64bitengine.pl
adapcctl.sh       adformsrvctl.sh     adpreclone.pl    gsmstart.sh       msc          shtiloglib.pl
adautocfg.sh      admanagedsrvctl.sh  adstpall.sh      ieo               mwactl.sh
 
To start the Application Server script is adstrtal.sh
 
[applmgr@ebs-app scripts]$ adstrtal.sh
 
You are running adstrtal.sh version 120.24.12020000.11
 
 
Enter the APPS username: apps
 
Enter the APPS password:  *****
Enter the WebLogic Server password: *******
 
The logfile for this session is located at /visapp/VIS/fs1/inst/apps/VIS_ebs-app/logs/appl/admin/log/adstrtal.log
 
Executing service control script:
/visapp/VIS/fs1/inst/apps/VIS_ebs-app/admin/scripts/jtffmctl.sh start 
Timeout specified in context file: 100 second(s) 
 
script returned:
****************************************************
You are running jtffmctl.sh version 120.3.12020000.4
 
Validating Fulfillment patch level via /visapp/VIS/fs1/EBSapps/comn/java/classes
Fulfillment patch level validated.
Starting Fulfillment Server for VIS on port 9311 …
 
jtffmctl.sh: exiting with status 0
 
 
.end std out.
 
.end err out.
 
****************************************************
 
 
 
Executing service control script:
/visapp/VIS/fs1/inst/apps/VIS_ebs-app/admin/scripts/adopmnctl.sh start 
Timeout specified in context file: 100 second(s) 
 
script returned:
****************************************************
 
You are running adopmnctl.sh version 120.0.12020000.2
 
Starting Oracle Process Manager (OPMN) …
 
adopmnctl.sh: exiting with status 0
 
adopmnctl.sh: check the logfile /visapp/VIS/fs1/inst/apps/VIS_ebs-app/logs/appl/admin/log/adopmnctl.txt for more information …  
 
 
.end std out.
 
.end err out.
 
****************************************************
 
 
 
Executing service control script:
/visapp/VIS/fs1/inst/apps/VIS_ebs-app/admin/scripts/adapcctl.sh start 
Timeout specified in context file: 100 second(s) 
 
script returned:
****************************************************
 
You are running adapcctl.sh version 120.0.12020000.6
 
Starting OPMN managed Oracle HTTP Server (OHS) instance …
 
adapcctl.sh: exiting with status 0
 
adapcctl.sh: check the logfile /visapp/VIS/fs1/inst/apps/VIS_ebs-app/logs/appl/admin/log/adapcctl.txt for more information …  
 
 
.end std out.
 
.end err out.
 
****************************************************
Executing service control script:
/visapp/VIS/fs1/inst/apps/VIS_ebs-app/admin/scripts/adnodemgrctl.sh start -nopromptmsg 
Timeout specified in context file: -1 second(s) 
 
script returned:
****************************************************
 
You are running adnodemgrctl.sh version 120.11.12020000.12
 
 
Calling txkChkEBSDependecies.pl to perform dependency checks for ALL MANAGED SERVERS
Perl script txkChkEBSDependecies.pl got executed successfully
 
 
Starting the Node Manager…
Refer /visapp/VIS/fs1/inst/apps/VIS_ebs-app/logs/appl/admin/log/adnodemgrctl.txt for details
 
NodeManager log is located at /visapp/VIS/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1
 
adnodemgrctl.sh: exiting with status 0
 
adnodemgrctl.sh: check the logfile /visapp/VIS/fs1/inst/apps/VIS_ebs-app/logs/appl/admin/log/adnodemgrctl.txt for more information …  
 
 
.end std out.
*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
*** Log File = /visapp/VIS/fs1/inst/apps/VIS_ebs-app/logs/appl/rgf/TXK/txkChkEBSDependecies_Mon_Jul_1_21_32_53_2021/txkChkEBSDependecies_Mon_Jul_1_21_32_53_2021.log 
 
.end err out.
 
****************************************************
 
 
 
Executing service control script:
/visapp/VIS/fs1/inst/apps/VIS_ebs-app/admin/scripts/adalnctl.sh start 
Timeout specified in context file: 100 second(s) 
 
script returned:
****************************************************
 
adalnctl.sh version 120.3.12020000.4
 
Checking for FNDFS executable.
Starting listener process APPS_VIS.
 
adalnctl.sh: exiting with status 0
 
 
adalnctl.sh: check the logfile /visapp/VIS/fs1/inst/apps/VIS_ebs-app/logs/appl/admin/log/adalnctl.txt for more information …  
 
 
.end std out.
 
.end err out.
 
****************************************************
 
 
 
Executing service control script:
/visapp/VIS/fs1/inst/apps/VIS_ebs-app/admin/scripts/adcmctl.sh start 
Timeout specified in context file: 1000 second(s) 
 
script returned:
****************************************************
 
You are running adcmctl.sh version 120.19.12020000.7
 
Starting concurrent manager for VIS …
Starting VIS_0705@VIS Internal Concurrent Manager
Default printer is noprint
 
adcmctl.sh: exiting with status 0
 
 
adcmctl.sh: check the logfile /visapp/VIS/fs1/inst/apps/VIS_ebs-app/logs/appl/admin/log/adcmctl.txt for more information …  
 
 
.end std out.
 
.end err out.
 
****************************************************
 
 
 
Executing service control script:
/visapp/VIS/fs1/inst/apps/VIS_ebs-app/admin/scripts/adadminsrvctl.sh start -nopromptmsg 
Timeout specified in context file: -1 second(s) 
 
script returned:
****************************************************
 
You are running adadminsrvctl.sh version 120.10.12020000.11
 
Starting WLS Admin Server…
Refer /visapp/VIS/fs1/inst/apps/VIS_ebs-app/logs/appl/admin/log/adadminsrvctl.txt for details
 
AdminServer logs are located at /visapp/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain/servers/AdminServer/logs
 
adadminsrvctl.sh: exiting with status 0
 
adadminsrvctl.sh: check the logfile /visapp/VIS/fs1/inst/apps/VIS_ebs-app/logs/appl/admin/log/adadminsrvctl.txt for more information …  
 
 
.end std out.
 
.end err out.
 
****************************************************
 
 
 
 
 
Executing service control script:
/visapp/VIS/fs1/inst/apps/VIS_ebs-app/admin/scripts/admanagedsrvctl.sh start forms_server1 -nopromptmsg
Timeout specified in context file: -1 second(s) 
 
script returned:
****************************************************
 
You are running admanagedsrvctl.sh version 120.14.12020000.12
 
Starting forms_server1…
 
Server specific logs are located at /visapp/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain/servers/forms_server1/logs
 
admanagedsrvctl.sh: exiting with status 0
 
admanagedsrvctl.sh: check the logfile /visapp/VIS/fs1/inst/apps/VIS_ebs-app/logs/appl/admin/log/adformsctl.txt for more information …  
 
 
.end std out.
 
.end err out.
 
****************************************************
 
 
 
Executing service control script:
/visapp/VIS/fs1/inst/apps/VIS_ebs-app/admin/scripts/admanagedsrvctl.sh start oafm_server1 -nopromptmsg
Timeout specified in context file: -1 second(s) 
 
script returned:
****************************************************
 
You are running admanagedsrvctl.sh version 120.14.12020000.12
 
Starting oafm_server1…
 
Server specific logs are located at /visapp/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain/servers/oafm_server1/logs
 
admanagedsrvctl.sh: exiting with status 0
 
admanagedsrvctl.sh: check the logfile /visapp/VIS/fs1/inst/apps/VIS_ebs-app/logs/appl/admin/log/adoafmctl.txt for more information …  
 
 
.end std out.
 
.end err out.
 
****************************************************
 
 
 
Executing service control script:
/visapp/VIS/fs1/inst/apps/VIS_ebs-app/admin/scripts/admanagedsrvctl.sh start oacore_server1 -nopromptmsg
Timeout specified in context file: -1 second(s) 
 
script returned:
****************************************************
 
You are running admanagedsrvctl.sh version 120.14.12020000.12
 
Starting oacore_server1…
 
Server specific logs are located at /visapp/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain/servers/oacore_server1/logs
 
admanagedsrvctl.sh: exiting with status 0
 
admanagedsrvctl.sh: check the logfile /visapp/VIS/fs1/inst/apps/VIS_ebs-app/logs/appl/admin/log/adoacorectl.txt for more information …  
 
 
.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 /visapp/VIS/fs1/inst/apps/VIS_ebs-app/logs/appl/admin/log/adstrtal.log for more
 
information …  
 
[applmgr@ebs-app scripts]$ 
 
To Check the Status of the Application:
 
applmgr@ebs-app scripts]$ ps -ef | grep tns
root        37     2  0 Jul04 ?        00:00:00 [netns]
applmgr  14192     1  0 21:33 ?        00:00:00 /visapp/VIS/fs1/EBSapps/10.1.2/bin/tnslsnr APPS_VIS -inherit
applmgr  17290 13002  0 21:46 pts/1    00:00:00 grep –color=auto tns
[applmgr@ebs-app scripts]$ 
 
 

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Leave a Comment

Your email address will not be published. Required fields are marked *