How Oracle Bugged Me ..

    ORA-12519, TNS:no appropriate service handler found

was the error i was getting whenever i ran my application deployed on Jboss and Oracle 10g XE as database server.
I used every trick in my tiny brain ,varying from using DBCP connection pooling,Container managed Connection pooling, Setting the no. of connection to very high value.. etc. etc…
But this error was inevitable .
I was going nuts ,googled around for this thousand times…
But luckily i found an blog post with the same problem.
Here are the guy’s thoughts on this (Same as mine are):
I used to hate Oracle Database (and other Oracle products too) because of it is much more complicated / heavyweight / slow / buggy and full of useless and sometime harmful stuff than needed. Also when you install you can’t remove it without leaving tons of zombie files around, breaking your JVM/Apache/Windows/etc. After an Oracle installation, your system will never be as before. And hey, have you ever seen an “universal installer” more pathetic than the oracle one?
what i got was that it was not problem at the connection pooling end . There was a bug in oracle which caused this , and issuing the following command at SQL command line will fix it (after restarting the listener): “ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE;”...
hmm thats it it worked for me..
Thanx Google and Mr.Luigi (Guy who wrote that blog post)…

Advertisements

4 thoughts on “How Oracle Bugged Me ..

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s