Database Administration (MOSC)

MOSC Banner

ORA-12519: TNS:no appropriate service handler found

edited Nov 6, 2013 9:47PM in Database Administration (MOSC) 1 commentAnswered

We are facing ORA-12519: TNS:no appropriate service handler found on our database. runningon 9.2.0.6

now if i check V$process the count is way below the threshold of the maximum process. but if check v$resrouce limit the current value seems to be breaching the threshold.

This looks to the be due to the bug "Bug 3896119  CURRENT_UTILIZATION of V$RESOURCE_LIMIT may be too high "

So does the listner check v$resrouce limit or v$process to determince the current number of processess   ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center