Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to create/ update passwords in oracle wallet with a script without having to enter wallet master password for each entry

M.A.ShoaibDec 8 2023

Hi Experts,

I have created oracle wallet and using it. We entered SYS/SYSTEM passwords and some Schemas and Service accounts' passwords. Now we are going to change passwords of SYS/SYSTEM every 60 or even 30 days - How can I change all passwords in a wallet on a Linux server with a script without entering wallet master password for each entry. For example I want to add new passwords thru a script, I can type the wallet's master passwords once:

================================================================================

mkstore -wrl /x1/wallet -createCredential prod_db_sys sys syspassword
mkstore -wrl /x1/wallet -createCredential prod_db_system system systempassword

mkstore -wrl /x1/wallet -createCredential prod_db2_sys sys syspassword
mkstore -wrl /x1/wallet -createCredential prod_db2_system system systempassword

================================================================================

Thanks in advance.

Shoaib

Added on Dec 8 2023

5 comments

265 views