ORA-17509: Attempt to do i/o beyond block1 offset

Cause : When a file is identified with logical block size of 0, only i/o's to block1 is allowed.

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

check additional error messages and call Oracle Support Services

update : 25-04-2017
ORA-17509

ORA-17509 - Attempt to do i/o beyond block1 offset
ORA-17509 - Attempt to do i/o beyond block1 offset

  • ora-40213 : contradictory values for settings: string, string
  • ora-00318 : log string of thread string, expected file size string doesn't match string
  • ora-13231 : failed to create index table [string] during R-tree creation
  • ora-24334 : no descriptor for this position
  • ora-13610 : The directive string does not exist for task string.
  • ora-10930 : trace name context forever
  • ora-14135 : a LOB column cannot serve as a partitioning column
  • ora-14400 : inserted partition key does not map to any partition
  • ora-19237 : XP0017 - unable to resolve call to function - string:string
  • ora-27480 : window "string" is currently open
  • ora-16412 : ONDEMAND archival requires active SQL apply operation
  • ora-02752 : osnfsmmap: illegal shared memory address
  • ora-39086 : cannot retrieve job information
  • ora-24029 : operation not allowed on a single-consumer queue
  • ora-19608 : %s is not a backup piece
  • ora-32814 : propagation schedule string does not exist
  • ora-15001 : diskgroup "string" does not exist or is not mounted
  • ora-13359 : extent does not have an area
  • ora-02258 : duplicate or conflicting NULL and/or NOT NULL specifications
  • ora-19018 : Invalid character in XML tag 'string'
  • ora-07407 : slbtpd: invalid exponent.
  • ora-36710 : (XSMXALLOC01) TARGETLOG variable workspace object must be dimensioned identically to TARGET variable workspace object.
  • ora-06439 : ssaio: the asynchronous write returned incorrect number of bytes
  • ora-29880 : such column list already indexed using another domain index and indextype
  • ora-24073 : cannot specify RETENTION_TIME on exception queue string.string
  • ora-01556 : MINEXTENTS for rollback segment must be greater than 1
  • ora-01295 : DB_ID mismatch between dictionary string and logfiles
  • ora-24438 : Invalid Authentication Handle specified.
  • ora-07590 : spdde: $DELPRC failure
  • ora-16040 : standby destination archive log file is locked
  • 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.