Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 805 db_block_size

SOLVED
Go to solution
KY.Chuang
Advisor

Oracle 805 db_block_size

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.
Service is King
9 REPLIES
Eric Lin
Occasional Advisor

Re: Oracle 805 db_block_size

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

Eric Lynn
BLADE_1
Frequent Advisor

Re: Oracle 805 db_block_size

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

fortune favours the brave
T G Manikandan
Honored Contributor

Re: Oracle 805 db_block_size

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
Advisor

Re: Oracle 805 db_block_size

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.
Service is King
BLADE_1
Frequent Advisor

Re: Oracle 805 db_block_size

hi,


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


hope this helps you

rgds
blade
fortune favours the brave
Christian Gebhardt
Honored Contributor

Re: Oracle 805 db_block_size

Hi

A summary of most answers:

be sure to change the

$ORACLE_HOME/dbs/init.ora

before creating the database

Chris
KY.Chuang
Advisor

Re: Oracle 805 db_block_size

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.?


Service is King
T G Manikandan
Honored Contributor
Solution

Re: Oracle 805 db_block_size

modification of db_block_size during Oracle Installer,

check the attachment
Brian Crabtree
Honored Contributor

Re: Oracle 805 db_block_size

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