Secode
asked on
Need help with creating an initSID.ora file
Hi, I'm about to install and create an Oracle server (9iR2) and need to create an initSID.ora file (replacing SID with the actual name). The server is a 1GHz Compaq Server with 2GB of RAM. It is running RedHat Enterprise Linux 4.0 ES. It will ONLY run Oracle with one instance (One SID?). I'm estimating MAX 5 connections at one time, most of the time it will be mostly 1 or 2 connections (computes) connected.
What would be a good init.ora configuration for such server?
What would be a good init.ora configuration for such server?
ASKER CERTIFIED SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I do acctually create an spfile from initSID.ora as the last thing I do in my script to set up the oracle.
create spfile='/u01/app/oracle/pr
I will use the default init.ora and just change the db_cache_size then. I see the init.ora file referes to SMALL, MEDIUM and LARGE. What should I use? The database will be getting data inserted more or less each minute.
create spfile='/u01/app/oracle/pr
I will use the default init.ora and just change the db_cache_size then. I see the init.ora file referes to SMALL, MEDIUM and LARGE. What should I use? The database will be getting data inserted more or less each minute.
ASKER
I was not able to use db_cache_size=XXX when I used the default init.ora as template:
ORA-00381: cannot use both new and old parameters for buffer cache size specification
I skipped setting the db_cache_size for now.
ORA-00381: cannot use both new and old parameters for buffer cache size specification
I skipped setting the db_cache_size for now.
You cannot set both db_cache_size and db_block_buffers.
Oracle is deprecating db_block_buffers in favor of the db_cache_size parameter, so it is highly recommended that you make the switch. Once you make this change, db_cache_size is dynamic so you can change it without having to restart the database. This is one very good advantage of using this parameter instead. The other being that db_block_buffers is only kept around for backward compatibility and will not be available going forward.
Oracle is deprecating db_block_buffers in favor of the db_cache_size parameter, so it is highly recommended that you make the switch. Once you make this change, db_cache_size is dynamic so you can change it without having to restart the database. This is one very good advantage of using this parameter instead. The other being that db_block_buffers is only kept around for backward compatibility and will not be available going forward.
ASKER
I'll skipp db_block_buffers then :)
Do not lose them because in emergancy case you will need them.