ORA-12519: TNS:no appropriate service handler f…

JavaScript implementation: how to write beautiful conditional expression>>>

sometimes you can connect to the database, Sometimes it can’t be connected.
it may be that the current number of connections on the database has exceeded the maximum it can handle.

selectcount (*) fromv $process — the current number of connections
selectvaluefromv $parameterwherename =’processes’ — the maximum number of connections allowed by the database

modify the maximum number of connections:
altersystemsetprocesses = 300scope = SPFILE< restart the database:
shutdown immediate
startup;

— check which users are using the data
selectosuser, a.username, CPU_ time/executions/1000000||’s’,sql_ fulltext,machine
fromv$sessiona,v$sqlareab
wherea.sql_ address=b.addressorderbycpu_ time/executionsdesc;

Similar Posts: