|
|
楼主 |
发表于 2007/11/8 15:08:52
|
显示全部楼层
adpatch error log:
************* Start of AutoPatch session *************
AutoPatch version: 11.5.0
AutoPatch started at: Wed Nov 07 2007 17:29:34
APPL_TOP is set to /u1/TEST/testmgr/testappl
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 [TJTEST] : TJTEST *
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 [tjap] : tjap *
You are about to apply a patch to the installation of Oracle Applications
in your ORACLE database 'TJTEST'
using ORACLE executables in '/u1/TEST/testmgr/testora/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 1942
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 Install
ZHT Traditional Chinese Base
Reading language information from applZHT.txt ...
Your base language will be TRADITIONAL CHINESE.
Your other languages to install are: AMERICAN
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.2]
STRT_TASK: [AutoPatch startup after aimini] [] [Wed Nov 07 2007 17:29:54]
Connecting to APPS......Connected successfully.
STRT_TASK: [Validate schema passwords] [] [Wed Nov 07 2007 17:29:54]
Connecting to APPLSYS......Connected successfully.
Connecting to APPS......Connected successfully.
STOP_TASK: [Validate schema passwords] [] [Wed Nov 07 2007 17:29:54]
STRT_TASK: [Upload Patch History information from filesystem] [] [Wed Nov 07 2007 17:29:54]
Trying to obtain a lock...
About to attempt instantiating the current-view snapshot: Wed Nov 07 2007 17:29:55
Attempting to instantiate the current-view snapshot...
Was already instantiated. So no instantiation done this time.
Done attempting to instantiate the current-view snapshot: Wed Nov 07 2007 17:31:03
**************** S T A R T O F U P L O A D ****************
Start date: Wed Nov 07 2007 17:31:03
0 "left over" javaupdates.txt files uploaded to DB: Wed Nov 07 2007 17:31:03
0 patches uploaded from the ADPSV format patch history files: Wed Nov 07 2007 17:31:03
Uploading information about files copied during the previous runs ...
0 "left over" filescopied_<session_id>.txt files uploaded to DB: Wed Nov 07 2007 17:31:03
****************** E N D O F U P L O A D ******************
End date: Wed Nov 07 2007 17:31:03
STOP_TASK: [Upload Patch History information from filesystem] [] [Wed Nov 07 2007 17:31:03]
Enter the directory where your Oracle Applications patch has been unloaded
The default directory is [/u1/TEST/testmgr/testcomn/admin/scripts/TJTEST_tjap] : /u1/TEST/testmgr/patch/6402972
STOP_TASK: [AutoPatch startup after aimini] [] [Wed Nov 07 2007 17:31:12]
Please enter the name of your AutoPatch driver file : u6402972.drv
STRT_TASK: [Run a single patch driver file] [] [Wed Nov 07 2007 17:31:32]
STRT_TASK: [Steps before copy portion] [] [Wed Nov 07 2007 17:31:32]
STRT_TASK: [Initial driver processing steps] [] [Wed Nov 07 2007 17:31:32]
Start time for driver file is: Wed Nov 07 2007 17:31:32
STOP_TASK: [Initial driver processing steps] [] [Wed Nov 07 2007 17:31:32]
STRT_TASK: [Get Oracle Applications Release and read driver file] [] [Wed Nov 07 2007 17:31:32]
STRT_TASK: [Get Oracle Applications Release] [] [Wed Nov 07 2007 17:31:32]
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] [] [Wed Nov 07 2007 17:31:33]
STRT_TASK: [Process patch driver file] [] [Wed Nov 07 2007 17:31:33]
Reading patch driver file...
Connecting to SYSTEM......Connected successfully.
STRT_TASK: [Parse and load patch driver file] [] [Wed Nov 07 2007 17:31:33]
Connecting to APPS......Connected successfully.
Parsing and loading patch driver file...
265 lines processed.
STOP_TASK: [Parse and load patch driver file] [] [Wed Nov 07 2007 17:31:33]
STRT_TASK: [Check patch integrity] [] [Wed Nov 07 2007 17:31:33]
Not checking patch integrity as integrity checking flag is turned off.
STOP_TASK: [Check patch integrity] [] [Wed Nov 07 2007 17:31:33]
Successfully read patch driver file.
STOP_TASK: [Process patch driver file] [] [Wed Nov 07 2007 17:31:33]
STRT_TASK: [Other driver and release-related logic] [] [Wed Nov 07 2007 17:31:33]
Determining target release...
Current target release is 11.5.10.2
STOP_TASK: [Other driver and release-related logic] [] [Wed Nov 07 2007 17:31:33]
STOP_TASK: [Get Oracle Applications Release and read driver file] [] [Wed Nov 07 2007 17:31:33]
STRT_TASK: [Prereq checking logic] [] [Wed Nov 07 2007 17:31:33]
STOP_TASK: [Prereq checking logic] [] [Wed Nov 07 2007 17:31:33]
STRT_TASK: [Ask translated patch question] [] [Wed Nov 07 2007 17:31:33]
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
This base patch contains files which may require translation
depending on the languages you currently have installed.
Oracle Corporation recommends that you obtain any translated versions of this
patch for each of your non-US languages PRIOR to applying this base patch.
The translated version of the patch should be applied immediately AFTER
applying this base patch.
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Do you wish to apply this patch now [No] ? yes
STOP_TASK: [Ask translated patch question] [] [Wed Nov 07 2007 17:31:45]
STRT_TASK: [Determine bugs to apply] [] [Wed Nov 07 2007 17:31:45]
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:
Wed Nov 07 2007 17:31:45
Turning off actions that reference unrecognized products.
Log and Info File sync point:
Wed Nov 07 2007 17:31:45
End of unrecognized products checking.
STOP_TASK: [Determine bugs to apply] [] [Wed Nov 07 2007 17:31:45]
STRT_TASK: [Process action options] [] [Wed Nov 07 2007 17:31:45]
STOP_TASK: [Process action options] [] [Wed Nov 07 2007 17:31:45]
STRT_TASK: [Modify actions for bootstrap mode] [] [Wed Nov 07 2007 17:31:45]
STOP_TASK: [Modify actions for bootstrap mode] [] [Wed Nov 07 2007 17:31:45]
STRT_TASK: [Ask for number of parallel workers] [] [Wed Nov 07 2007 17:31:45]
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 86 workers.
Oracle recommends that you use between 4 and 8 workers.
Enter the number of parallel workers [4] : 4
STOP_TASK: [Ask for number of parallel workers] [] [Wed Nov 07 2007 17:32:16]
AutoPatch will run in parallel mode.
STOP_TASK: [Steps before copy portion] [] [Wed Nov 07 2007 17:32:16]
STRT_TASK: [Copy portion steps] [] [Wed Nov 07 2007 17:32:16]
STRT_TASK: [apply new applterr.txt] [] [Wed Nov 07 2007 17:32:16]
Did not need to apply new applterr.txt.
STOP_TASK: [apply new applterr.txt] [] [Wed Nov 07 2007 17:32:16]
STRT_TASK: [AutoSplice applprod.txt and applUS.txt] [] [Wed Nov 07 2007 17:32:16]
Applying new applprod.txt (if any)...
Did not need to apply new applprod.txt.
STOP_TASK: [AutoSplice applprod.txt and applUS.txt] [] [Wed Nov 07 2007 17:32:16]
STRT_TASK: [Version checking for driver files] [] [Wed Nov 07 2007 17:32:16]
Performing version checking for driver files...
STOP_TASK: [Version checking for driver files] [] [Wed Nov 07 2007 17:32:16]
STRT_TASK: [Copy driver files] [] [Wed Nov 07 2007 17:32:16]
Copying driver files into installation area...
No driver files were selected for copying.
STOP_TASK: [Copy driver files] [] [Wed Nov 07 2007 17:32:16]
STRT_TASK: [Forcecopy driver files] [] [Wed Nov 07 2007 17:32:16]
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] [] [Wed Nov 07 2007 17:32:16]
STRT_TASK: [Screen out files not valid for this configuration] [] [Wed Nov 07 2007 17:32:16]
Screening out files not valid for this installation...
STOP_TASK: [Screen out files not valid for this configuration] [] [Wed Nov 07 2007 17:32:16]
STRT_TASK: [Read file driver files to get list of valid files] [] [Wed Nov 07 2007 17:32:16]
Determining valid on-site files...
Setting JAVA_TOP to '/u1/TEST/testmgr/testcomn/java'
STOP_TASK: [Read file driver files to get list of valid files] [] [Wed Nov 07 2007 17:32:26]
STRT_TASK: [Perform libout actions] [] [Wed Nov 07 2007 17:32:26]
Skipping...
Extract object modules from libraries for Specified driver
since no such action is present for this driver file
STOP_TASK: [Perform libout actions] [] [Wed Nov 07 2007 17:32:26]
STRT_TASK: [Perform version checking] [] [Wed Nov 07 2007 17:32:26]
Performing version checking...
Log and Info File sync point:
Wed Nov 07 2007 17:32:27
AutoPatch found some files which it will not apply.
These files are listed in the AutoPatch informational message file.
STOP_TASK: [Perform version checking] [] [Wed Nov 07 2007 17:32:27]
STRT_TASK: [Determine directories to create] [] [Wed Nov 07 2007 17:32:27]
Skipping...
Determine directories to create for Specified driver
since no such action is present for this driver file
STOP_TASK: [Determine directories to create] [] [Wed Nov 07 2007 17:32:27]
STRT_TASK: [Determine executables to link] [] [Wed Nov 07 2007 17:32:27]
Skipping...
Determine executables to link for Specified driver
since no such action is present for this driver file
STOP_TASK: [Determine executables to link] [] [Wed Nov 07 2007 17:32:27]
STRT_TASK: [Determine forms executable files to generate] [] [Wed Nov 07 2007 17:32:27]
Determining what Oracle Forms files to generate...
STOP_TASK: [Determine forms executable files to generate] [] [Wed Nov 07 2007 17:32:28]
STRT_TASK: [Determine Reports PL/SQL library files to generate] [] [Wed Nov 07 2007 17:32:28]
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] [] [Wed Nov 07 2007 17:32:28]
STRT_TASK: [Determine Reports files to generate] [] [Wed Nov 07 2007 17:32:28]
Determining what Oracle Reports files to generate...
STOP_TASK: [Determine Reports files to generate] [] [Wed Nov 07 2007 17:32:28]
STRT_TASK: [Determine message files to generate] [] [Wed Nov 07 2007 17:32:28]
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] [] [Wed Nov 07 2007 17:32:28]
STRT_TASK: [Find bugs with no active actions] [] [Wed Nov 07 2007 17:32:28]
Looking for active bug fixes with no active actions...
About to turn off duplicate actions: Wed Nov 07 2007 17:32:28
Start of adptod(): Wed Nov 07 2007 17:32:28
Actions scanned: 60
Duplicate actions: 0
End of adptod(): Wed Nov 07 2007 17:32:28
Done turning off duplicate actions: Wed Nov 07 2007 17:32:28
About to turn off bugs with no active actions: Wed Nov 07 2007 17:32:28
Start of adpunb(): Wed Nov 07 2007 17:32:28
Not applying Bug 3508478 for product "ap" because
none of its actions are active.
Not applying Bug 3663519 for product "ap" because
none of its actions are active.
Not applying Bug 3815251 for product "ap" because
none of its actions are active.
Not applying Bug 3900607 for product "ap" because
none of its actions are active.
Not applying Bug 3903109 for product "ap" because
none of its actions are active.
Not applying Bug 3946707 for product "ap" because
none of its actions are active.
Not applying Bug 4050196 for product "ap" because
none of its actions are active.
Not applying Bug 4101968 for product "ap" because
none of its actions are active.
Not applying Bug 4571030 for product "ap" because
none of its actions are active.
Not applying Bug 5203231 for product "ap" because
none of its actions are active.
Not applying Bug 5480768 for product "ap" because
none of its actions are active.
Not applying Bug 5702617 for product "ap" because
none of its actions are active.
Not applying Bug 5755268 for product "ap" because
none of its actions are active.
Not applying Bug 6131535 for product "ap" because
none of its actions are active.
Active bugs at start: 15
Bugs turned off: 14
Outer loop iterations: 15
Actions scanned: 1
End of adpunb(): Wed Nov 07 2007 17:32:28
Done turning off bugs with no active actions: Wed Nov 07 2007 17:32:28
About to save release list to filesystem: Wed Nov 07 2007 17:32:28
Done saving release list to filesystem: Wed Nov 07 2007 17:32:28
STOP_TASK: [Find bugs with no active actions] [] [Wed Nov 07 2007 17:32:28]
STRT_TASK: [Display customized files] [] [Wed Nov 07 2007 17:32:28]
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] [] [Wed Nov 07 2007 17:32:28]
STRT_TASK: [Copy files] [] [Wed Nov 07 2007 17:32:28]
Copying files into installation area...
**********************************************************
You are running admvcode
Header information is:
$Header: aiopatch.lc 115.44 2004/07/07 09:05:05 cbhati ship $
Start of admvcode session
Date/Time is Wed Nov 07 2007 17:32:28
Filelist file is: /u1/TEST/testmgr/testappl/admin/TJTEST/out/copymast.txt
Patch Character Set is: us7ascii
On-site Character Set is: UTF8
Log and Info File sync point:
Wed Nov 07 2007 17:32:28
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.
14 files copied without character set conversion.
0 files copied with successful character set conversion.
14 files copied successfully.
0 files had fatal errors.
admvcode is exiting with status 0
End of admvcode session
Date/time is Wed Nov 07 2007 17:32:28
**********************************************************
Done copying files into installation area.
STOP_TASK: [Copy files] [] [Wed Nov 07 2007 17:32:28]
STRT_TASK: [Forcecopy files] [] [Wed Nov 07 2007 17:32:28]
Skipping...
ForceCopy files into installation area for Specified driver
since no such action is present for this driver file
STOP_TASK: [Forcecopy files] [] [Wed Nov 07 2007 17:32:28]
STRT_TASK: [Perform libin actions] [] [Wed Nov 07 2007 17:32:28]
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] [] [Wed Nov 07 2007 17:32:28]
STRT_TASK: [Create directories] [] [Wed Nov 07 2007 17:32:28]
Skipping...
Create Directories for Specified driver
since no such action is present for this driver file
STOP_TASK: [Create directories] [] [Wed Nov 07 2007 17:32:28]
STRT_TASK: [Relink executables] [] [Wed Nov 07 2007 17:32:28]
Skipping...
Relink for Specified driver
since no such action is present for this driver file
STOP_TASK: [Relink executables] [] [Wed Nov 07 2007 17:32:28]
STRT_TASK: [Copy files in patch to destinations] [] [Wed Nov 07 2007 17:32:28]
Performing second half of mirrored copies...
No mirrored copies were executed in this patch.
STOP_TASK: [Copy files in patch to destinations] [] [Wed Nov 07 2007 17:32:29]
STRT_TASK: [Maintain Oracle Applications Java files] [] [Wed Nov 07 2007 17:32:29]
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] [] [Wed Nov 07 2007 17:32:29]
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] [] [Wed Nov 07 2007 17:32:29]
No product JAR files need to be re-generated.
STRT_TASK: [Generate appsborg.zip] [] [Wed Nov 07 2007 17:32:29]
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] [] [Wed Nov 07 2007 17:32:29]
STRT_TASK: [Generate appsborg2.zip] [] [Wed Nov 07 2007 17:32:29]
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] [] [Wed Nov 07 2007 17:32:29]
About to turn off bugs with no active actions: Wed Nov 07 2007 17:32:29
Start of adpunb(): Wed Nov 07 2007 17:32:29
Active bugs at start: 1
Bugs turned off: 0
Outer loop iterations: 15
Actions scanned: 1
End of adpunb(): Wed Nov 07 2007 17:32:29
Done turning off bugs with no active actions: Wed Nov 07 2007 17:32:29
About to save release list to filesystem: Wed Nov 07 2007 17:32:29
Done saving release list to filesystem: Wed Nov 07 2007 17:32:29
STOP_TASK: [Maintain Oracle Applications Java files] [] [Wed Nov 07 2007 17:32:29]
STRT_TASK: [Compile JSP files] [] [Wed Nov 07 2007 17:32:29]
Compiling JSP files...
Not compiling JSPs: no JSPs in patch.
No JSP files were compiled.
STOP_TASK: [Compile JSP files] [] [Wed Nov 07 2007 17:32:29]
STOP_TASK: [Copy portion steps] [] [Wed Nov 07 2007 17:32:29]
STRT_TASK: [Database portion steps] [] [Wed Nov 07 2007 17:32:29]
STRT_TASK: [Get initial list of invalid objects in DB] [] [Wed Nov 07 2007 17:32:29]
Number of invalid objects: 148
Getting list of invalid objects in APPS schema.
Invalid object reports are recorded in
/u1/TEST/testmgr/testappl/admin/TJTEST/log/01942_preenv.*
STOP_TASK: [Get initial list of invalid objects in DB] [] [Wed Nov 07 2007 17:32:30]
STRT_TASK: [Run SQL scripts and EXEC commands] [] [Wed Nov 07 2007 17:32:30]
Running SQL scripts and EXEC commands...
STRT_TASK: [Determine which SQL and EXEC commands to run] [] [Wed Nov 07 2007 17:32:30]
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] [] [Wed Nov 07 2007 17:32:31]
STRT_TASK: [Running database update commands] [] [Wed Nov 07 2007 17:32:31]
STRT_TASK: [Running SQL and EXEC commands in parallel] [] [Wed Nov 07 2007 17:32:31]
Running SQL and EXEC commands in parallel...
STRT_TASK: [Running parallel SQL and EXEC commands] [] [Wed Nov 07 2007 17:32:31]
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
APPS_TS_TX_DATA 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 APPS_TS_TX_IDX
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 APPS_TS_TX_DATA
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
APPS_TS_TX_IDX 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')
Connecting to APPS......Connected successfully.
Writing dependencies of jobs to run to appldep.txt file...
There are now 19 jobs remaining (current phase=A0):
0 running, 1 ready to run and 18 waiting.
Reading completed jobs from restart file (if any).
There are now 19 jobs remaining (current phase=A0):
0 running, 1 ready to run and 18 waiting.
Starting worker processes.
Worker process 1 started.
Worker process 2 started.
Worker process 3 started.
Worker process 4 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): seq
There are now 19 jobs remaining (current phase=A0):
0 running, 1 ready to run and 18 waiting.
Assigned: file apacc.odf on worker 1 for product ap username AP.
Time is: Wed Nov 07 2007 17:32:33
Completed: file apacc.odf on worker 1 for product ap username AP.
Time is: Wed Nov 07 2007 17:32:36
Starting phase 1 (A1): tab
There are now 18 jobs remaining (current phase=A1):
0 running, 2 ready to run and 16 waiting.
Assigned: file apacc.odf on worker 1 for product ap username AP.
Time is: Wed Nov 07 2007 17:32:36
Assigned: file apcaofft.sql on worker 2 for product ap username AP.
Time is: Wed Nov 07 2007 17:32:36
FAILED: file apcaofft.sql on worker 2 for product ap username AP.
Time is: Wed Nov 07 2007 17:32:46
Deferred: file apcaofft.sql on worker 2 for product ap username AP.
Time is: Wed Nov 07 2007 17:32:46
(Deferment number 1 for this job)
Assigned: file apcaofft.sql on worker 2 for product ap username AP.
Time is: Wed Nov 07 2007 17:32:46
Completed: file apacc.odf on worker 1 for product ap username AP.
Time is: Wed Nov 07 2007 17:32:52
FAILED: file apcaofft.sql on worker 2 for product ap username AP.
Time is: Wed Nov 07 2007 17:32:56
Deferred: file apcaofft.sql on worker 2 for product ap username AP.
Time is: Wed Nov 07 2007 17:32:56
(Deferment number 2 for this job)
Assigned: file apcaofft.sql on worker 1 for product ap username AP.
Time is: Wed Nov 07 2007 17:32:56
FAILED: file apcaofft.sql on worker 1 for product ap username AP.
Time is: Wed Nov 07 2007 17:33:06
ATTENTION: All workers either have failed or are waiting:
FAILED: file apcaofft.sql on worker 1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Current time is: Wed Nov 07 2007 17:33:06 |
|
|Archiver|小黑屋|手机版|壹佰网 ERP100
( 京ICP备19053597号-2 )
IP卡
狗仔卡
发表于 2007/11/8 14:28:02
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
抢沙发
千斤顶
显身卡
发表于 2007/11/8 17:37:47
发表于 2007/11/10 13:37:01
