Document Type | Technical Information
Category | Security
Applicable Product Versions | T6FS07, T7FS02, T7FS02PS
Document Number | TSETI010
Overview
This provides notes on using the DBMS Wallet.
Method
1. Changing the wallet open syntax
From Tibero6 FS07 onwards, single quotes must be used instead of double quotes when opening the wallet.
| Tibero Version | wallet open syntax |
| Before Tibero6 FS07 | SQL> alter system set encryption wallet open identified by "wallet"; System altered. |
| After Tibero6 FS07 | SQL> alter system set encryption wallet open identified by "wallet"; TBR-12069: Failed to open wallet.
SQL> alter system set encryption wallet open identified by 'wallet'; System altered. |
2. View to check wallet status
View to check the current status of the wallet: V$ENCRYPTION_WALLET
| wallet status | Example |
| wallet open status | SQL> select * from v$encryption_wallet;
WRL_TYPE WRL_PARAMETER STATUS ----------- --------------------------- ---------- FILE /home/tib6/wallet OPEN |
| wallet close status | SQL> select * from V$ENCRYPTION_WALLET;
WRL_TYPE WRL_PARAMETER STATUS ----------- --------------------------- ---------- FILE /home/tib6/wallet CLOSED |
3. Check script syntax when using tbexport
When extracting syntax with tbexport script=y for encrypted tablespaces, the “DEFAULT STORAGE (ENCRYPT)” part is omitted. If you need to use the script, you must add an option separately before executing.
(From Tibero7 FS02 PS04 onwards, extraction occurs without omission)
| Example | |
Actual creation syntax | SQL> create tablespace ts_wallet datafile '/home/tibero7/tbdata/ts_wallet.dtf' size 10M encryption using 'AES256' default storage (encrypt);
Tablespace 'TS_WALLET' created.
|
| Creation syntax via tbexport | $ tbexport full=y script=y
### When checking the extracted script, DEFAULT STORAGE (ENCRYPT) is omitted CREATE TABLESPACE "TS_WALLET" DATAFILE '/home/tib6/tbdata/ts_wallet.dtf' SIZE 10485760 EXTENT MANAGEMENT LOCAL AUTOALLOCATE ENCRYPTION USING 'AES256' /
### Executing this syntax as is results in a General syntax error SQL> CREATE TABLESPACE "TS_WALLET" DATAFILE '/home/tib6/tbdata/ts_wallet.dtf' SIZE 10485760 EXTENT MANAGEMENT LOCAL AUTOALLOCATE ENCRYPTION USING 'AES256' / TBR-7001: General syntax error. at line 1, column 142 of null: MANAGEMENT LOCAL AUTOALLOCATE ENCRYPTION USING 'AES256'
|