Home » RDBMS Server » Enterprise Manager » ORA-06512/ORA-21560
ORA-06512/ORA-21560 [message #435124] Mon, 14 December 2009 07:40 Go to next message
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
Re: ORA-06512/ORA-21560 [message #435126 is a reply to message #435124] Mon, 14 December 2009 07:52 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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?
Re: ORA-06512/ORA-21560 [message #435127 is a reply to message #435126] Mon, 14 December 2009 07:58 Go to previous messageGo to next message
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.
Re: ORA-06512/ORA-21560 [message #435128 is a reply to message #435127] Mon, 14 December 2009 07:59 Go to previous messageGo to next message
ramoradba
Messages: 2456
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. 
icon13.gif  Re: ORA-06512/ORA-21560 [message #435129 is a reply to message #435128] Mon, 14 December 2009 08:09 Go to previous messageGo to next message
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.
Re: ORA-06512/ORA-21560 [message #435131 is a reply to message #435129] Mon, 14 December 2009 08:27 Go to previous messageGo to next message
ramoradba
Messages: 2456
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 Go to previous messageGo to next message
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!
Re: ORA-06512/ORA-21560 [message #435169 is a reply to message #435132] Mon, 14 December 2009 22:40 Go to previous messageGo to next message
ramoradba
Messages: 2456
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 Smile
Re: ORA-06512/ORA-21560 [message #435226 is a reply to message #435169] Tue, 15 December 2009 05:15 Go to previous messageGo to next message
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,
Re: ORA-06512/ORA-21560 [message #436424 is a reply to message #435169] Wed, 23 December 2009 08:51 Go to previous message
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,
Previous Topic: installing manually oem fails instance not available
Next Topic: How To Add Shell Scripts already written to 10g Grid
Goto Forum:
  


Current Time: Fri Mar 29 00:39:34 CDT 2024