How to start database and Apps

(Release 12)

Login as database user
cd $ORACLE_HOME/appsutil/scripts/<SID_hostname>

./addbctl.sh start <Database Name> : To start Database

./addlnctl.sh start <Listener Name> : To start Listener

Login as apps user “applmgr”

cd $APPLCSF/scripts/<SID_hostname>
./adstrtal.sh apps/<apps_password>

You can stop the application by:
Login as apps user “applmgr”
./adstpall.sh apps/<apps_password>

For stopping listener and database:
./addlnctl.sh stop <listener_name> : Stop the listener

./addbctl.sh stop immediate : would carry “shutdown immediate” at database

================= Release 12 log ==============

[oracle@apps ~]$ . APPSVIS_ebs.env

Start database and listener before starting middle tier

Login as database user , Locate “addbctl.sh” and run this script

[oracle@apps ~]$ ./addbctl.sh

You are running addbctl.sh version 120.1

addbctl.sh: too few arguments specified.

addbctl.sh [start|stop] {normal|immediate|abort}

[oracle@apps ~]$ ./addbctl.sh start

You are running addbctl.sh version 120.1

Starting the database VIS …

SQL*Plus: Release 10.2.0.3.0 – Production on Sat Feb 14 13:07:25 2009

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to an idle instance.
ORACLE instance started.

Total System Global Area 159383552 bytes
Fixed Size 1260600 bytes
Variable Size 88081352 bytes
Database Buffers 58720256 bytes
Redo Buffers 11321344 bytes
Database mounted.
Database opened.
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – Production
With the Partitioning, OLAP and Data Mining options

addbctl.sh: exiting with status 0

2. Start listener

[oracle@apps ~]$ cd /oradb/oracle/VIS/db/tech_st/10.2.0/appsutil/scripts/VIS_apps/
[oracle@apps VIS_apps]$ ./addlnctl.sh start VIS

You are running addlnctl.sh version 120.1

Logfile: /oradb/oracle/VIS/db/tech_st/10.2.0/appsutil/log/VIS_apps/addlnctl.txt

Starting listener process VIS …

addlnctl.sh: exiting with status 0
[oracle@apps VIS_apps]$

Let’s start the middle Tier

[applmgr@apps scripts]$ ./adstrtal.sh apps/apps

You are running adstrtal.sh version 120.13.12000000.3

Executing service control script:
/orapps/oracle/VIS/inst/apps/VIS_apps/admin/scripts/adopmnctl.sh start
script returned:
****************************************************

You are running adopmnctl.sh version 120.4.12000000.3

Starting Oracle Process Manager (OPMN) …

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /orapps/oracle/VIS/inst/apps/VIS_apps/logs/appl/admin/log/adopmnctl.txt for more information …

.end std out.

.end err out.

****************************************************

Executing service control script:
/orapps/oracle/VIS/inst/apps/VIS_apps/admin/scripts/adapcctl.sh start
script returned:
****************************************************

You are running adapcctl.sh version 120.6.12000000.2

Starting OPMN managed Oracle HTTP Server (OHS) instance …

adapcctl.sh: exiting with status 150

adapcctl.sh: check the logfile /orapps/oracle/VIS/inst/apps/VIS_apps/logs/appl/admin/log/adapcctl.txt for more information …

.end std out.

.end err out.

****************************************************

Executing service control script:
/orapps/oracle/VIS/inst/apps/VIS_apps/admin/scripts/adoacorectl.sh start
script returned:
****************************************************

You are running adoacorectl.sh version 120.11.12000000.2

Starting OPMN managed OACORE OC4J instance …

adoacorectl.sh: exiting with status 204

adoacorectl.sh: check the logfile /orapps/oracle/VIS/inst/apps/VIS_apps/logs/appl/admin/log/adoacorectl.txt for more information …

.end std out.

.end err out.

****************************************************

Executing service control script:
/orapps/oracle/VIS/inst/apps/VIS_apps/admin/scripts/adformsctl.sh start
script returned:
****************************************************

You are running adformsctl.sh version 120.12.12000000.3

Starting OPMN managed FORMS OC4J instance …

adformsctl.sh: exiting with status 204

adformsctl.sh: check the logfile /orapps/oracle/VIS/inst/apps/VIS_apps/logs/appl/admin/log/adformsctl.txt for more information …

.end std out.

.end err out.

****************************************************

Executing service control script:
/orapps/oracle/VIS/inst/apps/VIS_apps/admin/scripts/adoafmctl.sh start
script returned:
****************************************************

You are running adoafmctl.sh version 120.6.12000000.2

Starting OPMN managed OAFM OC4J instance …

adoafmctl.sh: exiting with status 204

adoafmctl.sh: check the logfile /orapps/oracle/VIS/inst/apps/VIS_apps/logs/appl/admin/log/adoafmctl.txt for more information …

.end std out.

.end err out.

****************************************************

Executing service control script:
/orapps/oracle/VIS/inst/apps/VIS_apps/admin/scripts/adalnctl.sh start
script returned:
****************************************************

adalnctl.sh version 120.3

Checking for FNDFS executable.
Starting listener process APPS_VIS.

adalnctl.sh: exiting with status 0

adalnctl.sh: check the logfile /orapps/oracle/VIS/inst/apps/VIS_apps/logs/appl/admin/log/adalnctl.txt for more information …

.end std out.

.end err out.

****************************************************

Executing service control script:
/orapps/oracle/VIS/inst/apps/VIS_apps/admin/scripts/adcmctl.sh start
script returned:
****************************************************

You are running adcmctl.sh version 120.14

Starting concurrent manager for VIS …
Starting VIS_0214@VIS Internal Concurrent Manager
Default printer is noprint

adcmctl.sh: exiting with status 0

adcmctl.sh: check the logfile /orapps/oracle/VIS/inst/apps/VIS_apps/logs/appl/admin/log/adcmctl.txt for more information …

.end std out.

.end err out.

****************************************************

Executing service control script:
/orapps/oracle/VIS/inst/apps/VIS_apps/admin/scripts/jtffmctl.sh start
script returned:
****************************************************

You are running jtffmctl.sh version 120.3

Validating Fulfillment patch level via /orapps/oracle/VIS/apps/apps_st/comn/java/classes
Fulfillment patch level validated.
Starting Fulfillment Server for VIS on port 9300 …

jtffmctl.sh: exiting with status 0

.end std out.

.end err out.

****************************************************

adstrtal.sh: Exiting with status 4

adstrtal.sh: check the logfile /orapps/oracle/VIS/inst/apps/VIS_apps/logs/appl/admin/log/adstrtal.log for more information …

(Release 11)

Execute the following script in the sequence shown below

$ORACLE_HOME/appsutil/scripts/VIS_vision/addbctl.sh start $ORACLE _HOME/appsutil/scripts/VIS_vision/addlnctl.sh start VIS /u01/oracle/viscomn/admin/scripts/VIS_vision/adstrtal.sh apps/apps

To stop the services execute the script in the following sequence.

/u01/oracle/viscomn/admin/scripts/VIS_vision/adstpall.sh apps/apps $ORACLE_HOME/appsutil/scripts/VIS_vision/addlnctl.sh stop VIS $ORACLE_HOME/appsutil/scripts/VIS_vision/addbctl.sh stop immediate