ORA-00375: unable to get default db_block_size

Cause : the system was unable to determine the default db_block_size

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

see accompanying system specific error. As a workaround, specify the blocksize in the INIT.ORA file.

update : 20-09-2017
ORA-00375

ORA-00375 - unable to get default db_block_size
ORA-00375 - unable to get default db_block_size

  • ora-24330 : internal OCI error
  • ora-19108 : WHITESPACE keyword expected
  • ora-28519 : no heterogeneous data dictionary translations available
  • ora-19726 : cannot plug data [string] at level string into database running at compatibility level string
  • ora-04062 : %s of string has been changed
  • ora-16646 : Fast-Start Failover is disabled
  • ora-30978 : The XML Index is not locally partitioned.
  • ora-09718 : osnsui: cannot set up user interrupt handler.
  • ora-10567 : Redo is inconsistent with data block (file# string, block# string)
  • ora-02855 : Number of requests is less than the number of slaves
  • ora-13356 : adjacent points in a geometry are redundant
  • ora-01108 : file string is in backup or media recovery
  • ora-19764 : database id string does not match database id string in control file
  • ora-01782 : UNRECOVERABLE cannot be specified for a cluster or clustered table
  • ora-16186 : Modifying LOG_ARCHIVE_CONFIG requires SID='*' qualifier
  • ora-24090 : at least one protocol must be enabled
  • ora-09967 : unable to create or open lock file
  • ora-12618 : TNS:versions are incompatible
  • ora-26055 : Invalid buffer specified for direct path unload
  • ora-01596 : cannot specify system in string parameter
  • ora-36404 : (XSSPROP04) Property string cannot be applied to an undimensioned (scalar) TEMPORARY variable.
  • ora-14135 : a LOB column cannot serve as a partitioning column
  • ora-39162 : Transportable tablespace job require privileges
  • ora-02843 : Invalid value for kernel flag
  • ora-15092 : I/O request size string is not a multiple of logical block size string
  • ora-13643 : The task can not be interrupted or cancelled.
  • ora-39212 : installation error: XSL stylesheets not loaded correctly
  • ora-31413 : change set string is currently being advanced
  • ora-01323 : Invalid state
  • ora-23387 : replication parallel push dequeue error
  • 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.