In this post, I will share some good information about database parameters. Basically the database parameters are responsible for the functioning of the database and they also serve as a limit or boundary for the database. You can exploit this database parameters thus increasing the database's performance exponentially according to the needs.
For installing certain software like Oracle Identity Manager (OIM) or Oracle Business Intelligence Enterprise Edition (OBIEE) or for installing certain schemas via Repository Creation Unit (RCU) requires much higher database parameters as the default parameters are insufficient. For example the most common database parameter which needs to be increased are:
- sessions
- processes
- transactions
- open_cursors
STEP:
1. Start your database in "OPEN" mode
2. To display the current limits for the database parameters, use the command
show parameter <PARAMETER_NAME>
3. To modify the database parameters "sessions", "processes", "transactions", "open_cursors" using the following commands. it is best to set the database parameters to higher values which is at least more than 800. I prefer the value 1000 so I have show it below:
alter system set sessions=1000 scope=spfile;
alter system set processes=1000 scope=spfile;
alter system set open_cursors=1000 scope=spfile;
alter system set transactions=1100 scope=spfile;
4. Restart your database to make these static changes permanent
Now you are ready to install RCU schemas for OIM or OBIEE and no error will be thrown during the RCU schema installation if you have followed the above steps. But make sure you use the correct version of the RCU. If you find this post useful, please share it.
0 comments