Skip to content

Instantly share code, notes, and snippets.

@rponte

rponte/ORA-12519-error.sql

Created September 5, 2010 22:00
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rponte/566366 to your computer and use it in GitHub Desktop.
Save rponte/566366 to your computer and use it in GitHub Desktop.
Download ZIP
Increasing Processes, Sessions and Transactions in Oracle XE
Raw
ORA-12519-error.sql
-- Tendo problemas com "ORA-12519, TNS:no appropriate service handler found"?
-- dica: http://en.newinstance.it/2007/06/01/ora-12519-tnsno-appropriate-service-handler-found/
-- Basta rodar este comando e reiniciar o listener (OracleXETNSListener):
ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE;
Raw
showing_oracle_parameter.sql
select name, value
from v$parameter
where name in ('processes', 'sessions', 'transactions');
@rponte
Copy link
Author

rponte commented Jan 5, 2012

http://www.atpeaz.com/index.php/2010/fixing-the-ora-12519-tnsno-appropriate-service-handler-found-error/

@rponte
Copy link
Author

rponte commented Jan 11, 2012

http://www.fatlemon.co.uk/2009/06/increasing-processes-sessions-and-transactions-in-oracle-xe/

@rponte
Copy link
Author

rponte commented Jan 11, 2012

http://www.oracleracexpert.com/2009/09/how-to-change-static-parameters-in.html

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment