ORA-28365: wallet is not open:
One should be careful in securing the key and i think data can not be viewed unless we have the right key and wallet is open with right key.
Please do check with oracle online documentation all the time... its good.
SQL> select * from tde_test;
select * from tde_test
*
ERROR at line 1:
ORA-28365: wallet is not open
SQL> conn sys as sysdba
Enter password:
Connected.
SQL> desc dba_wallets;
ERROR:
ORA-04043: object dba_wallets does not exist
SQL> desc dba_wallet_acls;
Name Null? Type
----------------------------------------- -------- ----------------------------
WALLET_PATH NOT NULL VARCHAR2(1000)
ACL VARCHAR2(4000)
ACLID NOT NULL RAW(16)
SQL> select * from dba_wallet_Acls;
no rows selected
SQL>
SQL> desc v$encryption_Wallet;
Name Null? Type
----------------------------------------- -------- ----------------------------
WRL_TYPE VARCHAR2(20)
WRL_PARAMETER VARCHAR2(4000)
STATUS VARCHAR2(18)
SQL> select * from v$encryption_wallet;
WRL_TYPE
--------------------
WRL_PARAMETER
--------------------------------------------------------------------------------
STATUS
------------------
file
F:\app\HOME\admin\orcl\encryption_wallet/
CLOSED
SQL> desc v$wallet;
Name Null? Type
----------------------------------------- -------- ----------------------------
CERT_ID VARCHAR2(52)
DN VARCHAR2(255)
SERIAL_NUM VARCHAR2(40)
ISSUER VARCHAR2(255)
KEYSIZE NUMBER
STATUS VARCHAR2(16)
SQL> select * from v$wallet;
no rows selected
SQL> alter system set wallet open identified by "wrongpassword";
alter system set wallet open identified by "1myPassword"
*
ERROR at line 1:
ORA-28353: failed to open wallet
SQL> alter system set wallet open identified by "correctpassword";
System altered.
SQL> conn test/test;
SQL> select * from tde_test;
ID DATA
---------- --------------------------------------------------
1 It is a secret and can not be shown unless wallet is open!
SQL>
SQL>
Please note: wallet should be open each time the db is restarted.
One can close the wallet with alter command : ALTER SYSTEM SET WALLET CLOSE;
DBA personal should remember the key or should keep the key safe...
-- Have a fun working in oracle technologies.. Cheers....
15 years 3 months + of experience in database administration, performance engineering and software cost optimization. Expert in architecture of large scale product, service features in product developments and several POCs executions. Specialty in Database administration, Database Performance, SQL, PLSQL, Shell, Simple solutions for Designing Performance engineering solutions, actively working on Software Cost Optimization in CLOUD. Always ready for new challenges with simple solutions
Wednesday, December 28, 2011
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment