如何修改oracle ords23.4以上版本配置信息

郑全

如我们显示ords时，提示

[root@dbserver default]# systemctl status ords
● ords.service - Start Oracle REST Data Services
     Loaded: loaded (/etc/systemd/system/ords.service; enabled; vendor preset: disabled)
     Active: active (running) since Mon 2025-02-10 13:32:09 CST; 17min ago
   Main PID: 6632 (ords)
      Tasks: 70 (limit: 202224)
     Memory: 3.0G
        CPU: 37.803s
     CGroup: /system.slice/ords.service
             ├─6632 /bin/bash /u01/app/ords/bin/ords serve --apex-images /u01/app/apex/apex/images
             └─6670 /usr/local/java/jdk-17.0.14/bin/java -Doracle.dbtools.cmdline.home=/u01/app/ords -Duser.language=e>

Feb 10 13:32:15 dbserver ords[6670]: java.class.version=61.0
Feb 10 13:32:15 dbserver ords[6670]: 2025-02-10T05:32:15.172Z WARNING     *** jdbc.MaxLimit in configuration |default|>
Feb 10 13:32:15 dbserver ords[6670]: 2025-02-10T05:32:15.172Z WARNING     *** jdbc.InitialLimit in configuration |defa>
Feb 10 13:32:24 dbserver ords[6670]: 2025-02-10T05:32:24.666Z INFO
Feb 10 13:32:24 dbserver ords[6670]: Mapped local pools from /etc/ords/config/databases:
Feb 10 13:32:24 dbserver ords[6670]:   /ords/                              => default                        => VALID
Feb 10 13:32:24 dbserver ords[6670]: 2025-02-10T05:32:24.788Z INFO        Oracle REST Data Services initialized
Feb 10 13:32:24 dbserver ords[6670]: Oracle REST Data Services version : 23.4.0.r3461619


这时，如果我们想修改这个配置 jdbc.MaxLimit，jdbc.InitialLimit
使用以下命令即可
su - oracle

$ ords config set --global jdbc.InitialLimit 10
$ ords config set --global jdbc.MaxLimit 100


再去确认，已经不再报警

[root@dbserver default]# systemctl stop ords

[root@dbserver default]# systemctl start ords

[root@dbserver default]# systemctl status ords
● ords.service - Start Oracle REST Data Services
     Loaded: loaded (/etc/systemd/system/ords.service; enabled; vendor preset: disabled)
     Active: active (running) since Mon 2025-02-10 13:49:40 CST; 2s ago
   Main PID: 219500 (ords)
      Tasks: 64 (limit: 202224)
     Memory: 492.0M
        CPU: 10.029s
     CGroup: /system.slice/ords.service
             ├─219500 /bin/bash /u01/app/ords/bin/ords serve --apex-images /u01/app/apex/apex/images
             └─219544 /usr/local/java/jdk-17.0.14/bin/java -Doracle.dbtools.cmdline.home=/u01/app/ords -Duser.language>

Feb 10 13:49:40 dbserver systemd[1]: Started Start Oracle REST Data Services.
Feb 10 13:49:40 dbserver ords[219544]: NOTE: Picked up JDK_JAVA_OPTIONS: -Dconfig.url=/work/dbtools-dev/config/
Feb 10 13:49:42 dbserver ords[219544]: ORDS: Release 23.4 Production on Mon Feb 10 05:49:42 2025
Feb 10 13:49:42 dbserver ords[219544]: Copyright (c) 2010, 2025, Oracle.
Feb 10 13:49:42 dbserver ords[219544]: Configuration:
Feb 10 13:49:42 dbserver ords[219544]:   /etc/ords/config/
Feb 10 13:49:42 dbserver ords[219544]: 2025-02-10T05:49:42.190Z INFO        HTTP and HTTP/2 cleartext listening on hos>
Feb 10 13:49:42 dbserver ords[219544]: 2025-02-10T05:49:42.209Z INFO        Disabling document root because the specif>
Feb 10 13:49:42 dbserver ords[219544]: 2025-02-10T05:49:42.210Z INFO        Default forwarding from / to contextRoot c>
[root@dbserver default]#