OraFAQ Forum: Server Administration » Database not opening,error "Block Size small"

Home » RDBMS Server » Server Administration » Database not opening,error "Block Size small"

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database not opening,error "Block Size small" [message #260293]

Sat, 18 August 2007 02:46

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

Report message to a moderator

Re: Database not opening,error "Block Size small" [message #260294 is a reply to message #260293]

Sat, 18 August 2007 03:01

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?

Report message to a moderator

Re: Database not opening,error "Block Size small" [message #260299 is a reply to message #260293]

Sat, 18 August 2007 04:03

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: Database not opening,error "Block Size small" [message #260452 is a reply to message #260294]

Mon, 20 August 2007 00:36

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

Report message to a moderator

Re: Database not opening,error "Block Size small" [message #260457 is a reply to message #260452]

Mon, 20 August 2007 00:53

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: Database not opening,error "Block Size small" [message #260847 is a reply to message #260457]

Tue, 21 August 2007 02:04

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

Report message to a moderator

Re: Database not opening,error "Block Size small" [message #260862 is a reply to message #260293]

Tue, 21 August 2007 02:42

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.

Report message to a moderator

Re: Database not opening,error "Block Size small" [message #260864 is a reply to message #260293]

Tue, 21 August 2007 02:46

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.

Report message to a moderator

Re: Database not opening,error "Block Size small" [message #261030 is a reply to message #260864]

Tue, 21 August 2007 09:45

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.

Report message to a moderator

Re: Database not opening,error "Block Size small" [message #261060 is a reply to message #260847]

Tue, 21 August 2007 12:37

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

Report message to a moderator

Previous Topic:	db_cache_size
Next Topic:	07_dictionary_accessibility

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 08:30:31 CDT 2024