If we lost adconfig.pl file?Can we able to run autoconfig.

[applvision@apps admin]$ cd $AD_TOP/bin
[applvision@apps bin]$ ls -tlrh adconfig.pl
-rwxr-xr-x 1 applvision applmgr 36K Nov  6  2008 adconfig.pl
[applvision@apps bin]$ mv adconfig.pl adconfig.pl_27sep2013
[applvision@apps bin]$ sh /apps/vision/inst/apps/vision_apps/admin/scripts/adautocfg.sh
Enter the APPS user password:
Can't open perl script "/apps/vision/apps/apps_st/appl/ad/12.0.0/bin/adconfig.pl": No such file or directory
[applvision@apps bin]$

When we run autoconfig using "adautocfg.sh" it calls adconfig.sh file and which in turn calls adconfig.pl script.
adconfig.pl is main script which start the autoconfig engine.If we lost adconfig.pl it not possible to run autoconfig.

Once we lost adconfig.pl file its not possible to re generate it.We have to copy it from other server.

if we lost adrelink.sh and adlicmgr.sh script.Is it possible to regenrate it?

if we lost adrelink.sh and adlicmgr.sh script.Is it possible to regenrate it?

If anything miss we will go for autoconfig choice.Let's do the same here to get adrelink.sh and adlicmgr.sh file.

======================
Let's create a senario
======================
[applvision@apps ~]$ cd $AD_TOP/bin
[applvision@apps bin]$ ls -ltrh adrelink.sh
-rwxr-xr-x 1 applvision applmgr 1.7K Dec 31  2006 adrelink.sh
[applvision@apps bin]$ mv adrelink.sh adrelink.sh_27sep2013
[applvision@apps bin]$ ls -ltrh adrelink.sh
ls: adrelink.sh: No such file or directory
[applvision@apps bin]$ sh /apps/vision/inst/apps/vision_apps/admin/scripts/adautocfg.sh
Enter the APPS user password:

The log file for this session is located at: /apps/vision/inst/apps/vision_apps/admin/log/09280717/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
        Using CONFIG_HOME location     : /apps/vision/inst/apps/vision_apps
        Classpath                   : /apps/vision/apps/apps_st/comn/java/lib/appsborg2.zip:/apps/vision/apps/apps_st/comn/java/classes

        Using Context file          : /apps/vision/inst/apps/vision_apps/appl/admin/vision_apps.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...
        Configuring AD_TOP........COMPLETED
        Configuring FND_TOP.......COMPLETED
        Configuring ICX_TOP.......COMPLETED
        Configuring MSC_TOP.......COMPLETED
        Configuring IEO_TOP.......COMPLETED
        Configuring BIS_TOP.......COMPLETED
        Configuring AMS_TOP.......COMPLETED
        Configuring CCT_TOP.......COMPLETED
        Configuring WSH_TOP.......COMPLETED
        Configuring CLN_TOP.......COMPLETED
        Configuring OKE_TOP.......COMPLETED
        Configuring OKL_TOP.......COMPLETED
        Configuring OKS_TOP.......COMPLETED
        Configuring CSF_TOP.......COMPLETED
        Configuring IGS_TOP.......COMPLETED
        Configuring IBY_TOP.......COMPLETED
        Configuring JTF_TOP.......COMPLETED
        Configuring MWA_TOP.......COMPLETED
        Configuring CN_TOP........COMPLETED
        Configuring CSI_TOP.......COMPLETED
        Configuring WIP_TOP.......COMPLETED
        Configuring CSE_TOP.......COMPLETED
        Configuring EAM_TOP.......COMPLETED
        Configuring FTE_TOP.......COMPLETED
        Configuring ONT_TOP.......COMPLETED
        Configuring AR_TOP........COMPLETED
        Configuring AHL_TOP.......COMPLETED
        Configuring OZF_TOP.......COMPLETED
        Configuring IES_TOP.......COMPLETED
        Configuring CSD_TOP.......COMPLETED
        Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.
[applvision@apps bin]$ ls -ltrh $AD_TOP/bin/adrelink.sh
ls: /apps/vision/apps/apps_st/appl/ad/12.0.0/bin/adrelink.sh: No such file or directory
[applvision@apps bin]$

Answer *:-
Both are the shell scripts,Its not possible to regenerate it.
we need to copy both the files from other server.

Rebuild/Re create context file in oracle apps R12.

If we lost $CONTEXT_FILE .How to rebulid  in oracle apps R12.


=============
Let's create senario
==============
/apps/vision/inst/apps/vision_apps/appl/admin
[applvision@apps admin]$ ls -tlrh
total 120K
-rw-r--r-- 1 applvision applmgr  11K Sep 28 07:43 adovars_vision_apps.env
-rw------- 1 applvision applmgr 7.0K Sep 28 07:44 ojspCompile.properties
-rw------- 1 applvision applmgr 3.3K Sep 28 07:44 ojspCompile.conf
-rw------- 1 applvision applmgr 1010 Sep 28 07:44 oamextensions.xml
-rwxr-xr-x 1 applvision applmgr  86K Sep 28 07:46 vision_apps.xml
[applvision@apps admin]$ mv vision_apps.xml vision_apps.xml_27sep2013
[applvision@apps admin]$ perl $COMMON_TOP/clone/bin/adclonectx.pl retrieve

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

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adclonectx Version 120.23.12010000.1

Running:
/apps/vision/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /apps/vision/apps/apps_st/comn/clone/bin/../jlib/ojdbc14.jar:/apps/vision/apps/apps_st/comn/clone/bin/../jlib/xmlparserv2.jar:/apps/vision/apps/apps_st/comn/clone/bin/../jlib/java oracle.apps.ad.context.RetrieveContext

Log file located at /apps/vision/inst/apps/vision_apps/appl/admin/RetrieveContext_09280757.log

Database Host [apps]:

Database Host Domain [innovation.com]:

Database Port [1521]:1526

Database SID:vision

APPS Schema Name [APPS]:apps

APPS Schema Password:apps

The following context files are available:

[1] vision_apps (APPL_TOP Context)
[2] vision_apps (Database Context)

Select the context to retrieve [1]:1

Destination file path [/apps/vision/inst/apps/vision_apps/appl/admin/vision_apps.xml]:

Retrieved context file to /apps/vision/inst/apps/vision_apps/appl/admin/vision_apps.xml

Log file location: /apps/vision/inst/apps/vision_apps/appl/admin/RetrieveContext_09280757.log
[applvision@apps admin]$ ls -tlrh /apps/vision/inst/apps/vision_apps/appl/admin/vision_apps.xml
-rwxr-xr-x 1 applvision applmgr 86K Sep 28 08:00 /apps/vision/inst/apps/vision_apps/appl/admin/vision_apps.xml
[applvision@apps admin]$ date
Sat Sep 28 08:00:23 IST 2013
[applvision@apps admin]$

++++++++++++++++++++++
To re-build database tier context file follow below syntax.

[dbvision@apps bin]$ perl /db/vision/db/tech_st/11.1.0/appsutil/bin/adbldxml.pl appsuser=apps appspass=apps template=/db/vision/db/tech_st/11.1.0/appsutil/template/adxdbctx.tmp out=/db/vision/db/tech_st/11.1.0/appsutil

Thanks for visiting my blog !!!!!!!!!!

If we lost dbc file.How can we re generate it?

If we lost dbc file.How can we re generate it?

================
Let's create a scenario
================
[applvision@apps secure]$ ls -tlrh /apps/vision/inst/apps/vision_apps/appl/fnd/12.0.0/secure/vision.dbc
-rw------- 1 applvision applmgr 784 Sep 28 07:19 /apps/vision/inst/apps/vision_apps/appl/fnd/12.0.0/secure/vision.dbc
[applvision@apps secure]$ mv /apps/vision/inst/apps/vision_apps/appl/fnd/12.0.0/secure/vision.dbc /apps/vision/inst/apps/vision_apps/appl/fnd/12.0.0/secure/vision.dbc_27sep2013
[applvision@apps secure]$
[applvision@apps secure]$  ls -tlrh /apps/vision/inst/apps/vision_apps/appl/fnd/12.0.0/secure/vision.dbc
ls: /apps/vision/inst/apps/vision_apps/appl/fnd/12.0.0/secure/vision.dbc: No such file or directory
[applvision@apps secure]$

Now run autoconfig (or) run adgendbc.sh file to re generate dbc file.

[applvision@apps secure]$  sh /apps/vision/inst/apps/vision_apps/admin/scripts/adautocfg.sh
Enter the APPS user password:

