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
