You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by chandra sekhar <ch...@gmail.com> on 2018/04/20 16:18:44 UTC
Oracle REST Data Services Unavailable -- java.sql.SQLException:
Unable to start the Universal Connection Pool
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.newUniversalConnectionPoolException(UCPErrorHandler.java:336)
at
oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(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.
Re: Oracle REST Data Services Unavailable -- java.sql.SQLException:
Unable to start the Universal Connection Pool
Posted by chandra sekhar <ch...@gmail.com>.
Thanks Chris.Will check
On Mon, Apr 23, 2018 at 9:40 AM, Christopher Schultz <
chris@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 <jc...@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
> >> <ch...@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-unsubscribe@tomcat.apache.org
> >> For additional commands, e-mail: users-help@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-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
Re: Oracle REST Data Services Unavailable -- java.sql.SQLException:
Unable to start the Universal Connection Pool
Posted by Christopher Schultz <ch...@christopherschultz.net>.
-----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 <jc...@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
>> <ch...@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-unsubscribe@tomcat.apache.org
>> For additional commands, e-mail: users-help@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-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Oracle REST Data Services Unavailable -- java.sql.SQLException:
Unable to start the Universal Connection Pool
Posted by chandra sekhar <ch...@gmail.com>.
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 <jc...@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 <ch...@gmail.com>
> wrote:
> > <entry key="jdbc.MaxConnectionReuseCount">5000</entry>
> >
> > On Fri, Apr 20, 2018 at 1:03 PM, John Dale <jc...@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.cs02@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 <jc...@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.cs02@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-unsubscribe@tomcat.apache.org
> >> >> For additional commands, e-mail: users-help@tomcat.apache.org
> >> >>
> >> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> >> For additional commands, e-mail: users-help@tomcat.apache.org
> >>
> >>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
Re: Oracle REST Data Services Unavailable -- java.sql.SQLException:
Unable to start the Universal Connection Pool
Posted by John Dale <jc...@gmail.com>.
Do you have the service name specified in your DBCP metadata?
On Fri, Apr 20, 2018 at 11:18 AM, chandra sekhar <ch...@gmail.com> wrote:
> <entry key="jdbc.MaxConnectionReuseCount">5000</entry>
>
> On Fri, Apr 20, 2018 at 1:03 PM, John Dale <jc...@gmail.com> wrote:
>
>> what is the value for max connections in your pool?
>>
>>
>> On Fri, Apr 20, 2018 at 10:38 AM, chandra sekhar <ch...@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 <jc...@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.cs02@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-unsubscribe@tomcat.apache.org
>> >> For additional commands, e-mail: users-help@tomcat.apache.org
>> >>
>> >>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>> For additional commands, e-mail: users-help@tomcat.apache.org
>>
>>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Oracle REST Data Services Unavailable -- java.sql.SQLException:
Unable to start the Universal Connection Pool
Posted by chandra sekhar <ch...@gmail.com>.
<entry key="jdbc.MaxConnectionReuseCount">5000</entry>
On Fri, Apr 20, 2018 at 1:03 PM, John Dale <jc...@gmail.com> wrote:
> what is the value for max connections in your pool?
>
>
> On Fri, Apr 20, 2018 at 10:38 AM, chandra sekhar <ch...@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 <jc...@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.cs02@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-unsubscribe@tomcat.apache.org
> >> For additional commands, e-mail: users-help@tomcat.apache.org
> >>
> >>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
Re: Oracle REST Data Services Unavailable -- java.sql.SQLException:
Unable to start the Universal Connection Pool
Posted by John Dale <jc...@gmail.com>.
what is the value for max connections in your pool?
On Fri, Apr 20, 2018 at 10:38 AM, chandra sekhar <ch...@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 <jc...@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 <ch...@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-unsubscribe@tomcat.apache.org
>> For additional commands, e-mail: users-help@tomcat.apache.org
>>
>>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Oracle REST Data Services Unavailable -- java.sql.SQLException:
Unable to start the Universal Connection Pool
Posted by chandra sekhar <ch...@gmail.com>.
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 <jc...@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 <ch...@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-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
Re: Oracle REST Data Services Unavailable -- java.sql.SQLException:
Unable to start the Universal Connection Pool
Posted by John Dale <jc...@gmail.com>.
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 <ch...@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.newUniversalConnectionPoolException(UCPErrorHandler.java:336)
> at
> oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(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-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org