Syed Saad Ali
Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali
Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

AppsDBA CV Download CV Contact Me

Installations/Configurations-Applications

May 1, 2017 Scripts Location In Oracle Application R12
APPS DBAInstallations/Configurations-Applications

Scripts Location In Oracle Application R12

Database Tier Scripts

Database Scripts are located in

Database_Install_Dir/db/tech_st/10.2.0/appsutil/scripts/$CONTEXT_NAME

where CONTEXT_NAME is of format SID_HOSTNAME

For Database Use script addbctl.sh

For Database Listener Use script addlnctl.sh

Application Tier Scripts

Scripts for Application Tier services in R12 are located in

Install_base/inst/apps/$CONTEXT_NAME/admin/scripts

where CONTEXT_NAME is of format SID_HOSTNAME

adstrtal.sh
  • Master script to start all components/services of middle tier or application tier.
  • This script will use Service Control API to start all services which are enabled after checking them in context file (SID_HOSTNAME.xml or CONTEXT_NAME.xml)

adstpall.sh
  • Master script to stop all components/services of middle tier or application tier.

adalnctl.sh
  • Script to start / stop apps listener (FNDFS and FNDFS).
  • This listener will file will be in 10.1.2 ORACLE_HOME (i.e. Forms & Reports Home).
  •  listener.ora file will be in $INST_TOP/apps/$CONTEXT_NAME/ora/10.1.2/network/admin 

adapcctl.sh
  • Script to start/stop Web Server or Oracle HTTP Server.
  • This script uses opmn (Oracle Process Manager and Notification Server) with syntax similar to opmnctl [startstop]proc ohs like opmnctl stopproc ohs .

adcmctl.sh

 Script to start / stop concurrent manager.

adformsctl.sh
  • Script to start / stop Forms OC4J from 10.1.3 Oracle_Home.
  • This script will also use opmnctl to start/stop Forms OC4J like opmnctl stopproc type=oc4j instancename=forms

adformsrvctl.sh
  • This script is used only if you want to start forms in socket mode.
  • Default forms connect method in R12 is servlet.
  • This will start frmsrv executable from 10.1.2 Oracle_Home in Apps R12

adoacorectl.sh
  • This script will start/stop oacore OC4J in 10.1.3 Oracle_Home.
  • This scripts will also use opmnctl (similar to adapcctl & adformsctl) to start oacore instance of OC4J like opmnctl startproc type=oc4j instancename=oacore

adoafmctl.sh

 This script will start/stop oafm OC4J in 10.1.3 Oracle_Home.

This scripts will also use opmnctl (similar to above) to start oacore instance of OC4J like opmnctl startproc type=oc4j instancename=oafm

adopmnctl.sh
  • This script will start/stop opmn service in 10.1.3 Oracle_Home.
  • opmn will control all services in 10.1.3 Oracle_Home like web server or various oc4j instances.
  • If any services are stopped abnormally opmn will start them automatically.

jtffmctl.sh
  • This script will be used to start/stop one to one fulfilment server.

mwactl.sh
  • To start / stop mwa telnet server where Mobile Wireless Application (mwa) is mobile application.
April 28, 2017 Changing IP Address in an Oracle EBS R12 Environment
APPS DBAInstallations/Configurations-Applications

Changing IP Address in an Oracle EBS R12 Environment

1. First, Change the IP Address of the Server by editing the /etc/hosts file

(more…)

April 25, 2017 Forms Servlet mode to Socket mode conversion on Release 12 Apps
APPS DBAInstallations/Configurations-Applications

Forms Servlet mode to Socket mode conversion on Release 12 Apps

Run the following command to enable Forms Socket Mode on Forms/web nodes (Place correct context file name and port value)

$FND_TOP/bin/txkrun.pl -script=ChangeFormsMode -contextfile=$CONTEXT_FILE -mode=socket  -port=9030 -runautoconfig=No

Where port = forms port and contextfile=your environment contextfile

To Start/Stop/check Status of forms servers use following scripts

$cd $ADMIN_SCRIPTS_HOME
$./adformsrvctl.sh status/stop/start

April 18, 2017 How to Create The Service Manager ‘FNDSM’ on Oracle Applications
APPS DBAInstallations/Configurations-Applications

Create The Service Manager ‘FNDSM’

(more…)

All Rights Reserved