Oracle Error ORA-00058: DB_BLOCK_SIZE must be num to mount this database not num

Oracle Error Message

ORA-00057: maximum number of temporary table locks exceeded

Reason for the Error

You attempted to start a database whose initialization file DB BLOCK SIZE parameter value did not match the value used when the database was created.

Solution

There are few options to fix this error.

  • Check that you’re mounting the right database.
  • Check that you’re using the right initialization file.
  • In the initialization file, you may need to change the DB BLOCK SIZE parameter.