Home » RDBMS Server » Backup & Recovery » Freaking ORA-31626: job does not exist
Freaking ORA-31626: job does not exist [message #194885] Mon, 25 September 2006 21:57 Go to next message
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

Re: Freaking ORA-31626: job does not exist [message #195030 is a reply to message #194885] Tue, 26 September 2006 12:13 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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?
Re: Freaking ORA-31626: job does not exist [message #195060 is a reply to message #195030] Tue, 26 September 2006 15:31 Go to previous messageGo to next message
Littlefoot
Messages: 20900
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.
Re: Freaking ORA-31626: job does not exist [message #195062 is a reply to message #195060] Tue, 26 September 2006 15:47 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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~
Re: Freaking ORA-31626: job does not exist [message #195092 is a reply to message #194885] Wed, 27 September 2006 01:11 Go to previous message
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!!!
Previous Topic: password file
Next Topic: Partial export
Goto Forum:
  


Current Time: Thu Dec 08 10:33:26 CST 2016

Total time taken to generate the page: 0.19521 seconds