Skip to Main Content

Connect without typing password

Jose ArósteguiDec 10 2018 — edited Dec 10 2018

Hi experts,

We're currently using Oracle Wallets as a "External Password Store", in order to connect to database without typing passwords:

https://askdba.org/weblog/2009/09/using-oracle-wallet-to-execute-shell-scriptcron-without-hard-coded-oracle-database-pas…

For that it's required to modify tnsname.ora or sqlnet.ora.... so as SQLcl doesn't use Oracle Cliente, is there something similar?

The goal would be to create an encrypted keystore with the database user/password, so it's not necessary to type password when establishing database connections.

This is will be used by a custom deployment tool written as a shell script, that would run sqlplus commands (DML/DDL).

Thanks,
Jose.

Comments
Post Details
Added on Dec 10 2018
4 comments
580 views