I am using Oracle 10g on Windows
I am running a program (via JDBC) that is writing a burst of records to an Oracle Table (I would say may about 20,000 to 30,000 records, maybe more.
I am getting the following error:
SQL Exception: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12516, TNS:listener could not find available handler with matching protocol stack
I looked this up on the internet, and it said that the listener is measuring the amount of connections that have been opened, but NOT the amount of connections that have been terminated.
Apparently the listener only get the info about the number of connections that have been terminated once every 5 to 10 minutes or so. (Updated by PMON).
Apparently the solution is to change the number of PROCESSES in init.ora
I have 2 questions
What is the maximum amount of processes I can specify on init.ora ?
How do I restart Oracle without a reboot from that point on Windows ?
Thanks