4 Replies Latest reply: Oct 1, 2013 4:51 AM by Yogesh_Nigal RSS

    Not able to Drop user because of data dictionary discripency

    Yogesh_Nigal

      Hi,

      i am using oracle 11.2.0.1 EE installed on Linux 5.8.

       

      i am trying to delete a user but am getting below error.

       

      SQL> DROP USER GKGT CASCADE;

      DROP USER GKGT CASCADE

      *

      ERROR at line 1:

      ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [],[], [], [], [], []

       

      All the objects in the schema have got dropped after executing the command, but the data dictionary dba_objects and user_objects is not cleared still some reference is found in it as shown below.

       

       

      SQL> SELECT object_id,substr(OBJECT_name,1,20),object_type FROM dba_OBJECTS where owner like 'GKGT'

      order by object_name;

       

      OBJECT_ID SUBSTR(OBJECT_NAME,1 OBJECT_TYPE

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

          136772 T_DEVICE             TABLE

          136776 T_DEVICELOG          TABLE PARTITION

          136775 T_DEVICELOG          TABLE PARTITION

          136774 T_DEVICELOG          TABLE

          136710 T_DIRECTION          TABLE

          136728 T_EMPLOYEE           TABLE

          136720 T_EXEMPTEDTYPE       TABLE

          136726 T_FARE               TABLE

          136724 T_FAREROUTE          TABLE

          136718 T_JOURNEYTYPE        TABLE

          149385 T_PASSISSUE          TABLE PARTITION

       

      OBJECT_ID SUBSTR(OBJECT_NAME,1 OBJECT_TYPE

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

          149387 T_PASSISSUE          TABLE PARTITION

          149389 T_PASSISSUE          TABLE PARTITION

          149391 T_PASSISSUE          TABLE PARTITION

          149393 T_PASSISSUE          TABLE PARTITION

          149395 T_PASSISSUE          TABLE PARTITION

          149397 T_PASSISSUE          TABLE PARTITION

          149257 T_PASSISSUE          TABLE PARTITION

          149259 T_PASSISSUE          TABLE PARTITION

          149261 T_PASSISSUE          TABLE PARTITION

          149263 T_PASSISSUE          TABLE PARTITION

          149265 T_PASSISSUE          TABLE PARTITION

       

      OBJECT_ID SUBSTR(OBJECT_NAME,1 OBJECT_TYPE

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

          149267 T_PASSISSUE          TABLE PARTITION

          149269 T_PASSISSUE          TABLE PARTITION

          149271 T_PASSISSUE          TABLE PARTITION

          149273 T_PASSISSUE          TABLE PARTITION

          149275 T_PASSISSUE          TABLE PARTITION

          149277 T_PASSISSUE          TABLE PARTITION

          149279 T_PASSISSUE          TABLE PARTITION

          149281 T_PASSISSUE          TABLE PARTITION

          149283 T_PASSISSUE          TABLE PARTITION

          149285 T_PASSISSUE          TABLE PARTITION

          149287 T_PASSISSUE          TABLE PARTITION

       

      OBJECT_ID SUBSTR(OBJECT_NAME,1 OBJECT_TYPE

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

          149289 T_PASSISSUE          TABLE PARTITION

          149291 T_PASSISSUE          TABLE PARTITION

          149293 T_PASSISSUE          TABLE PARTITION

          149295 T_PASSISSUE          TABLE PARTITION

          149297 T_PASSISSUE          TABLE PARTITION

          149299 T_PASSISSUE          TABLE PARTITION

          149301 T_PASSISSUE          TABLE PARTITION

          149303 T_PASSISSUE          TABLE PARTITION

          149305 T_PASSISSUE          TABLE PARTITION

          149307 T_PASSISSUE          TABLE PARTITION

          149309 T_PASSISSUE          TABLE PARTITION

       

      OBJECT_ID SUBSTR(OBJECT_NAME,1 OBJECT_TYPE

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

          149311 T_PASSISSUE          TABLE PARTITION

          149313 T_PASSISSUE          TABLE PARTITION

          149315 T_PASSISSUE          TABLE PARTITION

          149317 T_PASSISSUE          TABLE PARTITION

          149319 T_PASSISSUE          TABLE PARTITION

          149321 T_PASSISSUE          TABLE PARTITION

          149323 T_PASSISSUE          TABLE PARTITION

          149325 T_PASSISSUE          TABLE PARTITION

          149327 T_PASSISSUE          TABLE PARTITION

          149329 T_PASSISSUE          TABLE PARTITION

          149331 T_PASSISSUE          TABLE PARTITION

       

      OBJECT_ID SUBSTR(OBJECT_NAME,1 OBJECT_TYPE

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

          149333 T_PASSISSUE          TABLE PARTITION

          149335 T_PASSISSUE          TABLE PARTITION

          149337 T_PASSISSUE          TABLE PARTITION

          149339 T_PASSISSUE          TABLE PARTITION

          149341 T_PASSISSUE          TABLE PARTITION

          149343 T_PASSISSUE          TABLE PARTITION

          149345 T_PASSISSUE          TABLE PARTITION

          149347 T_PASSISSUE          TABLE PARTITION

          149349 T_PASSISSUE          TABLE PARTITION

          149351 T_PASSISSUE          TABLE PARTITION

          149353 T_PASSISSUE          TABLE PARTITION

       

      OBJECT_ID SUBSTR(OBJECT_NAME,1 OBJECT_TYPE

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

          149355 T_PASSISSUE          TABLE PARTITION

          149357 T_PASSISSUE          TABLE PARTITION

          149359 T_PASSISSUE          TABLE PARTITION

          149361 T_PASSISSUE          TABLE PARTITION

          149363 T_PASSISSUE          TABLE PARTITION

          149365 T_PASSISSUE          TABLE PARTITION

          149367 T_PASSISSUE          TABLE PARTITION

          149369 T_PASSISSUE          TABLE PARTITION

          149371 T_PASSISSUE          TABLE PARTITION

          149373 T_PASSISSUE          TABLE PARTITION

          149375 T_PASSISSUE          TABLE PARTITION

       

      OBJECT_ID SUBSTR(OBJECT_NAME,1 OBJECT_TYPE

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

          149377 T_PASSISSUE          TABLE PARTITION

          149379 T_PASSISSUE          TABLE PARTITION

          149381 T_PASSISSUE          TABLE PARTITION

          149383 T_PASSISSUE          TABLE PARTITION

          136734 T_PASSISSUE          TABLE PARTITION

          136733 T_PASSISSUE          TABLE PARTITION

          136732 T_PASSISSUE          TABLE

          149149 T_PASSISSUE          TABLE PARTITION

          149151 T_PASSISSUE          TABLE PARTITION

          149153 T_PASSISSUE          TABLE PARTITION

          149155 T_PASSISSUE          TABLE PARTITION

       

      OBJECT_ID SUBSTR(OBJECT_NAME,1 OBJECT_TYPE

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

          149157 T_PASSISSUE          TABLE PARTITION

          149159 T_PASSISSUE          TABLE PARTITION

          149161 T_PASSISSUE          TABLE PARTITION

          149163 T_PASSISSUE          TABLE PARTITION

          149165 T_PASSISSUE          TABLE PARTITION

          149167 T_PASSISSUE          TABLE PARTITION

          149169 T_PASSISSUE          TABLE PARTITION

          149171 T_PASSISSUE          TABLE PARTITION

          149173 T_PASSISSUE          TABLE PARTITION

          149175 T_PASSISSUE          TABLE PARTITION

          149177 T_PASSISSUE          TABLE PARTITION

       

      OBJECT_ID SUBSTR(OBJECT_NAME,1 OBJECT_TYPE

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

          149179 T_PASSISSUE          TABLE PARTITION

          149181 T_PASSISSUE          TABLE PARTITION

          149183 T_PASSISSUE          TABLE PARTITION

          149185 T_PASSISSUE          TABLE PARTITION

          149187 T_PASSISSUE          TABLE PARTITION

          149189 T_PASSISSUE          TABLE PARTITION

          149191 T_PASSISSUE          TABLE PARTITION

          149193 T_PASSISSUE          TABLE PARTITION

          149195 T_PASSISSUE          TABLE PARTITION

          149197 T_PASSISSUE          TABLE PARTITION

          149199 T_PASSISSUE          TABLE PARTITION

       

      OBJECT_ID SUBSTR(OBJECT_NAME,1 OBJECT_TYPE

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

          149201 T_PASSISSUE          TABLE PARTITION

          149203 T_PASSISSUE          TABLE PARTITION

          149205 T_PASSISSUE          TABLE PARTITION

          149207 T_PASSISSUE          TABLE PARTITION

          149209 T_PASSISSUE          TABLE PARTITION

          149211 T_PASSISSUE          TABLE PARTITION

          149213 T_PASSISSUE          TABLE PARTITION

          149215 T_PASSISSUE          TABLE PARTITION

          149217 T_PASSISSUE          TABLE PARTITION

          149219 T_PASSISSUE          TABLE PARTITION

          149221 T_PASSISSUE          TABLE PARTITION

       

      OBJECT_ID SUBSTR(OBJECT_NAME,1 OBJECT_TYPE

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

          149223 T_PASSISSUE          TABLE PARTITION

          149225 T_PASSISSUE          TABLE PARTITION

          149227 T_PASSISSUE          TABLE PARTITION

          149229 T_PASSISSUE          TABLE PARTITION

          149231 T_PASSISSUE          TABLE PARTITION

          149233 T_PASSISSUE          TABLE PARTITION

          149235 T_PASSISSUE          TABLE PARTITION

          149237 T_PASSISSUE          TABLE PARTITION

          149239 T_PASSISSUE          TABLE PARTITION

          149241 T_PASSISSUE          TABLE PARTITION

          149243 T_PASSISSUE          TABLE PARTITION

       

      OBJECT_ID SUBSTR(OBJECT_NAME,1 OBJECT_TYPE

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

          149245 T_PASSISSUE          TABLE PARTITION

          149247 T_PASSISSUE          TABLE PARTITION

          149249 T_PASSISSUE          TABLE PARTITION

          149251 T_PASSISSUE          TABLE PARTITION

          149253 T_PASSISSUE          TABLE PARTITION

          149255 T_PASSISSUE          TABLE PARTITION

          136736 T_PASSISSUE_HISTORY  TABLE

          136743 T_PASSRECHARGE       TABLE PARTITION

          136744 T_PASSRECHARGE       TABLE PARTITION

          136742 T_PASSRECHARGE       TABLE

          136739 T_PASSRETURN         TABLE PARTITION

       

      OBJECT_ID SUBSTR(OBJECT_NAME,1 OBJECT_TYPE

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

          136740 T_PASSRETURN         TABLE PARTITION

          136738 T_PASSRETURN         TABLE

          136716 T_PAYMENTMETHOD      TABLE

          136714 T_SHIFT              TABLE

          136784 T_SHIFTDAYREVENUE    TABLE PARTITION

          148765 T_SHIFTDAYREVENUE    TABLE PARTITION

          148701 T_SHIFTDAYREVENUE    TABLE PARTITION

          148703 T_SHIFTDAYREVENUE    TABLE PARTITION

          148705 T_SHIFTDAYREVENUE    TABLE PARTITION

          148707 T_SHIFTDAYREVENUE    TABLE PARTITION

          148709 T_SHIFTDAYREVENUE    TABLE PARTITION

       

      OBJECT_ID SUBSTR(OBJECT_NAME,1 OBJECT_TYPE

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

          148711 T_SHIFTDAYREVENUE    TABLE PARTITION

          148713 T_SHIFTDAYREVENUE    TABLE PARTITION

          148715 T_SHIFTDAYREVENUE    TABLE PARTITION

          148717 T_SHIFTDAYREVENUE    TABLE PARTITION

          148719 T_SHIFTDAYREVENUE    TABLE PARTITION

          148721 T_SHIFTDAYREVENUE    TABLE PARTITION

          148723 T_SHIFTDAYREVENUE    TABLE PARTITION

          148725 T_SHIFTDAYREVENUE    TABLE PARTITION

          148727 T_SHIFTDAYREVENUE    TABLE PARTITION

          148729 T_SHIFTDAYREVENUE    TABLE PARTITION

          148731 T_SHIFTDAYREVENUE    TABLE PARTITION

       

      OBJECT_ID SUBSTR(OBJECT_NAME,1 OBJECT_TYPE

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

          148733 T_SHIFTDAYREVENUE    TABLE PARTITION

          148735 T_SHIFTDAYREVENUE    TABLE PARTITION

          148737 T_SHIFTDAYREVENUE    TABLE PARTITION

          148739 T_SHIFTDAYREVENUE    TABLE PARTITION

          148741 T_SHIFTDAYREVENUE    TABLE PARTITION

          148743 T_SHIFTDAYREVENUE    TABLE PARTITION

          148745 T_SHIFTDAYREVENUE    TABLE PARTITION

          148747 T_SHIFTDAYREVENUE    TABLE PARTITION

          148749 T_SHIFTDAYREVENUE    TABLE PARTITION

          148751 T_SHIFTDAYREVENUE    TABLE PARTITION

          148753 T_SHIFTDAYREVENUE    TABLE PARTITION

       

      OBJECT_ID SUBSTR(OBJECT_NAME,1 OBJECT_TYPE

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

          148755 T_SHIFTDAYREVENUE    TABLE PARTITION

          148757 T_SHIFTDAYREVENUE    TABLE PARTITION

          148759 T_SHIFTDAYREVENUE    TABLE PARTITION

          148761 T_SHIFTDAYREVENUE    TABLE PARTITION

          148763 T_SHIFTDAYREVENUE    TABLE PARTITION

          148699 T_SHIFTDAYREVENUE    TABLE PARTITION

          148819 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148821 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148823 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148825 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148827 T_SHIFTDAYREVENUE_DE TABLE PARTITION

       

      OBJECT_ID SUBSTR(OBJECT_NAME,1 OBJECT_TYPE

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

          148829 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148831 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148833 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148835 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148837 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148839 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148841 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148843 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148845 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148847 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148849 T_SHIFTDAYREVENUE_DE TABLE PARTITION

       

      OBJECT_ID SUBSTR(OBJECT_NAME,1 OBJECT_TYPE

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

          148851 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148853 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148855 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148857 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148859 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148861 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148863 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148865 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148867 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148869 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148871 T_SHIFTDAYREVENUE_DE TABLE PARTITION

       

      OBJECT_ID SUBSTR(OBJECT_NAME,1 OBJECT_TYPE

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

          148873 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148875 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148877 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148879 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148881 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148883 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148885 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148887 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148889 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148891 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148893 T_SHIFTDAYREVENUE_DE TABLE PARTITION

       

      OBJECT_ID SUBSTR(OBJECT_NAME,1 OBJECT_TYPE

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

          148895 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148897 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148899 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148901 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148903 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148905 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148907 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148909 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148911 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148913 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148915 T_SHIFTDAYREVENUE_DE TABLE PARTITION

       

      OBJECT_ID SUBSTR(OBJECT_NAME,1 OBJECT_TYPE

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

          148767 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148769 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148771 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148773 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148775 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148777 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148779 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148781 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148783 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148785 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148787 T_SHIFTDAYREVENUE_DE TABLE PARTITION

       

      OBJECT_ID SUBSTR(OBJECT_NAME,1 OBJECT_TYPE

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

          148789 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148791 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148793 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148795 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148797 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148799 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148801 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148803 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148805 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148807 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148809 T_SHIFTDAYREVENUE_DE TABLE PARTITION

       

      OBJECT_ID SUBSTR(OBJECT_NAME,1 OBJECT_TYPE

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

          148811 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148813 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148815 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          148817 T_SHIFTDAYREVENUE_DE TABLE PARTITION

          140326 T_SHIFTDAYSUMMARYREV TABLE PARTITION

          140325 T_SHIFTDAYSUMMARYREV TABLE PARTITION

          140324 T_SHIFTDAYSUMMARYREV TABLE

          136780 T_SHIFTDAYTRAFFIC    TABLE PARTITION

          136779 T_SHIFTDAYTRAFFIC    TABLE PARTITION

          136778 T_SHIFTDAYTRAFFIC    TABLE

          136712 T_TERMINAL           TABLE

       

      OBJECT_ID SUBSTR(OBJECT_NAME,1 OBJECT_TYPE

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

          136708 T_TOLLPLAZA          TABLE

          136747 T_TRANSACTION        TABLE PARTITION

          136748 T_TRANSACTION        TABLE PARTITION

          136746 T_TRANSACTION        TABLE

          136722 T_VEHICLECLASS       TABLE

          136730 T_VEHICLEOWNER       TABLE

       

      270 rows selected.

       

      SQL> desc gkgt.t_vehicleclass;

      ERROR:

      ORA-04043: object gkgt.t_vehicleclass does not exist

       

      SQL> select index_name from dba_indexes where owner='GKGT';

       

      no rows selected

       

      SQL> select TABLE_NAME from dba_TAB_PARTITIONS where TABLE_owner='GKGT';

       

      no rows selected

       

      SQL>

       

      After executing hout and hckeck.full scripts got following output.

       

      H.Check Version 9i+/hc3.50

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

      Catalog Version 11.2.0.1.0 (1102000100)

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

       

                                         Catalog       Fixed

      Procedure Name                     Version    Vs Release      Run

      ------------------------------ ... ---------- -- ----------   ---

      .- SynLastDDLTim               ... 1102000100 >  1001000200 : n/a

      .- LobNotInObj                 ... 1102000100 >  1000000200 : n/a

      .- MissingOIDOnObjCol          ... 1102000100 <=  *All Rel* : Ok

      .- SourceNotInObj              ... 1102000100 >  1002000100 : n/a

      .- IndIndparMismatch           ... 1102000100 <= 1102000100 : Ok

      .- InvCorrAudit                ... 1102000100 <= 1102000100 : Ok

      .- OversizedFiles              ... 1102000100 <=  *All Rel* : Ok

      .- TinyFiles                   ... 1102000100 >   900010000 : n/a

      .- PoorDefaultStorage          ... 1102000100 <=  *All Rel* : Ok

      .- PoorStorage                 ... 1102000100 <=  *All Rel* : Ok

      .- MissTabSubPart              ... 1102000100 >   900010000 : n/a

      .- PartSubPartMismatch         ... 1102000100 <= 1102000100 : Ok

      .- TabPartCountMismatch        ... 1102000100 <=  *All Rel* : Ok

      .- OrphanedTabComPart          ... 1102000100 >   900010000 : n/a

      .- ZeroTabSubPart              ... 1102000100 >   902000100 : n/a

      .- MissingSum$                 ... 1102000100 <=  *All Rel* : Ok

      .- MissingDir$                 ... 1102000100 <=  *All Rel* : Ok

      .- DuplicateDataobj            ... 1102000100 <=  *All Rel* : Ok

      .- ObjSynMissing               ... 1102000100 <=  *All Rel* : Ok

      .- ObjSeqMissing               ... 1102000100 <=  *All Rel* : Ok

      .- OrphanedUndo                ... 1102000100 <=  *All Rel* : Ok

      .- OrphanedIndex               ... 1102000100 <=  *All Rel* : Ok

       

      HCKE-0016: Orphaned IND$ (no SEG$)

      ORPHAN IND$: OBJ=188456 DOBJ=188456 TS=41 RFILE/BLOCK=46 30481 BO#=136746

      SegType=

       

      .- OrphanedIndexPartition      ... 1102000100 <=  *All Rel* : Ok

      .- OrphanedIndexSubPartition   ... 1102000100 <=  *All Rel* : Ok

      .- OrphanedTable               ... 1102000100 <=  *All Rel* : Ok

      .- OrphanedTablePartition      ... 1102000100 <=  *All Rel* : Ok

      .- OrphanedTableSubPartition   ... 1102000100 <=  *All Rel* : Ok

      .- MissingPartCol              ... 1102000100 <=  *All Rel* : Ok

      .- OrphanedSeg$                ... 1102000100 <=  *All Rel* : Ok

      .- OrphanedIndPartObj#         ... 1102000100 >  1101000600 : n/a

      .- DuplicateBlockUse           ... 1102000100 <=  *All Rel* : Ok

      .- HighObjectIds               ... 1102000100 >   801060000 : n/a

      .- PQsequence                  ... 1102000100 >   800060000 : n/a

      .- TruncatedCluster            ... 1102000100 >   801070000 : n/a

      .- FetUet                      ... 1102000100 <=  *All Rel* : Ok

      .- Uet0Check                   ... 1102000100 <=  *All Rel* : Ok

      .- ExtentlessSeg               ... 1102000100 <=  *All Rel* : Ok

      .- SeglessUET                  ... 1102000100 <=  *All Rel* : Ok

      .- BadInd$                     ... 1102000100 <=  *All Rel* : Ok

       

      HCKE-0030: OBJ$ INDEX entry has no IND$ entry

      INDEX has no IND$ entry: Obj=154022 GKGT.SYS_IL0000154016C00004$$

      INDEX has no IND$ entry: Obj=154020 GKGT.SYS_IL0000154016C00003$$

      INDEX has no IND$ entry: Obj=154018 GKGT.SYS_IL0000154016C00002$$

      INDEX has no IND$ entry: Obj=139421 GKGT.T_VERIFIEDSHIFTDAYEXEMPTED_PK

      INDEX has no IND$ entry: Obj=139363 GKGT.T_VERIFIEDSHIFTDAYSUMMARY_PK

      INDEX has no IND$ entry: Obj=139392 GKGT.T_VERIFIEDSHIFTDAYREVENUE_PK

      INDEX has no IND$ entry: Obj=136719 GKGT.T_JOURNEYTYPE_PK

      INDEX has no IND$ entry: Obj=139276 GKGT.T_HARDCODE_UK1

      INDEX has no IND$ entry: Obj=139274 GKGT.T_HARDCODEGROUP_UK1

      INDEX has no IND$ entry: Obj=139273 GKGT.T_HARDCODEGROUP_PK

      INDEX has no IND$ entry: Obj=136727 GKGT.T_FARE_PK

      INDEX has no IND$ entry: Obj=136725 GKGT.T_FAREROUTE_PK

       

      .- BadTab$                     ... 1102000100 <=  *All Rel* : Ok

       

      HCKE-0031: OBJ$ TABLE entry has no TAB$ entry

      TABLE has no TAB$ entry: Obj=139393 GKGT.T_VERIFIEDSHIFTDAYEXEMPTED

      TABLE has no TAB$ entry: Obj=139335 GKGT.T_VERIFIEDSHIFTDAYSUMMARY

      TABLE has no TAB$ entry: Obj=139364 GKGT.T_VERIFIEDSHIFTDAYREVENUE

      TABLE has no TAB$ entry: Obj=136718 GKGT.T_JOURNEYTYPE

      TABLE has no TAB$ entry: Obj=139272 GKGT.T_HARDCODEGROUP

      TABLE has no TAB$ entry: Obj=139275 GKGT.T_HARDCODE

      TABLE has no TAB$ entry: Obj=136724 GKGT.T_FAREROUTE

      TABLE has no TAB$ entry: Obj=136726 GKGT.T_FARE

       

      .- BadIcolDepCnt               ... 1102000100 >  1101000700 : n/a

      .- WarnIcolDep                 ... 1102000100 >  1101000700 : n/a

      .- OnlineRebuild$              ... 1102000100 <=  *All Rel* : Ok

      .- DropForceType               ... 1102000100 >  1001000200 : n/a

      .- TrgAfterUpgrade             ... 1102000100 <=  *All Rel* : Ok

      .- FailedInitJVMRun            ... 1102000100 <=  *All Rel* : Ok

      .- TypeReusedAfterDrop         ... 1102000100 >   900010000 : n/a

      .- Idgen1$TTS                  ... 1102000100 >   900010000 : n/a

      .- DroppedFuncIdx              ... 1102000100 >   902000100 : n/a

      .- BadOwner                    ... 1102000100 >   900010000 : n/a

      .- UpgCheckc0801070            ... 1102000100 <=  *All Rel* : Ok

      .- BadPublicObjects            ... 1102000100 <=  *All Rel* : Ok

      .- BadSegFreelist              ... 1102000100 <=  *All Rel* : Ok

      .- BadCol#                     ... 1102000100 >  1001000200 : n/a

      .- BadDepends                  ... 1102000100 <=  *All Rel* : Ok

      .- CheckDual                   ... 1102000100 <=  *All Rel* : Ok

      .- ObjectNames                 ... 1102000100 <=  *All Rel* : Ok

      .- BadCboHiLo                  ... 1102000100 <=  *All Rel* : Ok

      .- ChkIotTs                    ... 1102000100 <=  *All Rel* : Ok

      .- NoSegmentIndex              ... 1102000100 <=  *All Rel* : Ok

      .- BadNextObject               ... 1102000100 <=  *All Rel* : Ok

      .- OrphanIndopt                ... 1102000100 >   902000800 : n/a

      .- UpgFlgBitTmp                ... 1102000100 >  1001000100 : n/a

      .- RenCharView                 ... 1102000100 >  1001000100 : n/a

      .- Upg9iTab$                   ... 1102000100 >   902000400 : n/a

      .- Upg9iTsInd                  ... 1102000100 >   902000500 : n/a

      .- Upg10gInd$                  ... 1102000100 >  1002000000 : n/a

      .- DroppedROTS                 ... 1102000100 <=  *All Rel* : Ok

      .- ChrLenSmtcs                 ... 1102000100 >  1101000600 : n/a

      .- FilBlkZero                  ... 1102000100 <=  *All Rel* : Ok

      .- DbmsSchemaCopy              ... 1102000100 <=  *All Rel* : Ok

       

      Found 21 potential problem(s) and 0 warning(s)

      Contact Oracle Support with the output

      to check if the above needs attention or not

       

      PL/SQL procedure successfully completed.

       

      SQL>

       

      I Tried the following to delete the object from obj$ table but got error.

       

      SQL> SELECT * FROM SYS.DBA_OBJECTS WHERE OBJECT_ID IN (188456);

      no rows selected

       

      SQL> SELECT * FROM SYS.OBJ$ WHERE OBJ# IN (188456);

       

            OBJ#   DATAOBJ#     OWNER# NAME                            NAMESPACE SUBNAME

             TYPE# CTIME     MTIME     STIME         STATUS REMOTEOWNER                    LINKNAME

                 FLAGS OID$                                 SPARE1     SPARE2     SPARE3

      SPARE4

      SPARE5

      SPARE6

      ---------

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

       

          188456     188456        106 T_TRANSACTION_DATETIME                  4

                 1 23-SEP-13 23-SEP-13 23-SEP-13          1

                     0                                           6      65535        106

       

      SQL> CREATE TABLE OBJ$_DEL AS SELECT * FROM OBJ$;

      Table Created

       

      SQL> SELECT * FROM SYS.IND$ WHERE OBJ# IN (188456);

      no rows selected

       

      SQL> DELETE FROM SYS.OBJ$ WHERE OBJ# IN (188456);

      DELETE FROM SYS.OBJ$

                      *

      ERROR at line 1:

      ORA-08102: index key not found, obj# 40, file 1, block 120660 (2)

       

      Below is my Trace file:

       

      Tue Oct 01 10:20:22 2013

      Doing block recovery for file 1 block 84052

      Resuming block recovery (PMON) for file 1 block 84052

      Block recovery from logseq 190, block 248 to scn 1134842195

      Recovery of Online Redo Log: Thread 1 Group 6 Seq 190 Reading mem 0

        Mem# 0: /u01/app/oracle/oradata/oracle11/redo06.log

      Block recovery completed at rba 190.904.16, scn 0.1134842196

      Tue Oct 01 10:20:35 2013

      Sweep [inc][75031]: completed

      Sweep [inc][75022]: completed

      Sweep [inc2][75031]: completed

      Tue Oct 01 10:25:02 2013

      ORA-1 encountered when generating server alert SMG-3000

      Tue Oct 01 10:29:23 2013

      Thread 1 cannot allocate new log, sequence 191

      Private strand flush not complete

        Current log# 6 seq# 190 mem# 0: /u01/app/oracle/oradata/oracle11/redo06.log

      Thread 1 advanced to log sequence 191 (LGWR switch)

        Current log# 3 seq# 191 mem# 0: /u01/app/oracle/oradata/oracle11/redo03.log

      Tue Oct 01 10:31:18 2013

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_12160.trc  (incident=71247):

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x40] [PC:0xF3777EB, kghalf()+49] [flags: 0x0, count: 1]

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_12160.trc  (incident=71248):

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Incident details in: /u01/app/oracle/diag/rdbms/oracle11/oracle11/incident/incdir_71248/oracle11_ora_12160_i71248.trc

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_12160.trc  (incident=71249):

      ORA-00600: internal error code, arguments: [525], [0x692D43C4], [4], [row cache objects], [5], [0x6A3FA06C], [redo copy], [], [], [], [], []

      ORA-00607: Internal error occurred while making a change to a data block

      ORA-00602: internal programming exception

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Incident details in: /u01/app/oracle/diag/rdbms/oracle11/oracle11/incident/incdir_71249/oracle11_ora_12160_i71249.trc

      Tue Oct 01 10:31:21 2013

      Sweep [inc][71248]: completed

      Sweep [inc][71247]: completed

      Sweep [inc2][71248]: completed

      Tue Oct 01 10:31:21 2013

      Trace dumping is performing id=[cdmp_20131001103121]

      Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x40] [PC:0xF3777EB, kghalf()+49] [flags: 0x0, count: 1]

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_12160.trc  (incident=71250):

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [525], [0x692D43C4], [4], [row cache objects], [5], [0x6A3FA06C], [redo copy], [], [], [], [], []

      ORA-00607: Internal error occurred while making a change to a data block

      ORA-00602: internal programming exception

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Incident details in: /u01/app/oracle/diag/rdbms/oracle11/oracle11/incident/incdir_71250/oracle11_ora_12160_i71250.trc

      Trace dumping is performing id=[cdmp_20131001103122]

      Trace dumping is performing id=[cdmp_20131001103123]

      Tue Oct 01 10:32:10 2013

      Doing block recovery for file 1 block 84052

      Resuming block recovery (PMON) for file 1 block 84052

      Block recovery from logseq 191, block 27531 to scn 1134928966

      Recovery of Online Redo Log: Thread 1 Group 3 Seq 191 Reading mem 0

        Mem# 0: /u01/app/oracle/oradata/oracle11/redo03.log

      Block recovery completed at rba 191.28203.16, scn 0.1134928967

      Tue Oct 01 10:32:21 2013

      Sweep [inc][71250]: completed

      Sweep [inc][71249]: completed

      Sweep [inc2][71250]: completed

      Sweep [inc2][71249]: completed

      Tue Oct 01 10:32:40 2013

      Thread 1 cannot allocate new log, sequence 192

      Private strand flush not complete

        Current log# 3 seq# 191 mem# 0: /u01/app/oracle/oradata/oracle11/redo03.log

      Thread 1 advanced to log sequence 192 (LGWR switch)

        Current log# 4 seq# 192 mem# 0: /u01/app/oracle/oradata/oracle11/redo04.log

      Tue Oct 01 10:32:51 2013

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_12280.trc  (incident=74954):

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x40] [PC:0xF3777EB, kghalf()+49] [flags: 0x0, count: 1]

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_12280.trc  (incident=74956):

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_12280.trc  (incident=74963):

      ORA-00600: internal error code, arguments: [525], [0x692D43C4], [4], [row cache objects], [5], [0x6A3FA06C], [redo copy], [], [], [], [], []

      ORA-00607: Internal error occurred while making a change to a data block

      ORA-00602: internal programming exception

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Incident details in: /u01/app/oracle/diag/rdbms/oracle11/oracle11/incident/incdir_74963/oracle11_ora_12280_i74963.trc

      Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x40] [PC:0xF3777EB, kghalf()+49] [flags: 0x0, count: 1]

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_12280.trc  (incident=74971):

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [525], [0x692D43C4], [4], [row cache objects], [5], [0x6A3FA06C], [redo copy], [], [], [], [], []

      ORA-00607: Internal error occurred while making a change to a data block

      ORA-00602: internal programming exception

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Tue Oct 01 10:32:53 2013

      Trace dumping is performing id=[cdmp_20131001103253]

      Tue Oct 01 10:33:02 2013

      Doing block recovery for file 1 block 84052

      Resuming block recovery (PMON) for file 1 block 84052

      Block recovery from logseq 191, block 27531 to scn 1134949406

      Recovery of Online Redo Log: Thread 1 Group 3 Seq 191 Reading mem 0

        Mem# 0: /u01/app/oracle/oradata/oracle11/redo03.log

      Recovery of Online Redo Log: Thread 1 Group 4 Seq 192 Reading mem 0

        Mem# 0: /u01/app/oracle/oradata/oracle11/redo04.log

      Block recovery completed at rba 192.2301.16, scn 0.1134949408

      Tue Oct 01 10:33:21 2013

      Sweep [inc][74971]: completed

      Sweep [inc][74963]: completed

      Sweep [inc][74956]: completed

      Sweep [inc][74954]: completed

      Sweep [inc2][74963]: completed

      Tue Oct 01 10:35:03 2013

      ORA-1 encountered when generating server alert SMG-3000

      Tue Oct 01 10:37:59 2013

      Thread 1 cannot allocate new log, sequence 193

      Private strand flush not complete

        Current log# 4 seq# 192 mem# 0: /u01/app/oracle/oradata/oracle11/redo04.log

      Thread 1 advanced to log sequence 193 (LGWR switch)

        Current log# 5 seq# 193 mem# 0: /u01/app/oracle/oradata/oracle11/redo05.log

      Tue Oct 01 10:41:15 2013

      Thread 1 cannot allocate new log, sequence 194

      Private strand flush not complete

        Current log# 5 seq# 193 mem# 0: /u01/app/oracle/oradata/oracle11/redo05.log

      Thread 1 advanced to log sequence 194 (LGWR switch)

        Current log# 6 seq# 194 mem# 0: /u01/app/oracle/oradata/oracle11/redo06.log

      Tue Oct 01 10:45:03 2013

      ORA-1 encountered when generating server alert SMG-3000

      Tue Oct 01 10:47:12 2013

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_13196.trc  (incident=71231):

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x40] [PC:0xF3777EB, kghalf()+49] [flags: 0x0, count: 1]

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_13196.trc  (incident=71232):

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_13196.trc  (incident=71233):

      ORA-00600: internal error code, arguments: [525], [0x692D43C4], [4], [row cache objects], [5], [0x6A3FA06C], [redo copy], [], [], [], [], []

      ORA-00607: Internal error occurred while making a change to a data block

      ORA-00602: internal programming exception

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Incident details in: /u01/app/oracle/diag/rdbms/oracle11/oracle11/incident/incdir_71233/oracle11_ora_13196_i71233.trc

      Tue Oct 01 10:47:13 2013

      Sweep [inc][71232]: completed

      Sweep [inc][71231]: completed

      Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x40] [PC:0xF3777EB, kghalf()+49] [flags: 0x0, count: 1]

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_13196.trc  (incident=71234):

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [525], [0x692D43C4], [4], [row cache objects], [5], [0x6A3FA06C], [redo copy], [], [], [], [], []

      ORA-00607: Internal error occurred while making a change to a data block

      ORA-00602: internal programming exception

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Tue Oct 01 10:47:15 2013

      Trace dumping is performing id=[cdmp_20131001104715]

      Tue Oct 01 10:48:02 2013

      Doing block recovery for file 1 block 84052

      Resuming block recovery (PMON) for file 1 block 84052

      Block recovery from logseq 194, block 30971 to scn 1135075665

      Recovery of Online Redo Log: Thread 1 Group 6 Seq 194 Reading mem 0

        Mem# 0: /u01/app/oracle/oradata/oracle11/redo06.log

      Block recovery completed at rba 194.31643.16, scn 0.1135075666

      Tue Oct 01 10:48:13 2013

      Sweep [inc][71234]: completed

      Sweep [inc][71233]: completed

      Sweep [inc2][71233]: completed

      Tue Oct 01 10:49:54 2013

      Thread 1 cannot allocate new log, sequence 195

      Private strand flush not complete

        Current log# 6 seq# 194 mem# 0: /u01/app/oracle/oradata/oracle11/redo06.log

      Thread 1 advanced to log sequence 195 (LGWR switch)

        Current log# 3 seq# 195 mem# 0: /u01/app/oracle/oradata/oracle11/redo03.log

      Tue Oct 01 10:52:57 2013

      Thread 1 cannot allocate new log, sequence 196

      Private strand flush not complete

        Current log# 3 seq# 195 mem# 0: /u01/app/oracle/oradata/oracle11/redo03.log

      Thread 1 advanced to log sequence 196 (LGWR switch)

        Current log# 4 seq# 196 mem# 0: /u01/app/oracle/oradata/oracle11/redo04.log

      Tue Oct 01 10:54:30 2013

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_13646.trc  (incident=75015):

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x40] [PC:0xF3777EB, kghalf()+49] [flags: 0x0, count: 1]

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_13646.trc  (incident=75016):

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_13646.trc  (incident=75018):

      ORA-00600: internal error code, arguments: [525], [0x692D43C4], [4], [row cache objects], [5], [0x6A3FA06C], [redo copy], [], [], [], [], []

      ORA-00607: Internal error occurred while making a change to a data block

      ORA-00602: internal programming exception

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Incident details in: /u01/app/oracle/diag/rdbms/oracle11/oracle11/incident/incdir_75018/oracle11_ora_13646_i75018.trc

      Tue Oct 01 10:54:32 2013

      Sweep [inc][75018]: completed

      Sweep [inc][75016]: completed

      Sweep [inc][75015]: completed

      Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x40] [PC:0xF3777EB, kghalf()+49] [flags: 0x0, count: 1]

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_13646.trc  (incident=75027):

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [525], [0x692D43C4], [4], [row cache objects], [5], [0x6A3FA06C], [redo copy], [], [], [], [], []

      ORA-00607: Internal error occurred while making a change to a data block

      ORA-00602: internal programming exception

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Tue Oct 01 10:54:33 2013

      Trace dumping is performing id=[cdmp_20131001105433]

      Tue Oct 01 10:54:56 2013

      Doing block recovery for file 1 block 84052

      Resuming block recovery (PMON) for file 1 block 84052

      Block recovery from logseq 196, block 19635 to scn 1135176010

      Recovery of Online Redo Log: Thread 1 Group 4 Seq 196 Reading mem 0

        Mem# 0: /u01/app/oracle/oradata/oracle11/redo04.log

      Block recovery completed at rba 196.20309.16, scn 0.1135176012

      Tue Oct 01 10:55:04 2013

      ORA-1 encountered when generating server alert SMG-3000

      Tue Oct 01 10:55:32 2013

      Sweep [inc][75027]: completed

      Sweep [inc2][75018]: completed

      Tue Oct 01 10:58:12 2013

      Thread 1 cannot allocate new log, sequence 197

      Private strand flush not complete

        Current log# 4 seq# 196 mem# 0: /u01/app/oracle/oradata/oracle11/redo04.log

      Thread 1 advanced to log sequence 197 (LGWR switch)

        Current log# 5 seq# 197 mem# 0: /u01/app/oracle/oradata/oracle11/redo05.log

      Tue Oct 01 11:00:00 2013

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_j001_14049.trc:

      Tue Oct 01 11:00:01 2013

      Trace dumping is performing id=[cdmp_20131001110001]

      Tue Oct 01 11:01:37 2013

      Thread 1 advanced to log sequence 198 (LGWR switch)

        Current log# 6 seq# 198 mem# 0: /u01/app/oracle/oradata/oracle11/redo06.log

      Tue Oct 01 11:02:00 2013

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_j001_14126.trc:

      Tue Oct 01 11:02:01 2013

      Trace dumping is performing id=[cdmp_20131001110201]

      Tue Oct 01 11:04:46 2013

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_13633.trc:

      Tue Oct 01 11:04:47 2013

      Trace dumping is performing id=[cdmp_20131001110447]

      Tue Oct 01 11:05:06 2013

      ORA-1 encountered when generating server alert SMG-3000

      Tue Oct 01 11:07:47 2013

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_14407.trc  (incident=71235):

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x40] [PC:0xF3777EB, kghalf()+49] [flags: 0x0, count: 1]

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_14407.trc  (incident=71236):

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_14407.trc  (incident=74908):

      ORA-00600: internal error code, arguments: [525], [0x692D43C4], [4], [row cache objects], [5], [0x6A3FA06C], [redo copy], [], [], [], [], []

      ORA-00607: Internal error occurred while making a change to a data block

      ORA-00602: internal programming exception

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x40] [PC:0xF3777EB, kghalf()+49] [flags: 0x0, count: 1]

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_14407.trc  (incident=74975):

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [525], [0x692D43C4], [4], [row cache objects], [5], [0x6A3FA06C], [redo copy], [], [], [], [], []

      ORA-00607: Internal error occurred while making a change to a data block

      ORA-00602: internal programming exception

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Tue Oct 01 11:07:49 2013

      Sweep [inc][74975]: completed

      Sweep [inc][74908]: completed

      Sweep [inc][71236]: completed

      Sweep [inc][71235]: completed

      Tue Oct 01 11:08:02 2013

      Doing block recovery for file 1 block 84052

      Resuming block recovery (PMON) for file 1 block 84052

      Block recovery from logseq 198, block 19645 to scn 1135284382

      Recovery of Online Redo Log: Thread 1 Group 6 Seq 198 Reading mem 0

        Mem# 0: /u01/app/oracle/oradata/oracle11/redo06.log

      Block recovery completed at rba 198.20203.16, scn 0.1135284383

      Tue Oct 01 11:11:34 2013

      Thread 1 cannot allocate new log, sequence 199

      Private strand flush not complete

        Current log# 6 seq# 198 mem# 0: /u01/app/oracle/oradata/oracle11/redo06.log

      Thread 1 advanced to log sequence 199 (LGWR switch)

        Current log# 3 seq# 199 mem# 0: /u01/app/oracle/oradata/oracle11/redo03.log

      Tue Oct 01 11:12:36 2013

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_14851.trc  (incident=75133):

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x40] [PC:0xF3777EB, kghalf()+49] [flags: 0x0, count: 1]

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_14851.trc  (incident=75134):

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_14851.trc  (incident=75135):

      ORA-00600: internal error code, arguments: [525], [0x692D43C4], [4], [row cache objects], [5], [0x6A3FA06C], [redo copy], [], [], [], [], []

      ORA-00607: Internal error occurred while making a change to a data block

      ORA-00602: internal programming exception

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x40] [PC:0xF3777EB, kghalf()+49] [flags: 0x0, count: 1]

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_14851.trc  (incident=75136):

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [525], [0x692D43C4], [4], [row cache objects], [5], [0x6A3FA06C], [redo copy], [], [], [], [], []

      ORA-00607: Internal error occurred while making a change to a data block

      ORA-00602: internal programming exception

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Tue Oct 01 11:12:37 2013

      Sweep [inc][75134]: completed

      Sweep [inc][75133]: completed

      Tue Oct 01 11:12:50 2013

      Doing block recovery for file 1 block 84052

      Resuming block recovery (PMON) for file 1 block 84052

      Block recovery from logseq 198, block 19645 to scn 1135345412

      Recovery of Online Redo Log: Thread 1 Group 6 Seq 198 Reading mem 0

        Mem# 0: /u01/app/oracle/oradata/oracle11/redo06.log

      Recovery of Online Redo Log: Thread 1 Group 3 Seq 199 Reading mem 0

        Mem# 0: /u01/app/oracle/oradata/oracle11/redo03.log

      Block recovery completed at rba 199.13813.16, scn 0.1135345414

      Tue Oct 01 11:13:38 2013

      Sweep [inc][75136]: completed

      Sweep [inc][75135]: completed

      Tue Oct 01 11:14:56 2013

      Thread 1 cannot allocate new log, sequence 200

      Private strand flush not complete

        Current log# 3 seq# 199 mem# 0: /u01/app/oracle/oradata/oracle11/redo03.log

      Thread 1 advanced to log sequence 200 (LGWR switch)

        Current log# 4 seq# 200 mem# 0: /u01/app/oracle/oradata/oracle11/redo04.log

      Tue Oct 01 11:15:07 2013

      ORA-1 encountered when generating server alert SMG-3000

      Tue Oct 01 11:15:19 2013

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_15016.trc  (incident=75141):

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x40] [PC:0xF3777EB, kghalf()+49] [flags: 0x0, count: 1]

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_15016.trc  (incident=75142):

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_15016.trc  (incident=75143):

      ORA-00600: internal error code, arguments: [525], [0x692D43C4], [4], [row cache objects], [5], [0x6A3FA06C], [redo copy], [], [], [], [], []

      ORA-00607: Internal error occurred while making a change to a data block

      ORA-00602: internal programming exception

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x40] [PC:0xF3777EB, kghalf()+49] [flags: 0x0, count: 1]

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_15016.trc  (incident=75144):

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [525], [0x692D43C4], [4], [row cache objects], [5], [0x6A3FA06C], [redo copy], [], [], [], [], []

      ORA-00607: Internal error occurred while making a change to a data block

      ORA-00602: internal programming exception

      ORA-07445: exception encountered: core dump [kghalf()+49] [SIGSEGV] [ADDR:0x40] [PC:0xF3777EB] [Address not mapped to object] []

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Tue Oct 01 11:15:23 2013

      Sweep [inc][75144]: completed

      Sweep [inc][75143]: completed

      Sweep [inc][75142]: completed

      Sweep [inc][75141]: completed

      Tue Oct 01 11:15:41 2013

      Doing block recovery for file 1 block 84052

      Resuming block recovery (PMON) for file 1 block 84052

      Block recovery from logseq 200, block 4531 to scn 1135382144

      Recovery of Online Redo Log: Thread 1 Group 4 Seq 200 Reading mem 0

        Mem# 0: /u01/app/oracle/oradata/oracle11/redo04.log

      Block recovery completed at rba 200.5222.16, scn 0.1135382146

      Tue Oct 01 11:20:10 2013

      Thread 1 cannot allocate new log, sequence 201

      Private strand flush not complete

        Current log# 4 seq# 200 mem# 0: /u01/app/oracle/oradata/oracle11/redo04.log

      Thread 1 advanced to log sequence 201 (LGWR switch)

        Current log# 5 seq# 201 mem# 0: /u01/app/oracle/oradata/oracle11/redo05.log

      Tue Oct 01 11:20:25 2013

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_14883.trc  (incident=71272):

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_14883.trc  (incident=71273):

      ORA-00603: ORACLE server session terminated by fatal error

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Incident details in: /u01/app/oracle/diag/rdbms/oracle11/oracle11/incident/incdir_71273/oracle11_ora_14883_i71273.trc

      opiodr aborting process unknown ospid (14883) as a result of ORA-603

      Tue Oct 01 11:20:27 2013

      Trace dumping is performing id=[cdmp_20131001112027]

      Tue Oct 01 11:20:27 2013

      Sweep [inc][71273]: completed

      Sweep [inc][71272]: completed

      Sweep [inc2][71273]: completed

      Tue Oct 01 11:22:27 2013

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_15448.trc  (incident=74906):

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_15448.trc  (incident=75006):

      ORA-00603: ORACLE server session terminated by fatal error

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Incident details in: /u01/app/oracle/diag/rdbms/oracle11/oracle11/incident/incdir_75006/oracle11_ora_15448_i75006.trc

      opiodr aborting process unknown ospid (15448) as a result of ORA-603

      Tue Oct 01 11:22:29 2013

      Trace dumping is performing id=[cdmp_20131001112229]

      Tue Oct 01 11:22:29 2013

      Sweep [inc][75006]: completed

      Sweep [inc][74906]: completed

      Sweep [inc2][75006]: completed

      Tue Oct 01 11:22:37 2013

      Thread 1 cannot allocate new log, sequence 202

      Private strand flush not complete

        Current log# 5 seq# 201 mem# 0: /u01/app/oracle/oradata/oracle11/redo05.log

      Thread 1 advanced to log sequence 202 (LGWR switch)

        Current log# 6 seq# 202 mem# 0: /u01/app/oracle/oradata/oracle11/redo06.log

      Tue Oct 01 11:23:07 2013

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_15497.trc  (incident=75014):

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_15497.trc  (incident=75025):

      ORA-00603: ORACLE server session terminated by fatal error

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Incident details in: /u01/app/oracle/diag/rdbms/oracle11/oracle11/incident/incdir_75025/oracle11_ora_15497_i75025.trc

      opiodr aborting process unknown ospid (15497) as a result of ORA-603

      Tue Oct 01 11:23:09 2013

      Trace dumping is performing id=[cdmp_20131001112309]

      Tue Oct 01 11:23:29 2013

      Sweep [inc][75025]: completed

      Sweep [inc][75014]: completed

      Sweep [inc2][75025]: completed

      Tue Oct 01 11:24:03 2013

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_15382.trc  (incident=75043):

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_15382.trc  (incident=75050):

      ORA-00603: ORACLE server session terminated by fatal error

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Incident details in: /u01/app/oracle/diag/rdbms/oracle11/oracle11/incident/incdir_75050/oracle11_ora_15382_i75050.trc

      opiodr aborting process unknown ospid (15382) as a result of ORA-603

      Tue Oct 01 11:24:04 2013

      Trace dumping is performing id=[cdmp_20131001112404]

      Tue Oct 01 11:24:29 2013

      Sweep [inc][75050]: completed

      Sweep [inc][75043]: completed

      Sweep [inc2][75050]: completed

      Tue Oct 01 11:25:08 2013

      ORA-1 encountered when generating server alert SMG-3000

      Tue Oct 01 11:26:14 2013

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_15733.trc  (incident=71274):

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_15733.trc  (incident=71275):

      ORA-00603: ORACLE server session terminated by fatal error

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Incident details in: /u01/app/oracle/diag/rdbms/oracle11/oracle11/incident/incdir_71275/oracle11_ora_15733_i71275.trc

      opiodr aborting process unknown ospid (15733) as a result of ORA-603

      Tue Oct 01 11:26:16 2013

      Trace dumping is performing id=[cdmp_20131001112616]

      Tue Oct 01 11:26:17 2013

      Sweep [inc][71275]: completed

      Sweep [inc][71274]: completed

      Sweep [inc2][71275]: completed

      Tue Oct 01 11:29:14 2013

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_15621.trc  (incident=75076):

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_15621.trc  (incident=75078):

      ORA-00603: ORACLE server session terminated by fatal error

      ORA-00600: internal error code, arguments: [4097], [10], [20], [7021372], [], [], [], [], [], [], [], []

      opiodr aborting process unknown ospid (15621) as a result of ORA-603

      Tue Oct 01 11:29:15 2013

      Sweep [inc][75078]: completed

      Sweep [inc][75076]: completed

      Tue Oct 01 11:32:01 2013

      Thread 1 cannot allocate new log, sequence 203

      Private strand flush not complete

        Current log# 6 seq# 202 mem# 0: /u01/app/oracle/oradata/oracle11/redo06.log

      Thread 1 advanced to log sequence 203 (LGWR switch)

        Current log# 3 seq# 203 mem# 0: /u01/app/oracle/oradata/oracle11/redo03.log

      Tue Oct 01 11:35:09 2013

      ORA-1 encountered when generating server alert SMG-3000

      Tue Oct 01 11:35:10 2013

      Thread 1 cannot allocate new log, sequence 204

      Private strand flush not complete

        Current log# 3 seq# 203 mem# 0: /u01/app/oracle/oradata/oracle11/redo03.log

      Thread 1 advanced to log sequence 204 (LGWR switch)

        Current log# 4 seq# 204 mem# 0: /u01/app/oracle/oradata/oracle11/redo04.log

      Tue Oct 01 11:40:25 2013

      Thread 1 cannot allocate new log, sequence 205

      Private strand flush not complete

        Current log# 4 seq# 204 mem# 0: /u01/app/oracle/oradata/oracle11/redo04.log

      Thread 1 advanced to log sequence 205 (LGWR switch)

        Current log# 5 seq# 205 mem# 0: /u01/app/oracle/oradata/oracle11/redo05.log

      Tue Oct 01 11:43:41 2013

      Thread 1 advanced to log sequence 206 (LGWR switch)

        Current log# 6 seq# 206 mem# 0: /u01/app/oracle/oradata/oracle11/redo06.log

      Tue Oct 01 11:45:10 2013

      ORA-1 encountered when generating server alert SMG-3000

      Tue Oct 01 11:53:37 2013

      Thread 1 cannot allocate new log, sequence 207

      Private strand flush not complete

        Current log# 6 seq# 206 mem# 0: /u01/app/oracle/oradata/oracle11/redo06.log

      Thread 1 advanced to log sequence 207 (LGWR switch)

        Current log# 3 seq# 207 mem# 0: /u01/app/oracle/oradata/oracle11/redo03.log

      Tue Oct 01 11:55:11 2013

      ORA-1 encountered when generating server alert SMG-3000

      Tue Oct 01 11:57:06 2013

      Thread 1 cannot allocate new log, sequence 208

      Private strand flush not complete

        Current log# 3 seq# 207 mem# 0: /u01/app/oracle/oradata/oracle11/redo03.log

      Thread 1 advanced to log sequence 208 (LGWR switch)

        Current log# 4 seq# 208 mem# 0: /u01/app/oracle/oradata/oracle11/redo04.log

      Tue Oct 01 12:00:06 2013

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_j001_17866.trc:

      Tue Oct 01 12:00:08 2013

      Trace dumping is performing id=[cdmp_20131001120008]

      Tue Oct 01 12:02:06 2013

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_j001_17965.trc:

      Tue Oct 01 12:02:07 2013

      Trace dumping is performing id=[cdmp_20131001120207]

      Tue Oct 01 12:02:17 2013

      Thread 1 cannot allocate new log, sequence 209

      Private strand flush not complete

        Current log# 4 seq# 208 mem# 0: /u01/app/oracle/oradata/oracle11/redo04.log

      Thread 1 advanced to log sequence 209 (LGWR switch)

        Current log# 5 seq# 209 mem# 0: /u01/app/oracle/oradata/oracle11/redo05.log

      Tue Oct 01 12:04:34 2013

      ALTER DATABASE DATAFILE 39 ONLINE

      ORA-1190 signalled during: ALTER DATABASE DATAFILE 39 ONLINE...

      Tue Oct 01 12:05:07 2013

      Thread 1 cannot allocate new log, sequence 210

      Private strand flush not complete

        Current log# 5 seq# 209 mem# 0: /u01/app/oracle/oradata/oracle11/redo05.log

      Thread 1 advanced to log sequence 210 (LGWR switch)

        Current log# 6 seq# 210 mem# 0: /u01/app/oracle/oradata/oracle11/redo06.log

      Tue Oct 01 12:05:13 2013

      ORA-1 encountered when generating server alert SMG-3000

      Tue Oct 01 12:14:29 2013

      Thread 1 cannot allocate new log, sequence 211

      Private strand flush not complete

        Current log# 6 seq# 210 mem# 0: /u01/app/oracle/oradata/oracle11/redo06.log

      Thread 1 advanced to log sequence 211 (LGWR switch)

        Current log# 3 seq# 211 mem# 0: /u01/app/oracle/oradata/oracle11/redo03.log

      Tue Oct 01 12:15:13 2013

      ORA-1 encountered when generating server alert SMG-3000

      Tue Oct 01 12:17:35 2013

      Thread 1 cannot allocate new log, sequence 212

      Private strand flush not complete

        Current log# 3 seq# 211 mem# 0: /u01/app/oracle/oradata/oracle11/redo03.log

      Thread 1 advanced to log sequence 212 (LGWR switch)

        Current log# 4 seq# 212 mem# 0: /u01/app/oracle/oradata/oracle11/redo04.log

      Tue Oct 01 12:22:51 2013

      Thread 1 cannot allocate new log, sequence 213

      Private strand flush not complete

        Current log# 4 seq# 212 mem# 0: /u01/app/oracle/oradata/oracle11/redo04.log

      Thread 1 advanced to log sequence 213 (LGWR switch)

        Current log# 5 seq# 213 mem# 0: /u01/app/oracle/oradata/oracle11/redo05.log

      Tue Oct 01 12:25:14 2013

      ORA-1 encountered when generating server alert SMG-3000

      Tue Oct 01 12:25:30 2013

      Thread 1 cannot allocate new log, sequence 214

      Private strand flush not complete

        Current log# 5 seq# 213 mem# 0: /u01/app/oracle/oradata/oracle11/redo05.log

      Thread 1 advanced to log sequence 214 (LGWR switch)

        Current log# 6 seq# 214 mem# 0: /u01/app/oracle/oradata/oracle11/redo06.log

      Tue Oct 01 12:25:53 2013

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_19062.trc  (incident=75008):

      ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []

      Incident details in: /u01/app/oracle/diag/rdbms/oracle11/oracle11/incident/incdir_75008/oracle11_ora_19062_i75008.trc

      Tue Oct 01 12:25:55 2013

      Trace dumping is performing id=[cdmp_20131001122555]

      Tue Oct 01 12:25:55 2013

      Sweep [inc][75008]: completed

      Sweep [inc2][75008]: completed

      Tue Oct 01 12:35:15 2013

      ORA-1 encountered when generating server alert SMG-3000

      Tue Oct 01 12:35:36 2013

      Thread 1 cannot allocate new log, sequence 215

      Private strand flush not complete

        Current log# 6 seq# 214 mem# 0: /u01/app/oracle/oradata/oracle11/redo06.log

      Thread 1 advanced to log sequence 215 (LGWR switch)

        Current log# 3 seq# 215 mem# 0: /u01/app/oracle/oradata/oracle11/redo03.log

      Tue Oct 01 12:38:46 2013

      Thread 1 cannot allocate new log, sequence 216

      Private strand flush not complete

        Current log# 3 seq# 215 mem# 0: /u01/app/oracle/oradata/oracle11/redo03.log

      Thread 1 advanced to log sequence 216 (LGWR switch)

        Current log# 4 seq# 216 mem# 0: /u01/app/oracle/oradata/oracle11/redo04.log

      Tue Oct 01 12:43:57 2013

      Thread 1 advanced to log sequence 217 (LGWR switch)

        Current log# 5 seq# 217 mem# 0: /u01/app/oracle/oradata/oracle11/redo05.log

      Tue Oct 01 12:45:16 2013

      ORA-1 encountered when generating server alert SMG-3000

      Tue Oct 01 12:46:54 2013

      Thread 1 advanced to log sequence 218 (LGWR switch)

        Current log# 6 seq# 218 mem# 0: /u01/app/oracle/oradata/oracle11/redo06.log

      Tue Oct 01 12:55:17 2013

      ORA-1 encountered when generating server alert SMG-3000

      Tue Oct 01 12:56:12 2013

      Thread 1 cannot allocate new log, sequence 219

      Private strand flush not complete

        Current log# 6 seq# 218 mem# 0: /u01/app/oracle/oradata/oracle11/redo06.log

      Thread 1 advanced to log sequence 219 (LGWR switch)

        Current log# 3 seq# 219 mem# 0: /u01/app/oracle/oradata/oracle11/redo03.log

      Tue Oct 01 12:59:43 2013

      Thread 1 cannot allocate new log, sequence 220

      Private strand flush not complete

        Current log# 3 seq# 219 mem# 0: /u01/app/oracle/oradata/oracle11/redo03.log

      Thread 1 advanced to log sequence 220 (LGWR switch)

        Current log# 4 seq# 220 mem# 0: /u01/app/oracle/oradata/oracle11/redo04.log

      Tue Oct 01 13:00:14 2013

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_j001_21812.trc:

      Tue Oct 01 13:00:15 2013

      Trace dumping is performing id=[cdmp_20131001130015]

      Tue Oct 01 13:02:14 2013

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_j001_21917.trc:

      Tue Oct 01 13:02:15 2013

      Trace dumping is performing id=[cdmp_20131001130215]

      Tue Oct 01 13:04:54 2013

      Thread 1 cannot allocate new log, sequence 221

      Private strand flush not complete

        Current log# 4 seq# 220 mem# 0: /u01/app/oracle/oradata/oracle11/redo04.log

      Thread 1 advanced to log sequence 221 (LGWR switch)

        Current log# 5 seq# 221 mem# 0: /u01/app/oracle/oradata/oracle11/redo05.log

      Tue Oct 01 13:05:18 2013

      ORA-1 encountered when generating server alert SMG-3000

      Tue Oct 01 13:07:33 2013

      Thread 1 cannot allocate new log, sequence 222

      Private strand flush not complete

        Current log# 5 seq# 221 mem# 0: /u01/app/oracle/oradata/oracle11/redo05.log

      Thread 1 advanced to log sequence 222 (LGWR switch)

        Current log# 6 seq# 222 mem# 0: /u01/app/oracle/oradata/oracle11/redo06.log

      Tue Oct 01 13:14:26 2013

      Errors in file /u01/app/oracle/diag/rdbms/oracle11/oracle11/trace/oracle11_ora_22210.trc  (incident=75033):

      ORA-00600: internal error code, arguments: [13013], [5001], [175662], [8484451], [3], [8484451], [17], [], [], [], [], []

      Incident details in: /u01/app/oracle/diag/rdbms/oracle11/oracle11/incident/incdir_75033/oracle11_ora_22210_i75033.trc

      Tue Oct 01 13:14:27 2013

      Trace dumping is performing id=[cdmp_20131001131427]

      Tue Oct 01 13:14:29 2013

      Sweep [inc][75033]: completed

      Sweep [inc2][75033]: completed

      Tue Oct 01 13:15:19 2013

      ORA-1 encountered when generating server alert SMG-3000

      Tue Oct 01 13:17:09 2013

      Thread 1 cannot allocate new log, sequence 223

      Private strand flush not complete

        Current log# 6 seq# 222 mem# 0: /u01/app/oracle/oradata/oracle11/redo06.log

      Thread 1 advanced to log sequence 223 (LGWR switch)

        Current log# 3 seq# 223 mem# 0: /u01/app/oracle/oradata/oracle11/redo03.log

      Tue Oct 01 13:20:30 2013

      Thread 1 cannot allocate new log, sequence 224

      Private strand flush not complete

        Current log# 3 seq# 223 mem# 0: /u01/app/oracle/oradata/oracle11/redo03.log

      Thread 1 advanced to log sequence 224 (LGWR switch)

        Current log# 4 seq# 224 mem# 0: /u01/app/oracle/oradata/oracle11/redo04.log

      Tue Oct 01 13:25:20 2013

      ORA-1 encountered when generating server alert SMG-3000

      Tue Oct 01 13:25:41 2013

      Thread 1 cannot allocate new log, sequence 225

      Private strand flush not complete

        Current log# 4 seq# 224 mem# 0: /u01/app/oracle/oradata/oracle11/redo04.log

      Thread 1 advanced to log sequence 225 (LGWR switch)

        Current log# 5 seq# 225 mem# 0: /u01/app/oracle/oradata/oracle11/redo05.log

      Tue Oct 01 13:28:45 2013

      Thread 1 cannot allocate new log, sequence 226

      Private strand flush not complete

        Current log# 5 seq# 225 mem# 0: /u01/app/oracle/oradata/oracle11/redo05.log

      Thread 1 advanced to log sequence 226 (LGWR switch)

        Current log# 6 seq# 226 mem# 0: /u01/app/oracle/oradata/oracle11/redo06.log

      Tue Oct 01 13:35:21 2013

      ORA-1 encountered when generating server alert SMG-3000

      Tue Oct 01 13:38:27 2013

      Thread 1 cannot allocate new log, sequence 227

      Private strand flush not complete

        Current log# 6 seq# 226 mem# 0: /u01/app/oracle/oradata/oracle11/redo06.log

      Thread 1 advanced to log sequence 227 (LGWR switch)

        Current log# 3 seq# 227 mem# 0: /u01/app/oracle/oradata/oracle11/redo03.log

      Tue Oct 01 13:41:46 2013

      Thread 1 cannot allocate new log, sequence 228

      Private strand flush not complete

        Current log# 3 seq# 227 mem# 0: /u01/app/oracle/oradata/oracle11/redo03.log

      Thread 1 advanced to log sequence 228 (LGWR switch)

        Current log# 4 seq# 228 mem# 0: /u01/app/oracle/oradata/oracle11/redo04.log

      Tue Oct 01 13:45:22 2013

      ORA-1 encountered when generating server alert SMG-3000

      Tue Oct 01 13:46:54 2013

      Thread 1 cannot allocate new log, sequence 229

      Private strand flush not complete

        Current log# 4 seq# 228 mem# 0: /u01/app/oracle/oradata/oracle11/redo04.log

      Thread 1 advanced to log sequence 229 (LGWR switch)

        Current log# 5 seq# 229 mem# 0: /u01/app/oracle/oradata/oracle11/redo05.log

      Tue Oct 01 13:49:55 2013

      Thread 1 cannot allocate new log, sequence 230

      Private strand flush not complete

        Current log# 5 seq# 229 mem# 0: /u01/app/oracle/oradata/oracle11/redo05.log

      Thread 1 advanced to log sequence 230 (LGWR switch)

        Current log# 6 seq# 230 mem# 0: /u01/app/oracle/oradata/oracle11/redo06.log

      Tue Oct 01 13:55:23 2013

      ORA-1 encountered when generating server alert SMG-3000

       

       

       

      Need help to clear the data dictionary discripency and drop the user.