ORA-02822: Invalid block offset

Cause : A server was unable to seek to the designated block.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Check the UNIX error number.

update : 24-08-2017

ORA-02822 - Invalid block offset
ORA-02822 - Invalid block offset

  • ora-12423 : invalid position specified
  • ora-27214 : skgfrsfe: file search failed
  • ora-38795 : warning: FLASHBACK succeeded but OPEN RESETLOGS would get error below
  • ora-12509 : TNS:listener failed to redirect client to service handler
  • ora-06560 : pos, string, is negative or larger than the buffer size, string
  • ora-30025 : DROP segment 'string' (in undo tablespace) not allowed
  • ora-09882 : sstasfre/sstasdel: shmctl error, unable to remove tas shm page
  • ora-32139 : Cannot write to the stream
  • ora-31497 : invalid value specified for first_scn
  • ora-33074 : (XSAGDNGL36) In AGGMAP workspace object, the offset number is not a valid offset into dimension workspace object.
  • ora-36223 : (XSLPDSC04) object workspace object in IGNORE or DENSE list has illegal type
  • ora-23400 : invalid materialized view name "string"
  • ora-28116 : insufficient privileges to do direct path access
  • ora-28165 : proxy 'string' may not specify password-protected role 'string' for client 'string'
  • ora-19015 : Invalid XML tag identifier (string)
  • ora-13361 : not enough sub-elements within a compound ETYPE
  • ora-23388 : replication parallel push watermark error
  • ora-30356 : the specified refresh method is not supported in this context
  • ora-26670 : STREAMS option requires COMPATIBLE parameter to be string or higher
  • ora-24902 : invalid subscription name or name-length in subscription handle
  • ora-02199 : missing DATAFILE/TEMPFILE clause
  • ora-09857 : smprset: vm_protect error while protecting pga.
  • ora-01327 : failed to exclusively lock system dictionary as required by build
  • ora-39160 : error on whats my name call
  • ora-00101 : invalid specification for system parameter DISPATCHERS
  • ora-13125 : partition key is already set
  • ora-08431 : raw data missing zero as defined in picture
  • ora-00088 : command cannot be executed by shared server
  • ora-28665 : table and partition must have same compression attribute
  • ora-16786 : resource guard cannot access Data Guard broker metadata
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.