The log file for this session is located at: /apps/vision/inst/apps/vision_apps/admin/log/09280743/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
        Using CONFIG_HOME location     : /apps/vision/inst/apps/vision_apps
        Classpath                   : /apps/vision/apps/apps_st/comn/java/lib/appsborg2.zip:/apps/vision/apps/apps_st/comn/java/classes

        Using Context file          : /apps/vision/inst/apps/vision_apps/appl/admin/vision_apps.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...
        Configuring AD_TOP........COMPLETED
        Configuring FND_TOP.......COMPLETED
        Configuring ICX_TOP.......COMPLETED
        Configuring MSC_TOP.......COMPLETED
        Configuring IEO_TOP.......COMPLETED
        Configuring BIS_TOP.......COMPLETED
        Configuring AMS_TOP.......COMPLETED
        Configuring CCT_TOP.......COMPLETED
        Configuring WSH_TOP.......COMPLETED
        Configuring CLN_TOP.......COMPLETED
        Configuring OKE_TOP.......COMPLETED
        Configuring OKL_TOP.......COMPLETED
        Configuring OKS_TOP.......COMPLETED
        Configuring CSF_TOP.......COMPLETED
        Configuring IGS_TOP.......COMPLETED
        Configuring IBY_TOP.......COMPLETED
        Configuring JTF_TOP.......COMPLETED
        Configuring MWA_TOP.......COMPLETED
        Configuring CN_TOP........COMPLETED
        Configuring CSI_TOP.......COMPLETED
        Configuring WIP_TOP.......COMPLETED
        Configuring CSE_TOP.......COMPLETED
        Configuring EAM_TOP.......COMPLETED
        Configuring FTE_TOP.......COMPLETED
        Configuring ONT_TOP.......COMPLETED
        Configuring AR_TOP........COMPLETED
        Configuring AHL_TOP.......COMPLETED
        Configuring OZF_TOP.......COMPLETED
        Configuring IES_TOP.......COMPLETED
        Configuring CSD_TOP.......COMPLETED
        Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.
[applvision@apps secure]$ ls -tlrh /apps/vision/inst/apps/vision_apps/appl/fnd/12.0.0/secure/vision.dbc
-rw------- 1 applvision applmgr 784 Sep 28 07:44 /apps/vision/inst/apps/vision_apps/appl/fnd/12.0.0/secure/vision.dbc
[applvision@apps secure]$ date
Sat Sep 28 07:46:57 IST 2013
[applvision@apps secure]$

Re -cap

======

Move dbc file to create a senario.

Run autoconfig (or)run adgendbc.sh.

Check whether dbc file is created or not.

You have shutdown the Concurrent manager,Your juniour dba deleted the FNDLIBR executable. What happens when you start the concurrent manager?will CM come up (or) error out.

You have shutdown the Concurrent manager,Your junior dba deleted the FNDLIBR executable.
What happens when you start the concurrent manager?Will CM come up (or) error out.

----------------------------------------------
Move executable to create scenario
-----------------------------------------------

[applvision@apps bin]$ ls -ltrh FNDLIBR
-rwxr-xr-x 1 applvision applmgr 1.6M Mar 30  2009 FNDLIBR
[applvision@apps bin]$ mv FNDLIBR FNDLIBR_19sep2013
[applvision@apps bin]$ pwd


Lets try to start Concurrent manager.
[applvision@apps scripts]$ adcmctl.sh start apps/apps

You are running adcmctl.sh version 120.17.12010000.3

Starting concurrent manager for vision ...
Starting vision_0920@vision Internal Concurrent Manager
Default printer is noprint

adcmctl.sh: exiting with status 0


adcmctl.sh: check the logfile /apps/vision/inst/apps/vision_apps/logs/appl/admin/log/adcmctl.txt for more information ...

No processes are running
[applvision@apps scripts]$ ps -fu applvision
UID        PID  PPID  C STIME TTY          TIME CMD
501       5536  5527  0 06:23 ?        00:00:00 sshd: applvision@pts/2
501       5537  5536  0 06:23 pts/2    00:00:00 -bash
501       5807     1  0 06:25 pts/2    00:00:00 sendmail: ./r8K0tLqD005807 [127.0.0.1]: client MAIL
501       5813  5537  0 06:25 pts/2    00:00:00 ps -fu applvision

======================================
Concurrent manager log file contain below message
======================================

Starting vision_0920@vision Internal Concurrent Manager -- shell process ID 5794

          logfile=/apps/vision/inst/apps/vision_apps/logs/appl/conc/log/vision_0920.mgr
          PRINTER=noprint
           mailto=applvision
          restart=N
             diag=N
            sleep=30
             pmon=4
           quesiz=1
          Reviver is ENABLED

sh: line 34: FNDLIBR: command not found
The vision_0920@vision internal concurrent manager has terminated with status 127 - giving up.



Answer *:- It will not Concurrent manager,When you start concurrent manager,it will look for FNDLIBR executable which is located at cd $FND_TOP/bin.
FNDLIBD which inturn calls two executables FNDFS and FNDSM.

FNDFS is used to view the log and out files of concurrent managers.FNDFS is also called as report view agent.
FNDSM is start the concurrent manager.

You have removed the patch log directoy and what happens when you fire adpatch? Will patch get succeed or error out?

You have removed the patch log directoy and what happens when you fire adpatch?
Will patch get succeed or error out?

/apps/vision/apps/apps_st/appl/admin/vision
[applvision@apps vision]$ ls -tlrh
total 56K
drwx------ 2 applvision applmgr 4.0K Sep 20 06:35 21sep2013_log
-rw------- 1 applvision applmgr  25K Sep 22 01:25 adalldefaults.txt
drwx------ 2 applvision applmgr 4.0K Sep 22 02:24 log
drwx------ 3 applvision applmgr  16K Sep 22 02:24 out
drwxr-xr-x 2 applvision applmgr 4.0K Sep 22 02:26 restart
[applvision@apps vision]$ rm -rf log
[applvision@apps vision]$ ls -ld log
ls: log: No such file or directory
[applvision@apps vision]$ pwd
/apps/vision/apps/apps_st/appl/admin/vision
[applvision@apps vision]$
[applvision@apps vision]$ date
Thu Sep 26 06:51:05 IST 2013
[applvision@apps vision]$


My application services are down
=================================
[applvision@apps patches]$ ps -fu applvision
UID        PID  PPID  C STIME TTY          TIME CMD
501       5434  5398  0 05:59 ?        00:00:00 sshd: applvision@pts/3
501       5435  5434  0 05:59 pts/3    00:00:00 -bash
501       5964  5957  0 06:08 ?        00:00:00 sshd: applvision@pts/4
501       5965  5964  0 06:08 pts/4    00:00:00 -bash
501       6520  5435  0 06:32 pts/3    00:00:00 ps -fu applvision
[applvision@apps patches]$


Enabling maintainance mode
============================
Beginning database cleanup for previous session ...

Completed database cleanup for previous session.

            AD Administration Main Menu
   --------------------------------------------------

   1.    Generate Applications Files menu

   2.    Maintain Applications Files menu

   3.    Compile/Reload Applications Database Entities menu

   4.    Maintain Applications Database Entities menu

   5.    Change Maintenance Mode

   6.    Exit AD Administration









Enter your choice [6] : 5

             Change Maintenance Mode
   ----------------------------------------

Maintenance Mode is currently: [Disabled].


Maintenance mode should normally be enabled when patching
Oracle Applications and disabled when users are logged on
to the system.  See the Oracle Applications Maintenance
Utilities manual for more information about maintenance mode.


Please select an option:

   1.    Enable Maintenance Mode

   2.    Disable Maintenance Mode

   3.    Return to Main Menu



Enter your choice [3] : 1

sqlplus -s &un_apps/***** @/apps/vision/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adsetmmd.sql ENABLE

Successfully enabled Maintenance Mode.

Review the messages above, then press [Return] to continue.


Backing up restart files, if any......Done.

             Change Maintenance Mode
   ----------------------------------------

Maintenance Mode is currently: [Enabled].


Maintenance mode should normally be enabled when patching
Oracle Applications and disabled when users are logged on
to the system.  See the Oracle Applications Maintenance
Utilities manual for more information about maintenance mode.


Please select an option:

   1.    Enable Maintenance Mode

   2.    Disable Maintenance Mode

   3.    Return to Main Menu



i have unloaded the patch in this directory.
/apps/vision/apps/apps_st/patches/11808198

[applvision@apps 11808198]$ adpatch

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

                         Oracle Applications AutoPatch

                                 Version 12.0.0

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


Attention: AutoPatch no longer checks for unapplied pre-requisite patches.
You must use OAM Patch Wizard for this feature. Alternatively, you can
review the README for pre-requisite information.


Your default directory is '/apps/vision/apps/apps_st/appl'.
Is this the correct APPL_TOP [Yes] ?

AutoPatch records your AutoPatch session in a text file
you specify.  Enter your AutoPatch log file name or press [Return]
to accept the default file name shown in brackets.

Filename [adpatch.log] : test.log  ==> it has created the log direcotory,so adpatch will  not fail.

You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ?

Please enter the batchsize [1000] :


Please enter the name of the Oracle Applications System that this
APPL_TOP belongs to.

The Applications System name must be unique across all Oracle
Applications Systems at your site, must be from 1 to 30 characters
long, may only contain alphanumeric and underscore characters,
and must start with a letter.

Sample Applications System names are: "prod", "test", "demo" and
"Development_2".

Applications System Name [vision] : vision *


NOTE: If you do not currently have certain types of files installed
in this APPL_TOP, you may not be able to perform certain tasks.

Example 1: If you don't have files used for installing or upgrading
the database installed in this area, you cannot install or upgrade
the database from this APPL_TOP.

Example 2: If you don't have forms files installed in this area, you cannot
generate them or run them from this APPL_TOP.

Example 3: If you don't have concurrent program files installed in this area,
you cannot relink concurrent programs or generate reports from this APPL_TOP.


Do you currently have files used for installing or upgrading the database
installed in this APPL_TOP [YES] ? YES *


Do you currently have Java and HTML files for HTML-based functionality
installed in this APPL_TOP [YES] ? YES *


Do you currently have Oracle Applications forms files installed
in this APPL_TOP [YES] ? YES *


Do you currently have concurrent program files installed
in this APPL_TOP [YES] ? YES *


Please enter the name Oracle Applications will use to identify this APPL_TOP.

The APPL_TOP name you select must be unique within an Oracle Applications
System, must be from 1 to 30 characters long, may only contain
alphanumeric and underscore characters, and must start with a letter.

Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".

APPL_TOP Name [apps] : apps *

NOTE:
Adpatch will complete without ant errors,becuase it is able to create log directory.
/apps/vision/apps/apps_st/appl/admin/vision
[applvision@apps vision]$ ls -ltrh
total 56K
drwx------ 2 applvision applmgr 4.0K Sep 20 06:35 21sep2013_log
-rw------- 1 applvision applmgr  25K Sep 22 01:25 adalldefaults.txt
drwx------ 3 applvision applmgr  16K Sep 22 02:24 out
drwxr-xr-x 2 applvision applmgr 4.0K Sep 26 06:52 log
drwxr-xr-x 2 applvision applmgr 4.0K Sep 26 06:52 restart

see the timestamp
[applvision@apps vision]$ date
Thu Sep 26 06:53:53 IST 2013
[applvision@apps vision]$ cd log
[applvision@apps log]$ ls -tlh
total 32K
-rw-r--r-- 1 applvision applmgr 7.2K Sep 26 06:52 test.log
-rw-r--r-- 1 applvision applmgr  366 Sep 26 06:52 test.lgi
-rw-r--r-- 1 applvision applmgr  18K Sep 26 06:49 adadmin.log
[applvision@apps log]$

You have removed the patch log directoy.How do you re create it?

You have removed the patch log directoy which contains adworker's log and patch log files.How do you re create it?

Let's create a scenario
==============
/apps/vision/apps/apps_st/appl/admin/vision
[applvision@apps vision]$mv log 21sep2013_log
[applvision@apps vision]$ ls -tlhr
total 52K
-rw------- 1 applvision applmgr  25K Sep 16 03:31 adalldefaults.txt
drwx------ 2 applvision applmgr 4.0K Sep 20 06:35 21sep2013_log
drwx------ 3 applvision applmgr  16K Sep 20 06:40 out
drwxr-xr-x 2 applvision applmgr 4.0K Sep 20 06:41 restart

[applvision@apps scripts]$ adautocfg.sh
Enter the APPS user password:

The log file for this session is located at: /apps/vision/inst/apps/vision_apps/admin/log/09220124/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
        Using CONFIG_HOME location     : /apps/vision/inst/apps/vision_apps
        Classpath                   : /apps/vision/apps/apps_st/comn/java/lib/appsborg2.zip:/apps/vision/apps/apps_st/comn/java/classes

        Using Context file          : /apps/vision/inst/apps/vision_apps/appl/admin/vision_apps.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...
        Configuring AD_TOP........COMPLETED
        Configuring FND_TOP.......COMPLETED
        Configuring ICX_TOP.......COMPLETED
        Configuring MSC_TOP.......COMPLETED
        Configuring IEO_TOP.......COMPLETED
        Configuring BIS_TOP.......COMPLETED
        Configuring AMS_TOP.......COMPLETED
        Configuring CCT_TOP.......COMPLETED
        Configuring WSH_TOP.......COMPLETED
        Configuring CLN_TOP.......COMPLETED
        Configuring OKE_TOP.......COMPLETED
        Configuring OKL_TOP.......COMPLETED
        Configuring OKS_TOP.......COMPLETED
        Configuring CSF_TOP.......COMPLETED
        Configuring IGS_TOP.......COMPLETED
        Configuring IBY_TOP.......COMPLETED
        Configuring JTF_TOP.......COMPLETED
        Configuring MWA_TOP.......COMPLETED
        Configuring CN_TOP........COMPLETED
        Configuring CSI_TOP.......COMPLETED
        Configuring WIP_TOP.......COMPLETED
        Configuring CSE_TOP.......COMPLETED
        Configuring EAM_TOP.......COMPLETED
        Configuring FTE_TOP.......COMPLETED
        Configuring ONT_TOP.......COMPLETED
        Configuring AR_TOP........COMPLETED
        Configuring AHL_TOP.......COMPLETED
        Configuring OZF_TOP.......COMPLETED
        Configuring IES_TOP.......COMPLETED
        Configuring CSD_TOP.......COMPLETED
        Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.
[applvision@apps scripts]$ pwd
/apps/vision/inst/apps/vision_apps/admin/scripts
[applvision@apps scripts]$

source the env file
==================

[applvision@apps appl]$ ls -tlrh APPS*.env
-rw-r--r-- 1 applvision applmgr 1.1K Sep 22 01:25 APPSvision_apps.env
[applvision@apps appl]$ . ./APPSvision_apps.env


/apps/vision/apps/apps_st/appl/admin/vision
[applvision@apps vision]$ ls
21sep2013_log  adalldefaults.txt  log  out  restart
[applvision@apps vision]$ ls -lrh
total 56K
drwxr-xr-x 2 applvision applmgr 4.0K Sep 20 06:41 restart
drwx------ 3 applvision applmgr  16K Sep 20 06:40 out
drwx------ 2 applvision applmgr 4.0K Sep 22 01:25 log
-rw------- 1 applvision applmgr  25K Sep 22 01:25 adalldefaults.txt
drwx------ 2 applvision applmgr 4.0K Sep 20 06:35 21sep2013_log
[applvision@apps vision]$ cd log
[applvision@apps log]$ pwd
/apps/vision/apps/apps_st/appl/admin/vision/log
[applvision@apps log]$ ls -lrh
total 0
[applvision@apps log]$


Note *;- But log file will contians nothing ,its a empty directory.

you have shutdown database .Someone came and deleted controlfile.

you have shutdown database .Someone came and deleted controlfile. When you start the database you got the error saying controlfile missing. Now what you will do?

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
[dbvision@apps data]$ rm /db/vision/db/apps_st/data/cntrl01.dbf
[dbvision@apps data]$

SQL> startup
ORACLE instance started.
Total System Global Area 1071333376 bytes
Fixed Size                  1318172 bytes
Variable Size             440402660 bytes
Database Buffers          616562688 bytes
Redo Buffers               13049856 bytes
ORA-00205: error in identifying control file, check alert log for more info.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[dbvision@apps data]$ pwd
/db/vision/db/apps_st/data


Go to alert logfile and find which controlfile is missing.
=========================================================
[dbvision@apps data]$ adrci

ADRCI: Release 11.1.0.7.0 - Production on Sun Sep 22 01:13:42 2013

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

ADR base = "/db/vision/db/tech_st/11.1.0/admin/vision_apps"
adrci> show home
ADR Homes:
diag/rdbms/vision/vision
adrci> exit
[dbvision@apps data]$ cd "/db/vision/db/tech_st/11.1.0/admin/vision_apps"
[dbvision@apps vision_apps]$ cd diag/rdbms/vision/vision
[dbvision@apps vision]$ cd trace
[dbvision@apps trace]$ pwd
/db/vision/db/tech_st/11.1.0/admin/vision_apps/diag/rdbms/vision/vision/trace
[dbvision@apps trace]$ ls -tlrh alert*.log
-rw-r--r-- 1 dbvision dba 623K Sep 22 01:13 alert_vision.log
[dbvision@apps trace]$


alert logfile
============

ALTER DATABASE   MOUNT
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/db/vision/db/apps_st/data/cntrl01.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-205 signalled during: ALTER DATABASE   MOUNT...
Sun Sep 22 01:13:28 2013
Checker run found 1 new persistent data failures


if you have backup of the controlfile just copy it.Incase if you lost all you have may have multiplex of the controlfile in some other disk
just restore it.

[dbvision@apps data]$ cp -r cntrl02.dbf cntrl01.dbf
[dbvision@apps data]$


SQL> shutdown immediate
ORA-01507: database not mounted


ORACLE instance shut down.

SQL> startup mount
ORACLE instance started.

Total System Global Area 1071333376 bytes
Fixed Size                  1318172 bytes
Variable Size             440402660 bytes
Database Buffers          616562688 bytes
Redo Buffers               13049856 bytes
Database mounted.
SQL> alter database open;

Database altered.

SQL>

Interview question on adutilities and others

Where all ADUTILITIES EXE'S LOCATED?

$AD_TOP/bin
For each utility three files are presented.
[applvision@apps bin]$ ls -ltrh adadmin adadminnew adadmin_wrapper
-rwxr-xr-x 1 applvision applmgr 9.2K Dec 31  2006 adadmin_wrapper
-rwxr-xr-x 1 applvision applmgr 9.2K Mar 27  2009 adadmin
-rwxr-xr-x 1 applvision applmgr 3.5M Mar 30  2009 adadminnew
[applvision@apps bin]$

First two files are wrapper files and both are same in size.

==>adadmin will internall call adadminnew
==>adadminnew is key executable which calls adadmin.


What happen if we lost adadminnew?

adadmin will not work.

Scenario:

[applvision@apps bin]$ mv adadminnew adadminnew_14sep2013
[applvision@apps bin]$ adadmin
sh: /apps/vision/apps/apps_st/appl/ad/12.0.0/bin/adadminnew: No such file or directory
[applvision@apps bin]$


What we had to do if we lost adadminnew?

If we lost adadminnew we can recreate it by using adrelink.sh.

[applvision@apps bin]$ mv adadminnew adadminnew_14sep2013
[applvision@apps bin]$ adadmin
sh: /apps/vision/apps/apps_st/appl/ad/12.0.0/bin/adadminnew: No such file or directory
[applvision@apps bin]$

Now fire the below command to recreate it.

$AD_TOP/bin/adrelink.sh force=y "ad admin adadmin"

NOTE: force=y indicates to check for all libraries.



if we lost adrelink.sh and adlicmgr.sh script.Is it possible to regenrate it?

Both are the shell scripts.Its not possible to regenerate it.
we need to copy it from other server.



How can we generate env file?

BY using adadmin
Choose Maintain Applications file menu.
Create application environment file
Above is applicable in 11i and in R12 i don't see this option.
(or)
Run autoconfig.



if we lost dbc,can we recreate it?
Yes ,we can re create dbc file.
To generate dbc file run autoconfig(OR) Execute adgendbc.sh script.



Form where fmx is generated?

All the executable for forms are generated from fmb files.
cd $AU_TOP/forms/US.


Using adadmin is it possible to relink ad product?
No,we cannot do it using adrelink.sh



what is the configuration file of adutilities?
adconfig.txt which is located at $APPL_TOP/admin.


How oracle will know some adadmin session is running or not?

It will know from restart file.

cd $APPL_TOP/admin/$SID/restart
<name>.rf9

If rf9 is there,it assumes that some adutilities are running.
if any adadmin session failed then we restart adadmin session then it will read the information from restart file.


can we use adadmin in non-interactive mode?
Yes,we can use it using addefaultsfile.

Which adutlilty will not create table in the database?
adident utility will not create table in the dataabase.



Why we need to generate JAR files?

For certain patches,post patch activity.
During upgradation of oracle apps.

We can generate jar files in two ways.
Normal generation
=================
it will generate missing or out of date jar files.

Force generation
================
Force generation will generate all jar files.



What we had to do if we lost forms binary file?
Copy the binary file from another server.


What is the default form when we launch oracle application form?

FNDSCSCG.fmx
It is located in $FND_TOP/forms/US



What is the executable file when we are regenerating the forms?
in Oracle apps 11i f6ogen and in r12 frmcmp_batch.


What is the executable file when we are regenerating message files?
FNDMDGEN.FMX which is located at $FND_TOP/bin


What is the executable when we are regenerating reports?
rwcon60 in oracle application 11i.


How can we generate dbc file?
By running auto config.
By executing adgendbc.sh file which is located at $COMMON_TOP/admin/install/$CONTEXT_NAME
and in R12 $INST_TOP/install/admin.adgendbc.sh

(MWA)Telnet is not working on the below port 10230

User will raise ticket with dbateam saying mobile server(telnet)  is not running on ebsvision database(or)
you will get communication mail from user (or)business.

How do you check whether mobile services is up and running in R12?

[applvision@apps install]$ ps -fu applvision|grep -i Doracle
501       7146  5748  0 00:22 pts/3    00:00:00 grep -i doracle

Check whether the mobile port is listening for any sevices.
[applvision@apps install]$ netstat -ann|grep -i 10230

After checking above two steps we can say that telnet is down.

[applvision@apps scripts]$ cd $ADMIN_SCRIPTS_HOME
[applvision@apps scripts]$ pwd
/apps/vision/inst/apps/vision_apps/admin/scripts

Now start mobile service on the same port
============================
[applvision@apps scripts]$ nohup mwactl.sh start 10230 &
[1] 7161
[applvision@apps scripts]$ nohup: appending output to `nohup.out'

[1]+  Done                    nohup mwactl.sh start 10230
[applvision@apps scripts]$ pwd
/apps/vision/inst/apps/vision_apps/admin/scripts


Now verify it
============
[applvision@apps scripts]$ ps -fu applvision|grep -i Doracle
501       7163     1  1 00:22 pts/3    00:00:03 /apps/vision/apps/tech_st/10.1.3/appsutil/jdk/bin/java -DCLIENT_PROCESSID=7163 -Doracle.apps.mwa=/apps/vision/apps/apps_st/appl/mwa/12.0.0 -Doracle.apps.jrad.mmd=/apps/vision/apps/apps_st/comn/webapps/oacore/html/jrad -Doracle.apps.inst=/apps/vision/inst/apps/vision_apps -mx512m -ms128m oracle.apps.mwa.presentation.telnet.Listener 10230
501       7313  5748  0 00:26 pts/3    00:00:00 grep -i doracle
[applvision@apps scripts]$ netstat -ann|grep -i 10230
tcp        0      0 0.0.0.0:10230               0.0.0.0:*                   LISTEN
[applvision@apps scripts]$


Now the mobile services are up and running.Tell user to check now.

Adding a path in utl_file_dir

Please add this path (/db/vision/temp) in utl_file_dir parameter.
You will get above details from ticket or business communication.

Bring down all middle tier services if you are using Oracle Application Ebs.

[applvision@apps ~]$ ps -fu applvision
UID        PID  PPID  C STIME TTY          TIME CMD
501       5747  5739  0 23:41 ?        00:00:00 sshd: applvision@pts/3
501       5748  5747  1 23:41 pts/3    00:00:00 -bash
501       5835  5748  0 23:41 pts/3    00:00:00 ps -fu applvision

Crosscheck whether the given path is exists in utl_file_dir.

SQL> show parameter utl_file_dir

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
utl_file_dir                         string      /usr/tmp, /usr/tmp, /db/vision
                                                 /db/tech_st/11.1.0/appsutil/ou
                                                 tbound/vision_apps, /usr/tmp
SQL>

Note:UTL_FILE_DIR parameter is static ,we have to bounce the database in order to add the path.

How to check whether a parameter is static or dynamic?

SQL> select ISSYS_MODIFIABLE from v$parameter where name like '%utl_file_dir%';

ISSYS_MOD
---------
FALSE              ===>static 

SQL>

SQL>  select ISSYS_MODIFIABLE from v$parameter where name like '%log_archive_dest%';

ISSYS_MOD
---------
IMMEDIATE        ====>dynamic


Create pfile from spfile and open pfile add the path and start your database with your modified
pfile.

SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /db/vision/db/tech_st/11.1.0/d
                                                 bs/spfilevision.ora
SQL> create pfile='/db/vision/initaddpath.ora' from spfile;

File created.

SQL>

Bring down the database
========================
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>


Add path in pfile in utl_file_dir parameter
=============================
[dbvision@apps temp]$ grep -i /db/vision/temp /db/vision/initaddpath.ora
*.utl_file_dir='/usr/tmp','/usr/tmp','/db/vision/db/tech_st/11.1.0/appsutil/outbound/vision_apps','/usr/tmp','/db/vision/temp'
[dbvision@apps temp]$


Start the database with pfile
======================
[dbvision@apps temp]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.1.0.7.0 - Production on Sun Sep 22 00:02:47 2013

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount pfile='/db/vision/initaddpath.ora'
ORACLE instance started.

Total System Global Area 1071333376 bytes
Fixed Size                  1318172 bytes
Variable Size             440402660 bytes
Database Buffers          616562688 bytes
Redo Buffers               13049856 bytes
SQL> show parameter utl_file_dir

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
utl_file_dir                         string      /usr/tmp, /usr/tmp, /db/vision
                                                 /db/tech_st/11.1.0/appsutil/ou
                                                 tbound/vision_apps, /usr/tmp,
                                                 /db/vision/temp
SQL> create spfile from pfile='/db/vision/initaddpath.ora';

File created.

SQL> shutdown immediate
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1071333376 bytes
Fixed Size                  1318172 bytes
Variable Size             440402660 bytes
Database Buffers          616562688 bytes
Redo Buffers               13049856 bytes
Database mounted.
Database opened.
SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /db/vision/db/tech_st/11.1.0/d
                                                 bs/spfilevision.ora
SQL> show parameter utl_file_dir

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
utl_file_dir                         string      /usr/tmp, /usr/tmp, /db/vision
                                                 /db/tech_st/11.1.0/appsutil/ou
                                                 tbound/vision_apps, /usr/tmp,
                                                 /db/vision/temp
SQL>

ORA-02097: parameter cannot be modified because specified value is invalid

Please enable primary archiving to this location /db/arch1  and secondary archive location to /opt/arch2.Please switch logfile to ensure archive are generated in both the location.

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /db/vision/db/tech_st/11.1.0/dbs/arch
Oldest online log sequence     20
Next log sequence to archive   21
Current log sequence

SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /db/vision/db/tech_st/11.1.0/d
                                                 bs/spfilevision.ora
SQL> alter system set log_archive_dest_1='LOCATION=/db/arch1';

System altered.

SQL> alter system set log_archive_dest_2='LOCATION=/opt/arch2';

System altered.

SQL>

SQL> show parameter arch

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target                   integer     0
log_archive_config                   string
log_archive_dest                     string
log_archive_dest_1                   string      LOCATION=/db/arch1
log_archive_dest_10                  string
log_archive_dest_2                   string      LOCATION=/opt/arch2
log_archive_dest_3                   string
log_archive_dest_4                   string
log_archive_dest_5                   string
log_archive_dest_6                   string
log_archive_dest_7                   string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_8                   string
log_archive_dest_9                   string
log_archive_dest_state_1             string      enable
log_archive_dest_state_10            string      enable
log_archive_dest_state_2             string      enable
log_archive_dest_state_3             string      enable
log_archive_dest_state_4             string      enable
log_archive_dest_state_5             string      enable
log_archive_dest_state_6             string      enable
log_archive_dest_state_7             string      enable
log_archive_dest_state_8             string      enable

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_9             string      enable
log_archive_duplex_dest              string
log_archive_format                   string      %t_%s_%r.dbf
log_archive_local_first              boolean     TRUE
log_archive_max_processes            integer     4
log_archive_min_succeed_dest         integer     1
log_archive_start                    boolean     FALSE
log_archive_trace                    integer     0
standby_archive_dest                 string      ?/dbs/arch
SQL>

SQL> alter system switch logfile;

System altered.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[dbvision@apps 11.1.0]$ pwd
/db/vision/db/tech_st/11.1.0
[dbvision@apps 11.1.0]$ cd /db/arch1
[dbvision@apps arch1]$ pwd
/db/arch1
[dbvision@apps arch1]$ ls -tlrh
total 180M
-rw-r----- 1 dbvision dba 387M Sep 20 07:30 1_21_790902108.dbf
[dbvision@apps arch1]$ cd /opt/arch2
[dbvision@apps arch2]$ ls -tlrh
total 298M
-rw-r----- 1 dbvision dba 387M Sep 20 07:31 1_21_790902108.dbf
[dbvision@apps arch2]$





If archive log is disabled then how to do archiving in two location.
===================================================================
create pfile from spfile;
shutdown immediate
add below parameters and start database.
log_archive_dest_1='LOCATION=/db/arch1'
log_archive_dest_2='LOCATION=/opt/arch2'
*.log_archive_dest_state_1=ENABLE
*.log_archive_dest_state_2=ENABLE

startup mount pfile='location'
alter database archivelog;
create spfile from pfile='loc';
shutdown immediate
startup
alter system logfile;

what happens when someone deleted FNDLIBR/FNDFS executable?Is your concurrent will come up?

what happens when someone deleted FNDLIBR/FNDFS executable?Is your concurrent will come up?
We can re create it ,your Concurrent manager will not start if you lost executable.

Follow below steps to re create executable.

1)Login admin tier and run adadmin
2)         AD Administration Main Menu
   --------------------------------------------------

   1.    Generate Applications Files menu
  2.    Maintain Applications Files menu

 select '2' option.
Enter your choice [6] : 2

         Maintain Applications Files
   ----------------------------------------

   1.    Relink Applications programs  ==>Generate Specific executable.



----------------------------------------------
Move executable to create scenario
-----------------------------------------------

[applvision@apps bin]$ ls -ltrh FNDLIBR
-rwxr-xr-x 1 applvision applmgr 1.6M Mar 30  2009 FNDLIBR
[applvision@apps bin]$ mv FNDLIBR FNDLIBR_19sep2013
[applvision@apps bin]$ pwd


Lets try to start Concurrent manager.
[applvision@apps scripts]$ adcmctl.sh start apps/apps

You are running adcmctl.sh version 120.17.12010000.3

Starting concurrent manager for vision ...
Starting vision_0920@vision Internal Concurrent Manager
Default printer is noprint

adcmctl.sh: exiting with status 0


adcmctl.sh: check the logfile /apps/vision/inst/apps/vision_apps/logs/appl/admin/log/adcmctl.txt for more information ...

No processes are running
[applvision@apps scripts]$ ps -fu applvision
UID        PID  PPID  C STIME TTY          TIME CMD
501       5536  5527  0 06:23 ?        00:00:00 sshd: applvision@pts/2
501       5537  5536  0 06:23 pts/2    00:00:00 -bash
501       5807     1  0 06:25 pts/2    00:00:00 sendmail: ./r8K0tLqD005807 [127.0.0.1]: client MAIL
501       5813  5537  0 06:25 pts/2    00:00:00 ps -fu applvision

===============================================
Concurrent manager log file contain below message
==================================================

Starting vision_0920@vision Internal Concurrent Manager -- shell process ID 5794

          logfile=/apps/vision/inst/apps/vision_apps/logs/appl/conc/log/vision_0920.mgr
          PRINTER=noprint
           mailto=applvision
          restart=N
             diag=N
            sleep=30
             pmon=4
           quesiz=1
          Reviver is ENABLED

sh: line 34: FNDLIBR: command not found
The vision_0920@vision internal concurrent manager has terminated with status 127 - giving up.


Let's try to generate executable.

AD code level : [B.1]

            AD Administration Main Menu
   --------------------------------------------------

   1.    Generate Applications Files menu

   2.    Maintain Applications Files menu

   3.    Compile/Reload Applications Database Entities menu

   4.    Maintain Applications Database Entities menu

   5.    Change Maintenance Mode

   6.    Exit AD Administration









Enter your choice [6] : 2

         Maintain Applications Files
   ----------------------------------------

   1.    Relink Applications programs

   2.    Copy files to destinations

   3.    Convert character set

   4.    Maintain snapshot information

   5.    Check for missing files

   6.    Return to Main Menu









Enter your choice [6] : 1

AD Administration uses your Oracle Applications environment file
to set up the environment for relinking Applications.

Before proceeding with the relink, you may optionally want to:
 - Go back to the menu by answering No below.
 - Use an option on the Maintain Files menu
   to generate your Applications environment file.
 - Edit the file to add any customizations.
 - Verify the list of executables in adlinkbk.txt which are saved
   before relinking and add any additional executables as desired.
 - Choose this option again, and proceed with the relink.

Do you wish to proceed with the relink [Yes] ?

Enter the name of your Oracle Applications environment file below.
File name [vision_apps.env] :

Reading product executable information...

Enter list of products to link ('all' for all products) [all] : FND

Generate specific executables for each selected product [No] ? YES

AD Administration can relink your Oracle Applications programs with debug
information.  Oracle recommends that you do not relink your programs
with debug information unless asked to do so by Oracle Support Services.

Relink with debug information [No] ?

Relinking selected modules in Application Object Library.

List of executables in Application Object Library :

         ADCONV       AFTBLGEN     CMDCART.so        CONCSUB        FDULONG
        FNDAQCT       FNDATUPD       FNDCPASS       FNDCPGLC       FNDCPPUR
       FNDCPRRF       FNDCPSPN       FNDCPTST       FNDCPUCF         FNDCRM
       FNDDWPUR        FNDEMON       FNDFBPLS       FNDFBUPG       FNDFFCHY
       FNDFFRXR       FNDFFUPG       FNDFFVGN          FNDFS         FNDGFH
         FNDLIBR        FNDIMON        FNDLIBR        FNDLOAD      FNDLOADSO
       FNDMDCVT       FNDMDGEN       FNDPRESC       FNDPSTAX       FNDRTR45
         FNDSCH       FNDSLOAD          FNDSM       FNDSVCRG       FNDTMTST
     FNDWRR.exe         WFLOAD       WFMLRXFR       WFRESGEN         WFTEST
         fdfcmp       fndcpesr    fndfmxit.so    fndrwxit.so

Enter executables to relink, or enter 'all' [all] : FNDLIBDR
**********************************************************
You are running adrelink, version 120.43

Start of adrelink session
Date/time is  Fri Sep 20 06:34:54 IST 2013
Log file is  /apps/vision/apps/apps_st/appl/admin/vision/log/adrelink.log
Command line arguments are
   "force=y" "ranlib=y" "link_debug=n" "filelist=/apps/vision/apps/apps_st/appl/admin/vision/out/alkfnd000.txt"


Operating System Information (output of 'uname -a'):

Linux apps.innovation.com 2.6.18-238.el5PAE #1 SMP Tue Jan 4 15:50:36 EST 2011 i686 i686 i386 GNU/Linux


Backup Mode is "file"

Removing extra variables from the environment...
  adrelink will save the following variables (if set):
   - Generic:
"PATH ORACLE_HOME TMPDIR TZ APPL_TOP APPLFENV PLATFORM LD_LIBRARY_PATH COBDIR LIBPATH NLS_LANG JAVA_TOP PERL5LIB"
   - Shell-Specific: "PS1 PS2 PS3 PS4 IFS MAILCHECK _ LOGNAME A__z"
  Beginning pass 1.
   Processing 373 environment variables...
     361 removed; 12 saved.
  Beginning pass 2.
   Processing 12 environment variables...
     0 removed; 12 saved.
Done removing extra environment variables.

Removing Application products' bin directories from PATH ...
Done removing Application products' bin directories from PATH

Reading Oracle Applications environment file
Your Oracle Applications environment file is /apps/vision/apps/apps_st/appl/vision_apps.env

Removing $FND_TOP/$APPLBIN from PATH ...
Done removing $FND_TOP/$APPLBIN from PATH

Removing extra variables from the environment (again)...
  adrelink will save the following variables (if set):
   - Generic:
"PATH ORACLE_HOME TMPDIR TZ LD_LIBRARY_PATH COBDIR LIBPATH NLS_LANG JAVA_TOP PERL5LIB"
   - Shell-Specific: "PS1 PS2 PS3 PS4 IFS MAILCHECK _ LOGNAME A__z"
  Beginning pass 1.
   Processing 337 environment variables...
     328 removed; 9 saved.
  Beginning pass 2.
   Processing 9 environment variables...
     0 removed; 9 saved.
Done removing extra environment variables (again).


Re-reading critical environment variables ...
Done re-reading critical environment variables


ORACLE RDBMS   Version 10.1.0.5.0
Oracle Reports Version 10.1.2

Oracle Applications Release 12


Current product is  AD
LADLIB  is set to /apps/vision/apps/apps_st/appl/ad/12.0.0/lib/libad.a

Current product is  ALR
LALRLIB  is set to /apps/vision/apps/apps_st/appl/alr/12.0.0/lib/libalr.a

Current product is  AP
LAPLIB  is set to /apps/vision/apps/apps_st/appl/ap/12.0.0/lib/libap.a

Current product is  AR
LARLIB  is set to /apps/vision/apps/apps_st/appl/ar/12.0.0/lib/libar.a
LARSRW  is set to /apps/vision/apps/apps_st/appl/ar/12.0.0/lib/xirar.o $(LARLIB)

Current product is  BOM
LBOMLIB  is set to /apps/vision/apps/apps_st/appl/bom/12.0.0/lib/libbom.a

Current product is  CRP
LCRPLIB  is set to /apps/vision/apps/apps_st/appl/crp/12.0.0/lib/libcrp.a

Current product is  CZ
LCZLIB  is set to /apps/vision/apps/apps_st/appl/cz/12.0.0/lib/libcz.a

Current product is  DDR
adrelink: Warning: not setting  LDDRLIB
since /apps/vision/apps/apps_st/appl/ddr/12.0.0/lib/libddr.a does not exist
or cannot be read.

Current product is  DPP
adrelink: Warning: not setting  LDPPLIB
since /apps/vision/apps/apps_st/appl/dpp/12.0.0/lib/libdpp.a does not exist
or cannot be read.

Current product is  DT
LDTLIB  is set to /apps/vision/apps/apps_st/appl/dt/12.0.0/lib/libdt.a

Current product is  ENG
LENGLIB  is set to /apps/vision/apps/apps_st/appl/eng/12.0.0/lib/libeng.a

Current product is  FA
LFALIB  is set to /apps/vision/apps/apps_st/appl/fa/12.0.0/lib/libfa.a
LFASRW  is set to /apps/vision/apps/apps_st/appl/fa/12.0.0/lib/xirfa.o $(LFALIB)

Current product is  FEM
LFEMLIB  is set to /apps/vision/apps/apps_st/appl/fem/12.0.0/lib/libfem.a

Current product is  FF
LFFLIB  is set to /apps/vision/apps/apps_st/appl/ff/12.0.0/lib/libff.a

Current product is  FND
LFNDLIB  is set to /apps/vision/apps/apps_st/appl/fnd/12.0.0/lib/libfnd.a
LFNDSRW  is set to /apps/vision/apps/apps_st/appl/fnd/12.0.0/lib/xirfnd.o $(LFNDLIB)

Current product is  FTP
LFTPLIB  is set to /apps/vision/apps/apps_st/appl/ftp/12.0.0/lib/libftp.a

Current product is  GL
LGLLIB  is set to /apps/vision/apps/apps_st/appl/gl/12.0.0/lib/libgl.a

Current product is  GMA
LGMALIB  is set to /apps/vision/apps/apps_st/appl/gma/12.0.0/lib/libgma.a

Current product is  GMF
LGMFLIB  is set to /apps/vision/apps/apps_st/appl/gmf/12.0.0/lib/libgmf.a

Current product is  GML
LGMLLIB  is set to /apps/vision/apps/apps_st/appl/gml/12.0.0/lib/libgml.a

Current product is  IBY
LIBYLIB  is set to /apps/vision/apps/apps_st/appl/iby/12.0.0/lib/libiby.a

Current product is  INL
adrelink: Warning: not setting  LINLLIB
since /apps/vision/apps/apps_st/appl/inl/12.0.0/lib/libinl.a does not exist
or cannot be read.

Current product is  INV
LINVLIB  is set to /apps/vision/apps/apps_st/appl/inv/12.0.0/lib/libinv.a

Current product is  IZU
adrelink: Warning: not setting  LIZULIB
since /apps/vision/apps/apps_st/appl/izu/12.0.0/lib/libizu.a does not exist
or cannot be read.

Current product is  MRP
LMRPLIB  is set to /apps/vision/apps/apps_st/appl/mrp/12.0.0/lib/libmrp.a

Current product is  MSC
LMSCLIB  is set to /apps/vision/apps/apps_st/appl/msc/12.0.0/lib/libmsc.a

Current product is  MSO
LMSOLIB  is set to /apps/vision/apps/apps_st/appl/mso/12.0.0/lib/libmso.a

Current product is  MSR
LMSRLIB  is set to /apps/vision/apps/apps_st/appl/msr/12.0.0/lib/libmsr.a

Current product is  MST
LMSTLIB  is set to /apps/vision/apps/apps_st/appl/mst/12.0.0/lib/libmst.a

Current product is  MTH
adrelink: Warning: not setting  LMTHLIB
since /apps/vision/apps/apps_st/appl/mth/12.0.0/lib/libmth.a does not exist
or cannot be read.

Current product is  MWA
LMWALIB  is set to /apps/vision/apps/apps_st/appl/mwa/12.0.0/lib/libmwa.a

Current product is  PA
LPALIB  is set to /apps/vision/apps/apps_st/appl/pa/12.0.0/lib/libpa.a

Current product is  PAY
LPAYLIB  is set to /apps/vision/apps/apps_st/appl/pay/12.0.0/lib/libpay.a

Current product is  PO
LPOLIB  is set to /apps/vision/apps/apps_st/appl/po/12.0.0/lib/libpo.a
LPOSRW  is set to /apps/vision/apps/apps_st/appl/po/12.0.0/lib/xirpo.o $(LPOLIB)

Current product is  PON
LPONLIB  is set to /apps/vision/apps/apps_st/appl/pon/12.0.0/lib/libpon.a

Current product is  QPR
adrelink: Warning: not setting  LQPRLIB
since /apps/vision/apps/apps_st/appl/qpr/12.0.0/lib/libqpr.a does not exist
or cannot be read.

Current product is  RG
LRGLIB  is set to /apps/vision/apps/apps_st/appl/rg/12.0.0/lib/librg.a

Current product is  RRS
adrelink: Warning: not setting  LRRSLIB
since /apps/vision/apps/apps_st/appl/rrs/12.0.0/lib/librrs.a does not exist
or cannot be read.

Current product is  WIP
LWIPLIB  is set to /apps/vision/apps/apps_st/appl/wip/12.0.0/lib/libwip.a

Current product is  WPS
LWPSLIB  is set to /apps/vision/apps/apps_st/appl/wps/12.0.0/lib/libwps.a

Current product is  WSM
LWSMLIB  is set to /apps/vision/apps/apps_st/appl/wsm/12.0.0/lib/libwsm.a

Current product is  XDP
LXDPLIB  is set to /apps/vision/apps/apps_st/appl/xdp/12.0.0/lib/libxdp.a

LUSRLIB is /apps/vision/apps/apps_st/appl/fnd/12.0.0/usrxit/libusr.a

Not linking Oracle Applications with any Oracle mail product

LALRSTUB is now set to /apps/vision/apps/apps_st/appl/alr/12.0.0/lib/alstub.o
MAILLNK  is now set to /apps/vision/apps/apps_st/appl/alr/12.0.0/lib/alstub.o

Creating prefix makefiles ...
Done creating prefix makefiles

The file /apps/vision/apps/apps_st/appl/admin/vision/out/alkfnd000.txt contains:
***
***

adrelink is exiting with status 0

End of adrelink session
Date/time is  Fri Sep 20 06:35:01 IST 2013
**********************************************************

Line-wrapping log file for readability ...
Done line-wrapping log file.

Original copy is /apps/vision/apps/apps_st/appl/admin/vision/log/adrelink.lsv
New copy is /apps/vision/apps/apps_st/appl/admin/vision/log/adrelink.log


Review the messages above, then press [Return] to continue.


Backing up restart files, if any......Done.

         Maintain Applications Files
   ----------------------------------------

   1.    Relink Applications programs

   2.    Copy files to destinations

   3.    Convert character set

   4.    Maintain snapshot information

   5.    Check for missing files

   6.    Return to Main Menu









Enter your choice [6] :

                               

Now check your executable
===========================

[applvision@apps bin]$ ls -ltrh FNDLIBR
-rwxr-xr-x 1 applvision applmgr 1.6M Sep 19  2013 FNDLIBR
[applvision@apps bin]$

                                                         

Recreate grants and synonyms for apps schema?

Note *:-
it will recreate missing grants and synonyms.after completion of below adulility it will create two files.


[applvision@apps ~]$ 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 '/apps/vision/apps/apps_st/appl'.
Is this the correct APPL_TOP [Yes] ?

AD Administration records your AD Administration session in a text file
you specify.  Enter your AD Administration log file name or press [Return]
to accept the default file name shown in brackets.

Filename [adadmin.log] : practice.log

************* Start of AD Administration session *************
AD Administration version: 12.0.0
AD Administration started at: Mon Sep 16 2013 00:59:44

APPL_TOP is set to /apps/vision/apps/apps_st/appl

You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ?

Please enter the batchsize [1000] :


Please enter the name of the Oracle Applications System that this
APPL_TOP belongs to.

The Applications System name must be unique across all Oracle
Applications Systems at your site, must be from 1 to 30 characters
long, may only contain alphanumeric and underscore characters,
and must start with a letter.

Sample Applications System names are: "prod", "test", "demo" and
"Development_2".

Applications System Name [vision] : vision *


NOTE: If you do not currently have certain types of files installed
in this APPL_TOP, you may not be able to perform certain tasks.

Example 1: If you don't have files used for installing or upgrading
the database installed in this area, you cannot install or upgrade
the database from this APPL_TOP.

Example 2: If you don't have forms files installed in this area, you cannot
generate them or run them from this APPL_TOP.

Example 3: If you don't have concurrent program files installed in this area,
you cannot relink concurrent programs or generate reports from this APPL_TOP.


Do you currently have files used for installing or upgrading the database
installed in this APPL_TOP [YES] ? YES *


Do you currently have Java and HTML files for HTML-based functionality
installed in this APPL_TOP [YES] ? YES *


Do you currently have Oracle Applications forms files installed
in this APPL_TOP [YES] ? YES *


Do you currently have concurrent program files installed
in this APPL_TOP [YES] ? YES *


Please enter the name Oracle Applications will use to identify this APPL_TOP.

The APPL_TOP name you select must be unique within an Oracle Applications
System, must be from 1 to 30 characters long, may only contain
alphanumeric and underscore characters, and must start with a letter.

Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".

APPL_TOP Name [apps] : apps *



You are about to use or modify Oracle Applications product tables
in your ORACLE database 'vision'
using ORACLE executables in '/apps/vision/apps/tech_st/10.1.2'.

Is this the correct database [Yes] ?

AD Administration needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.

Enter the password for your 'SYSTEM' ORACLE schema:


The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS

Enter the ORACLE password of Application Object Library [APPS] :

AD Administration is verifying your username/password.
The status of various features in this run of AD Administration is:

                                           <-Feature version in->
Feature                          Active?   APPLTOP    Data model    Flags
------------------------------   -------   --------   -----------   -----------
CHECKFILE                        Yes       1          1             Y N N Y N Y
PREREQ                           Yes       6          6             Y N N Y N Y
CONCURRENT_SESSIONS              No        2          2             Y Y N Y Y N
PATCH_TIMING                     Yes       2          2             Y N N Y N Y
PATCH_HIST_IN_DB                 Yes       6          6             Y N N Y N Y
SCHEMA_SWAP                      Yes       1          1             Y N N Y Y Y
JAVA_WORKER                      Yes       1          1             Y N N Y N Y
CODELEVEL                        Yes       1          1             Y N N Y N Y



Identifier for the current session is 16762

Reading product information from file...

Reading language and territory information from file...

Reading language information from applUS.txt ...

AD Administration warning:
 Product Data File


Reading database to see what industry is currently installed.

Reading FND_LANGUAGES to see what is currently installed.
Currently, the following language is installed:

Code   Language                                Status
----   --------------------------------------- ---------
US     American English                        Base

Your base language will be AMERICAN.

Setting up module information.
Reading database for information about the modules.
Saving module information.
Reading database for information about the products.
Reading database for information about how products depend on each other.
Reading topfile.txt ...

Saving product information.

AD code level : [B.1]

            AD Administration Main Menu
   --------------------------------------------------

   1.    Generate Applications Files menu

   2.    Maintain Applications Files menu

   3.    Compile/Reload Applications Database Entities menu

   4.    Maintain Applications Database Entities menu

   5.    Change Maintenance Mode

   6.    Exit AD Administration

Enter your choice [6] : 4

         Maintain Applications Database Entities
   ---------------------------------------------------

   1.    Validate APPS schema

   2.    Re-create grants and synonyms for APPS schema

   3.    Maintain multi-lingual tables

   4.    Check DUAL table

   5.    Return to Main Menu


Enter your choice [5] : 2

AD utilities can support a maximum of 999 workers. Your
current database configuration supports a maximum of 84 workers.
Oracle recommends that you use between 8 and 16 workers.


Enter the number of workers [8] : 8

 Recreating grants and synonyms needed by all installed applications...

sqlplus -s APPS/***** @/apps/vision/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/afpub.sql &un_apps &pw_apps &un_pub &pw_pub

sqlplus -s APPS/***** @/apps/vision/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/afsys.sql SYSTEM &systempwd &un_apps &un_fnd

sqlplus -s APPS/***** @/apps/vision/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adpcpmsc.sql &un_fnd &pw_fnd &systempwd

sqlplus -s APPS/***** @/apps/vision/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adinvmsc.sql &un_fnd &pw_fnd &systempwd

sqlplus -s APPS/***** @/apps/vision/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adjvaprm.sql &un_apps &systempwd

sqlplus -s APPS/***** @/apps/vision/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adgrnctx.sql &systempwd &un_fnd CTXSYS &un_fnd FND

sqlplus -s APPS/***** @/apps/vision/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adgrnctx.sql &systempwd &un_fnd CTXSYS &un_icx ICX

sqlplus -s APPS/***** @/apps/vision/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adgrnctx.sql &systempwd &un_fnd CTXSYS &un_amv AMV

sqlplus -s APPS/***** @/apps/vision/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adgrnctx.sql &systempwd &un_fnd CTXSYS &un_jtf JTF

sqlplus -s APPS/***** @/apps/vision/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adgrnctx.sql &systempwd &un_fnd CTXSYS &un_cs CS

sqlplus -s APPS/***** @/apps/vision/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adgrnctx.sql &systempwd &un_fnd CTXSYS &un_ar AR

sqlplus -s APPS/***** @/apps/vision/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adgrnctx.sql &systempwd &un_fnd CTXSYS &un_apps APPS

sqlplus -s APPS/***** @/apps/vision/apps/apps_st/appl/ad/12.0.0/patch/115/sql/aduora.sql &un_apps &pw_apps &systempwd


Creating the AD_UTIL_PARAMS table...
Table AD_UTIL_PARAMS already exists, so dropping the table and recreating it.

Creating FND_INSTALL_PROCESSES table...

Setting parallel context: Maintaining grants and synonyms in APPS schema(s) at R120


Need to create grants and synonyms in APPS account APPS/*****

Making job list for APPS/*****


Selecting from FND_PRODUCT_GROUPS table...

Writing dependencies of jobs to run to appldep.txt file...

There are now 186 jobs remaining (current phase=admin):
    0 running, 186 ready to run and 0 waiting.

Reading completed jobs from restart file (if any).

There are now 186 jobs remaining (current phase=admin):
    0 running, 186 ready to run and 0 waiting.


Determining which java executables are supported by adJavaWorker...

Starting worker processes.

Worker process 1 started.

Worker process 2 started.

Worker process 3 started.

************* Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Mon Sep 16 2013 04:49:54

APPL_TOP is set to /apps/vision/apps/apps_st/appl

************* Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Mon Sep 16 2013 04:49:54

APPL_TOP is set to /apps/vision/apps/apps_st/appl

************* Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Mon Sep 16 2013 04:49:54

APPL_TOP is set to /apps/vision/apps/apps_st/appl

Worker process 4 started.

************* Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Mon Sep 16 2013 04:49:54

APPL_TOP is set to /apps/vision/apps/apps_st/appl

Worker process 5 started.

Worker process 6 started.

Worker process 7 started.

************* Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Mon Sep 16 2013 04:49:54

APPL_TOP is set to /apps/vision/apps/apps_st/appl

Worker process 8 started.

Checking if all jobs have their actual and symbolic arguments in sync....

Done.

Writing jobs to run to restart file.
************* Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Mon Sep 16 2013 04:49:54

APPL_TOP is set to /apps/vision/apps/apps_st/appl


Reading jobs from FND_INSTALL_PROCESSES table ...

************* Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Mon Sep 16 2013 04:49:54

APPL_TOP is set to /apps/vision/apps/apps_st/appl

************* Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Mon Sep 16 2013 04:49:54

APPL_TOP is set to /apps/vision/apps/apps_st/appl


Done reading jobs from FND_INSTALL_PROCESSES table ...

Telling workers to read 'todo' restart file.
Done.

Starting phase 1000 (admin): Administration


There are now 186 jobs remaining (current phase=admin):
    0 running, 186 ready to run and 0 waiting.

 Assigned: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  5 for product ad  username APPLSYS.

There are now 180 jobs remaining (current phase=admin):
    8 running, 172 ready to run and 0 waiting.

Completed: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  5 for product ad  username APPLSYS.

There are now 167 jobs remaining (current phase=admin):
    4 running, 163 ready to run and 0 waiting.

Completed: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  6 for product ad  username APPLSYS.

There are now 159 jobs remaining (current phase=admin):
    6 running, 153 ready to run and 0 waiting.

 Assigned: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  7 for product ad  username APPLSYS.

There are now 150 jobs remaining (current phase=admin):
    8 running, 142 ready to run and 0 waiting.

Completed: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  8 for product ad  username APPLSYS.

There are now 140 jobs remaining (current phase=admin):
    8 running, 132 ready to run and 0 waiting.

Completed: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  5 for product ad  username APPLSYS.

There are now 127 jobs remaining (current phase=admin):
    3 running, 124 ready to run and 0 waiting.

Completed: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  3 for product ad  username APPLSYS.

There are now 120 jobs remaining (current phase=admin):
    8 running, 112 ready to run and 0 waiting.

Completed: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  6 for product ad  username APPLSYS.

There are now 109 jobs remaining (current phase=admin):
    6 running, 103 ready to run and 0 waiting.

 Assigned: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  3 for product ad  username APPLSYS.

There are now 100 jobs remaining (current phase=admin):
    8 running, 92 ready to run and 0 waiting.

Completed: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  8 for product ad  username APPLSYS.

There are now 90 jobs remaining (current phase=admin):
    8 running, 82 ready to run and 0 waiting.

Completed: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  7 for product ad  username APPLSYS.

There are now 79 jobs remaining (current phase=admin):
    6 running, 73 ready to run and 0 waiting.

 Assigned: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  8 for product ad  username APPLSYS.

There are now 69 jobs remaining (current phase=admin):
    6 running, 63 ready to run and 0 waiting.

 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  8 for product ad  username APPLSYS.

There are now 60 jobs remaining (current phase=admin):
    8 running, 52 ready to run and 0 waiting.

Completed: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  7 for product ad  username APPLSYS.

There are now 50 jobs remaining (current phase=admin):
    8 running, 42 ready to run and 0 waiting.

Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  7 for product ad  username APPLSYS.

There are now 39 jobs remaining (current phase=admin):
    6 running, 33 ready to run and 0 waiting.

 Assigned: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  8 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  5 for product ad  username APPLSYS.

There are now 30 jobs remaining (current phase=admin):
    8 running, 22 ready to run and 0 waiting.

Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  6 for product ad  username APPLSYS.

There are now 20 jobs remaining (current phase=admin):
    8 running, 12 ready to run and 0 waiting.

Completed: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  7 for product ad  username APPLSYS.

There are now 10 jobs remaining (current phase=admin):
    8 running, 2 ready to run and 0 waiting.

Completed: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  7 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  6 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  5 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  4 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  8 for product ad  username APPLSYS.

Done maintaining grants and synonyms in APPS schema(s).


Telling workers to quit...


All workers have quit.


Dropping FND_INSTALL_PROCESSES table...


FND_INSTALL_PROCESSES table dropped.


Dropping AD_DEFERRED_JOBS table...


AD_DEFERRED_JOBS table dropped.

Review the messages above, then press [Return] to continue.


Backing up restart files, if any......Done.

         Maintain Applications Database Entities
   ---------------------------------------------------

   1.    Validate APPS schema

   2.    Re-create grants and synonyms for APPS schema

   3.    Maintain multi-lingual tables

   4.    Check DUAL table

   5.    Return to Main Men

Enter your choice [5] :