{1 - 24} GreyGrey
{25 - 49} GreenGreen
{50 - 499} BlueBlue
{500 - 4999} OrangeOrange
{5000 - 24999} RedRed
{25000+} BlackBlack

Please confirm that you would like to report this for an admin to review.


Oracle: ORA-00020 ORA-20011 ORA-29913 ORA-29400

Oracle Consultant needs help regarding

“ORA-00020 ORA-20011 ORA-29913 ORA-29400″





I am getting below error.

ORA-00020: maximum number of processes 500 exceeded
ORA-20 errors will not be written to the alert log for
 the next minute. Please look at trace files to see all
 the ORA-20 errors.

I thought are so many connection established on the data, but user are claiming that non of them were connected to database.

I did below command which gives number of number of users

select username
,      sid || ',' || serial# "ID"
,      status
,      last_call_et "Last Activity"
from   v$  session
where  username is not null
order by status desc
,        last_call_et desc
/ 

I see only 51 users.

I went to see database log, here is what I found.

Fatal NI connect error 12170.
 
  VERSION INFORMATION:
        TNS for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
        TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
        Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
  Time: 07-NOV-2012 14:39:56
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12535
 
TNS-12535: TNS:operation timed out
    ns secondary err code: 12560
    nt main err code: 505
 
TNS-00505: Operation timed out
    nt secondary err code: 78
    nt OS err code: 0
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.212.23.81)(PORT=2729))
Wed Nov 07 21:33:57 2012
Starting background process CJQ0
Wed Nov 07 21:33:58 2012
CJQ0 started with pid=452, OS id=4391936
Wed Nov 07 22:00:00 2012
Setting Resource Manager plan SCHEDULER[0x2DBEE]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Wed Nov 07 22:00:00 2012
Starting background process VKRM
Wed Nov 07 22:00:00 2012
VKRM started with pid=469, OS id=27526278
Wed Nov 07 22:00:11 2012
Begin automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
Wed Nov 07 22:00:34 2012
DBMS_STATS: GATHER_STATS_JOB encountered errors.  Check the trace file.
Errors in file /opt/oracle/diag/rdbms/ztklink/ZTKLINK/trace/ZTKLINK_j000_22610708.trc:
ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "single-quoted-string": expecting one of: "double-quoted-string"
KUP-01007: at line 1 column 34

I am not sure what this error is, and this what I saw in trace file

*** 2012-11-07 22:00:34.204
*** SESSION ID:(674.1333) 2012-11-07 22:00:34.206
*** CLIENT ID:() 2012-11-07 22:00:34.206
*** SERVICE NAME:(SYS$  USERS) 2012-11-07 22:00:34.206
*** MODULE NAME:(DBMS_SCHEDULER) 2012-11-07 22:00:34.206
*** ACTION NAME:(ORA$  AT_OS_OPT_SY_8544) 2012-11-07 22:00:34.206
 
ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "single-quoted-string": expecting one of: "double-quoted-string"
KUP-01007: at line 1 column 34
 
*** 2012-11-07 22:00:34.238
DBMS_STATS: GATHER_STATS_JOB: GATHER_TABLE_STATS('"SYSTEM"','"ET$  020F01040001"','""', ...)
DBMS_STATS: ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "single-quoted-string": expecting one of: "double-quoted-string"
KUP-01007: at line 1 column 34
 
*** 2012-11-07 22:00:34.459
DBMS_STATS: GATHER_STATS_JOB: GATHER_TABLE_STATS('"SYSTEM"','"ET$  020606440001"','""', ...)
DBMS_STATS: ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "single-quoted-string": expecting one of: "double-quoted-string"
KUP-01007: at line 1 column 34

*There is a constant trouble with this error. Users are complaining they are not able to connect to database. *

How can I get rid of this error. Any suggestion is greatly appreciated. Thanks.

Version

<div class="jive-quote">select * from v$  version</div>
BANNER                                                                           
-------------------------------------------------------------------------------- 
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production     
PL/SQL Release 11.2.0.2.0 - Production                                           
CORE	11.2.0.2.0	Production                                                         
TNS for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production                
NLSRTL Version 11.2.0.2.0 - Production



What do you suggest for

ORA-00020 ORA-20011 ORA-29913 ORA-29400

Kindly answer!

Oracle Discussion Forums : Thread List – Oracle Database



Confirm that you would like to Remove Email Alerts for your question. You cant undo this and you will not be able to re-subscribe.


Tags

No Answers

You must be Logged In to Answer this Question

Already a Member, Log In
Not a member yet? Sign Up

Categories

Sponsors


oracle forum