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]$