삽질은 내친구

$ sqlplus "sys/password as sysdba"

SQL> alter system set processes=150 scope=spfile;
System altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area  603979776 bytes
Fixed Size                  1260292 bytes
Variable Size             163579132 bytes
Database Buffers          436207616 bytes
Redo Buffers                2932736 bytes
Database mounted.
Database opened.

출처 : http://ksevindik.blogspot.com/2008/04/ora-12519-when-using-oracle-xe.html

ORA-12519 When Using Oracle XE

I recently installed Oracle XE on my laptop and tried to run our project which normally uses Oracle 10g in our company. After creating a db user and enabling it, I created tables, sequences, triggers and stored procedures etc by running db init scripts through ant without any problem. When it came to starting application in application server, I got "ORA-12519, TNS:no appropriate service handler found" messages. Thanks to this and this blog entries to reach at a quick solution. The problem was a bug in how Oracle XE handles monitoring processes, and you need to execute "ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE;" statement and then restart your database to get rid of it.

After overcoming this problem, I came up with a Turkish character encoding problem within my Hibernate generated sql statements but I am not hundred percent sure if I installed Oracle XE to deal with non latin characters appropriately. Anyway, it is easy to get rid of such encoding problems by setting user.language and user.country system properties to en and US consecutively.