Oacle ERP Patch 問題

hbwp2008

各位好:
   我因上4334965 patch 失敗, 導致無法登錄oracle ERP 系統 ,現也無法登錄adadmin模式.
附件error log:   請幫忙看看. 謝謝

注:APPS_TS_INTERFACE表空間衹到66%

gaoyiming

你把你的日志贴出来
你搞成附件 别人下载给你解决问题 还需要努力值

hbwp2008

ORA-01552: cannot use system rollback segment for non-system tablespace 'APPS_TS_INTERFACE'


AD Administration error:
adptaskStoreInfoToSessAttr: Error calling adptaskSessPrepatchTiming to store PROGRAM_NAME



AD Administration error:
adadmin_main: Error calling adptaskStoreInfoToSessAttr.


You should check the file
/u1/TEST/testmgr/testappl/admin/NEWTEST/log/adadmin.log

for errors.


************* Start of AD Administration session *************
AD Administration version: 11.5.0
AD Administration started at: Tue Oct 16 2007 11:21:16

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


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


Your previous AD Administration session did not run to completion.
Do you wish to continue with your previous AD Administration session [Yes] ? no

You chose to disregard your previous AD Administration session
and to restart AD Administration from the beginning.

Enter Yes to confirm that you wish to overwrite your previous
AD Administration session and begin a new AD Administration session.

Enter No to continue with your previous AD Administration session. [No] : No



You are about to use or modify Oracle Applications product tables
in your ORACLE database 'NEWTEST'
using ORACLE executables in '/u1/TEST/testmgr/testora/8.0.6'.

Is this the correct database [Yes] ? Yes

Connecting to SYSTEM......Connected successfully.

Already asked for the ORACLE username and password
of Application Object Library.
(The given username/password was: APPLSYS/*****)

Connecting to APPLSYS......Connected successfully.

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



Reading product information from file...

Reading language and territory information from file...

Reading language information from applUS.txt ...

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.
Connecting to SYSTEM......Connected successfully.

Connecting to APPLSYS......Connected successfully.


AD code level : [11i.AD.I.2]

Connecting to SYSTEM......Connected successfully.

Connecting to APPS......Connected successfully.

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 8 and 16 workers.



Creating FND_INSTALL_PROCESSES table...

Connecting to APPLSYS......Connected successfully.

Running adtasktim.sql ..

Connected.

PL/SQL procedure successfully completed.


Commit complete.


Already created fnd_install_processes table

Already created FND_INSTALL_PROCESSES_U1 index.

Connecting to APPS......Connected successfully.

Connecting to APPLSYS......Connected successfully.

Already created AD_DEFERRED_JOBS table

Already created AD_DEFERRED_JOBS_U1 index.

Connecting to APPS......Connected successfully.

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

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

Reading completed jobs from restart file (if any).

There are now 5 jobs remaining (current phase=admin):
    0 running, 5 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.

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 ...

   FAILED: file OKLNLINS.sql on worker  1 for product okl username OKL.

Time is: Tue Oct 16 2007 11:21:35

   FAILED: file CNNLINS.sql  on worker  2 for product cn  username CN.

Time is: Tue Oct 16 2007 11:21:35

   FAILED: file OZFNLINS.sql on worker  3 for product ozf username OZF.

Time is: Tue Oct 16 2007 11:21:35

   FAILED: file PONLINS.sql  on worker  5 for product po  username PO.

Time is: Tue Oct 16 2007 11:21:35

   FAILED: file ARNLINS.sql  on worker  6 for product ar  username AR.

Time is: Tue Oct 16 2007 11:21:35


Done reading jobs from FND_INSTALL_PROCESSES table ...

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

ATTENTION: All workers either have failed or are waiting:

           FAILED: file OKLNLINS.sql on worker  1.
           FAILED: file CNNLINS.sql  on worker  2.
           FAILED: file OZFNLINS.sql on worker  3.
           FAILED: file PONLINS.sql  on worker  5.
           FAILED: file ARNLINS.sql  on worker  6.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

Current time is: Tue Oct 16 2007 11:21:35

************* Start of AD Administration session *************
AD Administration version: 11.5.0
AD Administration started at: Thu Oct 18 2007 18:47:02

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


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


Your previous AD Administration session did not run to completion.
Do you wish to continue with your previous AD Administration session [Yes] ? Yes



You are about to use or modify Oracle Applications product tables
in your ORACLE database 'NEWTEST'
using ORACLE executables in '/u1/TEST/testmgr/testora/8.0.6'.

Is this the correct database [Yes] ? Yes

Connecting to SYSTEM......Connected successfully.

Already asked for the ORACLE username and password
of Application Object Library.
(The given username/password was: APPLSYS/*****)

Connecting to APPLSYS......Connected successfully.

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



Reading product information from file...

Reading language and territory information from file...

Reading language information from applUS.txt ...

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.
Connecting to SYSTEM......Connected successfully.

Connecting to APPLSYS......Connected successfully.


AD code level : [11i.AD.I.2]

Connecting to SYSTEM......Connected successfully.

Connecting to APPS......Connected successfully.

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 90 workers.
Oracle recommends that you use between 8 and 16 workers.



Creating FND_INSTALL_PROCESSES table...

Connecting to APPLSYS......Connected successfully.

Running adtasktim.sql ..

Connected.

PL/SQL procedure successfully completed.


Commit complete.


Already created fnd_install_processes table

Already created FND_INSTALL_PROCESSES_U1 index.

Connecting to APPS......Connected successfully.

Connecting to APPLSYS......Connected successfully.

Already created AD_DEFERRED_JOBS table

Already created AD_DEFERRED_JOBS_U1 index.

Connecting to APPS......Connected successfully.

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

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

Reading completed jobs from restart file (if any).

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

AD Administration error:
The following ORACLE error:

ORA-00942: table or view does not exist
                              

occurred while executing the SQL statement:

UPDATE FND_INSTALL_PROCESSES
SET control_code = 'W'
WHERE worker_id > 0

Time is: Thu Oct 18 2007 18:47:21


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

You should check the file
/u1/TEST/testmgr/testappl/admin/NEWTEST/log/adadmin.log

for errors.


************* Start of AD Administration session *************
AD Administration version: 11.5.0
AD Administration started at: Thu Oct 18 2007 19:12:42

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


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


Your previous AD Administration session did not run to completion.
Do you wish to continue with your previous AD Administration session [Yes] ? Yes



You are about to use or modify Oracle Applications product tables
in your ORACLE database 'NEWTEST'
using ORACLE executables in '/u1/TEST/testmgr/testora/8.0.6'.

Is this the correct database [Yes] ? Yes

Connecting to SYSTEM......Connected successfully.

Already asked for the ORACLE username and password
of Application Object Library.
(The given username/password was: APPLSYS/*****)

Connecting to APPLSYS......Connected successfully.

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



Reading product information from file...

Reading language and territory information from file...

Reading language information from applUS.txt ...

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.
Connecting to SYSTEM......Connected successfully.

Connecting to APPLSYS......Connected successfully.


AD code level : [11i.AD.I.2]

Connecting to SYSTEM......Connected successfully.

Connecting to APPS......Connected successfully.

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 76 workers.
Oracle recommends that you use between 8 and 16 workers.



Creating FND_INSTALL_PROCESSES table...

Connecting to APPLSYS......Connected successfully.

Running adtasktim.sql ..

Connected.

PL/SQL procedure successfully completed.


Commit complete.


Already created fnd_install_processes table

Already created FND_INSTALL_PROCESSES_U1 index.

Connecting to APPS......Connected successfully.

Connecting to APPLSYS......Connected successfully.

Already created AD_DEFERRED_JOBS table

Already created AD_DEFERRED_JOBS_U1 index.

Connecting to APPS......Connected successfully.

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

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

Reading completed jobs from restart file (if any).

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

AD Administration error:
The following ORACLE error:

ORA-00942: table or view does not exist
                              

occurred while executing the SQL statement:

UPDATE FND_INSTALL_PROCESSES
SET control_code = 'W'
WHERE worker_id > 0

Time is: Thu Oct 18 2007 19:13:00


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

You should check the file
/u1/TEST/testmgr/testappl/admin/NEWTEST/log/adadmin.log

for errors.

gaoyiming

楼主
/u1/TEST/testmgr/testappl/admin/NEWTEST/log/adadmin.log
这个是错误日志啊
我都怀疑你自己仔细看过日志吗

hbwp2008

我看過，我是個新手.好多都不懂，請老大賜教.

520.xiaomaomi

FAILED: file OKLNLINS.sql on worker  1.
           FAILED: file CNNLINS.sql  on worker  2.
           FAILED: file OZFNLINS.sql on worker  3.
           FAILED: file PONLINS.sql  on worker  5.
           FAILED: file ARNLINS.sql  on worker  6.
这些文件都存在吗？
用户权限有没有问题？

bol_man

这个就是DBA要看的东西吗？可怕啊

gaoyiming

/u1/TEST/testmgr/testappl/admin/NEWTEST/log/adadmin.log
把这个日志 贴上来
这个才是最有用的

hbwp2008

原帖由 gaoyiming 于 2007-10-19 15:36 发表
/u1/TEST/testmgr/testappl/admin/NEWTEST/log/adadmin.log
把这个日志 贴上来
这个才是最有用的

上面就是adadmin.log 呀！

ivanlvzoe

不知道楼主的环境是什么版本的,RUP3经常打,请参考 Note:337274.1,注意里面的细节

rossy

看不懂，帮顶！

kenny

最好把worker的日志也贴出来