You can see the installation blog at :
http://www.oracledbasagar.blogspot.in/2012/12/oracle-e-business-suite-1211.html
So,
From above screenshots you can see the locations for
Database and Application Base Directory ,i.e
Database BASE DIRECTORY : /u01/oraR12
Application BASE DIRECTORY : /u01/applR12
NOW,
We will see the location of different scripts needed for
administration according to the locations selected in above screenshots:
1.
DATABASE STARTUP AND SHUTDOWN
1.1)
Go to location (Use “oracle” user):
/u01/oraR12/db/tech_st/11.1.0/appsutil/scripts/r12erp_r12apps
(note : r12erp_r12apps is same as <database_sid>_<host_name>)
Here, at this location you will find :
[oracle@r12apps r12erp_r12apps]$ ls -lrt
total 60
-rwx------ 1 oracle oracle 7109 Nov 29 18:55 adexecsql.pl
-rw------- 1 oracle oracle 1208 Nov 29 18:55 adstrtdb.sql
-rw------- 1 oracle oracle 809 Nov 29 18:55 adstopdb.sql
-rwx------ 1 oracle oracle 5081 Nov 29 18:55 adchknls.pl
-rwx------ 1 oracle oracle 4128 Nov 29 18:55 addlnctl.sh
-rwx------ 1 oracle oracle 2782 Nov 29 18:55 addbctl.sh
-rwx------ 1 oracle oracle 3407 Nov 29 18:55 adlsnodes.sh
-rwx------ 1 oracle oracle 1526 Nov 29 18:55 adautocfg.sh
-rwx------ 1 oracle oracle 15249 Nov 29
18:55 adpreclone.pl
Use ,
[oracle@r12apps r12erp_r12apps]$ ./addbctl.sh stop
immeidate|normal|abort
to shutdown your database.
and
[oracle@r12apps r12erp_r12apps]$ ./addbctl.sh start
to startup your database.
1.2)
Go to location (Use “oracle” user):
/u01/oraR12/db/tech_st/11.1.0
Here , you will find an “env” file in a
format like “<database_sid>_<host_name>.env”
Example :
r12erp_r12apps.env
Just execute this .env
[oracle@r12apps 11.1.0]$ . ./r12erp_r12apps.env
[oracle@r12apps 11.1.0]$ sqlplus '/as sysdba'
SQL*Plus: Release 11.1.0.7.0 - Production on
Mon Dec 3 17:24:33 2012
Copyright
(c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition
Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining
and Real Application Testing options
SQL>
Using above also , you can startup and shutdown your database.
2.
DATABASE LISTENER
Go to location (Use “oracle” user ):
/u01/oraR12/db/tech_st/11.1.0/appsutil/scripts/r12erp_r12apps
Here , you will find a script with a name addlnctl.sh
[oracle@r12apps r12erp_r12apps]$ ./addlnctl.sh status r12erp
[oracle@r12apps r12erp_r12apps]$ ./addlnctl.sh stop r12erp
[oracle@r12apps r12erp_r12apps]$ ./addlnctl.sh start r12erp
where r12erp is the name of listener.
However , listener.ora ,tnsnames.ora and
sqlnet.ora are located at :
/u01/oraR12/db/tech_st/11.1.0/network/admin/r12erp_r12apps/
3.
APPLICATION RELATED SCRIPTS
Go to location (Use “apps” user):
/u01/applR12/inst/apps/r12erp_r12apps/admin/script
Here, at this location you will find :
[apps@r12apps scripts]$ ls -lrt
total 176
drwxr-xr-x 2 apps apps 4096 Nov 28 20:33 msc
drwxr-xr-x 2 apps apps 4096 Nov 28 20:35 ieo
-rw-rw-r-- 1 apps apps 2888 Nov 29 14:20 sqlnet.log
-rwx------ 1 apps apps 6002 Nov 29 19:16 adstrtal.sh
-rwx------ 1 apps apps 5858 Nov 29 19:16 adstpall.sh
-rwx------ 1 apps apps 7360 Nov 29 19:16 adalnctl.sh
-rwx------ 1 apps apps 16543 Nov 29 19:16
adcmctl.sh
-rwx------ 1 apps apps 7237 Nov 29 19:16 adexecsql.pl
-rwx------ 1 apps apps 1552 Nov 29 19:16 adautocfg.sh
-rwx------ 1 apps apps 15366 Nov 29 19:16
adpreclone.pl
-rwx------ 1 apps apps 2250 Nov 29 19:17 gsmstart.sh
-rwx------ 1 apps apps 2296 Nov 29 19:17 java.sh
-rwx------ 1 apps apps 8097 Nov 29 19:17 adoacorectl.sh
-rwx------ 1 apps apps 8835 Nov 29 19:17 adformsctl.sh
-rwx------ 1 apps apps 8339 Nov 29 19:17 adapcctl.sh
-rwx------ 1 apps apps 7371 Nov 29 19:17 adopmnctl.sh
-rwx------ 1 apps apps 8105 Nov 29 19:17 adoafmctl.sh
-rwx------ 1 apps apps 10251 Nov 29 19:17
adformsrvctl.sh
-rwx------ 1 apps apps 6495 Nov 29 19:19 jtffmctl.sh
-rwxrwxr-- 1 apps apps 6638 Nov 29 19:19 mwactl.sh
-rwxrwxr-- 1 apps apps 6645 Nov 29 19:19 mwactlwrpr.sh
[apps@r12apps scripts]$
3.1)
To completely stop all the components of application
tier use :
[apps@r12apps scripts]$ ./adstpall.sh
You are
running adstpall.sh version 120.10
Enter the APPS username: apps
Enter the APPS password:
......
......
…….
3.2)
To start all the components of application
tier use :
[apps@r12apps scripts]$ ./adstrtal.sh
You are running adstrtal.sh version 120.15
Enter the APPS username: apps
Enter the APPS password:
......
......
…….
3.3)
To check the status use :
[apps@r12apps scripts]$ ./adapcctl.sh status
You are running adapcctl.sh version
120.7.12010000.2
Checking status of OPMN managed Oracle HTTP
Server (OHS) instance ...
Processes in Instance:
r12erp_r12apps.r12apps.localdomain
---------------------------------+--------------------+---------+---------
ias-component | process-type |
pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group | OC4J:oafm |
24645 | Alive
OC4JGroup:default_group | OC4J:forms |
24578 | Alive
OC4JGroup:default_group | OC4J:oacore |
24500 | Alive
HTTP_Server | HTTP_Server |
24449 | Alive
adapcctl.sh: exiting with status 0
adapcctl.sh: check the logfile
/u01/applR12/inst/apps/r12erp_r12apps/logs/appl/admin/log/adapcctl.txt for more
information ...
[apps@r12apps scripts]$
