{"id":1338,"date":"2016-08-29T10:23:07","date_gmt":"2016-08-29T10:23:07","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1338"},"modified":"2016-08-29T10:23:07","modified_gmt":"2016-08-29T10:23:07","slug":"oracle-aso-tde-%ec%95%94%ed%98%b8%ed%99%94-key-%ea%b4%80%eb%a6%ac-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"https:\/\/haisins.synology.me\/wordpress\/?p=1338","title":{"rendered":"ORACLE ASO TDE \uc554\ud638\ud654 KEY \uad00\ub9ac \ubc29\ubc95"},"content":{"rendered":"

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

1.<\/span> 
\n<\/span><\/span><\/b>wallet password <\/span><\/b>\ubcc0\uacbd<\/span><\/b><\/b><\/p>\n

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

\ubcc0\uacbd\uc804 \uae30\uc874<\/span> wallet <\/span>\ubc31\uc5c5<\/span><\/span><\/p>\n

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

orapki wallet
\nchange_pwd -wallet <\/span>wallet_location<\/span><\/i>
\n[-oldpwd <\/span>password<\/span><\/i> ] [-newpwd <\/span>password<\/span><\/i>]<\/span><\/span><\/b><\/p>\n

orapki
\nwallet change_pwd -wallet \/u01\/app\/wallet -oldpwd oracle -newpwd welcome1<\/span><\/span><\/b><\/p>\n


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

wallet close<\/span>\ud6c4<\/span> (<\/span>old password<\/span><\/b> <\/span>\u2013<\/span><\/b> <\/span>oracle<\/span><\/b>), <\/span><\/span><\/p>\n


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

\ub2e4\uc2dc<\/span> open (<\/span>new
\npassword<\/span><\/b> <\/span>\u2013<\/span><\/b> <\/span>welcome1<\/span><\/b>) <\/span><\/span>\uc2dc\ubd80\ud130 \uc801\uc6a9<\/span><\/p>\n

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

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

2.<\/span> 
\n<\/span><\/span><\/b>Master Key <\/span><\/b>\ubcc0\uacbd<\/span><\/b><\/b><\/p>\n

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

2-1.<\/span>\ubcc0\uacbd\uc804 \uae30\uc874<\/span> wallet <\/span>\ubc31\uc5c5<\/span><\/span><\/p>\n

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

orapki<\/span><\/b>    <\/span>wallet<\/span><\/b>    <\/span>change_pwd<\/span><\/b>   <\/span>-wallet<\/span><\/b>     <\/span>wallet_location<\/span><\/i><\/b>    <\/span>[-oldpwd<\/span><\/b>     <\/span>password<\/span><\/i><\/b>   <\/span>]<\/span><\/b>    <\/span>[-<\/span><\/span><\/b><\/p>\n

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

newpwd <\/span>password<\/span><\/i>]<\/span><\/span><\/b><\/p>\n

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

orapki wallet change_pwd -wallet
\n\/u01\/app\/wallet -oldpwd oracle -newpwd welcome1<\/span><\/span><\/b><\/p>\n

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

2-2. old password<\/span>\ub85c<\/span> wallet close<\/span><\/span><\/p>\n

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

ALTER SYSTEM SET WALLET CLOSE IDENTIFIED BY “<\/span>oracle<\/span>“<\/span><\/span><\/b><\/p>\n

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

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

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

3. Re-Key – wallet<\/span><\/b>\uc758 \ubcc0\uacbd\ub41c \ube44\ubc00\ubc88\ud638\ub97c \uc774\uc6a9<\/span><\/span><\/p>\n

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

alter system set encryption key identified by “<\/span>welcome1<\/span>“;<\/span><\/span><\/b><\/p>\n

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

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

4. Re-Key<\/span><\/b>\ud6c4 \ubcc0\uacbd\ub41c<\/span> Master key<\/span><\/b>\uc758 \ud655\uc778<\/span><\/span><\/p>\n

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

mkstore -wrl wallet_location -list <\/span><\/b><\/p>\n

\u2013 <\/span><\/b>\uc800\uc7a5\ub41c \ubaa8\ub4e0<\/span> master key<\/span><\/b>\uc5d0 \ub300\ud55c \uc815\ubcf4<\/span> <\/span><\/span><\/b><\/p>\n


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

mkstore -wrl
\nwallet_location -viewEntry <\/span><\/span><\/b>ORACLE.SECURITY.DB.ENCRYPTION.MASTERKEY<\/span><\/span><\/b><\/p>\n

– <\/span><\/i><\/b>\ud604\uc7ac \uc0ac\uc6a9\ud558\uace0 \uc788\ub294<\/span> <\/span><\/i><\/b>master key<\/span><\/b>\uc5d0 \ub300\ud55c \uc815\ubcf4<\/span><\/span><\/p>\n

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


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

\ub610\ub294<\/span><\/span><\/p>\n


<\/span><\/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><\/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

orapki wallet display \u2013wallet <\/span>\/u01\/app\/wallet<\/span><\/span><\/span><\/b><\/p>\n


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


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

