Passwordless Data Pump 19c

Franck Pachot
Jul 16 · 3 min read

Example

mkstore -wrl $ORACLE_HOME/network/admin -create <<CREATE
w4ll3t-P455w0rd
w4ll3t-P455w0rd
CREATE
cat >> $ORACLE_HOME/network/admin/tnsnames.ora  <<CAT
CDB1A_SYSTEM=(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=CDB1A))(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
CAT
mkstore -wrl $ORACLE_HOME/network/admin -createCredential \
CDB1A_SYSTEM SYSTEM <<CREATE
user-P455w0rd
user-P455w0rd
w4ll3t-P455w0rd
CREATE
mkstore -wrl $ORACLE_HOME/network/admin -createCredential \
//localhost/PDB1?_user=system SYSTEM <<CREATE
user-P455w0rd
user-P455w0rd
w4ll3t-P455w0rd
CREATE
cat >> $ORACLE_HOME/network/admin/sqlnet.ora <<'CAT'
WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY="$ORACLE_HOME/network/admin")))
SQLNET.WALLET_OVERRIDE=TRUE
CAT
connect /@CDB1A_SYSTEM
show user
show con_name
connect /@//localhost/PDB1?_user=system
show user
show con_name

Data Pump expdp/impdp

expdp /@CDB1A_SYSTEM

‘“/ as sysdba”’

expdp '"/ as sysdba"'

Fixed in 20.1

Franck Pachot

Written by

https://twitter.com/FranckPachot DBA at CERN, Oracle OCM 12c, Oracle ACE Director, Oak Table member. My 499 posts at dbi-services: http://blog.dbi.pachot.net

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade