สิงหาคม 2552
 
 1
2345678
9101112131415
16171819202122
23242526272829
3031 
 
27 สิงหาคม 2552
 

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.

 
Name
Opinion
*ใช้ code html ตกแต่งข้อความได้เฉพาะสมาชิก

alpha707
 
Location :


[ดู Profile ทั้งหมด]

ฝากข้อความหลังไมค์
Rss Feed

ผู้ติดตามบล็อก : 1 คน [?]




[Add alpha707's blog to your web]

 
pantip.com pantipmarket.com pantown.com