Ora-00600 internal error code arguments 13011

ora-00600 internal error code arguments 13011

ORA is the generic code for unhandled internal Oracle exceptions i.e. bugs. The correct approach to dealing with such errors is to contact. Hi,. Sometimes you can get “ORA value is out of range ” error during create a spatial index. Details of error are as follows. Cause: A. ORA internal error code, arguments: [], [pp/oracle/product//dbhome_1/dbs/arch1_1_dbff.

Related Videos

resolving ora 10458 01195 01110 errors

Ora-00600 internal error code arguments 13011 - with you

ORA [] when delete from MGMT_SYSTEM_PERFORMANCE_LOG table

My Oracle Support Banner

Last updated on JULY 06,

Applies to:

Oracle Database - Standard Edition - Version and later
Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

  • DML Delete on MGMT_SYSTEM_PERFORMANCE_LOG returns and slow performance reported:

ORA internal error code, arguments: [], [], [], [3], [], [0], [], [], [], [], [], []

  • Current SQL Statement for this session (sql_id=11pz8hkfms)

DELETE MGMT_SYSTEM_PERFORMANCE_LOG WHERE TIME < :B2 AND ROWNUM <= :B1
PL/SQL Stack
PL/SQL Call Stack
object line object
handle number name
0xd0 package body sprers.eu_LOADER
0xd0 package body sprers.eu_LOADER
0xda30 package body sprers.eu_MAINTENANCE
0x91ae0 1 anonymous block

  • Call Stack Trace

    delexe opiexe opipls opiodr

  • 'analyze' on the above table my fail to indicate a corruption.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document



Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit sprers.eu
� Oracle

ORA internal error code, arguments: [], [], []

Error in Alert log file:

This format relates to Oracle Server to
Arg [a] Passcount
Arg [b] Data Object number
Arg [c] Tablespace Relative DBA of block containing the row to be updated
Arg [d] Row Slot number
Arg [e] Relative DBA of block being updated (should be same as [c])
Arg [f] Code


Check the object id with following error:

OBJECT_NAME OBJECT_TYPE OWNER MGMT_SYSTEM_PERFORMANCE_LOG TABLE SYSMAN


Analyse the table

Check the data file

SQL>  Select name from v$datafile where rfile#=2;
NAME

C:\APP\ADMINISTRATOR\ORADATA\ITIMDB\SYSAUXDBF

Verify the corruption with database verify utility DBV

Find the index related to tables:

Rebuild index online:

After rebuild indexes the error is finished.

Like this:

LikeLoading

Related

This entry was posted in Oracle and tagged corruption error, Error in alert log, ORA on by SandeepSingh DBA.

About SandeepSingh DBA

Hi, I am working in IT industry with having more than 10 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

View all posts by SandeepSingh DBA →

Alert Log Shows ORA [] and ORA[kewrose_1] (Doc ID )

DELETE statement shown in the trace log is causing the ORAs:

delete from <table_name> tab where (:beg_snap <= sprers.eu_id and sprers.eu_id <= :end_snap and dbid = :dbid) and
not exists (select 1 from <table1> b where (sprers.eu = sprers.eu) and (sprers.eu_id >= sprers.eu_snap_id) and (sprers.eu_id <= sprers.eu_snap_id))

ORA internal error code, arguments: [kewrose_1], [], [ORA internal error code, arguments: [], [], [], [26], [], [0], [], [], [], [], [], []

Main Stack:
OCIKSIN <- kewrose_oci_stmt_exec <- kewrgwxf1_gwrsql_exft_1
<- kewrgwxf_gwrsql_exft <- kewrpsn_purge_snapshot <- kewrpdc_periodic_cleanup
<- kewrsnrm_snapshot_removal <- kewrpsr_purge_snapshot_range
<- kewrapad_auto_purge_all_dbids <- kewraps_auto_purge_slave <- kebm_slave_main
<- ksvrdp <- opirip <- opidrv <- sou2o <- opimai_real <- opimai <- BackgroundThreadStart

ORA internal error code, arguments: [], [], [], [26], [], [0], [], [], [], [], [], []

Main Stack:
delexe <- opiexe <- kpoal8 <- opiodr <- kpoodrc <- rpiswu2 <- kpoodr <- xupirtrc <- upirtrc
<- kpurcsc <- kpuexec <- OCIStmtExecute <- kewrose_oci_stmt_exec
<- kewrgwxf1_gwrsql_exft_1 <- kewrgwxf_gwrsql_exft <- kewrpsn_purge_snapshot
<- kewrpdc_periodic_cleanup <- kewrsnrm_snapshot_removal
<- kewrpsr_purge_snapshot_range <- kewrapad_auto_purge_all_dbids
<- kewraps_auto_purge_slave <- kebm_slave_main <- ksvrdp <- opirip <- opidrv <- sou2o
<- opimai_real <- opimai <- BackgroundThreadStart

 
Legal Notices
drop procedure sprers.eu_mvmfrm;

drop materialized view sprers.eu_rkmfrm;


Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\rakshak\rakshak\trace\rakshak_ora_trc  (incident=):
ORA ORACLE server session terminated by fatal error
ORA internal error code, arguments: [], [], [], [], [], [17], [], [], [], [], [], []
Incident details in: D:\APP\ADMINISTRATOR\diag\rdbms\rakshak\rakshak\incident\incdir_\rakshak_ora__itrc
Tue Jun 16
Dumping diagnostic data in directory=[cdmp_], requested by (instance=1, osid=), summary=[incident=].
opiodr aborting process unknown ospid () as a result of ORA
Tue Jun 16
Sweep [inc][]: completed
Sweep [inc2][]: completed
Tue Jun 16
SMON: Parallel transaction recovery tried
Tue Jun 16




ORA [], [], [], [], [], [17], [], [], [], [], [], []


Tue Jun 16
Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\rakshak\rakshak\trace\rakshak_j_trc:
ORA internal error code, arguments: [], [], [], [], [], [17], [], [], [], [], [], []
ORA at "sprers.eu_SNAPSHOT", line
ORA at "sprers.eu_SNAPSHOT", line
ORA at "sprers.eu_SNAPSHOT", line
ORA at "sprers.eu_MVCLIENTFOLLOWUP", line 4
ORA at line 1


select object_name,object_type,owner from dba_objects where data_object_id=;


analyze table DEPENDENCY$ validate structure cascade;




SELECT
sprers.eum "SOFTWARE",last_call_et,
       substr(sprers.eu_text, 1, 50) "SQL"
,'alter system disconnect session ''' Facebook

Matchless: Ora-00600 internal error code arguments 13011

Oryol anti terror center
HAIR AND FUR ERROR
ERROR DISTRIBUTION FOR FLOYD-STEINBERG ALGORITHM

ORA internal error code, arguments string  tips

 

 

 

 

Oracle Error Tips by Stephanie F.

 

The Oracle docs note this on the ORA error:

Error: ORA
Text: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s]

Cause: This is the generic internal error number for Oracle program
exceptions. This indicates that a process has encountered an
exceptional condition.
Action: Report as a bug - the first argument is the internal error number 

On the Oracle DBA Forums, a user needs help with ORA, as well as understanding the accompanying arguments.

The replier informed the user that because ORA is an internal error, the Oracle Corporation knows the arguments.  Here are the notes which helped the user resolve ORA

An ORA is an internal error, and only Oracle Corporation knows the agruments.

ALWAYS open a TAR when you get a ora

I check MOSC, and you can see many of the "common" codes there.


******************************************

ORA internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]

