Scripts Location In Oracle Application R12

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.

About Syed Saad

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

ebs-12214_upgrade

Step By Step Upgrading Oracle EBS to R12.2.14

Step By Step Upgrading Oracle EBS to R12.2.14 This post will offer comprehensive guidance on …

Leave a Reply