Website Design, Website Development, Shopping Carts, Content Management Systems, Custom Programming, Custom Applications Appsdba: November 2007

Oracle Applications, Middleware, Database, DB RAC & HA

It is place where anyone grab more knowledge about Oracle Applications, middleware etc.

 
APPS R12
  • File System
  • Tech Stack
  • Admin Scripts
  • Forms Mode
  • APPS 11i
  • Know more
  • Maintenance Mode
  • Maintenance Mode(New)
  • Patching
  • APPS Scripts
  • Database Scripts
  • Protect APPS Password
  • Concurrent Manager
  • Database Refersh
  • Patchset Utility
  • Forms Data Loader
  • Web Server
  • Space Required
  • Responsibilities Of APPSDBA
  • OAS 9i/10gR2
  • Software Load Balancer
  • OAS 10gR3
  • Components
  • HTTP Server as Port 80
  • Database
  • Enable Archive
  • Clear Temp Tablespace
  • Drop DB (New in 10g)
  • Database Performance
  • Oracle Process
  • Advanced Topic
  • Database RAC

  • Do you know
  • Clusterware
  • Manage RAC Environment
  • High Availability
  • Certifications
  • EBS R12 Beta Exam
  • APPS 11i - 1z0-233
  • RAC 10gR2 - 1z0-048
  • Oracle Certifications
  • DBA Tools
  • TOAD
  • KEEP TOOL
  • ORACLE's SQL DEVELOPER
  • Spotlight on Oracle E-Business
  • DBDiff For Oracle

  • Scripts for Startup and Shutdown the nodes in Oracle Apps R12 ?
    Wednesday, November 28, 2007
    Startup Shutdown
    ————————————–
    As in Oracle Apps 11i order for startup is
    A) Start Database Tier Services
    –Start Database Listener
    –Start Database
    B) Start Application/Middle Tier Services
    – adstrtal.sh
    Order for shutdown in Oracle Apps R12 is
    A) Stop Application/Middle Tier Services
    – adstpall.sh
    B) Stop Database Tier Services
    –Stop Database
    –Stop Database Listener

    Database Tier Scripts in R12
    ————————————–
    For Database tier you need to
    1) Start database
    2) Start database listener.
    Scripts are located in Database_Install_Dir/db/tech_st/10.2.0/appsutil/scripts/$CONTEXT_NAME- For Database
    Use script addbctl.sh
    - For Database Listener
    Use script addlnctl.sh
    or alternatively you can use
    lsnrctl startstop listener_name (For Database Listener)
    sqlplus “/as sysdba”
    SQL> startup shutdown immediate
    Middle/Application Tier Scripts in R12
    ————————————————-
    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
    1. 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)
    2. adstpall.sh
    Master script to stop all components/services of middle tier or application tier.
    3. 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 directory
    4. 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 .
    5. adcmctl.sh
    Script to start / stop concurrent manager, Similar to one in 11i. (This script in turn calls startmgr.sh )
    6. 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
    7. adformsrvctl.sh
    This script is used only if you wish to start forms in socket mode. Default forms connect method in R12 is servlet.
    If started this will start frmsrv executable from 10.1.2 Oracle_Home in Apps R12
    8. 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
    9. 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
    10. 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/should start them automatically.
    11. jtffmctl.sh
    This script will be used to start/stop one to one fulfilment server.
    12. mwactl.sh
    To start / stop mwa telnet server where mwa is mobile application.
    Log File Location for Startup Shutdown Services in R12
    ———————————————————————-
    Log files for startup/shutdown scripts for application/mid tier in R12 are in $INST_TOP/apps/$CONTEXT_NAME/logs/appl/admin/log
    (adalnctl.txt, adapcctl.txt, adcmctl.txt, adformsctl.txt, adoacorectl.txt, adoafmctl.txt, adopmnctl.txt, adstrtal.log, jtffmctl.txt )
    posted by Jaswinder Singh @ 5:10 AM   1 comments
    About Me

    Name: Jaswinder Singh
    Home: Bangalore, Karnataka, India
    Certifications: RAC Certified Expert, OCP 9i, 10g & 11i
    About Me: I am working as APPSDBA, have hands on experience on DB RAC, HA on OAS 10g and Oracle Applications.
    See my complete profile
    Previous Post
    Archives
    Links
    Powered by

    Free Blogger Templates

    BLOGGER

    ADVERTISEMENT
    click here
    © 2006 Appsdba .