Cause: This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition, ora-00600 internal error code arguments 13011. Causes of this message include:

timeouts
file corruption
failed data checks in memory
hardware, memory, or I/O errors
ora-00600 internal error code arguments 13011 restored files
The first argument is the internal message number. Other arguments are various numbers, names, and character strings. The numbers may change meanings between different versions of Oracle.

Action: Report this error to Oracle Support Services after gathering the following information:

events that led up to the error
the operations that were attempted that led to the error
the conditions of the operating system and databases at the time of the error
any unusual circumstances that occurred before receiving the ORA message
contents of any trace files generated by the error
the relevant portions of the Alter files

Note: The cause of this message may manifest itself as different errors at different times. Be aware of the history of errors that occurred before this internal error.


 

 

 

Burleson is the American Team

Note:This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience!Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

ora-00600 internal error code arguments 13011 include the URL for the page.


                    

Copyright © - 

All rights reserved by Burleson

Oracle

® is the registered trademark of Oracle Corporation.

 

sprers.eu

Alert Log Shows ORA [] and ORA[kewrose_1] (Doc ID )

DELETE statement shown in the trace log is causing the ORAs:

delete from <table_name> tab where (:beg_snap <= sprers.eu_id and sprers.eu_id <= :end_snap and dbid = :dbid) and
not exists (select 1 from <table1> b where (sprers.eu = sprers.eu) and (sprers.eu_id >= sprers.eu_snap_id) and (sprers.eu_id <= sprers.eu_snap_id))

ORA internal error code, arguments: [kewrose_1], [], [ORA internal error code, arguments: [], [], [], [26], [], [0], [], [], [], [], [], []

Main Stack:
OCIKSIN <- kewrose_oci_stmt_exec <- kewrgwxf1_gwrsql_exft_1
<- kewrgwxf_gwrsql_exft <- kewrpsn_purge_snapshot <- kewrpdc_periodic_cleanup
<- kewrsnrm_snapshot_removal <- kewrpsr_purge_snapshot_range
<- kewrapad_auto_purge_all_dbids <- kewraps_auto_purge_slave <- kebm_slave_main
<- ksvrdp <- opirip <- opidrv <- sou2o <- opimai_real <- opimai <- BackgroundThreadStart

ORA internal error code, arguments: [], [], [], [26], [], [0], [], [], [], ora-00600 internal error code arguments 13011, [], [], []

Main Stack:
delexe <- opiexe <- kpoal8 <- opiodr <- kpoodrc <- rpiswu2 <- kpoodr <- xupirtrc <- upirtrc
<- kpurcsc <- kpuexec <- OCIStmtExecute <- kewrose_oci_stmt_exec
<- kewrgwxf1_gwrsql_exft_1 <- kewrgwxf_gwrsql_exft <- kewrpsn_purge_snapshot
<- kewrpdc_periodic_cleanup <- kewrsnrm_snapshot_removal
<- kewrpsr_purge_snapshot_range <- kewrapad_auto_purge_all_dbids
<- kewraps_auto_purge_slave <- kebm_slave_main <- ksvrdp <- opirip <- opidrv <- sou2o
<- opimai_real <- opimai <- BackgroundThreadStart

 
Communities

0 Comments

Leave a Comment