Home » RDBMS Server » Server Administration » creating database with 8K block size in oracle 9i - ORA-00058 (Oracle 9i on windows)
creating database with 8K block size in oracle 9i - ORA-00058 [message #363262] Fri, 05 December 2008 10:26 Go to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
dbanukesh
Messages: 96
Registered: November 2008
Location: London
Member

Please refer more comprehensive screenshot.
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 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
A comprehensive screenshot? Tabula raza, I'm afraid.
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
Littlefoot
Messages: 20888
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"
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 Go to previous messageGo to next message
dbanukesh
Messages: 96
Registered: November 2008
Location: London
Member

./fa/5407/0/

lets see if it is visible,
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
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 Go to previous messageGo to next message
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
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 Go to previous message
dbanukesh
Messages: 96
Registered: November 2008
Location: London
Member

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

Cheers
Nukesh
Previous Topic: Problem starting the Oracle Sid service
Next Topic: can not change SID
Goto Forum:
  


Current Time: Sat Dec 03 09:54:10 CST 2016

Total time taken to generate the page: 0.09267 seconds