Error While Restore Oracle Database - ORA-28365: wallet is not open

ORA-39083: Object type TABLE:"DBNAME" failed to create with error:
ORA-28365: wallet is not open

SQL Error: ORA-28367: wallet does not exist
28367. 0000 -  "wallet does not exist"
*Cause:    The Oracle wallet has not been created or the wallet location
           parameters in sqlnet.ora specifies an invalid wallet path.
*Action:   Verify that the WALLET_LOCATION or the ENCRYPTION_WALLET_LOCATION
           parameter is correct and that a valid wallet exists in the path
           specified

Problem : I was trying to restore the database on Oracle machine. Then it is giving above mention error. Since i resolved the problem months ago and not remember accurately, the sequence of error i faced.

Solution :

I performed below steps while fixing above problem

1. Please add below in sqlnet.ora and restarted the services

-------------------------

SQLNET.AUTHENTICATION_SERVICES= (NONE) 

--which was NTS earlier

WALLET_LOCATION =

   (SOURCE =

     (METHOD = FILE)

     (METHOD_DATA =

       (DIRECTORY = C:\app\oracle\admin\<sid>\wallet)

     )

   )

SQLNET.WALLET_OVERRIDE = False

SSL_CLIENT_AUTHENTICATION = FALSE

SSL_VERSION = 0

-----------------------------

2.Confirm the follwing content should be present in tnsname.ora 

NEAORACLE =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = **hostname**)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = <sid>)

    )

  )

  

3. Create folder wallet in this path (C:\app\oracle\admin\<sid>\)and give full access to ewallet file by right clicking on it properties>security

4. Execute following query in sys db

select * from v$encryption_wallet; --- here wallet_type is unknown and status  is not open

administer key management set keystore close; -- to make it wallet type as  password

administer key management set keystore open identified by admin_123;--it will create ewallet file

administer key management set key identified by admin_123 with backup;--change password then in import utility  use ENCRYPTION_PASSWORD=admin_123--use password which u set for key

5. open cmd ,set sid and execute following command to import table into existing db

   

   impdp sys/password@<sid> DIRECTORY=Source_dmp ENCRYPTION_PASSWORD=<pwd> DUMPFILE=<dumpname> TABLES=<tname> PARALLEL=8 EXCLUDE=INDEX remap_schema=<originalSchema>:<remapSchema> remap_tablespace=<originalTablespace>:<remapTablespace> exclude=statistics