Oracle error ORA-12516

It looks like the problem is that the default max number of
connections is too small in Oracle XE -- causing the ORA-12516 error
when running unit tests. Luckily, it is pretty easy to fix, I'll
explain how to below.

Once you connect to Oracle under a system account using sqlplus (e.g.,
sqlplus system/password@xe), run these two commands:

show parameter processes
show parameter sessions

The output is a little confusing, since the lines are usually split in
the console window. For my system for instance, the setting
"processes" was 40. But about half of those are already reserved for
system processes, so you actually have a lot less available. Anyway, I
bumped mine up by running these 2 commands in sqlplus:

alter system set processes=100 scope=spfile;
alter system set sessions = 115 scope = spfile;

That sets the max number of processes to 100 and sessions to 115. (I
grabbed these values from //clemensblog.blogspot.com/2006/04/oracle-bpel-xe-part-2.html).

You need to restart Oracle for these changes to take effect (these
value changes will persist), such as: sudo /etc/init.d/oracle-xe
restart

Cheers,
Christian

refer to //groups.google.com/group/migrate-users/browse_thread/thread/a432b3cbe564b2b5/16132df4a127b32f?pli=1

//www.markcallen.com/oracle/oracle-xe-tuning




Free TextEditor

Create Date : 27 สิงหาคม 2552		0 comments
Last Update : 27 สิงหาคม 2552 11:20:15 น.
Counter : 372 Pageviews.
Share Tweet