Skip to Main Content

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.

Install custom ORDS 24.2 : ORA-12530, TNS:listener: rate limit reached

Jim DicksonAug 14 2024 — edited Aug 14 2024

During install of ORDS 24.2, encountered ORA-12530, TNS:listener: rate limit reached

In a previous post https://forums.oracle.com/ords/apexds/post/mismatch-with-the-server-cert-dn-ora-12530-tns-listener-rat-1183 for same error encountered at run-time,

Timo Herwix (https://forums.oracle.com/ords/apexds/user/timo-herwix) kindly recommended some ords config set values. These recommendations were confirmed (more or less) by Oracle Support (eventually).

My question is: can I set these same values during install i.e. combine ords install & ords config ?

My ords install command =

ords --config /etc/ords/config install adb --interactive --log-folder /home/oracle/ords_logs

want to add (to avoid ORA-12530 error)

ords config set jdbc.InitialLimit 0
ords config set jdbc.MaxLimit 3
ords config set jdbc.MinLimit 0

ords help implies install and config are mutually exclusive.

[oracle@apex23c-web ~]$ ords --help
2024-08-14T07:11:48Z INFO ORDS has not detected the option '--config' and this will be set up to the default directory.

ORDS: Release 24.2 Production on Wed Aug 14 07:11:50 2024

Copyright (c) 2010, 2024, Oracle.

Configuration:
/etc/ords/config

Usage:
ords [OPTIONS] [COMMAND]

Oracle REST Data Services command line interface

Options:
--config <folder> Path to Oracle REST Data Services
configuration folder

   --debug                  Equivalent to --verbose

-h, --help Show usage information for the command

   --java-options \<options...>  
                            To specify additional Java options that should  
                            be passed to the Java Virtual Machine

-v, --verbose Configure Oracle REST Data Services to run in
verbose mode

   --version                Show version information

Commands:
config Configure application and database connection
pool settings

   extract                  Extracts Oracle REST Data Services scripts.

   install                  Configure database connection and  
                            install/upgrade Oracle REST Data Services  
                            schema, ORDS database user and related  
                            database objects.

   migrate                  Migrates Oracle REST Data Services  
                            configuration files and parameter file from  
                            release 21.4.x and earlier releases.

   pool                     Monitor pools of a running Oracle REST Data  
                            Services instance

   serve                    Launch Oracle REST Data Services in standalone  
                            mode

   uninstall                Uninstall Oracle REST Data Services schema,  
                            ORDS database user and related database  
                            objects.

   war                      Create a web application from the the  
                            distributed ords.war that can be deployed in a  
                            supported servlet container.

Run ords <COMMAND> --help for more information on a command.

This post has been answered by thatJeffSmith-Oracle on Aug 14 2024
Jump to Answer

Comments

Post Details

Added on Aug 14 2024
3 comments
284 views