10. adpatch 补丁应用指南（常见问题处理）(9)

手册

1.15.6 如果有错误The index cannot be created as the

table has duplicate keys.

可以使用下面的sql查找重复的key

SELECT ... FROM ... GROUP BY ... HAVING count(*)>1 AD Worker error: Unable to compare or correct tables or indexes or keys because of the error above

这个错误可能是数据原因引起的。如果要创建key索引的字段有重复值，就会出现这个问题。此问题可能有不同的解决方法，列举几个： - delete the duplicate rows

- run a concurrent request to delete the duplicate rows - rename the unique key value 例如： Note 987878.1 Create Index CSF_PHONETIC_VALUES_U3 Fails As The Table Has Duplicate Keys Note 430673.1 icxwtab.odf is unable to create index ICX_TRANSACTIONS_U1

1.15.7 如果有错误AD Worker - aduobbrt2: INFO:

ORA-03211: The segment does not exist or is not in a valid state

原因可能是DBMS_SPACE_ADMIN要操作的segment不存在或者segment的当前状态不能进

行此操作。这种情况经常发生在还没有分配segment的临时表上。执行DBMS_ADMIN_SPACE的时候，需要segment存在。

这种情况下，通常需要先将临时表drop掉。 参考例子： Note 372945.1 Applying 3480000 csdcsd1.odf Aduobbrt2: Info: ORA-03211: The Segment Does Not Exist Note 818044.1 During Patch Application, hxctab.odf Errors With: \Worker - aduobbrt2: INFO: ORA-03211: The Segment Does Not Exist Or Is Not In A Valid State\ Note 1546496.1 ORA-03211 During 12.1 Driver In Cstcbom.odf 手册

Note 457866.1 Ad Worker Fails For Wiphdr.Odf In Patch.6116755 The segment does not exist or is not in a valid state Note 1286823.1 Worker GMDCOA.odf Fails When Upgrading To R12.1 from Rel 11i

1.15.8 如果有错误ORA-00054: resource busy and

acquire with NOWAIT specified

如果出现错误：

ORA-00054: resource busy and acquire with NOWAIT specified The object is locked by another process.

可以尝试下面步骤：

? 使用adctrl重启失败的worker

? 确认安装补丁过程中应用是关闭状态 ? 查找并释放锁 ? 重启数据库

1.15.9 如果运行poxcom.odf报错ORA-00911: invalid

character

原因可能是：odf文件中的视图po_lines_xml定义中不能包含\符号

可以通过安装包含120.18.12000000.33或更高版本poxcom.odf文件的补丁解决问题。 可能的补丁有：

Patch 16369996:R12.PO.A

Patch 16214305:R12.PO.A Patch 16061415:R12.PO.A Patch 15893161:R12.PO.A Patch 15843328:R12.PO.A

1.15.10 手工加载.odf文件

参考Note 551325.1 How to verify or create a Database Object using a odf (adodfcmp) or xdf (FndXdfCmp) file ?

命令实例：

手册

adodfcmp odffile= mode= changedb=yes userid=/ touser=/ priv_schema=SYSTEM/ where mode can be : baseonly, tables, indexes, noindexes, sequences, views, grants For exemple: adodfcmp userid=as/ars mode=views odffile=$AS_TOP/patch/115/odf/asdss.odf changedb=yes touser=apps/apps_password priv_schema=apps/apps_password adodfcmp userid=ar/ar mode=tables odffile=$AR_TOP/patch/115/odf/arhz.odf changedb=yes touser=apps/apps_password priv_schema=apps/apps_password

1.16 如何解决.xdf文件运行失败

补丁日志中可能会看到下面错误：

ATTENTION: All workers either have failed or are waiting: FAILED: file .xdf on worker #.

1.16.1 确保已经安装补丁所有的前置条件

可以使用下面的查询查找系统中是否已经安装补丁的前置条件

SQL> select bug_number from ad_bugs where bug_number in ('&patch_number1','&patch_number2',...);

1.16.2 查看adwork日志

在adpatch的日志中可以看到执行出错的job是分配在哪个worker上运行的，在adwork的

日志中查看错误的详细信息。 可能会看到类似下面的错误： Invoking Utility FndXdfCmp ... Class: oracle.apps.fnd.odf2.FndXdfCmp Method: applyXDF Arguments: &un_gl &pw_gl &un_apps &pw_apps &jdbc_protocol &jdbc_db_addr table &fullpath__patch/115/xdf_.xdf &fullpath_fnd_patch/115/xdf_xsl index_category=large parallel_index_threshold=20000 手册

========================================================== XDF file application started. ================================================================================ Applying XDF file : /$APPL_TOP//12.0.0/patch/115/xdf/.xdf ================================================================================ => there comes the error.

1.16.3 在MOS中使用下面条件搜索

? .xdf

? adworker日志中的错误信息

1.16.4 查看数据库alert日志

检查数据库alert日志，看是否有跟错误有关的信息。

如果出现错误No AOL metadata present in the XDF file

可以参考Note 373842.1 Patch 348000 fails: ORA-1658 \AOL metadata present in the XDF file\ 中的步骤

1.16.5 如果有错误Error message is ORA-01430

可能是下面错误：

Invoking Utility FndXdfCmp ... Class: oracle.apps.fnd.odf2.FndXdfCmp Method: applyXDF ... ALTER TABLE table_name ADD ( column_name column_type ) Start time for statement above is date End time for statement above is date Error in executing statement ALTER TABLE table_name ADD ( column_name type ) 手册

Error message is ORA-01430: la colonna che si sta aggiungendo esiste gi? nella tabella 需要在应用层和数据库层unset local环境变量，然后重启数据库，并从头开始重新安装补丁。 查看： Note 1504251.1 Patch Is Failing Running FndXdfCmp With ORA-01430 Note 297777.1 Failures for many XDF files in upgrading 11i Release to 11i10 Using MP 3140000

1.16.6 如果出现错误ORA-12514, TNS:listener does not

currently know of service requested in connect descriptor

Exception in thread \java.sql.SQLException: Listener refused the connection with the

following error:

ORA-12514, TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by the client was:

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=t106pldbms02.nehr.dev)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=HTBSITB2)))

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:439) at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:165)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171)

at oracle.apps.ad.worker.AdJavaWorker.getAppsConnection(AdJavaWorker.java:1027) at oracle.apps.ad.worker.AdJavaWorker.main(AdJavaWorker.java:276)

参考：

Note 1461916.1 ADPATCH Appears To Hang When Processing xdf files. Connection Error Reported In Worker Logs