When Apply
Procurement Path:
p21198991_R12.PRC_PF.B_R12_LINUX.zip
ERROR
Time when worker failed: Fri Jan 06 2017 15:14:58
Time when worker started job: Fri Jan 06 2017 15:14:58
Start time for file is: Fri Jan 06 2017 15:14:58
sqlplus -s APPS/*****
@/u1/oracle/PROD/apps/apps_st/appl/pos/12.0.0/patch/115/sql/POS_SUPPLIER_SEARCH_INDEX.sql
Connected.
DECLARE
*
ERROR at line 1:
ORA-20000: possearchindex.sql(500): ORA-20000: Exception
at
POS_SUPPLIER_SEARCH_INDEX_PKG.create_index(1800): ORA-20000:
Exception at
POS_SUPPLIER_SEARCH_INDEX_PKG.create_index(1800):
ORA-29855: error occurred in
the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10502: index POS_SUPPLIER_SEARCH_INDEX does not exist
DRG-11135: feature not generally available
ORA-06512: at line 57
Solution:
How To
Troubleshoot Issues on Script POS_SUPPLIER_SEARCH_INDEX.sql (Doc ID 1677737.1)
Apply Opatch on Database As per Document: p17402822_112040_Linux-x86-64.zip
[applmgr@uat-ebsap ~]$ sqlplus apps/apps
SQL*Plus: Release 10.1.0.5.0 - Production on Fri Jan 6
17:50:41 2017
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
- 64bit Production
With the Partitioning, Real Application Clusters,
Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL>
@/u1/oracle/PROD/apps/apps_st/appl/pos/12.0.0/patch/115/sql/POS_SUPPLIER_SEARCH_INDEX.sql
PL/SQL procedure successfully completed.
Commit complete.
Disconnected from Oracle Database 11g Enterprise Edition
Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters,
Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
No comments:
Post a Comment