[ORACLE] WALLET OPEN 방법

1. vi $ORACLE_HOME/network/admin/sqlnet.ora (sqlnet.ora 파일 열기)

[oracle12@localhost ~]$ vi $ORACLE_HOME/network/admin/sqlnet.ora
# sqlnet.ora Network Configuration File: /home/oracle12/db/product/12.1.0/dbhome_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
ENCRYPTION_WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/home/oracle12/db/product/12.1.0/dbhome_1/network/admin/WALLET)))

 

2. 아래의 내용을 추가 (1번에 첨부한 예시처럼 작성)

ENCRYPTION_WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=wallet 경로 입력)))

 

3. db boot 후 wallet OPEN

ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY “pw입력”;

ALTER SYSTEM SET WALLET OPEN IDENTIFIED BY “pw입력”;

 

4. 입력한 경로에 ewallet.p12 파일이 생성 됨