Database properties for OBIEE installation

I came across a very interesting video about obiee installation, there is nothing new with the installation actually but there is something that has to be done before the installation that caught my attention.

setting the database with appropriate properties, as we all are aware that OBIEE is database driven so with out which there is no point in going further. Now lets see what i have learnt new in this aspect.

Firstly we should be aware that there are some prerequisites given below for the OBIEE installation w.r.t DB properties,

process 500
open_cursors 800
sessions 250

now lets see how to set these properties.Firstly we must connect to the database as a admin user ,generally sys and check the status of database using below command. Make sure you do this with Admin user ,if you don't have one then talk to your DBA and get this done.

select status from v$instance;

Now set the above parameters using the below commands

alter system set processes=500 scope=spfile;

alter system set open_cursors=800;

alter system set processes=500 scope=spfile;

And the final step is to restart the Database, which we can do using 

Startup force

Thats it youre done now go ahead with running the RCU against the database.