Oracle 805 db_block_size

[KY.Chuang]

Dear all,
I have a question about Oracle db_block_size?
I create a Database with Oracle Installer, and I
want to set the db_block_size to 8192...So, I try to modify
$ORACLE_HOMe/dbs/init.ora
add the parameter
(db_block_size = 8192)
But everytime When I check
the db_block_size which new Database created. It always is 2408 (default). Why ???
Which file I can modify the db_block_size when I cretae the Database with Oracle Installer???

Thanks. K.Y.

[Eric Lin]

Hi KY

db_block_size need to be set in your initSID.ora file when you arecreating database.
In your case, check your initSID file to see if you can find other entries for db_block_size.

Good luck

[BLADE_1]

hi k.y,

Are u creating a starter database using Oracle Installer? If yes, then u can specify it during the installation. Or u can also run the DBASSIST tool after installing Oracle on the Box.
If u r creating the database using GUI u don't have to edit the init.ora file. It gets automatically updated with whatever values u had specified during the database creation.


When u r manually creating the database using a "create database script" then before running the script u have to edit the init.ora and change all the default parameters i.e db_block_size etc. Then at the svrmgrl prompt.
#svrmgrl > startup nomount pfile=

#svrmgrl> @

rgds
nainesh

[T G Manikandan]

First thing is you cannot modify the db_block_size after the database creation.

Second,
The db_block_size should be in the right init.ora file.

For example your SID name is test then it should be in the inittest.ora file.


Thanks

[KY.Chuang]

Dear all,
Happy Valentine's Day.
I want to say is:
My Oracle is based on HP9000.
So, I can't use Oracle Configuration assistant to create Databse.
I try to modify the init.ora (set the db_block_size = 8192)when I create the databse with Oracle Installer, but it's no useful.

I remember Oracle have a sample script which create Database (like rdb1.sql and rdb2.sql)... But I can't find them.Because I want to manually create Databse...

Thanks.

[BLADE_1]

hi,


i have attached a document to manually create a database on unix.


hope this helps you

rgds
blade

[Christian Gebhardt]

Hi

A summary of most answers:

be sure to change the

$ORACLE_HOME/dbs/init.ora

before creating the database

Chris

[KY.Chuang]

Dear all,
I tried to copy a init.ora to
init.ora and modify the
db_block_size = 8192.
Then, I create the Database with Oracle Installer.
When created database, I mount
the database and check the parameter(select * from V$PARAMETER;)
It's still 2048 (db_block_size).
So, I guess which to modify the init.ora to create Database with Oracle Installer, It's no useful.?

[T G Manikandan · Accepted solution]

modification of db_block_size during Oracle Installer,

check the attachment

[Brian Crabtree]

You might want to verify that you do not have an "ifile" parameter in your init.ora. This can point to an additional file that holds static parameters for multiple databases on the system, or for OPS databases on a shared mount.

Brian