-
error on dbms_job
hi,
when i set dbms_job to execute statspack.snap it throws following err.
if i run manually it works.
ORA-12012: error on auto execute of job 70
ORA-00001: unique constraint (PERFSTAT.STATS$UNDOSTAT_PK) violated
ORA-06512: at "PERFSTAT.STATSPACK", line 2228
ORA-06512: at "PERFSTAT.STATSPACK", line 91
ORA-06512: at line 1
how to overcome,pls help
thanks.
-
-
i set statspact to execute at 7am
begin
DBMS_JOB.SUBMIT ( :jobno , 'statspack.snap;', trunc(sysdate+7/24), 'sysdate+1' );
commit;
end;
when the time comes it throws err in log file. The same code i can run in my personal pc.
Thanks.
-
Originally Posted by ams-jamali
The same code i can run in my personal pc.
Just to be sure, is your personal PC acting as a client of the database where STATSPACK is failing or you have a local test database in you personal PC?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
No, my personal PC not acting as client to test database.It fails in testDB so i tried that in my local PC(both are separate DB).
-
so you have a messed up statspack install, re-install it
-
if i had messed up it should not work when i run statspack manually.
ok i will re-install it.,
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|