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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ords install error ora-04031

juliojgsFeb 8 2023

I'm trying to install ords 22.4 , but I'm getting an ORA-04031 error.

I choose options
[2] Create or update a database pool and install/upgrade ORDS in the database
[2] Create an additional database pool
Enter the database pool name: mydb
Enter a number to select the database connection type to use
[3] Custom database URL
Choose [1]: 3

here I enter the jdbc connection string (it is tcps, so I cannot use the other connection methods) ,

sys user and password

Then I get the error:

Failed to connect to user: SYS AS SYSDBA url: jdbc:oracle:thin:@(DESCRIPTION= (ADDRESS=(PROTOCOL=TCPS)(PORT=2484)(HOST=xxxxx.xxx.xxx))(CONNECT_DATA=(SERVICE_NAME=XXXXX))))
ORA-04031: unable to allocate 12312 bytes of shared memory ("shared pool","unknown object","KKSSP^501","kglseshtTable")

java.sql.SQLException: ORA-04031: unable to allocate 12312 bytes of shared memory ("shared pool","unknown object","KKSSP^501","kglseshtTable")

Database is 19 … dba has allegedly just set it ready for us to use.

Is it probably a database issue? or it can be related to the connection beign tcps instead of common tcp 1521?
This post has been answered by jariola on Feb 9 2023
Jump to Answer

Comments

Post Details

Added on Feb 8 2023
#installation
1 comment
128 views