[#QA-29] ORA-600 [2845] while selecting, Invalid ROWID.

Questions & Answers

ORA-600 [2845] while selecting, Invalid ROWID.

Created: 15/Jul/07 06:09 PM Updated: 16/Sep/07 04:24 PM

Fix Version/s:

None

Product Version:	7.3.4.5.0
Operating System:	TRU64

Description

« Hide

ORA-600 [2845] while selecting, Invalid ROWID.

All

Comments

Change History

Sort Order:

Ascending order - Click to sort in descending order

[ Permlink | « Hide ]

ubTools Support - 15/Jul/07 06:14 PM

Error code:

ORA-00600: internal error code, arguments: [2845], [0], [30], [0], [], [], [], []

Error code definition:

Oracle is reading a range of blocks from a database file.
If the starting block number or file number is 0, or the file number is  greater than can be accommodated in
the SGA (DB_FILES), error ORA-600 [2845] is raised.

Ref: Metalink Note: 31057.1 ORA-600 [2845] "Read of bad DBA Requested"

Cursor dump:

********************   Cursor Dump   ************************
Current cursor: 30, pgadep: 0
  pgactx: 14a415b8 ctxcbk: 0 ctxqbc: 14a41990 qbcrws: 14a40ef0
Cursor Dump:
----------------------------------------
...
----------------------------------------
Cursor 30 (1400ea8e0): CURFETCH  curiob: 14019be40
curflg: 46 curpar: 0 curusr: c curses 8a2f38
cursor name: SELECT "NOTE" FROM "MEDIX"."PAT_SES" WHERE "ROWID"=:1
child pin: 5485b30, child lock: 54f2960, parent lock: 54c5f68
xscflg: 80110676, parent handle: 14a46070
 nxt: 3.0x00000018  nxt: 2.0x000007d8  nxt: 1.0x000004e0
Cursor frame allocation dump:
frm: -------- Comment --------  Size  Seg Off
bind 0: dty=1 mxl=32(18) mal=00 scl=00 pre=00 oacflg=01
  bfp=140192748 bln=18 avl=18 flg=05
  value="00000000.0000.0000"
----------------------------------------
...

Problem explanation:

As seen in the cursor dump above, the current cursor number is 30. The cursor#30 has a bind variable using a ROWID. But, the value of this bind variable is "00000000.0000.0000". In Oracle7, this ROWID points to block#0, slot#0, file#0. This is wrong.

Recommendation:

Check application against any possible wrong ROWID usage.
Call Oracle Support.