EPM - Oracle EPM 11.1.1.2 Installation - Change DB Parameters

Make sure change initial database parameters while preparing database for Oracle EPM 11.1.1.2.

1. nls_length_semantics

select name, value from v$parameter where name ='nls_length_semantics';

alter system set nls_length_semantics=char SCOPE=both;

2. open_cursors

select name, value from v$parameter where name ='open_cursors';

alter system set open_cursors=5000 SCOPE=both;

3. sessions

select name, value from v$parameter where name =' sessions ';

alter system set sessions =500 SCOPE= spfile;

4. processes

select name, value from v$parameter where name =' processes ';

alter system set processes =500 SCOPE= spfile;