Oracle ATP – rotate wallet

To connect to ATP/AWD you need download a wallet

Download Wallet

Wallet can be rotated to increase security of the database.

Oracle support Immediate rotation or grace rotation with grace period 1-24h.

Always Free Autonomous Database support only immediate rotation of the wallet.

Test connection with current wallet. Download wallet and set connection to DB using SQL developer.

Connection was succesfull

Create new wallet file with new password

  1. Test connection using current wallet – the connection was successful
  2. Test connection using new wallet file – connection success
  3. Rotate wallet in then ATP configuration – after press Rotate Wallet, it was popup wich ask to enter database name

Base on message old wallet files will still work and with time they will be terminated,

If we want to terminate it immediate – then restart the database

Enter DB name and click Rotate

Are current wallet files still working?

Using old wallet 1 – I can’t connect

Using old wallet 2 – I can’t connect

Generate new wallet file

Wallet rotate – doesn’t display any date when I rotate the file

Using new wallet file which was generated after I click ROTATE WALLET button I was able to login – I didn’t restart a DB between those tests, only rotate wallet file.

As we see Always Free ATP support only immediate rotation of they key and this is working as expected.

When you rotate key, you need to update all applications which are using that key in order to connect to DB

Leave a Reply

Your email address will not be published. Required fields are marked *