========================================================================
If This Error Facing on Adconfig.sh or autoconfig.sh
=======================================================================
Atempting upload of Context file and templates to database...ERROR: InDbCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;: 1; Oracle error -1187: ORA-01187: cannot read from file 515 because it failed verification tests ORA-01110: data file 515: '/oradata/proddb/data/temp03.dbf' has been detected in FND_GSM_UTIL.APPEND_CTX_FRAGMENT. oracle.apps.ad.autoconfig.oam.InDbCtxFileException: Error executng BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;: 1; Oracle error -1187: ORA-01187: cannot read from file 515 because it failed verification tests ORA-01110: data file 515: '/oradata/proddb/data/temp03.dbf' has been detected in FND_GSM_UTIL.APPEND_CTX_FRAGMENT. at oracle.apps.ad.autoconfig.oam.InDbCtxFile.uploadCtx(InDbCtxFile.java:220) at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.uploadToDb(CtxSynchronizer.java:328) at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBCtx(FileSysDBCtxMerge.java:678) at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBFiles(FileSysDBCtxMerge.java:222) at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1688) at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:763) FAILED COMPLETED ======================================================================================================================================================= Solution Apply ============================================================================================================================================
login as: dgdb dgdb@192.168.1.80's password: Last login: Mon May 2 15:54:08 2016 from 192.168.81.61 [dgdb@b6dgdb ~]$ cd /oradb/proddb/PROD/db/tech_st/11.1.0/ [dgdb@b6dgdb 11.1.0]$ . ./T2_b6dgdb.env [dgdb@b6dgdb 11.1.0]$ sqlplus / as sysdba SQL*Plus: Release 11.1.0.7.0 - Production on Mon May 2 16:46:14 2016 Copyright (c) 1982, 2008, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> sql> select bytes/1024/1024 from dba_temp_files; select bytes/1024/1024 from dba_temp_files * ERROR at line 1: ORA-01187: cannot read from file 513 because it failed verification tests ORA-01110: data file 513: '/oradata/proddb/data/temp01.dbf' SQL> col name format a50 SQL> run 1* select file#,status,name from v$tempfile FILE# STATUS NAME ---------- ------- -------------------------------------------------- 1 ONLINE /oradata/proddb/data/temp01.dbf 2 ONLINE /oradata/proddb/data/temp02.dbf 3 ONLINE /oradata/proddb/data/temp03.dbf SQL> col DESCRIPTION format a40 SQL> SQL> SELECT * FROM database_properties WHERE property_name like '%TABLESPACE' PROPERTY_NAME PROPERTY_VALUE DESCRIPTION ------------------------------ ---------------------------------------- ---------------------------------------- DEFAULT_TEMP_TABLESPACE TEMP ID of default temporary tablespace DEFAULT_PERMANENT_TABLESPACE SYSTEM Default Permanent Tablespace ID CREATE TEMPORARY TABLESPACE temp3 TEMPFILE '/oradata/proddb/data/temp_01' SIZE 1024M TABLESPACE GROUP temp; alter tablespace temp3 add tempfile '/oradata/proddb/data/temp_02' SIZE 1024M; ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp3; SQL> SELECT * FROM dba_tablespace_groups; GROUP_NAME TABLESPACE_NAME ------------------------------ ------------------------------ TEMP TEMP1 TEMP TEMP2 DROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES; DROP TABLESPACE temp2 INCLUDING CONTENTS AND DATAFILES; sql> select TABLESPACE_NAME,FILE_NAME from dba_temp_files TABLESPACE_NAME FILE_NAME ------------------------------ ---------------------------------------- TEMP3 /oradata/proddb/data/temp_02 TEMP3 /oradata/proddb/data/temp_01 ======================================================================================================================================== Then Run Adconfig.sh ======================================================================================================================================== login as: dgapps dgapps@192.168.1.81's password: Last login: Mon May 2 16:24:32 2016 from 192.168.81.61 [dgapps@c6dgapps ~]$ cd /oraapps/prodapps/ oraInventory/ PROD/ [dgapps@c6dgapps ~]$ cd /oraapps/prodapps/PROD/apps/apps_st/appl/ [dgapps@c6dgapps appl]$ cd ad/12.0.0/bin [dgapps@c6dgapps bin]$ [dgapps@c6dgapps bin]$ sh adconfig.sh Enter the full path to the Context file:/oraapps/prodapps/PROD/inst/apps/T2_c6dgapps/appl/admin/T2_c6dgapps.xml
Comments
Tags: Adcfgclone error, Adcfgclone error Oracle error -25153: ORA-25153:, Cloning of DB Tier., dba imam, dba immam, dba_imam, dba_immam, Empty Has Been Detected, error on adconfig.sh, Imam Dba, imam_dba, Immam Dba, immam_dba, ORA-25153, ORA-25153: Temporary Tablespace, ORA-25153: Temporary Tablespace Is Empty Has Been Detected, Oracle error -25153, Temp Tablespace error, Temporary Tablespace