Overview

This document explains how to use the Tibero Wallet feature to automatically authenticate and connect without entering a password in the tbsql, tbloader, tbexport, and tbimport utilities.

It also summarizes the Wallet setup methods and application procedures for each utility based on test scenarios.

Method

Test Scenario Overview

The Wallet operation is verified through the following scenarios.

1. Confirm Wallet creation and automatic connection in tbsql.

2. Perform data loading with tbloader using the same Wallet.

3. Create a dedicated Wallet for tbexport/tbimport and perform export/import.

4. Check normal operation at each step.

    

tbsql – Wallet Creation and Automatic Connection Method

Environment Variable Setup (tbsql only)

export ISQL_WALLET_PATH=/home/test7/wallet.dat
. ~/.bash_profile

Wallet Creation (SAVE CREDENTIAL)

[test7@TestServer ~]$ tbsql

Enter Username: sys
Enter Password:
Connected to Tibero.

SQL> save credential;
Complete to generate the wallet file.
SQL> exit

Wallet file creation results:

• A wallet.dat file is created.

• The file is stored in an encrypted binary format.

Confirm Wallet Automatic Connection

[test7@TestServer ~]$ tbsql
Connected to Tibero.

SQL> ls user;

Confirm that connection occurs without password input.

tbloader – Data Loading Method with Wallet Applied

Environment Variable Setup (tbloader only)

export LR_WALLET_PATH=/home/test7/wallet.dat
. ~/.bash_profile

Prerequisites

The following must be prepared in advance when using tbloader.

• tbloader does not automatically create tables.

• Target tables must be created in advance with DDL.

create table TEST.SALES2 (
  id       number,
  name     varchar2(50),
  amount   number,
  reg_date date
);

Execute tbloader

[test7@TestServer ~]$ tbloader errors=0 data=sales.dat log=sales.log control=sales.ctl direct=y

tbLoader 7
Start loading...
Committed and Completed successfully.

Check Loading Results

SQL> select * from TEST.SALES2 order by id;

Confirm that data loading is successfully performed with Wallet applied.

tbexport / tbimport – Wallet Application Method

Environment Variable Setup (exp/imp only)

export EXPIMP_WALLET=/home/test7/.expimp_wallet
. ~/.bash_profile

Initial tbexport Execution (For Wallet Creation)

tbexport username=sys password=test file=test.dmp table=test.sales2 log=test_exp.log port=5555 sid=test7 save_credential=/home/test7/.expimp_wallet

Wallet creation results:

• A dedicated Wallet file for exp/imp is created.

• Password input is required only once initially.

Subsequent tbexport Execution (Without Password)

tbexport file=test.dmp table=test.sales2 log=test_exp.log port=5555 sid=test7

Confirm that export executes successfully.

Execute tbimport

DROP TABLE TEST.SALES2;

tbimport file=test.dmp table=test.sales2 log=test_imp.log port=5555 sid=test7

Confirm that import completes successfully.

Check Import Results

SQL> select * from TEST.SALES2 order by id;

Confirm that data is restored correctly.

Note

• Wallet files are stored in encrypted binary format.

• The Wallet feature is for automatic password authentication.

• Wallet environment variable settings may differ for each utility.