I have a test suite which contains about 4000 tests in it. We use Oracle as our database . When i run the test suite , some tests run fine and after some time i get ORA-12519 TNS:no appropriate service handler found
When i run the tester in isolation , it works correctly , so guess the issue is with the connection to the oracle database located on my machine
I followed couple of posts online and did Run the command “alter system set processes=150 scope=spfile;” in the SQL*Plus but that did not help too
Did some one experience this issue before and what do i need to do to get if fixed?
I would be awesome if some one could explain the cause and the required action
Thanks
Sql*Plus as system and use this
alter system set processes=600 scope=spfile; (instead of 150 , i set it to 600)
Make sure that you restart your database.
This is answered here
What can cause intermittent ORA-12519 (TNS: no appropriate handler found) errors
Thanks