I think service name should be there.Can you tell me how to check this? On Fri, Apr 20, 2018 at 1:43 PM, John Dale <jcdw...@gmail.com> wrote:
> 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 > >
