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)…

Crossposted from https://jasdeepsingh.wordpress.com/2007/06/14/how-oracle-bugged-me/

Comments:

Luigi - Jun 5, 2007

You are welcome! :)

[…] July 20, 2007 Posted by ਜਸਦੀਪ in Oracle, Script. trackback I used to hate oracle due to this .. I hated its bulkyness and hype… Money it makes with DBA certifications… Quite […]

Thanks for that workaround. Helped my like a charm.

My Pleasure Michael.. I was helped by Mr Luigi. on this … and one Above all Google..