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] :
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] :
No comments:
Post a Comment