OraFAQ Forum: Server Administration » creating database with 8K block size in oracle 9i

Home » RDBMS Server » Server Administration » creating database with 8K block size in oracle 9i - ORA-00058 (Oracle 9i on windows)

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

creating database with 8K block size in oracle 9i - ORA-00058 [message #363262]

Fri, 05 December 2008 10:26

dbanukesh
Messages: 96
Registered: November 2008
Location: London

Member

Hi folks,

I am getting error while creating database with 8k block size in oracle 9i. I am using DBCA for this but after all attempts it seems not working for me. Do anybody have idea why it is failing. Please refer attached screenshot.

Thanks in Advance!
Nukesh

Report message to a moderator

Re: creating database with 8K block size in oracle 9i - ORA-00058 [message #363266 is a reply to message #363262]

Fri, 05 December 2008 10:42

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Which 9i?

ORA-00058: DB_BLOCK_SIZE must be %s to mount this database (not %s)
 *Cause:  DB_BLOCK_SIZE initialization parameter is wrong for the database
          being mounted. It does not match the value used to create the
          database.
 *Action: Fix the value of the DB_BLOCK_SIZE parameter or mount a database
          that matches the value.

Regards
Michel

Report message to a moderator

Re: creating database with 8K block size in oracle 9i - ORA-00058 [message #363267 is a reply to message #363266]

Fri, 05 December 2008 11:03

dbanukesh
Messages: 96
Registered: November 2008
Location: London

Member

Hi Michel,

I am just starting with a fresh installation (9.2.0.1) It works with 4k db block size. but i have to create db with 8k as my old db which i am duplication here is 8k size. while creating db with dbca i just edited 4096 to 8192 and it fails halfway.

Cheers
Nukesh

Report message to a moderator

Re: creating database with 8K block size in oracle 9i - ORA-00058 [message #363268 is a reply to message #363267]

Fri, 05 December 2008 11:14

dbanukesh
Messages: 96
Registered: November 2008
Location: London

Member

Please refer more comprehensive screenshot.

Report message to a moderator

Re: creating database with 8K block size in oracle 9i - ORA-00058 [message #363269 is a reply to message #363268]

Fri, 05 December 2008 11:38

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

A comprehensive screenshot? Tabula raza, I'm afraid.

Report message to a moderator

Re: creating database with 8K block size in oracle 9i - ORA-00058 [message #363271 is a reply to message #363269]

Fri, 05 December 2008 11:44

dbanukesh
Messages: 96
Registered: November 2008
Location: London

Member

I am using orafaq forum first time. i cant find my screenshot in the thread. it has snapshot of the error.

Thanks
Nukesh

Report message to a moderator

Re: creating database with 8K block size in oracle 9i - ORA-00058 [message #363274 is a reply to message #363271]

Fri, 05 December 2008 11:47

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I believe it does. However, we can't see it.

In order to attach a screenshot:

save it as a JPG or PNG file
while writing a message, click the "Choose ..." button, browse in order to find a file
click the "Upload File" button
optionally, choose "Insert image into message body"

Report message to a moderator

Re: creating database with 8K block size in oracle 9i - ORA-00058 [message #363277 is a reply to message #363274]

Fri, 05 December 2008 11:53

dbanukesh
Messages: 96
Registered: November 2008
Location: London

Member

lets see if it is visible,

Attachment: ora-00058error.JPG
(Size: 126.71KB, Downloaded 3436 times)

Report message to a moderator

Re: creating database with 8K block size in oracle 9i - ORA-00058 [message #363284 is a reply to message #363277]

Fri, 05 December 2008 12:11

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I don't use DBCA but message says "Clone database creation in progress". You can't change the block size when you clone a database.

Regards
Michel

Report message to a moderator

Re: creating database with 8K block size in oracle 9i - ORA-00058 [message #363286 is a reply to message #363284]

Fri, 05 December 2008 12:21

dbanukesh
Messages: 96
Registered: November 2008
Location: London

Member

Well.. this is a fresh installation on new server. i will do export/import later on from the old db to this new db. i never faced this error earlier. it is bit astonishing for me too. Bt there is no cloning stuff goin on. I appreciate your responces - Thanks. i am chocked now.need a mug of coffee.

Thanks
Nukesh

Report message to a moderator

Re: creating database with 8K block size in oracle 9i - ORA-00058 [message #363288 is a reply to message #363286]

Fri, 05 December 2008 12:46

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

As I said I don't use DBCA but for create a template script this first then I customize it. Are you sure you didn't check a wrong option?

Regards
Michel

Report message to a moderator

Re: creating database with 8K block size in oracle 9i - ORA-00058 [message #363290 is a reply to message #363286]

Fri, 05 December 2008 12:49

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Probably one of the options you use with DBCA.
The templates that are used by DBCA are prone to errors.
OP wrote:
>>while creating db with dbca i just edited 4096 to 8192 and it fails halfway
Michel Wrote:
>> You can't change the block size when you clone a database.

That did ring some bells.
There used to be a specific bug with 9i DBCA (templates). Do not edit/change the block size or just use "new database template".
Better, just use command line options to create the database.
As another prominent member of this forum would frequently say,

Those live by GUI, die by GUI.

Report message to a moderator

Re: creating database with 8K block size in oracle 9i - ORA-00058 [message #363404 is a reply to message #363290]

Sat, 06 December 2008 17:53

dbanukesh
Messages: 96
Registered: November 2008
Location: London

Member

Thanks Mahesh and Miche for your responces. I will try to create this by command line and let you gus know if i still face same problem.

Cheers
Nukesh

Report message to a moderator

Re: creating database with 8K block size in oracle 9i - ORA-00058 [message #364441 is a reply to message #363404]

Mon, 08 December 2008 09:42

dbanukesh
Messages: 96
Registered: November 2008
Location: London

Member

Guys, i have created database manually. Everything looks good. Thanks for your responses.

Cheers
Nukesh

Report message to a moderator

Previous Topic:	Problem starting the Oracle Sid service
Next Topic:	can not change SID

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 20:52:08 CST 2024