========================================================================If This Error Facing on Adconfig.sh or autoconfig.sh
========================================================================Attempting 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
No comments:
Post a Comment