LOCATION :
SIGNIFICANCE :
IMPORTANT POINTS :
FILE :
#########################################################################################################
************* Start of AutoPatch session *************
AutoPatch version: 11.5.0
AutoPatch started at: Thu Jul 01 2010 01:44:54
APPL_TOP is set to /eb_rdo11_d/applmgr/d550appl
Options = "nomaintainmrc,nocompiledb".
NLS_LANG value from the environment is : AMERICAN_AMERICA.UTF8
NLS_LANG value for this AD utility run is : AMERICAN_AMERICA.UTF8
You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ? No
Please enter the batchsize [1000] : 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 [d550] : d550 *
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 [NO] ? NO *
Do you currently have Oracle Applications forms files installed
in this APPL_TOP [NO] ? NO *
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 [d550a_tned35n] : d550a_tned35n *
You are about to apply a patch to the installation of Oracle Applications
in your ORACLE database 'd550a'
using ORACLE executables in '/eb_rdo11_d/applmgr/d550ora/8.0.6'.
Is this the correct database [Yes] ? Yes
AutoPatch needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.
Enter the password for your 'SYSTEM' ORACLE schema: *****
Connecting to SYSTEM......Connected successfully.
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] : *****
AutoPatch is verifying your username/password.
Connecting to APPLSYS......Connected successfully.
The status of various features in this run of AutoPatch 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
Connecting to SYSTEM......Connected successfully.
Connecting to APPLSYS......Connected successfully.
Identifier for the current session is 12214
Reading product information from file...
Reading language and territory information from file...
Reading language information from applUS.txt ...
Reading database to see what industry is currently installed.
Reading FND_LANGUAGES to see what is currently installed.
Currently, the following languages are installed:
Code Language Status
---- --------------------------------------- ---------
US American English Base
FRC Canadian French Install
ESA Latin American Spanish Install
Reading language information from applFRC.txt ...
Reading language information from applESA.txt ...
Your base language will be AMERICAN.
Your other languages to install are: CANADIAN FRENCH, LATIN AMERICAN SPANISH
Setting up module information.
Reading database for information about the modules.
Saving module information.
Reading database for information about the products.
Connecting to SYSTEM......Connected successfully.
Connecting to APPLSYS......Connected successfully.
Connecting to SYSTEM......Connected successfully.
Reading database for information about how products depend on each other.
Connecting to APPLSYS......Connected successfully.
Reading topfile.txt ...
Saving product information.
Connecting to SYSTEM......Connected successfully.
Connecting to APPLSYS......Connected successfully.
AD code level : [11i.AD.I.7]
STRT_TASK: [AutoPatch startup after aimini] [] [Thu Jul 01 2010 01:45:56]
Connecting to APPS......Connected successfully.
STRT_TASK: [Validate schema passwords] [] [Thu Jul 01 2010 01:45:56]
Connecting to APPLSYS......Connected successfully.
Connecting to APPS......Connected successfully.
STOP_TASK: [Validate schema passwords] [] [Thu Jul 01 2010 01:45:57]
STRT_TASK: [Upload Patch History information from filesystem] [] [Thu Jul 01 2010 01:45:57]
Trying to obtain a lock...
About to attempt instantiating the current-view snapshot: Thu Jul 01 2010 01:45:57
Attempting to instantiate the current-view snapshot...
Was already instantiated. So no instantiation done this time.
Done attempting to instantiate the current-view snapshot: Thu Jul 01 2010 01:45:57
**************** S T A R T O F U P L O A D ****************
Start date: Thu Jul 01 2010 01:45:57
0 "left over" javaupdates.txt files uploaded to DB: Thu Jul 01 2010 01:45:57
0 patches uploaded from the ADPSV format patch history files: Thu Jul 01 2010 01:45:57
Uploading information about files copied during the previous runs ...
0 "left over" filescopied_<session_id>.txt files uploaded to DB: Thu Jul 01 2010 01:45:57
****************** E N D O F U P L O A D ******************
End date: Thu Jul 01 2010 01:45:57
STOP_TASK: [Upload Patch History information from filesystem] [] [Thu Jul 01 2010 01:45:57]
Enter the directory where your Oracle Applications patch has been unloaded
The default directory is [/tools_software/software/NA11.5.10.2/9732494] : /tools_software/software/NA11.5.10.2/9732494
STOP_TASK: [AutoPatch startup after aimini] [] [Thu Jul 01 2010 01:45:59]
Please enter the name of your AutoPatch driver file : u9732494.drv
STRT_TASK: [Run a single patch driver file] [] [Thu Jul 01 2010 01:46:04]
STRT_TASK: [Steps before copy portion] [] [Thu Jul 01 2010 01:46:04]
STRT_TASK: [Initial driver processing steps] [] [Thu Jul 01 2010 01:46:04]
Start time for driver file is: Thu Jul 01 2010 01:46:04
STOP_TASK: [Initial driver processing steps] [] [Thu Jul 01 2010 01:46:04]
STRT_TASK: [Get Oracle Applications Release and read driver file] [] [Thu Jul 01 2010 01:46:04]
STRT_TASK: [Get Oracle Applications Release] [] [Thu Jul 01 2010 01:46:04]
Getting Oracle Applications Release...
Connecting to APPLSYS......Connected successfully.
Current installed release is 11.5.10.2
Connecting to APPS......Connected successfully.
STOP_TASK: [Get Oracle Applications Release] [] [Thu Jul 01 2010 01:46:05]
STRT_TASK: [Process patch driver file] [] [Thu Jul 01 2010 01:46:05]
Reading patch driver file...
Connecting to SYSTEM......Connected successfully.
STRT_TASK: [Parse and load patch driver file] [] [Thu Jul 01 2010 01:46:05]
Connecting to APPS......Connected successfully.
Parsing and loading patch driver file...
42 lines processed.
STOP_TASK: [Parse and load patch driver file] [] [Thu Jul 01 2010 01:46:05]
STRT_TASK: [Check patch integrity] [] [Thu Jul 01 2010 01:46:05]
Not checking patch integrity as integrity checking flag is turned off.
STOP_TASK: [Check patch integrity] [] [Thu Jul 01 2010 01:46:05]
Successfully read patch driver file.
STOP_TASK: [Process patch driver file] [] [Thu Jul 01 2010 01:46:05]
STRT_TASK: [Other driver and release-related logic] [] [Thu Jul 01 2010 01:46:05]
Determining target release...
Current target release is 11.5.10.2
STOP_TASK: [Other driver and release-related logic] [] [Thu Jul 01 2010 01:46:05]
STOP_TASK: [Get Oracle Applications Release and read driver file] [] [Thu Jul 01 2010 01:46:05]
STRT_TASK: [Prereq checking logic] [] [Thu Jul 01 2010 01:46:05]
Check the current view before changing already_applied
STOP_TASK: [Prereq checking logic] [] [Thu Jul 01 2010 01:46:05]
STRT_TASK: [Ask translated patch question] [] [Thu Jul 01 2010 01:46:05]
STOP_TASK: [Ask translated patch question] [] [Thu Jul 01 2010 01:46:05]
STRT_TASK: [Determine bugs to apply] [] [Thu Jul 01 2010 01:46:05]
Determining which bug fixes to apply...
Turning off bug fixes for products not installed or shared in the database...
Resetting bug actions for bug fixes we will not apply...
Processing files for Oracle Government Applications...
Done determining which bug fixes to apply.
Log and Info File sync point:
Thu Jul 01 2010 01:46:05
Turning off actions that reference unrecognized products.
Log and Info File sync point:
Thu Jul 01 2010 01:46:05
End of unrecognized products checking.
STOP_TASK: [Determine bugs to apply] [] [Thu Jul 01 2010 01:46:05]
STRT_TASK: [Process action options] [] [Thu Jul 01 2010 01:46:05]
STOP_TASK: [Process action options] [] [Thu Jul 01 2010 01:46:05]
STRT_TASK: [Modify actions for bootstrap mode] [] [Thu Jul 01 2010 01:46:05]
STOP_TASK: [Modify actions for bootstrap mode] [] [Thu Jul 01 2010 01:46:05]
STRT_TASK: [Ask for number of parallel workers] [] [Thu Jul 01 2010 01:46:05]
Connecting to SYSTEM......Connected successfully.
Connecting to APPS......Connected successfully.
AD utilities can support a maximum of 999 workers. Your
current database configuration supports a maximum of 351 workers.
Oracle recommends that you use between 64 and 128 workers.
Enter the number of parallel workers [64] : 20
STOP_TASK: [Ask for number of parallel workers] [] [Thu Jul 01 2010 01:46:08]
AutoPatch will run in parallel mode.
STOP_TASK: [Steps before copy portion] [] [Thu Jul 01 2010 01:46:08]
STRT_TASK: [Copy portion steps] [] [Thu Jul 01 2010 01:46:08]
STRT_TASK: [apply new applterr.txt] [] [Thu Jul 01 2010 01:46:08]
Did not need to apply new applterr.txt.
STOP_TASK: [apply new applterr.txt] [] [Thu Jul 01 2010 01:46:08]
STRT_TASK: [AutoSplice applprod.txt and applUS.txt] [] [Thu Jul 01 2010 01:46:08]
Applying new applprod.txt (if any)...
Did not need to apply new applprod.txt.
STOP_TASK: [AutoSplice applprod.txt and applUS.txt] [] [Thu Jul 01 2010 01:46:08]
STRT_TASK: [Version checking for driver files] [] [Thu Jul 01 2010 01:46:08]
Performing version checking for driver files...
STOP_TASK: [Version checking for driver files] [] [Thu Jul 01 2010 01:46:08]
STRT_TASK: [Copy driver files] [] [Thu Jul 01 2010 01:46:08]
Copying driver files into installation area...
No driver files were selected for copying.
STOP_TASK: [Copy driver files] [] [Thu Jul 01 2010 01:46:08]
STRT_TASK: [Forcecopy driver files] [] [Thu Jul 01 2010 01:46:08]
Skipping...
ForceCopy driver files into installation area for Specified driver
since no such action is present for this driver file
STOP_TASK: [Forcecopy driver files] [] [Thu Jul 01 2010 01:46:08]
STRT_TASK: [Screen out files not valid for this configuration] [] [Thu Jul 01 2010 01:46:08]
Screening out files not valid for this installation...
STOP_TASK: [Screen out files not valid for this configuration] [] [Thu Jul 01 2010 01:46:08]
STRT_TASK: [Read file driver files to get list of valid files] [] [Thu Jul 01 2010 01:46:08]
Determining valid on-site files...
Setting JAVA_TOP to '/eb_rdo11_d/applmgr/d550comn/java'
STOP_TASK: [Read file driver files to get list of valid files] [] [Thu Jul 01 2010 01:46:12]
STRT_TASK: [Perform libout actions] [] [Thu Jul 01 2010 01:46:12]
Skipping...
Extract object modules from libraries for Specified driver
since no such action is present for this driver file
STOP_TASK: [Perform libout actions] [] [Thu Jul 01 2010 01:46:12]
STRT_TASK: [Perform version checking] [] [Thu Jul 01 2010 01:46:12]
Performing version checking...
STOP_TASK: [Perform version checking] [] [Thu Jul 01 2010 01:46:14]
STRT_TASK: [Determine directories to create] [] [Thu Jul 01 2010 01:46:14]
Skipping...
Determine directories to create for Specified driver
since no such action is present for this driver file
STOP_TASK: [Determine directories to create] [] [Thu Jul 01 2010 01:46:14]
STRT_TASK: [Determine executables to link] [] [Thu Jul 01 2010 01:46:14]
Skipping...
Determine executables to link for Specified driver
since no such action is present for this driver file
STOP_TASK: [Determine executables to link] [] [Thu Jul 01 2010 01:46:14]
STRT_TASK: [Determine forms executable files to generate] [] [Thu Jul 01 2010 01:46:14]
Skipping...
Determine forms to generate for Specified driver
since no such action is present for this driver file
STOP_TASK: [Determine forms executable files to generate] [] [Thu Jul 01 2010 01:46:14]
STRT_TASK: [Determine Reports PL/SQL library files to generate] [] [Thu Jul 01 2010 01:46:14]
Skipping...
Determine Oracle Reports libraries to generate for Specified driver
since no such action is present for this driver file
STOP_TASK: [Determine Reports PL/SQL library files to generate] [] [Thu Jul 01 2010 01:46:14]
STRT_TASK: [Determine Reports files to generate] [] [Thu Jul 01 2010 01:46:14]
Skipping...
Determine reports to generate for Specified driver
since no such action is present for this driver file
STOP_TASK: [Determine Reports files to generate] [] [Thu Jul 01 2010 01:46:14]
STRT_TASK: [Determine message files to generate] [] [Thu Jul 01 2010 01:46:14]
Skipping...
Determine if need to generate message files for Specified driver
since no such action is present for this driver file
STOP_TASK: [Determine message files to generate] [] [Thu Jul 01 2010 01:46:14]
STRT_TASK: [Find bugs with no active actions] [] [Thu Jul 01 2010 01:46:14]
Looking for active bug fixes with no active actions...
About to turn off duplicate actions: Thu Jul 01 2010 01:46:14
Start of adptod(): Thu Jul 01 2010 01:46:14
Actions scanned: 2
Duplicate actions: 0
End of adptod(): Thu Jul 01 2010 01:46:14
Done turning off duplicate actions: Thu Jul 01 2010 01:46:14
About to turn off bugs with no active actions: Thu Jul 01 2010 01:46:14
Start of adpunb(): Thu Jul 01 2010 01:46:14
Active bugs at start: 1
Bugs turned off: 0
Outer loop iterations: 1
Actions scanned: 1
End of adpunb(): Thu Jul 01 2010 01:46:14
Done turning off bugs with no active actions: Thu Jul 01 2010 01:46:14
About to save release list to filesystem: Thu Jul 01 2010 01:46:14
Done saving release list to filesystem: Thu Jul 01 2010 01:46:14
STOP_TASK: [Find bugs with no active actions] [] [Thu Jul 01 2010 01:46:14]
STRT_TASK: [Display customized files] [] [Thu Jul 01 2010 01:46:14]
Reading customized files list (if any)...
This patch replaces the following customized files:
No customized files are replaced by this patch.
STOP_TASK: [Display customized files] [] [Thu Jul 01 2010 01:46:14]
STRT_TASK: [Copy files] [] [Thu Jul 01 2010 01:46:14]
Copying files into installation area...
**********************************************************
You are running admvcode
Header information is:
$Header: aiopatch.lc 115.51 2007/12/03 08:26:43 nissubra ship $
Start of admvcode session
Date/Time is Thu Jul 01 2010 01:46:15
Filelist file is: /eb_rdo11_d/applmgr/d550appl/admin/d550a/out/copymast.txt
Patch Character Set is: us7ascii
On-site Character Set is: UTF8
Log and Info File sync point:
Thu Jul 01 2010 01:46:15
Information about files copied to the APPL_TOP would be written to the
informational message file.
Character set 'US7ASCII' is a subset of character set 'UTF8'.
No character set conversion is required.
Copying files to APPL_TOP...
0 directories created.
1 files copied without character set conversion.
0 files copied with successful character set conversion.
1 files copied successfully.
0 files had fatal errors.
admvcode is exiting with status 0
End of admvcode session
Date/time is Thu Jul 01 2010 01:46:15
**********************************************************
Done copying files into installation area.
STOP_TASK: [Copy files] [] [Thu Jul 01 2010 01:46:15]
STRT_TASK: [Forcecopy files] [] [Thu Jul 01 2010 01:46:15]
Skipping...
ForceCopy files into installation area for Specified driver
since no such action is present for this driver file
STOP_TASK: [Forcecopy files] [] [Thu Jul 01 2010 01:46:15]
STRT_TASK: [Perform libin actions] [] [Thu Jul 01 2010 01:46:15]
Skipping...
Archive object modules into product libraries for Specified driver
since no such action is present for this driver file
STOP_TASK: [Perform libin actions] [] [Thu Jul 01 2010 01:46:15]
STRT_TASK: [Create directories] [] [Thu Jul 01 2010 01:46:15]
Skipping...
Create Directories for Specified driver
since no such action is present for this driver file
STOP_TASK: [Create directories] [] [Thu Jul 01 2010 01:46:15]
STRT_TASK: [Relink executables] [] [Thu Jul 01 2010 01:46:15]
Skipping...
Relink for Specified driver
since no such action is present for this driver file
STOP_TASK: [Relink executables] [] [Thu Jul 01 2010 01:46:15]
STRT_TASK: [Copy files in patch to destinations] [] [Thu Jul 01 2010 01:46:15]
Performing second half of mirrored copies...
No mirrored copies were executed in this patch.
STOP_TASK: [Copy files in patch to destinations] [] [Thu Jul 01 2010 01:46:17]
STRT_TASK: [Maintain Oracle Applications Java files] [] [Thu Jul 01 2010 01:46:17]
Updating Oracle Applications Java files if necessary...
No Oracle Applications Java files required updates.
Checking to see if any files possibly included in the product JAR files
were copied by this patch...
No files possibly included in the product JAR files
were copied by this patch.
STRT_TASK: [Run AutoConfig to instantiate special templates] [] [Thu Jul 01 2010 01:46:17]
Skipping ...
Running AutoConfig to instantiate templates which affect
the generation of JAR files since none of these templates
were patched during this run of adpatch.
STOP_TASK: [Run AutoConfig to instantiate special templates] [] [Thu Jul 01 2010 01:46:17]
No product JAR files need to be re-generated.
STRT_TASK: [Generate appsborg.zip] [] [Thu Jul 01 2010 01:46:17]
Checking to see if adjborg.txt or any files included in
adjborg.txt were copied by this patch...
Neither adjborg.txt nor any file included in
adjborg.txt was copied by this patch.
STOP_TASK: [Generate appsborg.zip] [] [Thu Jul 01 2010 01:46:17]
STRT_TASK: [Generate appsborg2.zip] [] [Thu Jul 01 2010 01:46:17]
Checking to see if adjborg2.txt or any files included in
adjborg2.txt were copied by this patch...
Neither adjborg2.txt nor any file included in
adjborg2.txt was copied by this patch.
STOP_TASK: [Generate appsborg2.zip] [] [Thu Jul 01 2010 01:46:17]
About to turn off bugs with no active actions: Thu Jul 01 2010 01:46:17
Start of adpunb(): Thu Jul 01 2010 01:46:17
Active bugs at start: 1
Bugs turned off: 0
Outer loop iterations: 1
Actions scanned: 1
End of adpunb(): Thu Jul 01 2010 01:46:17
Done turning off bugs with no active actions: Thu Jul 01 2010 01:46:17
About to save release list to filesystem: Thu Jul 01 2010 01:46:17
Done saving release list to filesystem: Thu Jul 01 2010 01:46:17
STOP_TASK: [Maintain Oracle Applications Java files] [] [Thu Jul 01 2010 01:46:17]
STRT_TASK: [Compile JSP files] [] [Thu Jul 01 2010 01:46:17]
Skipping...
Compile JSP files for Specified driver
since no such action is present for this driver file
or this APPL_TOP does not implement the "web" server type
STOP_TASK: [Compile JSP files] [] [Thu Jul 01 2010 01:46:17]
STOP_TASK: [Copy portion steps] [] [Thu Jul 01 2010 01:46:17]
STRT_TASK: [Database portion steps] [] [Thu Jul 01 2010 01:46:17]
STRT_TASK: [Get initial list of invalid objects in DB] [] [Thu Jul 01 2010 01:46:17]
Number of invalid objects: 224
Getting list of invalid objects in APPS schema.
Invalid object reports are recorded in
/eb_rdo11_d/applmgr/d550appl/admin/d550a/log/12214_preenv.*
STOP_TASK: [Get initial list of invalid objects in DB] [] [Thu Jul 01 2010 01:46:23]
STRT_TASK: [Run SQL scripts and EXEC commands] [] [Thu Jul 01 2010 01:46:23]
Running SQL scripts and EXEC commands...
STRT_TASK: [Determine which SQL and EXEC commands to run] [] [Thu Jul 01 2010 01:46:23]
Determining which SQL and EXEC commands to run...
Validating PL/SQL direct execute exceptions file ...
Initializing PL/SQL direct execute exceptions hash table ...
Done initializing PL/SQL direct execute exceptions hash table.
Uploading PL/SQL direct execute exceptions from file ...
Done uploading PL/SQL direct execute exceptions from file.
Done validating PL/SQL direct execute exceptions file.
Done determining which SQL and EXEC commands to run.
STOP_TASK: [Determine which SQL and EXEC commands to run] [] [Thu Jul 01 2010 01:46:23]
STRT_TASK: [Running database update commands] [] [Thu Jul 01 2010 01:46:23]
STRT_TASK: [Running SQL and EXEC commands in parallel] [] [Thu Jul 01 2010 01:46:23]
Running SQL and EXEC commands in parallel...
STRT_TASK: [Running parallel SQL and EXEC commands] [] [Thu Jul 01 2010 01:46:23]
Creating FND_INSTALL_PROCESSES table...
Connecting to APPLSYS......Connected successfully.
Running adtasktim.sql ..
Connected.
PL/SQL procedure successfully completed.
Commit complete.
CREATE TABLE fnd_install_processes( worker_id number not null,
control_code varchar2(1) not null, status varchar2(1) not null,
context varchar2(80) not null, pdi_product varchar2(10) not null,
pdi_username varchar2(32) not null, command varchar2(30) not null,
file_product varchar2(10) not null, subdirectory varchar2(30) not null,
filename varchar2(30) not null, phase number not null,
install_group_num number not null, skip_flag varchar2(1), arguments
varchar2(1996), symbolic_arguments varchar2(1996), phase_name
varchar2(30), start_time date, end_time date, restart_time date,
elapsed_time number, restart_count number, defer_count number,
machine_name varchar2(32), local_node varchar2(1)) TABLESPACE APPLSYSD
initrans 255
INSERT INTO ad_timestamps (TYPE,ATTRIBUTE,TIMESTAMP) select
'FND_INSTALL_PROCESSES', 'AutoPatch', sysdate from dual where not exists
(select 'x' from ad_timestamps where type = 'FND_INSTALL_PROCESSES' and
attribute = 'AutoPatch')
CREATE UNIQUE INDEX fnd_install_processes_u1 on
fnd_install_processes(worker_id) TABLESPACE APPLSYSX storage(initial 4K
next 4K)
GRANT ALL ON fnd_install_processes TO APPS WITH GRANT OPTION
Connecting to APPS......Connected successfully.
Connecting to APPLSYS......Connected successfully.
CREATE TABLE AD_DEFERRED_JOBS( phase number not null,
file_product varchar2(10) not null, subdirectory varchar2(30) not null,
filename varchar2(30) not null, arguments varchar2(1996),
start_time date, restart_time date, elapsed_time number,
restart_count number, defer_count number) TABLESPACE APPLSYSD initrans 100
storage(initial 4K next 4K)
CREATE UNIQUE INDEX AD_DEFERRED_JOBS_U1 on AD_DEFERRED_JOBS
(phase,file_product,subdirectory,filename,arguments) TABLESPACE APPLSYSX
storage(initial 4K next 4K)
GRANT ALL ON AD_DEFERRED_JOBS TO APPS WITH GRANT OPTION
Connecting to APPS......Connected successfully.
Connecting to APPLSYS......Connected successfully.
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (0, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (1, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (2, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (3, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (4, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (5, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (6, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (7, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (8, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (9, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (10, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (11, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (12, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (13, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (14, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (15, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (16, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (17, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (18, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (19, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (20, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
Connecting to APPS......Connected successfully.
Writing dependencies of jobs to run to appldep.txt file...
There are now 1 jobs remaining (current phase=A0):
0 running, 1 ready to run and 0 waiting.
Reading completed jobs from restart file (if any).
There are now 1 jobs remaining (current phase=A0):
0 running, 1 ready to run and 0 waiting.
Starting worker processes.
Worker process 1 started.
Worker process 2 started.
Worker process 3 started.
Worker process 4 started.
Worker process 5 started.
Worker process 6 started.
Worker process 7 started.
Worker process 8 started.
Worker process 9 started.
Worker process 10 started.
Worker process 11 started.
Worker process 12 started.
Worker process 13 started.
Worker process 14 started.
Worker process 15 started.
Worker process 16 started.
Worker process 17 started.
Worker process 18 started.
Worker process 19 started.
Worker process 20 started.
Checking if all jobs have their actual and symbolic arguments in sync....
Done.
Writing jobs to run to restart file.
Reading jobs from FND_INSTALL_PROCESSES table ...
Done reading jobs from FND_INSTALL_PROCESSES table ...
Telling workers to read 'todo' restart file.
Done.
Starting phase 0 (A0): plb
There are now 1 jobs remaining (current phase=A0):
0 running, 1 ready to run and 0 waiting.
Assigned: file MSCPOSTB.pls on worker 1 for product msc username MSC.
Time is: Thu Jul 01 2010 01:46:27
Completed: file MSCPOSTB.pls on worker 1 for product msc username MSC.
Time is: Thu Jul 01 2010 01:46:48
Telling workers to quit...
3 workers have quit. Waiting for 17 more.
All workers have quit.
Dropping FND_INSTALL_PROCESSES table...
Connecting to APPLSYS......Connected successfully.
DROP TABLE fnd_install_processes PURGE
DELETE FROM ad_timestamps WHERE TYPE = 'FND_INSTALL_PROCESSES'
FND_INSTALL_PROCESSES table dropped.
Dropping AD_DEFERRED_JOBS table...
DROP TABLE AD_DEFERRED_JOBS PURGE
AD_DEFERRED_JOBS table dropped.
Connecting to APPS......Connected successfully.
STOP_TASK: [Running parallel SQL and EXEC commands] [] [Thu Jul 01 2010 01:46:54]
Done running SQL and EXEC commands in parallel.
STRT_TASK: [Running parallel Invoker Rights processing] [] [Thu Jul 01 2010 01:46:54]
Running Invoker's Rights Maintenance...
Connecting to SYSTEM......Connected successfully.
Creating FND_INSTALL_PROCESSES table...
Connecting to APPLSYS......Connected successfully.
Running adtasktim.sql ..
Connected.
PL/SQL procedure successfully completed.
Commit complete.
CREATE TABLE fnd_install_processes( worker_id number not null,
control_code varchar2(1) not null, status varchar2(1) not null,
context varchar2(80) not null, pdi_product varchar2(10) not null,
pdi_username varchar2(32) not null, command varchar2(30) not null,
file_product varchar2(10) not null, subdirectory varchar2(30) not null,
filename varchar2(30) not null, phase number not null,
install_group_num number not null, skip_flag varchar2(1), arguments
varchar2(1996), symbolic_arguments varchar2(1996), phase_name
varchar2(30), start_time date, end_time date, restart_time date,
elapsed_time number, restart_count number, defer_count number,
machine_name varchar2(32), local_node varchar2(1)) TABLESPACE APPLSYSD
initrans 255
INSERT INTO ad_timestamps (TYPE,ATTRIBUTE,TIMESTAMP) select
'FND_INSTALL_PROCESSES', 'AutoPatch', sysdate from dual where not exists
(select 'x' from ad_timestamps where type = 'FND_INSTALL_PROCESSES' and
attribute = 'AutoPatch')
CREATE UNIQUE INDEX fnd_install_processes_u1 on
fnd_install_processes(worker_id) TABLESPACE APPLSYSX storage(initial 4K
next 4K)
GRANT ALL ON fnd_install_processes TO APPS WITH GRANT OPTION
Connecting to APPS......Connected successfully.
Connecting to APPLSYS......Connected successfully.
CREATE TABLE AD_DEFERRED_JOBS( phase number not null,
file_product varchar2(10) not null, subdirectory varchar2(30) not null,
filename varchar2(30) not null, arguments varchar2(1996),
start_time date, restart_time date, elapsed_time number,
restart_count number, defer_count number) TABLESPACE APPLSYSD initrans 100
storage(initial 4K next 4K)
CREATE UNIQUE INDEX AD_DEFERRED_JOBS_U1 on AD_DEFERRED_JOBS
(phase,file_product,subdirectory,filename,arguments) TABLESPACE APPLSYSX
storage(initial 4K next 4K)
GRANT ALL ON AD_DEFERRED_JOBS TO APPS WITH GRANT OPTION
Connecting to APPS......Connected successfully.
Connecting to APPLSYS......Connected successfully.
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (0, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (1, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (2, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (3, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (4, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (5, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (6, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (7, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (8, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (9, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (10, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (11, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (12, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (13, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (14, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (15, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (16, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (17, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (18, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (19, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (20, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
Connecting to APPS......Connected successfully.
Setting parallel context: Invoker's Rights processing at R115
Need to perform Invoker's Rights processing
Making job list for APPLSYS/*****
Writing dependencies of jobs to run to appldep.txt file...
There are now 42 jobs remaining (current phase=A0):
0 running, 1 ready to run and 41 waiting.
Reading completed jobs from restart file (if any).
There are now 42 jobs remaining (current phase=A0):
0 running, 1 ready to run and 41 waiting.
Starting worker processes.
Worker process 1 started.
Worker process 2 started.
Worker process 3 started.
Worker process 4 started.
Worker process 5 started.
Worker process 6 started.
Worker process 7 started.
Worker process 8 started.
Worker process 9 started.
Worker process 10 started.
Worker process 11 started.
Worker process 12 started.
Worker process 13 started.
Worker process 14 started.
Worker process 15 started.
Worker process 16 started.
Worker process 17 started.
Worker process 18 started.
Worker process 19 started.
Worker process 20 started.
Checking if all jobs have their actual and symbolic arguments in sync....
Done.
Writing jobs to run to restart file.
Reading jobs from FND_INSTALL_PROCESSES table ...
Done reading jobs from FND_INSTALL_PROCESSES table ...
Telling workers to read 'todo' restart file.
Done.
Starting phase 0 (A0): invoker
There are now 42 jobs remaining (current phase=A0):
0 running, 1 ready to run and 41 waiting.
Assigned: file adinvset.pls on worker 1 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:46:58
Completed: file adinvset.pls on worker 1 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:09
Starting phase 1 (A1): invoker+1
There are now 41 jobs remaining (current phase=A1):
0 running, 20 ready to run and 21 waiting.
Assigned: file adinvrun.pls on worker 1 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:09
Assigned: file adinvrun.pls on worker 2 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:09
Assigned: file adinvrun.pls on worker 3 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:09
Assigned: file adinvrun.pls on worker 4 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:09
Assigned: file adinvrun.pls on worker 5 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:09
Assigned: file adinvrun.pls on worker 6 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:09
Assigned: file adinvrun.pls on worker 7 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:09
Assigned: file adinvrun.pls on worker 8 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:09
Assigned: file adinvrun.pls on worker 9 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:09
Assigned: file adinvrun.pls on worker 10 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:09
Assigned: file adinvrun.pls on worker 11 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:09
Assigned: file adinvrun.pls on worker 12 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:09
Assigned: file adinvrun.pls on worker 13 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:09
Assigned: file adinvrun.pls on worker 14 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:09
Assigned: file adinvrun.pls on worker 15 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:09
Assigned: file adinvrun.pls on worker 16 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:09
Assigned: file adinvrun.pls on worker 17 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:09
Assigned: file adinvrun.pls on worker 18 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:09
Assigned: file adinvrun.pls on worker 19 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:09
Assigned: file adinvrun.pls on worker 20 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:09
There are now 41 jobs remaining (current phase=A1):
20 running, 0 ready to run and 21 waiting.
Completed: file adinvrun.pls on worker 1 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:10
Completed: file adinvrun.pls on worker 3 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:10
Completed: file adinvrun.pls on worker 15 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:10
Completed: file adinvrun.pls on worker 19 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:10
Completed: file adinvrun.pls on worker 4 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:10
Completed: file adinvrun.pls on worker 18 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:10
Completed: file adinvrun.pls on worker 20 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:10
Completed: file adinvrun.pls on worker 5 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:10
Completed: file adinvrun.pls on worker 7 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:10
Completed: file adinvrun.pls on worker 6 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:10
Completed: file adinvrun.pls on worker 9 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:10
Completed: file adinvrun.pls on worker 2 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Completed: file adinvrun.pls on worker 8 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Completed: file adinvrun.pls on worker 10 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Completed: file adinvrun.pls on worker 11 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Completed: file adinvrun.pls on worker 12 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Completed: file adinvrun.pls on worker 14 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Completed: file adinvrun.pls on worker 13 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Completed: file adinvrun.pls on worker 16 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Completed: file adinvrun.pls on worker 17 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
There are now 21 jobs remaining (current phase=A1):
0 running, 0 ready to run and 21 waiting.
Starting phase 2 (A2): invoker+2
There are now 21 jobs remaining (current phase=A2):
0 running, 20 ready to run and 1 waiting.
Assigned: file adinvrn2.pls on worker 1 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Assigned: file adinvrn2.pls on worker 2 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Assigned: file adinvrn2.pls on worker 3 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Assigned: file adinvrn2.pls on worker 4 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Assigned: file adinvrn2.pls on worker 5 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Assigned: file adinvrn2.pls on worker 6 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Assigned: file adinvrn2.pls on worker 7 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Assigned: file adinvrn2.pls on worker 8 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Assigned: file adinvrn2.pls on worker 9 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Assigned: file adinvrn2.pls on worker 10 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Assigned: file adinvrn2.pls on worker 11 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Assigned: file adinvrn2.pls on worker 12 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Assigned: file adinvrn2.pls on worker 13 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Assigned: file adinvrn2.pls on worker 14 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Assigned: file adinvrn2.pls on worker 15 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Assigned: file adinvrn2.pls on worker 16 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Assigned: file adinvrn2.pls on worker 17 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Assigned: file adinvrn2.pls on worker 18 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Assigned: file adinvrn2.pls on worker 19 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Assigned: file adinvrn2.pls on worker 20 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
There are now 21 jobs remaining (current phase=A2):
20 running, 0 ready to run and 1 waiting.
Completed: file adinvrn2.pls on worker 2 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Completed: file adinvrn2.pls on worker 3 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Completed: file adinvrn2.pls on worker 4 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:11
Completed: file adinvrn2.pls on worker 7 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:12
Completed: file adinvrn2.pls on worker 1 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:12
Completed: file adinvrn2.pls on worker 11 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:12
Completed: file adinvrn2.pls on worker 5 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:12
Completed: file adinvrn2.pls on worker 8 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:12
Completed: file adinvrn2.pls on worker 10 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:12
Completed: file adinvrn2.pls on worker 6 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:12
Completed: file adinvrn2.pls on worker 13 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:12
Completed: file adinvrn2.pls on worker 14 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:12
Completed: file adinvrn2.pls on worker 20 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:12
Completed: file adinvrn2.pls on worker 12 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:12
Completed: file adinvrn2.pls on worker 15 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:12
Completed: file adinvrn2.pls on worker 16 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:12
Completed: file adinvrn2.pls on worker 17 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:12
Completed: file adinvrn2.pls on worker 9 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:12
Completed: file adinvrn2.pls on worker 19 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:12
Completed: file adinvrn2.pls on worker 18 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:12
There are now 1 jobs remaining (current phase=A2):
0 running, 0 ready to run and 1 waiting.
Starting phase 3 (A3): invoker+3
There are now 1 jobs remaining (current phase=A3):
0 running, 1 ready to run and 0 waiting.
Assigned: file adinvcln.pls on worker 1 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:12
Completed: file adinvcln.pls on worker 1 for product ad username APPLSYS.
Time is: Thu Jul 01 2010 01:47:13
Done with Invoker's Rights processing.
Telling workers to quit...
All workers have quit.
Dropping FND_INSTALL_PROCESSES table...
Connecting to APPLSYS......Connected successfully.
DROP TABLE fnd_install_processes PURGE
DELETE FROM ad_timestamps WHERE TYPE = 'FND_INSTALL_PROCESSES'
FND_INSTALL_PROCESSES table dropped.
Dropping AD_DEFERRED_JOBS table...
DROP TABLE AD_DEFERRED_JOBS PURGE
AD_DEFERRED_JOBS table dropped.
Connecting to APPS......Connected successfully.
STOP_TASK: [Running parallel Invoker Rights processing] [] [Thu Jul 01 2010 01:47:18]
STOP_TASK: [Running SQL and EXEC commands in parallel] [] [Thu Jul 01 2010 01:47:18]
Updating the checkfile repository if necessary...
Processing the last batch...: Thu Jul 01 2010 01:47:18
Done updating the checkfile repository...
STOP_TASK: [Running database update commands] [] [Thu Jul 01 2010 01:47:19]
About to turn off bugs with no active actions: Thu Jul 01 2010 01:47:19
Start of adpunb(): Thu Jul 01 2010 01:47:19
Active bugs at start: 1
Bugs turned off: 0
Outer loop iterations: 1
Actions scanned: 1
End of adpunb(): Thu Jul 01 2010 01:47:19
Done turning off bugs with no active actions: Thu Jul 01 2010 01:47:19
Done running SQL scripts and EXEC commands.
STOP_TASK: [Run SQL scripts and EXEC commands] [] [Thu Jul 01 2010 01:47:19]
STRT_TASK: [Maintain MRC] [] [Thu Jul 01 2010 01:47:19]
Attempting to maintain MRC...
Connecting to APPLSYS......Connected successfully.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Your current code level does not require an MRC schema for MRC functionality.
Because of this, no MRC schema maintenance has been performed.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Connecting to APPS......Connected successfully.
STOP_TASK: [Maintain MRC] [] [Thu Jul 01 2010 01:47:20]
STRT_TASK: [Compile invalid objects in DB] [] [Thu Jul 01 2010 01:47:20]
Compiling invalid objects...
Not compiling invalid objects: feature disabled (or serial mode)
STOP_TASK: [Compile invalid objects in DB] [] [Thu Jul 01 2010 01:47:20]
STRT_TASK: [Get final list of invalid objects in DB] [] [Thu Jul 01 2010 01:47:20]
Number of invalid objects: 224
Getting list of invalid objects in APPS schema.
Invalid object reports are recorded in
/eb_rdo11_d/applmgr/d550appl/admin/d550a/log/12214_postenv.*
STOP_TASK: [Get final list of invalid objects in DB] [] [Thu Jul 01 2010 01:47:25]
STOP_TASK: [Database portion steps] [] [Thu Jul 01 2010 01:47:25]
STRT_TASK: [Generate portion steps] [] [Thu Jul 01 2010 01:47:25]
STRT_TASK: [Generate forms PL/SQL library files] [] [Thu Jul 01 2010 01:47:25]
Skipping...
Generate forms library files for Specified driver
since no such action is present for this driver file
STOP_TASK: [Generate forms PL/SQL library files] [] [Thu Jul 01 2010 01:47:25]
STRT_TASK: [Generate forms menu files] [] [Thu Jul 01 2010 01:47:25]
Skipping...
Generate forms menu files for Specified driver
since no such action is present for this driver file
STOP_TASK: [Generate forms menu files] [] [Thu Jul 01 2010 01:47:25]
STRT_TASK: [Generate forms executable files] [] [Thu Jul 01 2010 01:47:25]
Skipping...
Generate forms for Specified driver
since no such action is present for this driver file
STOP_TASK: [Generate forms executable files] [] [Thu Jul 01 2010 01:47:25]
STRT_TASK: [Generate reports PL/SQL library files] [] [Thu Jul 01 2010 01:47:25]
Skipping...
Generate reports libraries for Specified driver
since no such action is present for this driver file
STOP_TASK: [Generate reports PL/SQL library files] [] [Thu Jul 01 2010 01:47:25]
STRT_TASK: [Generate reports files] [] [Thu Jul 01 2010 01:47:25]
Skipping...
Generate reports for Specified driver
since no such action is present for this driver file
STOP_TASK: [Generate reports files] [] [Thu Jul 01 2010 01:47:25]
STRT_TASK: [Generate Oracle Graphics PL/SQL libraries files] [] [Thu Jul 01 2010 01:47:25]
Skipping...
Generate graphics libraries for Specified driver
since no such action is present for this driver file
STOP_TASK: [Generate Oracle Graphics PL/SQL libraries files] [] [Thu Jul 01 2010 01:47:25]
STRT_TASK: [Generate Oracle Graphics files] [] [Thu Jul 01 2010 01:47:25]
Skipping...
Generate graphics for Specified driver
since no such action is present for this driver file
STOP_TASK: [Generate Oracle Graphics files] [] [Thu Jul 01 2010 01:47:25]
STRT_TASK: [Generate message files] [] [Thu Jul 01 2010 01:47:25]
Skipping...
Generate Messages for Specified driver
since no such action is present for this driver file
STOP_TASK: [Generate message files] [] [Thu Jul 01 2010 01:47:25]
STRT_TASK: [Generate Workflow resource files] [] [Thu Jul 01 2010 01:47:25]
Skipping...
Generate Workflow resource files for Specified driver
since no such action is present for this driver file
STOP_TASK: [Generate Workflow resource files] [] [Thu Jul 01 2010 01:47:25]
STOP_TASK: [Generate portion steps] [] [Thu Jul 01 2010 01:47:25]
STRT_TASK: [AutoConfig steps] [] [Thu Jul 01 2010 01:47:25]
Skipping ...
Running AutoConfig since none of its templates were
patched during this run of adpatch.
STOP_TASK: [AutoConfig steps] [] [Thu Jul 01 2010 01:47:25]
STRT_TASK: [Steps after generate portion] [] [Thu Jul 01 2010 01:47:25]
STRT_TASK: [Save Patch History] [] [Thu Jul 01 2010 01:47:25]
STRT_TASK: [Save Patch History to database] [] [Thu Jul 01 2010 01:47:25]
Saving Patch History information to Database...
Trying to obtain a lock...
> Inserted 1 patch history records (total).
Gathering Statistics for AD_PATCH_HIST_TEMP
Done Gathering Statistics for AD_PATCH_HIST_TEMP
>>> Inserted 1 bug history records for this patch (total).
>>>>> Inserted 2 action history records for this bug (total).
About to update the current-view snapshot: Thu Jul 01 2010 01:47:28
Updating the current-view snapshot...
Done updating the current-view snapshot: Thu Jul 01 2010 01:50:16
STOP_TASK: [Save Patch History to database] [] [Thu Jul 01 2010 01:50:16]
Done saving Patch History information.
STOP_TASK: [Save Patch History] [] [Thu Jul 01 2010 01:50:16]
STRT_TASK: [IREP steps] [] [Thu Jul 01 2010 01:50:20]
About to do IREP processing...
Attempting to process IREP files ...
The package FND_ADPATCH does not exist, continuing...
Done IREP processing.
STOP_TASK: [IREP steps] [] [Thu Jul 01 2010 01:50:20]
STOP_TASK: [Steps after generate portion] [] [Thu Jul 01 2010 01:50:20]
STOP_TASK: [Run a single patch driver file] [] [Thu Jul 01 2010 01:50:20]
STRT_TASK: [AutoPatch post-driver logic] [] [Thu Jul 01 2010 01:50:20]
Copying applprod.tmp to applprod.txt (if needed)...
Did not need to copy applprod.tmp to applprod.txt.
Copying admin/<sid>/applterr.txt to admin/applterr.txt (if needed)...
Did not need to copy admin/d550a/applterr.txt to admin/applterr.txt.
STOP_TASK: [AutoPatch post-driver logic] [] [Thu Jul 01 2010 01:50:20]
Log and Info File sync point:
Thu Jul 01 2010 01:50:20
AutoPatch is exiting successfully.
sqlplus -s APPS/***** @/eb_rdo11_d/applmgr/d550appl/ad/11.5.0/admin/sql/adtimrpt.sql 12214 adt12214
Spooling to adt12214.lst
Spooling to adt12214.csv
A job timing report has been generated for the current session.
You should check the file
/eb_rdo11_d/applmgr/d550appl/admin/d550a/out/adt12214.lst
for details.
Purging timing information for prior sessions.
sqlplus -s APPS/***** @/eb_rdo11_d/applmgr/d550appl/ad/11.5.0/admin/sql/adtpurge.sql 10 1000
Done purging timing information for prior sessions.
AutoPatch is complete.
AutoPatch may have written informational messages to the file
/eb_rdo11_d/applmgr/d550appl/admin/d550a/log/9732494.lgi
Errors and warnings are listed in the log file
/eb_rdo11_d/applmgr/d550appl/admin/d550a/log/9732494.log
and in other log files in the same directory.