Skip to content
Advertisements

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.

Advertisements
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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: