Oracle - parallel max servers

From ExxtremeWiki
Jump to: navigation, search

Oracle - parallel max servers [edit] This section is about the parallel_max_servers setting in Oracle.

ORA-12519' errors can occur in Maximo if you have to many instances running on a single server or if you have more connections than you have CPU's or CPU Cores to handle. Oracle sets the Parallel_Max_Servers setting based on the number of CPU(s)/Cores available and you can tweak it slightly if necessary... However I recommend that you review your system configuration to be sure you have sized your Oracle server correctly for the expected user load.

From Burlson's site:

http://www.dba-oracle.com/sf_ora_12519_tns_no_appropriate_service_handler_found.htm

"Also, on Oracle DBA Forums (http://dbaforums.org/oracle/lofiversion/index.php/t7587.html), there is information referring to ORA-12519. Here, it is pointed out that ORA-12519 can be caused by low "processes" values, which can be resolved by increasing the DB parameter, "parallel_max_servers". Also, ORA-12519 can be thrown because of DB and client versions which do not match."

Example Error from a Live Maximo System:

As of 9:22 PM EST, none of my jdbc connections will work, even on the former 62xd and 63xd. I did not see any changes to the database targets in all of the emails, but it is possible I could have missed it.

The connection url that I am trying to use is:

jdbc:oracle:thin:@<servername>:1521:<tnsname>

And the error I am getting is:

Invalid java.sql.SQLException: Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handler found The Connection descriptor used by the client was: <servername>:1521:<tnsname>


--wkh 05:30, 5 March 2009 (UTC)