Home » RDBMS Server » Server Administration » ORA-12801error (Oracle 10g ,Redhat linux)
ORA-12801error [message #421008] Thu, 03 September 2009 11:36 Go to next message
SRIVASUWIN
Messages: 45
Registered: October 2006
Location: TRICHY
Member
Hi Gurus,

Please suggest me for the following error:

Error Message:

Server:Redhat Linux
Database: Oracle 10g(10.2.0.2)

Error occur while running auto job:(Daily manner auto job)yerterday went fine today has problem)

Job failed due to reason:

ORA-01722: invalid number
Error in: MAIN FATAL. ORA-20001:
INP2123;01.06;yyyy_1;drop_indexes;;
ORA-12801: error signaled in
parallel qu
Error in: PGM_START FATAL. ORA-20001: INP2123;01.06;MAIN;;;
ORA-20001:
INP2123;01.06;yyyy_1;drop_indexes;;
ORA-128
begin
*
ERROR at line 1:
ORA-20001: START;01.00;PGM_START;Start PL program: INP2123;ORA-20001:
INP2123;01.06;MAIN;;;
ORA-20001: test2123;01.06;yyyy_1;drop_indexes;;
ORA-12801: error signaled in parallel query server P021
ORA-01722: invalid number;
ORA-20001: test2123;01.06;MAIN;;;
ORA-20001: test2123;01.06;yyyy_1;drop_indexes;;
ORA-12801: error signaled in parallel query server P021
ORA-01722: invalid number
ORA-06512: at "test.test_COMMON", line 318
ORA-06512: at "test.PGM_START", line 96
ORA-06512: at line 2

Tried options:
--------------

I have checked objects status for "test2123" package(valid)
Enough tablespace free space is avaialble.

Any suggestions ???

Thanks in advance
Regards
Srivasu
Re: ORA-12801error [message #421019 is a reply to message #421008] Thu, 03 September 2009 12:26 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>ORA-01722: invalid number
means a non-numeric character was being assigned to a NUMBER.
you need to find & fix it.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
Previous Topic: Need Guidline for deploying server,
Next Topic: Strange ora_*** processes
Goto Forum:
  


Current Time: Sun Dec 08 06:32:11 CST 2024