Http://www.chengxuyuans.com/oracle/90720.html
Select value from v$parameter where name = ' processes ';
alter system SET processes = + scope = SPFile;
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 is:
Localhost:1521:orcl
At Oracle.jdbc.driver.DatabaseError.throwSqlException (Databaseerror.java
: 112)
At Oracle.jdbc.driver.DatabaseError.throwSqlException (Databaseerror.java
: 261)
At Oracle.jdbc.driver.T4CConnection.logon (t4cconnection.java:387)
At Oracle.jdbc.driver.physicalconnection.<init> (Physicalconnection.java:
414)
At Oracle.jdbc.driver.t4cconnection.<init> (t4cconnection.java:165)
At Oracle.jdbc.driver.T4CDriverExtension.getConnection (T4cdriverextensio
N.JAVA:35)
At Oracle.jdbc.driver.OracleDriver.connect (oracledriver.java:801)
At Java.sql.DriverManager.getConnection (drivermanager.java:571)
At Java.sql.DriverManager.getConnection (drivermanager.java:215)
At Com.supersit.service.impl.JdbcNZJGImpl.initConn (jdbcnzjgimpl.java:64)
At Com.supersit.service.impl.JdbcNZJGImpl.getBussinessWays (Jdbcnzjgimpl.
java:238)
At Com.supersit.action.MarketEntityAction.marketToPhone (marketentityacti
on.java:1221)
At Sun.reflect.GeneratedMethodAccessor597.invoke (Unknown Source)
At Sun.reflect.DelegatingMethodAccessorImpl.invoke (delegatingmethodacces
SORIMPL.JAVA:43)
At Java.lang.reflect.Method.invoke (method.java:606)
At Com.opensymphony.xwork2.DefaultActionInvocation.invokeAction (Defaulta
ctioninvocation.java:453)
At Com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly (Defa
ultactioninvocation.java:292)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (Defaultactioni
nvocation.java:255)
At Org.apache.struts2.interceptor.debugging.DebuggingInterceptor.interce
PT (debugginginterceptor.java:256)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (Defaultactioni
nvocation.java:249)
At Com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doInte
Rcept (defaultworkflowinterceptor.java:176)
At com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept
(methodfilterinterceptor.java:98)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (Defaultactioni
nvocation.java:249)
At Com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept (V
alidationinterceptor.java:265)
At Org.apache.struts2.interceptor.validation.AnnotationValidationInterce
Ptor.dointercept (annotationvalidationinterceptor.java:68)
At com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept
(methodfilterinterceptor.java:98)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (Defaultactioni
nvocation.java:249)
At Com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.interc
EPT (conversionerrorinterceptor.java:138)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (Defaultactioni
nvocation.java:249)
At com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept
(parametersinterceptor.java:236)
At com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept
(methodfilterinterceptor.java:98)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (Defaultactioni
nvocation.java:249)
At com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept
(parametersinterceptor.java:236)
At com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept
(methodfilterinterceptor.java:98)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (Defaultactioni
nvocation.java:249)
At Com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.inter
Cept (staticparametersinterceptor.java:190)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (Defaultactioni
nvocation.java:249)
At Org.apache.struts2.interceptor.MultiselectInterceptor.intercept (Multi
SELECTINTERCEPTOR.JAVA:75)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (Defaultactioni
nvocation.java:249)
At Org.apache.struts2.interceptor.CheckboxInterceptor.intercept (Checkbox
INTERCEPTOR.JAVA:90)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (Defaultactioni
nvocation.java:249)
At Org.apache.struts2.interceptor.FileUploadInterceptor.intercept (fileup
loadinterceptor.java:243)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (Defaultactioni
nvocation.java:249)
At Com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept (
MODELDRIVENINTERCEPTOR.JAVA:100)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (Defaultactioni
nvocation.java:249)
At Com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.inte
Rcept (scopedmodeldriveninterceptor.java:141)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (Defaultactioni
nvocation.java:249)
At Com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept (Cha
ininginterceptor.java:145)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (Defaultactioni
nvocation.java:249)
At Com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept (Pr
epareinterceptor.java:171)
At com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept
(methodfilterinterceptor.java:98)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (Defaultactioni
nvocation.java:249)
At Com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept (i18nint
erceptor.java:176)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (Defaultactioni
nvocation.java:249)
At Org.apache.struts2.interceptor.ServletConfigInterceptor.intercept (Ser
vletconfiginterceptor.java:164)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (Defaultactioni
nvocation.java:249)
At Com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept (Aliasi
nterceptor.java:192)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (Defaultactioni
nvocation.java:249)
At Com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.inter
Cept (exceptionmappinginterceptor.java:187)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (Defaultactioni
nvocation.java:249)
At Org.apache.struts2.impl.StrutsActionProxy.execute (STRUTSACTIONPROXY.J
AVA:54)
At Org.apache.struts2.dispatcher.Dispatcher.serviceAction (dispatcher.jav
a:511)
At Org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction (Exec
uteoperations.java:77)
At Org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter
. DoFilter (strutsprepareandexecutefilter.java:91)
At Org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (Appl
icationfilterchain.java:215)
At Org.apache.catalina.core.ApplicationFilterChain.doFilter (applicationf
ilterchain.java:188)
At Org.springframework.web.filter.CharacterEncodingFilter.doFilterIntern
Al (characterencodingfilter.java:88)
At Org.springframework.web.filter.OncePerRequestFilter.doFilter (onceperr
EQUESTFILTER.JAVA:90)
At Org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (Appl
icationfilterchain.java:215)
At Org.apache.catalina.core.ApplicationFilterChain.doFilter (applicationf
ilterchain.java:188)
At Org.apache.catalina.core.StandardWrapperValve.invoke (standardwrapperv
alve.java:213)
At Org.apache.catalina.core.StandardContextValve.invoke (STANDARDCONTEXTV
alve.java:172)
At Org.apache.catalina.core.StandardHostValve.invoke (STANDARDHOSTVALVE.J
ava:127)
At Org.apache.catalina.valves.ErrorReportValve.invoke (ERRORREPORTVALVE.J
ava:117)
At Org.apache.catalina.core.StandardEngineValve.invoke (standardengineval
ve.java:108)
At Org.apache.catalina.connector.CoyoteAdapter.service (coyoteadapter.jav
a:174)
At Org.apache.coyote.http11.Http11Processor.process (Http11processor.java
: 879)
At ORG.APACHE.COYOTE.HTTP11.HTTP11BASEPROTOCOL$HTTP11CONNECTIONHANDLER.P
Rocessconnection (http11baseprotocol.java:665)
At Org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket (POOLTCPENDPO
int.java:528)
At Org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt (leaderfol
LOWERWORKERTHREAD.JAVA:81)
At Org.apache.tomcat.util.threads.threadpool$controlrunnable.run (threadp
ool.java:689)
At Java.lang.Thread.run (thread.java:744)
Database connection Number Issues