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] :

How to validate apps schema through adadmin?

Note *:-
It will validate apps schema.
It will report all missing grants and synonyms in a text file called appl.txt.
Above file is located at /apps/vision/apps/apps_st/appl/admin/vision/out/APPS.lst


[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] : 1


Validating APPS schema "APPS"...


sqlplus -s SYSTEM/***** @/apps/vision/apps/apps_st/appl/ad/12.0.0/sql/advrfapp.sql APPS APPLSYS


Done validating APPS schema "APPS".

Validation output is recorded in
/apps/vision/apps/apps_st/appl/admin/vision/out/APPS.lst


Successful completion of the SQL scripts above does not
guarantee that any or all of your APPS schemas are correct.

You must review the output from this validation step and fix
all indicated problems.  You should then re-run this step to
ensure that all problems have been corrected.



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 Menu

Enter your choice [5] :