Thanks Chris.Will check On Mon, Apr 23, 2018 at 9:40 AM, Christopher Schultz < ch...@christopherschultz.net> wrote:
> -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA256 > > Chandra, > > On 4/20/18 12:38 PM, chandra sekhar wrote: > > Thanks for the response! Without giving this "jdbc:oracle:thin" > > parameter in default.xml other Apex environments are working > > fine.Please suggest.. > > IIRC, for "thick" clients, there is some amount of local-OS > configuration that needs to occur in order to define the connection > (and give it a name) so that you can connect to it. > > Ask your Oracle DBAs about configuration differences between the > environments where things are working versus where they aren't. There > is probably some configuration file somewhere you don't even know > about that is missing something important. > > Hope that helps, > - -chris > > > 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 > >> > >> > > > -----BEGIN PGP SIGNATURE----- > Comment: GPGTools - http://gpgtools.org > Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ > > iQIzBAEBCAAdFiEEMmKgYcQvxMe7tcJcHPApP6U8pFgFAlrd4loACgkQHPApP6U8 > pFii5g//QV4m1AK6wag5dhIqRpP/YKRlNn5prW/vsaS08oKdvgcYO5V5XqisSCH0 > Ib/RJksPS/Ro0xzW+hpZgS28iWvoa5i+rhZbOwuYYcEINLVfEpRLv63GD7t0RXpQ > VnpCUsS7Iok73aBzy/zGQ4MgeHJdYFTRb+EcjN3upkicFD6VmoBjqyRs8wX4U5IJ > L15cxA9Npv4VOVS8O0wi1d2l8kl452rtO518A5P+KY85arx6Jxtma2WlZR4wUtby > z1VoWoClM6Zs9GuBbdFKAMhfx5I3sua2n70fonGUagvgZvz5j4QDoIVxjF5+RIHy > yHfsxd64gg1vbCANHiyLv4Rml1FcbNxk9AVyQU82DAlb5NowN2pbeGDH5k/+RmW4 > ScHY0eT1U+XSXcBWk63qQZHX0HVX6m+l9QfUbk5y4IKtjMOVlCDZne1qvZ8xE4Yt > K8/7vdpowtIusC6j2XseubZdun5puxBjvaL/lTNccCUIPVHUwp53964ws7vzrQVZ > YDasBqj15fKAOZuxhHfhJ1VWQsJkcCTk7XTQqpQ0SsXeMZ/SUY1NIh9lyUbpiw4D > VyMAFu2DiZG6+t3cGybJxcnwXhxZlzqUBpKAO+P4zcqW5cYClmxeZ135X28vqYMI > dgS/wpWU01qlDp/O45FQVl1gvKsilFR47gZEN/u5jIv01bTsPbk= > =0dEC > -----END PGP SIGNATURE----- > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > >
