Skip to content

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.



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 – 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 – 64bit
With the Partitioning, OLAP and Data Mining options
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:
Job “SCOTT”.”SYS_EXPORT_TABLE_01″ successfully completed at 14:52:47.

One Comment Post a comment

Trackbacks & Pingbacks

  1. 2010 in review « DBA

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: