{"id":1337,"date":"2016-08-29T10:18:06","date_gmt":"2016-08-29T10:18:06","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1337"},"modified":"2016-08-29T10:18:06","modified_gmt":"2016-08-29T10:18:06","slug":"oracle-aso-tde-%ec%84%a4%ec%a0%95-%eb%b0%a9%eb%b2%95-%ec%b4%88%ea%b8%b0%ec%84%b8%ed%8c%85","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1337","title":{"rendered":"ORACLE ASO TDE \uc124\uc815 \ubc29\ubc95 – \ucd08\uae30\uc138\ud305"},"content":{"rendered":"

 <\/span><\/p>\n

 <\/span><\/p>\n

1. Transparent Data Encryption <\/span><\/b>\uc124\uc815\uc758 \ud655\uc778<\/span><\/span><\/span><\/b><\/p>\n

<\/span><\/span><\/span><\/span><\/span><\/p>\n


<\/span><\/p>\n

ORACLE@:\/HOME\/ORACLE <\/span><\/p>\n

# connect \/ as sysdba Connected.<\/span><\/span><\/p>\n

SQL> select * from v$option where parameter
\nlike ‘%Transparent%’;<\/span><\/span><\/p>\n

 <\/span><\/p>\n

 <\/span><\/p>\n

PARAMETER VALUE<\/span><\/span><\/p>\n

 <\/span><\/p>\n

————————————————
\n———-<\/span><\/span><\/p>\n

 <\/span><\/p>\n

Transparent Application Failover TRUE<\/span><\/span><\/p>\n

 <\/span><\/p>\n

Transparent Data Encryption TRUE<\/span><\/span><\/p>\n


<\/span><\/p>\n

 <\/span><\/p>\n

 <\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

 <\/span>2. Wallet<\/span><\/b>\uc758 \uc0dd\uc131<\/span><\/b><\/p>\n

<\/p>\n

<\/span><\/p>\n

 <\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

$ORACLE_HOME\/network\/admin <\/span>\uc758<\/span> sqlnet.ora <\/span>\ud30c\uc77c\uc744 \uc5f4\uace0<\/span> ENCRYPTION_WALLET_LOCATION <\/span>\ud30c\ub77c\ubbf8\ud130\uc5d0<\/span> Wallet<\/span>\uc774
\n\uc0dd\uc131\ub420 \uc704\uce58\ub97c<\/span> <\/span>\uc9c0\uc815\ud569\ub2c8\ub2e4<\/span>. Default DIR = \/u01\/app\/wallet <\/span>\uc9c0\uc815<\/span>, TEST <\/span>\uc2dc \uc784\uc758\ub85c \ubcc0\uacbd\ud558\uc154\ub3c4 \uc0c1\uad00<\/span><\/span><\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

 <\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

\uc5c6\uc2b5\ub2c8\ub2e4<\/span>. (<\/span>\ucc38\uace0<\/span>: <\/span>\ucd5c\ucd08
\n\uc0dd\uc131\uc2dc \uc124\uc815 \ud6c4<\/span> DB
\nRestart <\/span>\ud544\uc694<\/span>)<\/span><\/span><\/p>\n


<\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

<\/span><\/span><\/span><\/span><\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

[oracle@ora11g admin]$ more sqlnet.ora<\/span><\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

 <\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

ENCRYPTION_WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DI<\/span><\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

 <\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

RECTORY=\/u01\/app\/wallet)))<\/span><\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

<\/span><\/span><\/span><\/span><\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

 <\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

ALTER SYSTEM <\/span>\ubb38\uc73c\ub85c<\/span> Wallet<\/span>\uc744
\n\uc0dd\uc131\ud569\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

 <\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

[oracle@ora11g admin]$ sqlplus \/ as sysdba<\/span><\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

 <\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

Connected.<\/span><\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

 <\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

SQL> alter system set encryption key
\nidentified by “<\/span>oracle<\/span><\/b>“;<\/span><\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

 <\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

System altered.<\/span><\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

 <\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

 <\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

ENCRYPTION_WALLET_LOCATION <\/span>\ud30c\ub77c\ubbf8\ud130\ub85c \uc124\uc815\ub41c \uc704\uce58\uc5d0<\/span> Wallet<\/span>\uc774<\/span><\/span><\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

 <\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

\uc0dd\uc131\ub418\uc5c8\uc74c\uc744 \ud655\uc778\ud569\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

<\/span><\/span><\/span><\/span><\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

[oracle@ora11g ~]$ cd \/u01\/app\/wallet\/<\/span><\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

 <\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

[oracle@ora11g wallet]$ ls<\/span><\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

 <\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

ewallet.p12 <\/span><\/p>\n

\ubc18\ub4dc\uc2dc \ubc31\uc5c5\uc744 \ubc1b\uc544\ub46c\uc57c \ud568<\/span><\/b>!!<\/span><\/span><\/b><\/p>\n

<\/p>\n

<\/span><\/p>\n

 <\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

\uc554\ud638\ud654\ub41c \ud14c\uc774\ube14\uc744 \uc0ac\uc6a9\ud558\ub294
\n\ubaa8\ub4e0 \uc791\uc5c5\uc740<\/span> Wallet<\/span>\uc774<\/span> Open<\/span>\ub41c \uc0c1\ud0dc\ub85c \uc9c4\ud589\ub418\uc5b4\uc57c<\/span> <\/span>\ud558\uba70<\/span>, Database<\/span>\ub97c<\/span> Restart<\/span>\ud558\uba74
\n\uae30\ubcf8\uc801\uc73c\ub85c<\/span> Wallet<\/span>\uc740<\/span> Close <\/span>\uc0c1\ud0dc\uc785\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

 <\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

Wallet<\/span>\uc744<\/span> Open\/Close<\/span>\ud558\ub294
\n\uba85\ub839\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n


<\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

<\/span><\/span><\/span><\/span><\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

[oracle@ora11g
\n~]$ sqlplus \/ as sysdba Connected.<\/span><\/span><\/p>\n


<\/span><\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

SQL> alter system set wallet close identified
\nby “oracle<\/b>“;<\/span><\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

 <\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

System altered.<\/span><\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

 <\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

SQL> alter system set wallet open identified
\nby “oracle<\/b>“;<\/span><\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

 <\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

System altered.<\/span><\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

 <\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

 <\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

Wallet<\/span>\uc758 \ud604\uc7ac \uc0c1\ud0dc\ub97c \ubcf4\ub824\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 \uc870\ud68c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n


<\/span><\/p>\n

 <\/span><\/p>\n

SQL> select * from v$encryption_wallet;<\/span><\/span><\/p>\n

 <\/span><\/p>\n

WRL_TYPE<\/span><\/span><\/p>\n

 <\/span><\/p>\n

——————–<\/span><\/span><\/p>\n

 <\/span><\/p>\n

WRL_PARAMETER<\/span><\/span><\/p>\n

 <\/span><\/p>\n

——————————————————————————–<\/span><\/span><\/p>\n

 <\/span><\/p>\n

STATUS<\/span><\/span><\/p>\n

 <\/span><\/p>\n

——————<\/span><\/span><\/p>\n

 <\/span><\/p>\n

file<\/span><\/span><\/p>\n

 <\/span><\/p>\n

\/u01\/app\/wallet<\/span><\/span><\/p>\n

 <\/span><\/p>\n

OPEN<\/span><\/span><\/p>\n

 <\/span><\/p>\n

 <\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/span><\/p>\n

 <\/span><\/p>\n


<\/span><\/p>\n


<\/span><\/p>\n


<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

    1. Transparent Data Encryption \uc124\uc815\uc758 \ud655\uc778 ORACLE@:\/HOME\/ORACLE  # connect \/ as sysdba Connected. SQL> select * from v$option where parameter like ‘%Transparent%’;     PARAMETER VALUE   ———————————————— ———-   Transparent Application Failover TRUE   Transparent Data Encryption TRUE      2. Wallet\uc758 \uc0dd\uc131   $ORACLE_HOME\/network\/admin \uc758 sqlnet.ora \ud30c\uc77c\uc744 \uc5f4\uace0 ENCRYPTION_WALLET_LOCATION \ud30c\ub77c\ubbf8\ud130\uc5d0 Wallet\uc774 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[336],"tags":[760,761,762,763,764],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1337"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1337"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1337\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1337"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1337"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1337"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}