OraFAQ Forum: Enterprise Manager » ORA-06512/ORA-21560

Home » RDBMS Server » Enterprise Manager » ORA-06512/ORA-21560

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

ORA-06512/ORA-21560 [message #435124]

Mon, 14 December 2009 07:40

danae.kiouf
Messages: 6
Registered: December 2009
Location: GREECE

Junior Member

HELLO,

I AM TRYING TO RUN A CODE FROM ENTERPRISE MANAGER VIA A JOB(DATABASE SCHEDULER). IT RUNS FINE FOR SOME ROWS OF DATA AND THEN GIVES THE FOLLOWINF ERROR:

ORA-20001:
ORA-20001:
ERROR:-21560
ORA-21560: argument 3 is null, invalid, or out of range
ORA-06512: at "USERNAME.DATABASE", line 742
ORA-06512: at "USERNAME.CALL_LOADER", line 40
ORA-06512: at "USERNAME.EXECUTE_BATCH", line 10
ORA-06512: at "USERNAME.EXECUTE_BATCH", line 951
ORA-06512: at line 2

IF I RUN THE CODE FROM PL-SQL NO ERRORS APPEAR. DOES ANYBODY HAVE ANY IDEA ABOUT THIS?

THANKS IN ADVANCE

Report message to a moderator

Re: ORA-06512/ORA-21560 [message #435126 is a reply to message #435124]

Mon, 14 December 2009 07:52

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

Senior Member
Account Moderator

What does the procedure do? Which argument is #3? How do you acquire argument 3's value?

Report message to a moderator

Re: ORA-06512/ORA-21560 [message #435127 is a reply to message #435126]

Mon, 14 December 2009 07:58

danae.kiouf
Messages: 6
Registered: December 2009
Location: GREECE

Junior Member

I have concluded that it is not a matter of a specific parameter.
This error is raised randomly and if i rerun again the process usually executes without problem.This process opens a file and copies tha last 4000 character in a lob field.

Report message to a moderator

Re: ORA-06512/ORA-21560 [message #435128 is a reply to message #435127]

Mon, 14 December 2009 07:59

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

ORA-21560: argument string is null, invalid, or out of range 
Cause: The argument is expecting a non-null,
valid value but the argument value passed in is null,
invalid, or out of range. 
Examples include when the LOB/FILE positional or size argument
has a value outside the range 1 through (4GB - 1), 
or when an invalid open mode is used to open a file, etc.
 
Action: Check your program and correct the caller of the routine to not pass a null,
invalid or out-of-range argument value.

Report message to a moderator

Re: ORA-06512/ORA-21560 [message #435129 is a reply to message #435128]

Mon, 14 December 2009 08:09

danae.kiouf
Messages: 6
Registered: December 2009
Location: GREECE

Junior Member

Thank you,

I'll try to locate it but it is not so easy.

Report message to a moderator

Re: ORA-06512/ORA-21560 [message #435131 is a reply to message #435129]

Mon, 14 December 2009 08:27

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

I'll try to locate it but it is not so easy.

http://www.error-code.org.uk/

http://ORA-01017.ora-code.com/

i.e.

http://ORA-01017.ora-code.com/

replace the error with your error and browse that.

http://download.oracle.com/docs/cd/B10501_01/server.920/a96525.pdf

http://download.oracle.com/docs/cd/B19306_01/server.102/b14219.pdf

Even search/google for oerr

sriram Smile

[Updated on: Mon, 14 December 2009 08:28]

Report message to a moderator

Re: ORA-06512/ORA-21560 [message #435132 is a reply to message #435131]

Mon, 14 December 2009 08:43

danae.kiouf
Messages: 6
Registered: December 2009
Location: GREECE

Junior Member

Thanks you very much,

All day today I am looking for this in google. Smile

))
Actually, in my previous answer about the difficulty of the location was on my program and not to the Internet.
I am running now my process in pl-sql and when it finishes I will try again to run it via Enterprise Manager in a test environment. I wil put exceptions to see exactly where the process fail...

Thank you again,

The first pdf is very good!

Report message to a moderator

Re: ORA-06512/ORA-21560 [message #435169 is a reply to message #435132]

Mon, 14 December 2009 22:40

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

Actually, in my previous answer about the difficulty of the location was on my program and not to the Internet

Here my point is to give you the basic error information.
So always search before posting.For the errors...Almost the cause and actions provided by oracle will give the hints how to overcome the error.

Please post your Oracle version with 4 digits so that it will help the experts to give you hints/provide some information.

Good luck Smile

sriram

Report message to a moderator

Re: ORA-06512/ORA-21560 [message #435226 is a reply to message #435169]

Tue, 15 December 2009 05:15

danae.kiouf
Messages: 6
Registered: December 2009
Location: GREECE

Junior Member

Dear sriram,

The Oracle version is the following: 10.2.0.4.0

Thank you,

Report message to a moderator

Re: ORA-06512/ORA-21560 [message #436424 is a reply to message #435169]

Wed, 23 December 2009 08:51

danae.kiouf
Messages: 6
Registered: December 2009
Location: GREECE

Junior Member

You should have known that the errors raised from oracle is not always the actual ones.
And more specifically the error i get is raised only when i call/execute the same part of code from a job and not from plsql developer test window.

So i have concluded that it is caused due to dinamic job generation from within another job that uses external sqlldr utility to load multiple parallel files.
so the issue is not so easy to identify

It has to do with system resources available

Thank you,

Report message to a moderator

Previous Topic:	installing manually oem fails instance not available
Next Topic:	How To Add Shell Scripts already written to 10g Grid

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 17:10:11 CST 2024