ORA-00058: DB_BLOCK_SIZE must be 8192 to mount this database (not 4096)

ORA-00058: DB_BLOCK_SIZE must be 8192 to mount this database (not 4096)

Error
ORA-00058: DB_BLOCK_SIZE must be 8192 to mount this database (not 4096)

SQL> startup pfile='C:\init.ora';
ORACLE instance started.

Total System Global Area 1610609744 bytes
Fixed Size 9028688 bytes
Variable Size 1207959552 bytes
Database Buffers 385875968 bytes
Redo Buffers 7745536 bytes
ORA-00058: DB_BLOCK_SIZE must be 8192 to mount this database (not 4096)

Cause:
May be used some different PFILE to up the database which DB_BLOCK_SIZE is not match with my control files.

Solution:
1. You can check the correct the PFILE and SPFILE is present.

2. You can check the alert log file where you get all parameter value. you can create new PFILE from alert log file.

3. You can edit this PFILE with block size as mentioned in error and try start again.

DB_BLOCK_SIZE=8192

4. May you mount the wrong database check the database.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.