Managing Oracle Applications through scripts

Controlling Forms/Reports/Concurrent Managers
===============================
All the controlling scripts are located under COMMON_TOP\admin\scripts\DB_Host directory
i.e E:\Oracle\11i\viscomn\admin\scripts\VIS_Nimra

Controlling Forms Server
————————
adfrmctl.cmd is the script which can be called to stop/start Forms server

Syntax
——
adfrmctl {start | stop}

Note: Behind the scene, adfrmctl calls NET START <Form_Server_Name> to stop/start the server

Examples
——–
E:\>adfrmctl stop OR
E:\>NET STOP “OracleFormsServer-Forms60VIS_nimra”
Controlling Concurrent Server
—————————–
adcmctl.cmd is the script which can be called to stop/start Concurrent server

Syntax
——
adrcmctl {start | stop |status} <APPS UserId/APPS password>

Note: Behind the scene, adcmctl calls NET START <Concurrent_Server_Name> to stop/start the server

Examples
——–
E:\>adcmctl status OR
E:\>NET STOP “OracleConcurrentServer”
Controlling Reports Server
————————–
adrepctl.cmd is the script which can be called to stop/start Report server

Syntax
——
adrepctl {start | stop}

Note: Behind the scene, adrepctl calls NET START <Report_Server_Name> to stop/start the server

Examples
——–
E:\>adrepctl stop OR
E:\>NET STOP “OracleReportServer”
Controlling Apache Server
————————–
adapcctl.cmd is the script which can be called to stop/start Apache server

Syntax
——
adapcctl {start | stop | status}

Note: Behind the scene, adrepctl calls NET START <Apache_Server_Name> to stop/start the server

Examples
——–
E:\>adapcctl stop OR
E:\>NET STOP “OracleApacheServer”
Controlling Oracle FullFillment Server
————————————–
jtffmctl.cmd the script which can be called to stop/start Oracle Fulfillment server

Syntax
——
jtffmctl.cmd {start | stop}

Note: Behind the scene, jtffmctl.cmd calls NET START <Fulfillment_Server_Name> to stop/start the server

Examples
——–
E:\>jtffmctl stop OR
E:\>NET STOP “OracleFulfillmentServer”
Controlling Oracle Metrics forms Server
————————————–
adfmsctl is the script which can be called to stop/start Oracle Forms Metrics server

Syntax
——
adfmsctl {start | stop}

Note: Behind the scene, adfmsctl calls NET START <Metrics_Server_Name> to stop/start the server

Examples
——–
E:\>adfmsctl stop OR
E:\>NET STOP “OracleMetricsServer”
Controlling Oracle Metrics forms Client
————————————–
adfmcctl is the script which can be called to stop/start Oracle Forms Metrics Client

Syntax
——
adfmcctl {start | stop}

Note: Behind the scene, adfmcctl calls NET START <Metrics_Client_Name> to stop/start the Client

Examples
——–
E:\>adfmcctl stop OR
E:\>NET STOP “OracleMetricsClient”
Controlling Oracle Net8 Listener for Application Services
———————————————————
adalnctl is the script which can be called to stop/start Oracle Net8 Listener

Syntax
——
adalnctl {start | stop | status}

Note: Behind the scene, adalnctl calls LSNRCTL80 to stop/start the Net8 listener

Examples
——–
E:\>adalnctl start OR
E:\>LSNRCTL80 start
Controlling all the Applications
——————————–
We can use adstpall.cmd and adstrtal.cmd to stop and start all the applications at once

Syntax
——
adstpall | adstrtal.cmd {appsuser\password}

Example:
——-
E:\>adstpall.cmd – To Stop all Apps
E:\>adstrtal.cmd – To Start all Apps

Log File
——–
E:\oracle\viscomn\admin\log\VIS_nimra\.log for details

[Service Control Execution Report]
The report format is:
  <Service>                                  <Script>         <Status>

  Oracle Apache Server VIS_nimra             adapcctl.cmd     Started
  OracleVISOra806_2TNSListener80APPS_VIS     adalnctl.cmd     Failed
  OracleConcMgrVIS_nimra                     adcmctl.cmd      Started
  OracleFormsServer-Forms60VIS_nimra         adfrmctl.cmd     Started
  OracleReportServer-Rep60_VIS               adrepctl.cmd     Started
  Oracle Metrics Client VIS_nimra            adfmcctl.cmd     Started
  Oracle Metrics Server VIS_nimra            adfmsctl.cmd     Started
  Oracle Fulfillment Server VIS_nimra        jtffmctl.cmd     Started
  Oracle Restricted Apache Server VIS_nimra  adaprstctl.cmd   Disabled
  Oracle Apache Server VIS_nimra for PL/SQL  adapcctl.cmd     Disabled
  Oracle TCF SocketServer VIS_nimra          adtcfctl.cmd     Disabled
  Oracle ICSM VIS_nimra                      ieoicsm.cmd      Disabled
  Oracle iProcurement Bulk Loader VIS_nimra  icxblkctl.cmd    Disabled

Note: Remember adstrtal or adstpall does not start/stop RDBMS Database service

2 Comments

Leave a comment