Error on Oracle ORDS with the message: The pool named: |default|lo| is invalid and will be ignored: The database password secret in the wallet associated with the pool named

Symptoms: 

After changing some configuration on the Host server - such as hostname - you might see issue on the ORDS page, similar to this:

[WARNING] The pool named: |default|lo| is invalid and will be ignored: The database password secret in the wallet associated with the pool named: |default|lo| is missing

Mapped local pools from /<ORDS_CONFIG_DIR>/databases:

/ords/ default => INVALID

Cause: 

cwallet.sso file got corrupted after changing config on the host server.

Solution:

As cwallet.sso file is corrupted, its required to create a new wallet file using following command.

1> Delete (or backup) /<ORDS_CONFIG_DIR>/databases/default/wallet/cwallet.sso

2> Recreate the cwallet.sso using below command by resetting the password for ORDS_PUBLIC_USER.

cd $ORDS_PATH

ords config secret db.password

Make Sure you should see " The setting named: db.password was set to: ****** in configuration: default "

NOTE: If the exception is given for a user defined pool, then you should provide pool name for resetting the password.

3. Start / Restart ORDS.

References:

   Oracle Support Doc ID 3004436.1