ords install

Ords configuration

References

https://forums.oracle.com/ords/apexds/post/ords-image-in-container-registry-6849

https://container-registry.oracle.com/ords/ocr/ba/database/ords

Install

This command will install/update the ords version in the database and save a wallet on the hosts disk.

The first password is for sys as sysdba, the second is for ORDS_PUBLIC_USER

Important

This install needs to be run once per database and webhost to ensure the wallet is configured correctly. The wallet is not stored in ansible. The tns must be upper case but it is configured that way in the ords settings file which is manage by ansible

cat password.txt
<PASSWORD FOR admin-user>
<PASSWORD FOR proxy-user>
 
sudo mkdir -p/bw3/config/d4_ords
sudo chown 54321:54321 /bw3/config/d4_ords
 
cat password.txt | docker run --rm -i \
    # -v /bw3/config/d4_ords:/etc/ords/config \
    container-registry.oracle.com/database/ords:latest \
    install --admin-user sys --proxy-user --db-tns-dir /etc/ords/config --db-tns-alias CCPD4 --feature-sdw true --password-stdin

Change the Ords password

This command will update the wallet if the ORDS_PUBLIC_USER password has been changed

cat password.txt
# <PASSWORD>
 
cat password.txt | docker run --rm -it \
  -v ords_config:/etc/ords/config
  container-registry.oracle.com/database/ords:latest \
  config secret --password-stdin db.password

Enable Ords in schema

Login as bw3 user

begin
    ords_admin.enable_schema(p_schema => 'BW3');
end;
/