Thursday, 23 February 2017

Configure database parameter that is mandatory to configure OSB

There are some parameter that need to set before you configure your oracle service bus domain. If you will not set these parameter you may get some issues during Oracle Service Bus domain configuration.

Below are the parameters that need to set.

1) Login to the database as the sysdba and set the parameters mentioned in the following table.

S.No
Parameter
Value
Command
1.
Charset
Unicode(AL32UTF8)
While installing database
2.
Processes
1500
sql> alter system set processes = 1500 scope=spfile

3.
Memory_target
7GB
sql> alter system set Memory_target = 7gb scope=spfile
4.
Sga_target
0
sql> alter system set Sga_target = 0 scope=spfile
5.
Pga_aggregate_target
0
sql> alter system set Pga_aggregate_target = 0 scope=spfile
6.
Sga_max_size
0
sql> alter system set Sga_max_size = 0 scope=spfile
7.
Job_queue_processes
number of cpu cores
sql> alter system set Job_queue_processes = < number of cpu cores > scope=spfile
8.
Open_cursors
500
sql> alter system set Open_cursors = 500 scope=spfile
9.
Session_cached_cursors
500
sql> alter system set Session_cached_cursors = 500 scope=spfile

No comments:

Post a Comment