-----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
