OraFAQ Forum: Backup & Recovery » Freaking ORA-31626: job does not exist

Home » RDBMS Server » Backup & Recovery » Freaking ORA-31626: job does not exist

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Freaking ORA-31626: job does not exist [message #194885]

Mon, 25 September 2006 21:57

archie_deleon
Messages: 2
Registered: September 2006
Location: philippines

Junior Member

Hi, I'm currently using the expdp command in Oracle 10g. I'm encountering the problem below:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user CPI
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1193
ORA-39062: error creating master process DM00
ORA-39107: Master process DM00 violated startup protocol. Master error:
ORA-06533: Subscript beyond count

currently the user above has a dba and exp_full_database roles
I've tried changing the SGA size as said in the previous links but the above problems still occur Mad

Report message to a moderator

Re: Freaking ORA-31626: job does not exist [message #195030 is a reply to message #194885]

Tue, 26 September 2006 12:13

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

This is a very known bug that is to do with resource manager plans.
The standard workaround (at that time) was not to use them.
Please check metalink. There is definately a doc up there.

PS
>>I've tried changing the SGA size as said in the previous link
What does these errors have to do with SGA size?

Report message to a moderator

Re: Freaking ORA-31626: job does not exist [message #195060 is a reply to message #195030]

Tue, 26 September 2006 15:31

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I believe the had in mind answer to the similar (same?) problem discussed here; it seems that it succeeded, so - perhaps you could read it, Archie - it might help.

Report message to a moderator

Re: Freaking ORA-31626: job does not exist [message #195062 is a reply to message #195060]

Tue, 26 September 2006 15:47

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Both are different issues.
For this,
>>ORA-04031: unable to allocate 4194344 bytes of shared memory ("streams pool","un
known object","streams pool","fixed allocation callback")

tweaking SGA might help.

Regards~

Report message to a moderator

Re: Freaking ORA-31626: job does not exist [message #195092 is a reply to message #194885]

Wed, 27 September 2006 01:11

archie_deleon
Messages: 2
Registered: September 2006
Location: philippines

Junior Member

ok guys i'll try checking the metalink for this error (and try retweeking the SGA values)

many thanks and best regards!!!

Report message to a moderator

Previous Topic:	password file
Next Topic:	Partial export

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 30 14:24:48 CDT 2024