My Oracle Support Banner

OEM Batches Error While Executing Batch TD- PURGE (Doc ID 2907297.1)

Last updated on NOVEMBER 07, 2022

Applies to:

Oracle Utilities Customer to Meter Base - Version 2.7.0.3.0 and later
Information in this document applies to any platform.

Goal

On: 4.4.0.2.0, System Wide issue

While user trying to execute the batch TD-PURGE from OEM, they are getting the table space errors.
Here they could observe few things
1. 2 batch job's are being created for this batch .
2.One batch job is created with actual user ID which is passed from OEM and
the 2nd batch job is created with the user id (@@SCH@@) .
3. For the first job batch run tree is created and is getting Ended but for
the 2nd job tree is not created and the job submission status remains in started state.


The error which we are getting for second job (with user id @@SCH@@) is mentioned below.
Error Code:ORA-01950: no privileges on tablespace 'CISTS_01' ORA-06512: at "SCHADM.OEM_OUAF", line 13 ORA-06512: at "SYS.DBMS_ISCHED", line 242 ORA-06512: at "SYS.DBMS_SCHEDULER", line 566 ORA-06512: at "CISADM.OUAF_BATCH", line 781 ORA-06512: at "CISADM.OUAF_BATCH", line 781 ORA-06512: at "CISADM.OUAF_BATCH", line 899 ORA-06512: at "CISADM.OUAF_BATCH", line 1108 ORA-06512: at line 2
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.