Home » RDBMS Server » Server Administration » Database not opening,error "Block Size small"
Database not opening,error "Block Size small" [message #260293] Sat, 18 August 2007 02:46 Go to next message
jaswinderjassi
Messages: 3
Registered: August 2007
Location: India
Junior Member

Facing problems ,database not opening.Whenever tried to open database ,message displayed block size is not sufficient, small block size.

How can I increase the database size.....
Please
Re: Database not opening,error "Block Size small" [message #260294 is a reply to message #260293] Sat, 18 August 2007 03:01 Go to previous messageGo to next message
NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad
Member
Check the db_block_size parameter in the init.ora file. If you are using Oracle 10g the default value is 8192. Set the parameter accordingly. In 9i (for windows) the default is 2048. What is your oracle version and platform?
Re: Database not opening,error "Block Size small" [message #260299 is a reply to message #260293] Sat, 18 August 2007 04:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Copy and paste the error message, and more the whole SQL*Plus session.

Post your Oracle version (4 decimals).

Regards
Michel
Re: Database not opening,error "Block Size small" [message #260452 is a reply to message #260294] Mon, 20 August 2007 00:36 Go to previous messageGo to next message
jaswinderjassi
Messages: 3
Registered: August 2007
Location: India
Junior Member

I m using Oracle 9i & platform is XP.
How can I set the block size & what value should I set ?

Jaswinder
Re: Database not opening,error "Block Size small" [message #260457 is a reply to message #260452] Mon, 20 August 2007 00:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Sat, 18 August 2007 11:03
Copy and paste the error message, and more the whole SQL*Plus session.

Post your Oracle version (4 decimals).

Regards
Michel


Re: Database not opening,error "Block Size small" [message #260847 is a reply to message #260457] Tue, 21 August 2007 02:04 Go to previous messageGo to next message
jaswinderjassi
Messages: 3
Registered: August 2007
Location: India
Junior Member

Following are the errors I am facing:


ERROR:
ORA-01033: ORACLE initialization or shutdown in progress


ERROR at line 1:
ORA-01122: database file 2 failed verification check
ORA-01110: data file 2: 'E:\ORACLE\ORADATA\BDS\UNDOTBS01.DBF'
ORA-01200: actual file size of 282880 is smaller than correct size of 285440
blocks



Regards

Jass
Re: Database not opening,error "Block Size small" [message #260862 is a reply to message #260293] Tue, 21 August 2007 02:42 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

The error is not related at all with block size that you specified at first.
Creating a new control file can fix this problem.
Re: Database not opening,error "Block Size small" [message #260864 is a reply to message #260293] Tue, 21 August 2007 02:46 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Before doing this please crosscheck the init.ora file and see you have the correct controlfile destination specified in the initialization parameter.
Re: Database not opening,error "Block Size small" [message #261030 is a reply to message #260864] Tue, 21 August 2007 09:45 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
ORA-01122:	database file string failed verification check
Cause:	The information in this file is inconsistent with information from the control file.
 See accompanying message for reason.
Action:	Make certain that the db files and control files are the correct files for this database.
Re: Database not opening,error "Block Size small" [message #261060 is a reply to message #260847] Tue, 21 August 2007 12:37 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
ORA-01200: actual file size of 282880 is smaller than correct size of 285440

As arju said create new control file WITH SIZE CLUASE

Eg:
1 CREATE CONTROLFILE REUSE DATABASE "db01" NORESETLOGS NOARCHIVELOG
2 MAXLOGFILES 16
3 MAXLOGMEMBERS 3
4 MAXDATAFILES 100
5 MAXINSTANCES 8
6 MAXLOGHISTORY 7271
7 LOGFILE
8 GROUP 1 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\db01\REDO01.LOG' SIZE 10M,
9 GROUP 2 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\db01\REDO02.LOG' SIZE 10M,
10 GROUP 3 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\db01\REDO03.LOG' SIZE 10M
11 -- STANDBY LOGFILE
12 DATAFILE
13 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\db01\SYSTEM01.DBF' SIZE 600M,
14 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\db01\UNDOTBS01.DBF' SIZE 65M,
15 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\db01\SYSAUX01.DBF' SIZE 330M,
16 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\db01\USERS01.DBF' SIZE 185600K,
17 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\db01\EXAMPLE01.DBF' SIZE 150M
18* CHARACTER SET WE8MSWIN1252



Note: Size is Datafile Size or Redolog file size.

Create New temporary tablespace
Make it default database temp tbs
drop old temp tbs

Regards
Taj


Previous Topic: db_cache_size
Next Topic: 07_dictionary_accessibility
Goto Forum:
  


Current Time: Sat Dec 10 03:00:21 CST 2016

Total time taken to generate the page: 0.08701 seconds