3 Replies Latest reply: Sep 10, 2012 5:36 AM by 415289 RSS

    How to create wallet

    583359
      Hi All,

      I have installed oracle 11g R2 11.2.0.1.0 Enterprise Edition database software on my windows 7 64 bit machine and created a database and created a schema under that. My requirement is to create a below table in schema.

      create table mytab(cardno varchar2(50 byte) encrypt);

      but when executing above ddl it giving me below error.

      ORA-28365: wallet is not open

      Please suggest me how to achieve this.

      Regards,
      Bhushan

      Edited by: Bhushan Bagul on Sep 10, 2012 2:34 AM
        • 1. Re: How to create wallet
          Dbb
          Google say

          http://docs.oracle.com/cd/B19306_01/network.102/b14268/asowalet.htm

          http://www.oracle-base.com/articles/10g/transparent-data-encryption-10gr2.php
          • 2. Re: How to create wallet
            Harm Joris ten Napel-Oracle
            Hi Bhushan,

            if you want to setup TDE the wallet will be created automatically if you run the 'alter system' command, do NOT use a precreated wallet for TDE, see:

            note 317311.1      10g R2 New Feature TDE : Transparent Data Encryption

            greetings,

            Harm ten Napel
            • 3. Re: How to create wallet
              415289
              create table mytab(cardno varchar2(50 byte) encrypt);
              ORA-28365: wallet is not open
              below cmd will create wallet with master key.
              alter system set key identified by “password”;

              if you already done with above step then open the wallet as

              alter system set encryption wallet open identified by "wallet_password";

              http://www.oracle.com/technetwork/database/security/advanced-security-11g-whitepaper-133635.pdf

              also note,TDE is separate oracle license product.