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