ORA-28365: wallet is not open
When i try to make export one table using datapump with encryption_password parameter , It shows following error.
ORA-39001: invalid argument value
ORA-39180: unable to encrypt ENCRYPTION_PASSWORD
ORA-28365: wallet is not open
So i try to fix this error,
Create folder for wallet in $ORACLE_BASE/admin/SID/wallet
and then go to add it this below statement to sqlnet.ora file.
WALLET_LOCATION = (SOURCE=
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY=D:\oracle\product\10.2.0\admin\ACE\wallet)
)))
then
SQL> alter system set key identified by test;
sytem altered.
Now you can able to using encryption_password parameter.
C:\Documents and Settings\Administrator>EXPDP SCOTT/TIGER@ace DIRECTORY=TEST ENC
RYPTION_PASSWORD=test tables=test
Export: Release 10.2.0.1.0 – 64bit Production on Sunday, 28 March, 2010 14:52:34
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – 64bit
Production
With the Partitioning, OLAP and Data Mining options
Starting “SCOTT”.”SYS_EXPORT_TABLE_01″: SCOTT/********@ace DIRECTORY=TEST ENCRY
PTION_PASSWORD=********* tables=*********
Estimate in progress using BLOCKS method…
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported “SCOTT”.”TEST” 5.664 KB 4 rows
Master table “SCOTT”.”SYS_EXPORT_TABLE_01″ successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:
H:\TEST\EXPDAT.DMP
Job “SCOTT”.”SYS_EXPORT_TABLE_01″ successfully completed at 14:52:47.
Trackbacks & Pingbacks