| Help ORA-12545 [message #67259] |
Thu, 11 March 2004 13:41  |
Bala
Messages: 205
Registered: November 1999
|
Senior Member |
|
|
We have upgraded our client servers to Oracle 9.2.0.4. Our application connecting using JDBC throws an error ORA-12545 target host or object does not exist. This happens after 84 connections. Is there anybody who has faced similar issues and what is the resolution.
Thanks in advance
Bala
|
|
|
|
| Re: Help ORA-12545 [message #67719 is a reply to message #67259] |
Wed, 26 January 2005 08:17  |
scott
Messages: 73
Registered: September 1999
|
Member |
|
|
|
This particular situation with 84 is odd. Is it possible that your database server is AIX? If so, then my GUESS is that your connections are "dedicated" meaning that each get its own process on the DBSERVER. I would check to verify that the user that runs the database on AIX (normally 'oracle" or 'oracle9' or something similar) isn't getting squashed by the maximum process limit. Without taking great care when the user is built to change the process limit to a number higher than 128, the "oracle" user ends up being built with that limit in place. If that is the case, then oracle is simply UNABLE to spawn another dedicated server process, which will produce the 12545 error...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