5. wallet <\/span><\/b>\uc124\uc815<\/span><\/b> Default \/ auto open \/ local auto open<\/span><\/b>:<\/span><\/span><\/p>\n


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


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

DB shutdown -> startup <\/span>\uc2dc \ud655\uc778<\/span><\/span><\/p>\n

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

orapki wallet
\ncreate -wallet wallet_location -auto_login [-pwd password] <\/span><\/span><\/p>\n

orapki wallet create -wallet \/u01\/app\/wallet -auto_login -pwd
\nwelcome1<\/span><\/span><\/span><\/p>\n

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


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


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


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


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

To create a local auto login wallet, use the
\nfollowing command:<\/span><\/span><\/p>\n

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

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

orapki wallet
\ncreate -wallet wallet_location -auto_login_local [-pwd password] <\/span><\/span><\/p>\n

orapki wallet create -wallet \/u01\/app\/wallet
\n-auto_login_local -pwd welcome1<\/span><\/span><\/span><\/p>\n

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

oracle@:\/u01\/app\/wallet<\/span> <\/span><\/a><\/span>$<\/span> <\/span>ls -alrt<\/span> <\/span>cwallet.sso  <\/span>\uad8c\ud55c<\/span><\/b> <\/span>600,<\/span><\/b> <\/span>\ubc31\uc5c5<\/span><\/span><\/b><\/p>\n

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

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

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

6.<\/span>   <\/span><\/span><\/b>wallet Recovery<\/span><\/b>:<\/span><\/b><\/p>\n

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

6-1.<\/span>   
\n<\/span><\/span><\/b>Wallet close <\/span><\/b>\ud6c4<\/span><\/b> ewallet.p12 <\/span><\/b>\uc0ad\uc81c<\/span><\/b><\/b><\/p>\n

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

–<\/span>       <\/span><\/span>DB shutdown \/ startup <\/span>\ud6c4 \ub370\uc774\ud0c0 \uc870\ud68c<\/span><\/p>\n

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

–<\/span>       <\/span><\/span>\ubc31\uc5c5\ubc1b\uc740<\/span> ewallet.p12 <\/span>\ub85c \ubcf5\uad6c<\/span><\/p>\n


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

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

6-2.<\/span>  <\/span>Wallet open <\/span><\/span><\/b>\ub41c
\n\uc0c1\ud0dc\uc5d0\uc11c<\/span><\/b> ewallet.p12 <\/span><\/b>\uc0ad\uc81c<\/span><\/span><\/b><\/p>\n

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

–<\/span>         
\n<\/span><\/span>DB shutdown \/ startup <\/span>\ud6c4
\n\ub370\uc774\ud0c0 \uc870\ud68c<\/span><\/p>\n

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

–<\/span>       <\/span><\/span>\ubc31\uc5c5\ubc1b\uc740<\/span> ewallet.p12 <\/span>\ub85c \ubcf5\uad6c<\/span><\/p>\n

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

6-3.<\/span>   
\n<\/span><\/span><\/b>Local auto open <\/span><\/b>\uc73c\ub85c \uc804\ud658 \ud6c4<\/span><\/b> cwallet.sso <\/span><\/b>\uc0ad\uc81c<\/span><\/b><\/b><\/p>\n

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

–<\/span>       <\/span><\/span>Auto login \/ local auto login <\/span>\uc73c\ub85c \ubcc0\uacbd\uc744 \uc704\ud574\uc11c\ub294 \ube44\ubc00\ubc88\ud638\uac00 \ucd5c\uc18c <\/span>8 <\/span>\uc790\ub9ac \uc774\uc0c1\uc774\uc5b4\uc57c \ud568<\/span>.<\/span><\/span><\/p>\n

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

–<\/span>       <\/span><\/span>DB shutdown \/ startup <\/span>\ud6c4 \ub370\uc774\ud0c0 \uc870\ud68c<\/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><\/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><\/span>\ubc31\uc5c5\ubc1b\uc740<\/span> ewallet.p12 <\/span>\ub85c \ubcf5\uad6c \ud6c4<\/span> local auto open <\/span>\uc73c\ub85c
\n\ubcc0\uacbd<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

  1.  wallet password \ubcc0\uacbd   \ubcc0\uacbd\uc804 \uae30\uc874 wallet \ubc31\uc5c5   orapki wallet change_pwd -wallet wallet_location [-oldpwd password ] [-newpwd password] orapki wallet change_pwd -wallet \/u01\/app\/wallet -oldpwd oracle -newpwd welcome1 wallet close\ud6c4 (old password \u2013 oracle),  \ub2e4\uc2dc open (new password \u2013 welcome1) \uc2dc\ubd80\ud130 \uc801\uc6a9     2.  Master Key \ubcc0\uacbd   2-1.\ubcc0\uacbd\uc804 \uae30\uc874 wallet \ubc31\uc5c5   […]<\/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,765],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1338"}],"collection":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1338"}],"version-history":[{"count":0,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1338\/revisions"}],"wp:attachment":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1338"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1338"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1338"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}