Do you have the service name specified in your DBCP metadata? On Fri, Apr 20, 2018 at 11:18 AM, chandra sekhar <chandra.c...@gmail.com> wrote: > <entry key="jdbc.MaxConnectionReuseCount">5000</entry> > > On Fri, Apr 20, 2018 at 1:03 PM, John Dale <jcdw...@gmail.com> wrote: > >> what is the value for max connections in your pool? >> >> >> On Fri, Apr 20, 2018 at 10:38 AM, chandra sekhar <chandra.c...@gmail.com> >> wrote: >> > Hi John, >> > >> > Thanks for the response! >> > Without giving this "jdbc:oracle:thin" parameter in default.xml other >> Apex >> > environments are working fine.Please suggest.. >> > >> > On Fri, Apr 20, 2018 at 12:29 PM, John Dale <jcdw...@gmail.com> wrote: >> > >> >> if I remember correctly, oracle requires the name of its database >> >> service in the connection parameters (aka schema). >> >> >> >> Try something like: jdbc:oracle:thin:someuser@// >> myhost:1521/myservicename >> >> >> >> If you aren't doing a thin connection, I'm sure the same principle >> >> still applies. Oracle likes the schema on the URL (aka service name?) >> >> >> >> It's been awhile, so I'm not completely sure. Hope you get it >> connected. >> >> >> >> On Fri, Apr 20, 2018 at 10:18 AM, chandra sekhar < >> chandra.c...@gmail.com> >> >> wrote: >> >> > Hi, >> >> > >> >> > We were recently installed and configured Apex on two servers and did >> the >> >> > Load balance.We were facing the issue like "Oracle REST Data Services >> >> > Unavailable" and we found the below error messages in the catalina.out >> >> Can >> >> > anybody suggest me. >> >> > >> >> > Error Message: >> >> > ========== >> >> > Caused by: java.sql.SQLException: Unable to start the Universal >> >> Connection >> >> > Pool: oracle.ucp.UniversalConnectionPoolException: Failed to create >> >> > initialPoolSize connections while starting a pool: >> >> > java.lang.IllegalArgumentException: empty service member name >> >> > at >> >> > oracle.ucp.util.UCPErrorHandler.newSQLException( >> >> UCPErrorHandler.java:456) >> >> > at >> >> > oracle.ucp.util.UCPErrorHandler.throwSQLException( >> >> UCPErrorHandler.java:133) >> >> > at >> >> > oracle.ucp.jdbc.PoolDataSourceImpl.startPool( >> >> PoolDataSourceImpl.java:942) >> >> > at >> >> > oracle.ucp.jdbc.PoolDataSourceImpl.getConnection( >> >> PoolDataSourceImpl.java:1969) >> >> > at >> >> > oracle.ucp.jdbc.PoolDataSourceImpl.access$500( >> >> PoolDataSourceImpl.java:198) >> >> > at >> >> > oracle.ucp.jdbc.PoolDataSourceImpl$30.build( >> >> PoolDataSourceImpl.java:4353) >> >> > at >> >> > oracle.ucp.jdbc.PoolDataSourceImpl.getConnection( >> >> PoolDataSourceImpl.java:1924) >> >> > at >> >> > oracle.ucp.jdbc.PoolDataSourceImpl.getConnection( >> >> PoolDataSourceImpl.java:1901) >> >> > at >> >> > oracle.dbtools.common.jdbc.DataSourceConnection.getConnection( >> >> DataSourceConnection.java:46) >> >> > at >> >> > oracle.dbtools.common.pools.DataSourceTargetImpl.connection( >> >> DataSourceTargetImpl.java:41) >> >> > at >> >> > oracle.dbtools.url.mapping.db.DatabaseURLMappingImpl.injectPool( >> >> DatabaseURLMappingImpl.java:383) >> >> > ... 50 more >> >> > Caused by: oracle.ucp.UniversalConnectionPoolException: Failed to >> create >> >> > initialPoolSize connections while starting a pool: >> >> > java.lang.IllegalArgumentException: empty service member name >> >> > at >> >> > oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolExce >> >> ption(UCPErrorHandler.java:336) >> >> > at >> >> > oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolEx >> >> ception(UCPErrorHandler.java:59) >> >> > at oracle.ucp.common.Core.initialize(Core.java:1307) >> >> > at >> >> > oracle.ucp.common.UniversalConnectionPoolBase.start( >> >> UniversalConnectionPoolBase.java:725) >> >> > at >> >> > oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.start( >> >> OracleJDBCConnectionPool.java:129) >> >> > at >> >> > oracle.ucp.jdbc.PoolDataSourceImpl.startPool( >> >> PoolDataSourceImpl.java:938) >> >> > ... 58 more >> >> > Caused by: java.lang.IllegalArgumentException: empty service member >> name >> >> > at oracle.ucp.common.ServiceMember.<init>( >> >> ServiceMember.java:163) >> >> > at oracle.ucp.common.ServiceMember.<init>( >> >> ServiceMember.java:129) >> >> > at oracle.ucp.common.Service$2.<init>(Service.java:790) >> >> > at oracle.ucp.common.Service.create(Service.java:785) >> >> > at oracle.ucp.common.Service.create(Service.java:588) >> >> > at oracle.ucp.common.Topology.create(Topology.java:145) >> >> > at oracle.ucp.common.Core$9.call(Core.java:1248) >> >> > at oracle.ucp.common.Core$9.call(Core.java:1236) >> >> > at oracle.ucp.common.Core.initialize(Core.java:1283) >> >> > >> >> > With Thanks & Best Regards, >> >> > Chandra. >> >> >> >> --------------------------------------------------------------------- >> >> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org >> >> For additional commands, e-mail: users-h...@tomcat.apache.org >> >> >> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org >> For additional commands, e-mail: users-h...@tomcat.apache.org >> >>
--------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
