Sunday, March 24, 2013

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

  |     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.

Friday, March 22, 2013

Locked object details of a spcefic database sessions


select substr(c.object_name,1,30),c.object_type,
   b.sid,
   b.serial#,
substr(b.module,1,25),
substr(b.action,1,30)
from
   v$locked_object a ,
   v$session b,
   dba_objects c
where  b.sid = a.session_id
and a.object_id = c.object_id and b.sid=1383;

Query to find out Sid details of form sessions of specific front end user

Query to find out Sid details of form sessions of specific front end user

select /*+ CHOOSE*/
s.sid,
s.serial#,
substr(s.username, 1, 6),
s.status,
substr(s.module, 1, 25),
substr(s.action, 1, 30),
s.last_call_et
from v$session s, v$process p
where p.addr = s.paddr and s.sid = nvl('&sid', s.sid) and
p.spid = nvl('&spid', p.spid) and
nvl(s.process, -1) = nvl('&ClientPid', nvl(s.process, -1)) and
s.action like '%&USER_NAME%';

Use the below query to find the sid and other details of specifice database module running(programs)

Use the below query to find the sid and other details of specifice database module running(programs)

select /*+ CHOOSE*/
s.sid,
s.serial#,
substr(s.username, 1, 6),
s.status,
substr(s.module, 1, 25),
substr(s.action, 1, 30),
s.last_call_et
from v$session s, v$process p
where p.addr = s.paddr and s.sid = nvl('&sid', s.sid) and
p.spid = nvl('&spid', p.spid) and
nvl(s.process, -1) = nvl('&ClientPid', nvl(s.process, -1)) and
s.module = '%&Module_name%';

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...