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 : 634 Pageviews. |
|
 |
|