The ENCRYPTION_MODE parameter specifies the type of security used during export and import operations.
ENCRYPTION_MODE = { DUAL | PASSWORD | TRANSPARENT }
The allowable values and their default settings are explained below:
DUAL: This mode creates a dump file that can be imported using an Oracle Encryption Wallet, or the the ENCRYPTION_PASSWORD specified during the export operation. This is the default setting if the ENCRYPTION_PASSWORD parameter is set and there is an open wallet. PASSWORD: This mode creates a dump file that can only be imported using the ENCRYPTION_PASSWORD specified during the export operation. This is the default setting if the ENCRYPTION_PASSWORD parameter is set and there isn't an open wallet. TRANSPARENT: This mode creates an encrypted dump file using and open Oracle Encryption Wallet. If the ENCRYPTION_PASSWORD is specified while using this mode and error is produced. This is the default setting of only the ENCRYPTION parameter is set.
Wallet setup
cd /u01/app/oracle/admin/chennai/ mkdir wallet Open sqlnet.ora Enter the below value wallet_location=(source=(method=file)(method_data=(directory=/u01/app/oracle/admin/chennai/wallet))) Connect database SQL> alter system set encryption key authenticated by "ORACLE@123"; System altered.
Demo:-
orcl101] expdp scott/tiger tables=emp directory=TEST_DIR dumpfile=emp28.dmp logfile=emp28.log encryption=all encryption_mode=dual ENCRYPTION_PASSWORD=oracle
Export: Release 18.0.0.0.0 – Production on Fri Aug 24 02:43:43 2018
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 – Production
ORA-39002: invalid operation
ORA-39188: unable to encrypt dump file set
ORA-28365: wallet is not open
Login into Database:-
SQL> alter system set encryption key authenticated by “ORACLE@123”;
System altered.
Again try
orcl101] expdp scott/tiger tables=emp directory=TEST_DIR dumpfile=emp29.dmp logfile=emp29.log encryption=all encryption_mode=dual ENCRYPTION_PASSWORD=oracle
Export: Release 18.0.0.0.0 - Production on Fri Aug 24 02:47:59 2018
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Starting "SCOTT"."SYS_EXPORT_TABLE_01": scott/******** tables=emp directory=TEST_DIR dumpfile=emp29.dmp logfile=emp29.log encryption=all encryption_mode=dual ENCRYPTION_PASSWORD=********
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported "SCOTT"."EMP" 0 KB 0 rows
Master table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:
/u01/app/oracle/datapump/emp29.dmp
Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at Fri Aug 24 02:48:02 2018 elapsed 0 00:00:03
Catch Me On:- Hariprasath Rajaram
Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba