Oracle Error 20011
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta
Ora-20011 Ora-29400
Discuss the workings and policies of this site About Us Learn ora-20011 ora-08103 more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack
Kup-11024
Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, ora-20011 kup-11024 helping each other. Join them; it only takes a minute: Sign up Oracle Error Has Occurred:ORA-20011: Execute_system: Error while receiving up vote 1 down vote favorite After executing one package, i got the below error Oracle Error Has Occurred:ORA-20011: Execute_system: Error while receiving. Status = 1 Please let me know what the error means ,why the error ora-20011 approximate ndv failed ora-00600 occurs and how to rectify the same oracle oracle11g share|improve this question asked Sep 13 '13 at 15:09 Nalina Devi 62 add a comment| 1 Answer 1 active oldest votes up vote 2 down vote Oracle has reserved the error numbers between ORA-20000 and ORA-20999 for us users. Which means that someone at your site has programmed their own user defined error. The package issues a RAISE_APPLICATION_ERROR(-20011,'Execute_system: Error while receiving.'); statement. Either directly in the package body or indirectly via a database trigger on one of the tables the package is modifying. Regards, Rob. share|improve this answer answered Sep 13 '13 at 15:16 Rob van Wijk 13.4k42139 Thanks Rob for your information. –Nalina Devi Sep 16 '13 at 12:40 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to
Solution for below information alert. Alert log File information: Mon Nov 28 22:00:10 2011 DBMS_STATS: GATHER_STATS_JOB encountered errors. Check the trace file. Errors in file /u01/oracle/admin/testdb/diag/rdbms/testdb/testdb/trace/testdb_j000_14552.trc: ORA-20011: Approximate NDV failed:
Dbms_stats: Gather_stats_job Encountered Errors
ORA-29913: error in executing ODCIEXTTABLEOPEN callout KUP-11024: This external table can only ora-29400 data cartridge error error opening file be accessed from within a Data Pump job. I have checked the alert log and respective trace
Ora-29913
files. On Trace files, I found some information alert. Trace File Information: DBMS_STATS: GATHER_STATS_JOB: GATHER_TABLE_STATS('"owner"','"tablename"','""', ...) DBMS_STATS: ORA-20011: Approximate NDV failed: ORA-08103: object no longer exists I have checked metalink http://stackoverflow.com/questions/18789659/oracle-error-has-occurredora-20011-execute-system-error-while-receiving notes and got the solutions. Why we getting this error everyday midnight? 1.While nightly stats gather job (DBMS_STATS) is running and when trying to gather statistics for temporary data pump external tables, we are getting the above error. 2.Temporary Datapump external tables have not been cleaned up properly. These should have been dropped when the DataPump jobs completed. Note: http://kpraveendba.blogspot.com/2013/11/ora-20011-approximate-ndv-failed-ora.html while datapump running, oracle internally create master table for tracking and putting the datapump status. This master table helps to stop or start the datapump jobs. Solutions: To clean up the Orphaned datapump jobs. 1.To ensure that there is no datapump jobs running at the same time as the dbms_stats job 2.To Check and cleanup orphaned datapump jobs. SELECT owner_name, job_name, operation, job_mode, state, attached_sessions FROM dba_datapump_jobs WHERE job_name NOT LIKE 'BIN$%' ORDER BY 1,2; 3.To identify the external tables. SQL> conn / as sysdba Connected. SQL> set linesize 200 trimspool on set pagesize 2000 col owner form a30 col created form a25 col last_ddl_time form a25 col object_name form a30 col object_type form a25 SQL> select OWNER,OBJECT_NAME,OBJECT_TYPE, status, to_char(CREATED,'dd-mon-yyyy hh24:mi:ss') created ,to_char(LAST_DDL_TIME , 'dd-mon-yyyy hh24:mi:ss') last_ddl_time from dba_objects where object_name like 'ET$%' / OWNER OBJECT_NAME OBJECT_TYPE STATUS CREATED LAST_DDL_TIME ------------------------------ ------------------------------ ------------------------- ------- ------------------------- ------------------------- PRAVEEN ET$001A18EF0001 TABLE VALID 18-may-2011 03:15:59 18-may-2013 03:15:59 PRAVEEN ET$009802870001 TABLE VALID 12-may-2011 09:26:44 12-may-201309:26:44 PRAVEEN ET$005800090001 TABLE VALID 12-may-2011 09:18:23 12-may-201309:18:23 PRAVEEN ET$005800070001 TABLE VALID 12-may-2011 09:16:42 12-m
STUDIO Summary When the user tries to create a Bizagi project using an Oracle database, the creation fails http://kb.bizagi.com/Knowledgebase/ERROR-ORA20011-and-ORA06512 and the Summary of Problems displays the error code ORA-20011 http://www.orafaq.com/forum/t/187704/ and several errors with code ORA-06512. Applies to Bizagi Engine 10.x using Oracle Database 11g Release 11.2.0.1.0 Symptoms The following errors are displayed when a user tries to create a Bizagi project using an Oracle database: ORA-20011: Approximate NDV failed: oracle error ORA-00439: feature not enabled: Data Guard Broker ORA-06512: at “SYS.DBMS_STATS”, line 20508 ORA-06512: at “SYS.DBMS_STATS”, line 20951 ORA-06512: at “SYS.DBMS_STATS”, line 21498 ORA-06512: at “BIZAGIADMON.SPBA_ORA_GATHER_STATS”, line 35 ORA-06512: at line 1 Cause During the creation of the project, Bizagi executes a Stored procedure (dbms_stats.gather_fixed_objects_stats) to collect statistics from Oracle database. oracle error 20011 For Oracle Database 11g Release 11.2.0.1.0, Oracle has identified a known issue with this procedure and had release a patch in order to resolve this. The bug is found on Standard Edition databases, but should also apply to Enterprise Edition. Solution Download and apply the Patch 9056912 available for you platform, you can find this patch login in your Oracle Support. Once this patch had been applied, the problem is fixed. Rate this Article: ORA-06512, ORA-20011, Oracle, Oracle Database 11g, Details Last Modified:Last Year Last Modified By: JorgeR Type: ERROR Level: Advanced Article not rated yet. Article has been viewed 2.0K times. Options Email Article Enter Email Address... Print Article Social Bookmarks Social Bookmarks Delicious Digg Redit StumbleUpon Furl Yahoo Export As PDF Enter Email Address... Social Bookmarks Delicious Digg Redit StumbleUpon Furl Yahoo Powered By InstantKB 2014-1 Final © 2016 Execution: 0.000. 14 queries. Compression Disabled.
Message Navigator E-mail to friend Encountering ORA-20011, ORA-29400, ORA-12012 after upgrade to 11.2.0.3 [message #584943] Mon, 20 May 2013 12:54 cakeday Messages: 31Registered: May 2010 Member Hello Experts: i upgraded oracle from version 11.1.0.7 to 11.2.0.3; Applied the OPatch and the April 2013 PSU patch. After i upgraded the database, i am getting the following errors in my alert log.. i am also listing a part of my alert log below for your reference. Please help since this is a very critical production database. CLIENT_NAME JOB_START_TIME JOB_NAME JOB STATUS JOB_ERROR auto space advisor 5/19/2013 10:05:42.939996 PM ORA$AT_SA_SPC_SY_15566 FAILED 6502 auto space advisor 5/19/2013 6:05:32.809577 PM ORA$AT_SA_SPC_SY_15555 FAILED 6502 auto space advisor 5/19/2013 2:05:23.400671 PM ORA$AT_SA_SPC_SY_15553 FAILED 6502 auto space advisor 5/19/2013 10:05:11.979476 AM ORA$AT_SA_SPC_SY_15551 FAILED 6502 auto space advisor 5/19/2013 6:00:02.714771 AM ORA$AT_SA_SPC_SY_15548 FAILED 6502 auto space advisor 5/18/2013 10:04:42.454018 PM ORA$AT_SA_SPC_SY_15546 FAILED 6502 auto space advisor 5/18/2013 6:04:31.750763 PM ORA$AT_SA_SPC_SY_15536 FAILED 6502 auto space advisor 5/18/2013 2:04:21.394908 PM ORA$AT_SA_SPC_SY_15534 FAILED 6502 auto space advisor 5/18/2013 10:04:10.336048 AM ORA$AT_SA_SPC_SY_15532 FAILED 6502 auto space advisor 5/18/2013 6:00:03.008264 AM ORA$AT_SA_SPC_SY_15529 FAILED 6502 auto space advisor 5/17/2013 10:00:02.618205 PM ORA$AT_SA_SPC_SY_15526 FAILED 6502 auto space advisor 5/16/2013 10:00:02.480381 PM ORA$AT_SA_SPC_SY_15523 SUCCEEDED 0 auto space advisor 5/15/2013 10:00:02.732581 PM ORA$AT_SA_SPC_SY_15520 SUCCEEDED 0 ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error ORA-12012: error on auto execute of job "SYS"."ORA$AT_SA_SPC_SY_15529" ORA-06502: PL/SQL: numeric or value error ORA-06512: at "SYS.DBMS_ADVISOR