Skip to Main Content
Forums

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Steps to update jdbc.MaxLimit for a REST data service

user12003658Mar 12 2021

There is a REST data source based WAR file deployed in Oracle 12.2.1.3 FMW environment. Oracle report module uses this data source to populate data in static HTML pages. The end-users received 505 internal server error while trying to run reports. The managed server log showed the following errors:
Error: Could not obtain a database connection because all connections in the pool: |apex|| were in use. Borrowed Connections: 10 Available Connections: 0 Maximum Connections: 10 ***
[ERROR] [] [oracle.dbtools] [tid: [ACTIVE].ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)'] java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: All connections in the Universal Connection Pool are in use[[
InternalServerException [statusCode=500, reasons=[]]
Based on Metalink doc 1592840.1, it is clear that the data source ran out of its default jdbc.MaxLimit of 10.
How can I increase the limit? Do I need to rebuild the WAR file? Could you please share the detailed steps involved?

Thanks in advance!

Comments

Valeriy Burmaka

I have the same error on Windows 10 Pro, Dell Precision 7810, 32 GB memory,
2 CPU x 8 Cores x 2 threads = 32 threads...

User_81UY9

any progress on your installation? @user-g0fb5-oracle@user-gmsnn

Is error occurring during the installation of XE, or after it is completed?
Did you receive an error during installation?

Valeriy Burmaka 
ORA-00821 occurs during installation, and it is impossible to connect to the database
using sqlplus as sysdba "sqlplus / as sysdba".
User_81UY9

@christian-shay-oracle,I encountered during the installation and will not able to complete due to ORA-00821: Specified value of SGA_target 2096M is too small, needs to be atleast 2240M. I am installing on Windows 64 bit with 64gb of RAM.

User_81UY9

The problem is it won't allow me to create a database with more than 2GB RAM of PGA+SGA(Database Express limitation) but it won't allow me to create with too small SGA for shared pool size. I have 64GB of RAM in my machine, running MS Windows SQLServer 2019

Valeriy Burmaka

...product\21c\cfgtoollogs\dbca\XE\XE.log :
----------------------------------------------------------------------------------------------------------------
2022-01-24 22:01:34.262 CST ] Prepare for db operation
DBCA_PROGRESS : 7%
[ 2022-01-24 22:01:39.199 CST ] Copying database files
DBCA_PROGRESS : 8%
[ 2022-01-24 22:02:00.239 CST ] [WARNING] ORA-00821: Specified value of sga_target 1536M is too small, needs to be at least 1600M
ORA-01078: failure in processing system parameters
DBCA_PROGRESS : 9%
[ 2022-01-24 22:02:00.239 CST ] [FATAL] ORA-01034: ORACLE not available
... and so on ...

User_7CH7A

Any word on this? I have the exact same problem. Seems to be high-memory machines. I have Windows 10 Pro for Workstations... 32-core, 48GB RAM.

Valeriy Burmaka

/************************
** Solution was found: **
************************/

  1. "Start button" -> Find [Control Panel] -> [System Configuration] -> [Boot] folder.
  2. Click [Advanced Options...] button. In the form "Boot Advanced Options"
    check the "[ ] Number of processors " checkbox, then select number of CPUs (about 8). Save your changes.
    (Just in case - I selected 4 CPUs).
  3. Restart your PC.
  4. Install Oracle 21c XE database. Install process is to slow (took about 30 min), but without errors.
  5. When installation is done, check the services (using the command "lsnrctl status").
    Services "XE", "XEXDB", "XEPDB1" have to work.
  6. Go go [Advanced Options...] of your PC (see item#2) and UNCHECK the "[ ] Number of processors " checkbox. Save your changes.
  7. Restart your PC. Database will work as expected.
  8. Enjoy :)
User_YJECZ

@user-gmsnn THANK YOU!!! this worked for me. I have a ryzen 5950x with 16cores and I bumped it down to 4 for the install. The errors I was getting was mostly about TNS, but turns out the database wasnt installed correctly and the installer did not tell me.

1 person found this helpful
Valeriy Burmaka

You are welcome ! :)

1 - 11

Post Details

Added on Mar 12 2021
3 comments
2,991 views