Posts Tagged ‘Oracle error -25153’

ORA-25153: Temp Tablespace error on adconfig.sh

July 24th, 2022, posted in Oracle, Oracle EBS Application
Share

========================================================================

                                                        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
Share

Adcfgclone error Oracle error -25153: ORA-25153: Temporary Tablespace is Empty has been detected in

October 27th, 2019, posted in Oracle EBS Application, Oracle Queries
Share
 | 50% completed ERROR: InDbCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;: 1; Oracle error -25153: ORA-25153: Temporary Tablespace is Empty 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 -25153: ORA-25153: Temporary Tablespace is Empty 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:1680)
at oracle.apps.ad.clone.ApplyApplTop.runCVM(ApplyApplTop.java:510)
at oracle.apps.ad.clone.ApplyApplTop.runAutoConfig(ApplyApplTop.java:552)
at oracle.apps.ad.clone.ApplyApplTop.doConf(ApplyApplTop.java:339)
at oracle.apps.ad.clone.ApplyApplTop.doApply(ApplyApplTop.java:382)
at oracle.apps.ad.clone.ApplyApplTop.(ApplyApplTop.java:267)
at oracle.apps.ad.clone.ApplyAppsTier.(ApplyAppsTier.java:105)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:67)
at java.lang.Thread.run(Thread.java:595)

 

 

Solution:

Add Tempfile to the temporary tablespace. It will resolve the issue !!

Share