Monday, January 3, 2011

Running AD Utilities

To run AD utilities, set the environment to define the system configuration parameters. For example, a utility may require the directory path to the Applications ORACLE_HOME. This parameter, and others, make up your system environment.
Using either Windows Explorer or the Run option from the Start menu, enter the command:
%APPL_TOP%\envshell.cmd
This creates a command window with the required environment settings for Oracle Applications. All subsequent commands should be run in this window.

C:\>cd %APPL_TOP%
C:\oracle\PROD\apps\apps_st\appl>
C:\oracle\PROD\apps\apps_st\appl>dir *.cmd
 Volume in drive C has no label.
 Volume Serial Number is 8C5C-16E4

 Directory of C:\oracle\PROD\apps\apps_st\appl

01/01/2011  04:56 PM             1,996 appsinf.cmd
01/01/2011  04:56 PM             2,451 APPSPROD_p-hq-sv-or-01.cmd
01/01/2011  04:56 PM             1,530 envshellPROD_p-hq-sv-or-01.cmd
01/01/2011  04:56 PM            16,095 PROD_p-hq-sv-or-01.cmd
01/01/2011  04:56 PM             1,465 relinkPROD_p-hq-sv-or-01.cmd
               5 File(s)         23,537 bytes
               0 Dir(s)  67,014,561,792 bytes free
C:\oracle\PROD\apps\apps_st\appl>envshellPROD_p-hq-sv-or-01.cmd
ECHO is off.
ECHO is off.
Mon 01/03/2011 10:45 AM
ECHO is off.
ECHO is off.
Setting environment for using Microsoft Visual Studio 2005 x86 tools.
APPSORA.cmd exiting with status 0

At this point a new command window will be opened , use this windows for all subsequent commands now.

You can check you env like below under this new window

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\oracle\PROD\apps\apps_st\appl>echo %ORACLE_HOME%
C:\oracle\PROD\apps\tech_st\10.1.2

C:\oracle\PROD\apps\apps_st\appl>echo %LOCAL%
PROD

C:\oracle\PROD\apps\apps_st\appl>echo %PATH%
C:\MicrosoftVisualStudio8\Common7\IDE;C:\MicrosoftVisualStudio8\VC\BIN;C:\MicrosoftVisualStudio8\Common7\Tools;C:\Micros
oftVisualStudio8\Common7\Tools\bin;C:\MicrosoftVisualStudio8\VC\PlatformSDK\bin;C:\MicrosoftVisualStudio8\SDK\v2.0\bin;C
:\WINDOWS\Microsoft.NET\Framework\v2.0.50727;C:\MicrosoftVisualStudio8\VC\VCPackages;C:\oracle\PROD\apps\apps_st\appl\au
\12.0.0\bin;C:\oracle\PROD\apps\apps_st\appl\fnd\12.0.0\bin;C:\oracle\PROD\apps\apps_st\appl\ad\12.0.0\bin;C:\oracle\PRO
D\apps\tech_st\10.1.3\appsutil\jdk\jre\bin;C:\oracle\PROD\apps\tech_st\10.1.3\perl\5.8.3\bin\MSWin32-x86-multi-thread\;C
:\oracle\PROD\apps\apps_st\comn\util\unzip\unzip;C:\oracle\PROD\apps\tech_st\10.1.3\appsutil\jdk\bin;C:\oracle\PROD\apps
\tech_st\10.1.2\bin;C:\oracle\PROD\apps\tech_st\10.1.3\appsutil\jdk\bin;C:\oracle\PROD\apps\tech_st\10.1.3\appsutil\jdk\
jre\bin;C:\cygwin;C:\WINDOWS;C:\WINDOWS\system32;C:\oracle\PROD\apps\tech_st\10.1.3\ant\bin

C:\oracle\PROD\apps\apps_st\appl>echo %APPL_CONFIG%
PROD_p-hq-sv-or-01

C:\oracle\PROD\apps\apps_st\appl>


Configuring Windows Services:
If you are running AD utilities on a Windows platform, you must first shut down all forms services, Web listener services, and concurrent manager services. In addition, you must verify that the database and database listeners are running.
following  lists the services and status required when running an AD utility

Starting a Utility:
To start an AD utility, enter the utility's executable name on the command line. For example, to start AD Administration, you would enter the command:
C:\oracle\PROD\apps\apps_st\appl>adadmin

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                     Oracle Applications AD Administration

                                 Version 12.0.0

NOTE: You may not use this utility for custom development
      unless you have written permission from Oracle Corporation.

Your default directory is 'C:\oracle\PROD\apps\apps_st\appl'.
Is this the correct APPL_TOP [Yes] ?

Exiting or Stopping a Utility:
When menu-driven utilities complete a processing task, they return you to the main menu, where you either choose another process or Exit. AD Administration is an example. Other utilities do not use a menu format. In this case, the utility exits automatically when processing is complete.
Before it begins processing tasks, you can stop a utility by entering abort at any prompt.
In some cases, a utility may begin the processing actions, but quits before the actions are complete (because of an error). Or, during a parallel processing session, you may decide to stop the processing actions by shutting down the workers.

Restarting a Utility:
You can restart a utility by entering the executable name on the command line. When you restart, the utility prompts you to enter a new log file, or to specify the log file from the interrupted session. When you reuse the log file from a previous session, the utility adds the message "Start of <utility name> session" to the end of the file and appends messages from the continued session as it generates them.

Related Posts
Maintenance Utilities 
Configuration and Environment files commonly used by the AD Utilities

No comments:

Post a Comment