Forum Stats

  • 3,840,337 Users
  • 2,262,589 Discussions
  • 7,901,227 Comments

Discussions

Setting up Passwordless EXPDP

user490177
user490177 Member Posts: 7 Blue Ribbon
edited Mar 4, 2020 2:29PM in Database Security - General

Hello,

I was recently tasked to revamp our current procedures for exports that run nightly.  One of the changes I am attempting to make is to execute the expdp commands without providing any passwords using a wallet.  To this end, I set up two new folders, one to contain my wallet and one to contain the networking files needed.

I set TNS_ADMIN to my non-default location to reference my created files.

I created the wallet.

$ mkstore -wrl expdp_wallet/ -create

I added the credential to the wallet.

$ mkstore -wrl expdp_wallet/ -createCredential EXPDP_TNS EXPDP_USER tiger

I validated that is present.

$ mkstore -wrl expdp_wallet/ -listCredential

List credential (index: connect_string username)

1: EXPDP_TNS EXPDP_USER

I can connect with the user to the database using the tns defined.

$ sqlplus expdp_user/[email protected]_TNS

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.5.0.0.0

SQL>

When I try to connect using the wallet the connection fails.

$ sqlplus /@EXPDP_TNS

ERROR:

ORA-01017: invalid username/password; logon denied

$ sqlplus /nolog

SQL> connect /@EXPDP_TNS

ERROR:

ORA-01017: invalid username/password; logon denied

I have deleted and recreated the wallet several times, each to no avail, any ideas?

Best Answer

  • user490177
    user490177 Member Posts: 7 Blue Ribbon
    edited Mar 4, 2020 2:29PM Answer ✓

    Figured it out, finally.

    I was using a copy of my sqlnet.ora file which contained ENCRYPTION_WALLET_LOCATION (it was pointing at the correct wallet location) but when I changed it to simply WALLET_LOCATION it worked.

Answers

  • user490177
    user490177 Member Posts: 7 Blue Ribbon
    edited Mar 4, 2020 2:29PM Answer ✓

    Figured it out, finally.

    I was using a copy of my sqlnet.ora file which contained ENCRYPTION_WALLET_LOCATION (it was pointing at the correct wallet location) but when I changed it to simply WALLET_LOCATION it worked.