CONTAINER-REGISTRY ORDS ENTRYPOINT.SH SCRIPT DOES NOT ACCEPT MULTIPLE POOLS

[chrishoina]

The entrypoint script should take the first database on the ${ORTDS_CONFIG_DIR}/databases/, to validate the health.

This DB does not need to be referred to as "default."

Specifically, this line in the entrypoint.sh script should be updated:

Line 251: POOL_FILE=$(ls -A ${ORDS_CONF_DIR}/databases/*/pool.xml | head -1)

Original Oracle forum thread (where user first reported).

[chrishoina]

Internal ticket: ORDS-22996

[BruninkJ]

There is another issue with this entry point script. When you use a (RAC) service name for connecting to the pdb the following query does not give the correct result.

RESULT=$(echo " SET HEADING OFF FEEDBACK OFF VERIFY OFF ECHO OFF SELECT open_mode FROM v$pdbs WHERE name = UPPER('\''$DBSERVICENAME'\''); EXIT; " \ | sql -s "sys/*****@rac-scan:1522/$DBSERVICENAME" 2>/dev/null )\ | grep -c "READ WRITE")

The domain name is used to reference the server which is not used in de the v$pdb view. also the name of the service does not necessarily need to be the same as the pdb name
I altered the script as follows as a workaround

select CASE when ( select count(*) from v$pdbs where UPPER('$DBSERVICENAME') = UPPER(name) ) > 0 then (select open_mode from v$pdbs WHERE UPPER(name) = UPPER('$DBSERVICENAME')) ELSE (select open_mode from v$pdbs WHERE UPPER(name) = (select UPPER(pdb) from cdb_services where instr(UPPER('$DBSERVICENAME'),UPPER(NAME),1,1) > 0 ) ) END as open_mode from dual;

[chrishoina]

@BruninkJ I'm on holiday for the next few days. But will return on Monday 14-Sept. Expect to see a follow-up then. Thank you for brining this too our attention. We may have updated this in the latest release, but I'll have to double check. Thanks!