Oracle Internal Code Error

-----------------------------

ERROR:

ORA-06553: PLS-801: internal error [56319]

ERROR:

ORA-06553: PLS-801: internal error [56319]

Error accessing package DBMS_APPLICATION_INFO

--------------

shutdown immediate;

startup migrate;

@$ORACLE_HOME/rdbms/admin/utlirp.sql

shutdown immediate;

startup

@$ORACLE_HOME/rdbms/admin/utlrp.sql

connect system/password

execute dbms_stats.delete_database_stats

execute dbms_registry_sys.validate_components

select owner,object_type,count(*) from dba_objects where status='INVALID' group by owner,object_type;

---------------------

SQL> create table ldtest as select * from ldfibs;

create table ldtest as select * from ldfibs

*

ERROR at line 1:

ORA-00600: internal error code, arguments: [15735], [2160], [2152], [], [], [], [],

SQL>

SQL> alter system set parallel_execution_message_size = 4096 scope=spfile;

-----------------------

oracle operation table size details could not be determined

--------------------

ORA-25153: Temporary Tablespace is Empty

1)

CREATE TEMPORARY TABLESPACE temp2

TEMPFILE 'E:\SNSD1011\TEMP02.ORA' SIZE 5M REUSE

AUTOEXTEND ON NEXT 1M MAXSIZE unlimited

EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

2)

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp2;

3)

DROP TABLESPACE temporary INCLUDING CONTENTS AND DATAFILES;

4)

cREATE TEMPORARY TABLESPACE temporary

TEMPFILE 'E:\SNSD1011\TEMP01.ORA' SIZE 500M REUSE

AUTOEXTEND ON NEXT 100M MAXSIZE unlimited

EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

5)

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temporary;

6)

DROP TABLESPACE temp2 INCLUDING CONTENTS AND DATAFILES;

7)

SELECT tablespace_name, file_name, bytes

FROM dba_temp_files WHERE tablespace_name = 'temporary';

--------------

SQL> EXEC dbms_stats.gather_schema_stats('LDBO',cascade=>TRUE);

BEGIN dbms_stats.gather_schema_stats('LDBO',cascade=>TRUE); END;

*

ERROR at line 1:

ORA-00600: internal error code, arguments: [qernsRowP], [1], [], [], [], [],

[], []

-----------------

Connectivity error: [Microsoft][ODBC driver for Oracle][Oracle]

ORA-01578: ORACLE data block corrupted (file # 1, block # 16382) ORA-01110: data file 1: 'D:\LMSD0304\SYSTEM01.ORA'

select * from V$DATABASE_BLOCK_CORRUPTION;

SELECT SEGMENT_TYPE,OWNER||'.'||SEGMENT_NAME

FROM DBA_EXTENTS

WHERE FILE_ID = 1 AND 16382 BETWEEN BLOCK_ID

AND BLOCK_ID+BLOCKS -1;

analyze table SYS.IDL_UB1$ validate structure;

BEGIN

DBMS_REPAIR.ADMIN_TABLES

(

TABLE_NAME => 'IDL_UB1$',

TABLE_TYPE => DBMS_REPAIR.REPAIR_TABLE,

ACTION => DBMS_REPAIR.CREATE_ACTION,

TABLESPACE => 'SYSTEM'

);

END;

/