{"id":1595,"date":"2018-01-23T17:58:06","date_gmt":"2018-01-23T08:58:06","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1595"},"modified":"2018-01-23T18:48:15","modified_gmt":"2018-01-23T09:48:15","slug":"oracle-12c-r2-aso-%eb%8a%94-aria-%ea%b3%bc-seed-%eb%b0%a9%ec%8b%9d-%ec%a7%80%ec%9b%90-%ea%b0%80%eb%8a%a5","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1595","title":{"rendered":"Oracle 12c R2 ASO \ub294 ARIA \uacfc SEED \ubc29\uc2dd \uc9c0\uc6d0 \uac00\ub2a5"},"content":{"rendered":"

Oracle DB 12C Release 2 \ubc84\uc804 \ubd80\ud130 Oracle ASO ( Advanced Security Option \u2013 \uad6c Oracle TDE ) \uc758 \uae30\ub2a5\uc744 \uc774\uc6a9 \ud558\uba74<\/p>\n

DB \uc554\ud638\ud654 \uc2dc \ud55c\uad6d\uc758 \ub300\ud45c \uc54c\uace0\ub9ac\uc998\uc778 ARIA \ubc29\uc2dd\uacfc SEED \ubc29\uc2dd \uc9c0\uc6d0\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4. (Oracle 12C Release 1\uc740 \ubd88\uac00)<\/p>\n

<\uc9c0\uc6d0\uc5ec\ubd80 \ud655\uc778><\/p>\n

\"\"<\/p>\n

\ubcf8 \ud658\uacbd\uc740 \ub9ac\ub205\uc2a4 \ud658\uacbd \uc5d0\uc11c \ud14c\uc2a4\ud2b8 \ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n

    \n
  1. \n
    Sqlnet.ora \uc138\ud305\ud569\ub2c8\ub2e4.
    \n<\/span><\/div>\n<\/li>\n<\/ol>\n
    \n\n\n<\/colgroup>\n\n\n\n
    ENCRYPTION_WALLET_LOCATION =
    \n<\/span><\/p>\n

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

    (METHOD_DATA =
    \n<\/span><\/p>\n

    (DIRECTORY = \/oracle\/oracle12\/app\/oracle\/admin\/oracle12\/wallet)
    \n<\/span><\/p>\n

    ) )<\/span><\/td>\n<\/tr>\n

    \"\"<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
      \n
    1. \n
      ASO \uc554\ud638\ud654 \ud0a4\ub97c \ub9cc\ub4ed\ub2c8\ub2e4.
      \n<\/span><\/div>\n<\/li>\n<\/ol>\n
      \n\n\n<\/colgroup>\n\n\n\n
      # mkdir \/oracle\/oracle12\/app\/oracle\/admin\/oracle12\/wallet
      \n<\/span><\/p>\n

      # sqlplus system\/oracle as syskm
      \n<\/span><\/p>\n

      SQL> ADMINISTER KEY MANAGEMENT CREATE KEYSTORE ‘\/oracle\/oracle12\/app\/oracle\/admin\/oracle12\/wallet’ IDENTIFIED BY oracle;
      \n<\/span><\/p>\n

      SQL> host ls -al \/oracle\/oracle12\/app\/oracle\/admin\/oracle12\/wallet
      \n<\/span><\/td>\n<\/tr>\n

      \"\"<\/p>\n

      \"\"<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

        \n
      1. \n
        ASO \uc554\ud638\ud654 \ud0a4\ub97c OPEN \ud569\ub2c8\ub2e4.
        \n<\/span><\/div>\n<\/li>\n<\/ol>\n
        \n\n\n<\/colgroup>\n\n\n\n
        # mkdir \/oracle\/oracle12\/app\/wallet
        \n<\/span><\/p>\n

        # sqlplus system\/oracle as syskm
        \n<\/span><\/p>\n

        SQL> ADMINISTER KEY MANAGEMENT CREATE KEYSTORE ‘\/oracle\/oracle12\/app\/wallet’ IDENTIFIED BY oracle;
        \n<\/span><\/p>\n

        SQL> ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY oracle WITH BACKUP USING ’emp_key_backup’ ;
        \n<\/span><\/td>\n<\/tr>\n

        \"\"<\/p>\n

        \"\"<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

          \n
        1. \n
          \ud14c\uc2a4\ud2b8 \ud560 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc640 \uc720\uc800\ub97c \ub9cc\ub4ed\ub2c8\ub2e4.
          \n<\/span><\/div>\n<\/li>\n<\/ol>\n
          \n\n\n<\/colgroup>\n\n\n\n
          SQL> CREATE TABLESPACE ASO_TEST DATAFILE ‘\/oracle\/oracle12\/oradata\/oracle12\/aso_test01.dbf’ SIZE 400M
          \n<\/span><\/p>\n

          2 LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
          \n<\/span><\/p>\n

          SQL> CREATE USER ASO_TEST IDENTIFIED BY ASO_TEST ;
          \n<\/span><\/p>\n

          SQL> GRANT CONNECT, RESOURCE TO ASO_TEST ;
          \n<\/span><\/p>\n

          SQL> ALTER USER ASO_TEST DEFAULT TABLESPACE ASO_TEST ;
          \n<\/span><\/p>\n

          SQL> ALTER USER ASO_TEST QUOTA UNLIMITED ON ASO_TEST ;<\/span><\/td>\n<\/tr>\n

          \"\"<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

          \n

            \n
          1. \n
            \uc554\ud638\ud654 \uceec\ub7fc\uc774 \ud3ec\ud568\ub41c \uc554\ud638\ud654 \ud14c\uc774\ube14\uc744 \uad6d\uc0b0 \uc554\ud638\ud654 \uc54c\uace0\ub9ac\uc998 ARIA , SEED \ubc29\uc2dd\uc73c\ub85c \ub9cc\ub4e4\uc5b4 \ubd05\ub2c8\ub2e4. < \ud14c\uc774\ube14 \ubc29\uc2dd \uc554\ud638\ud654 \ud14c\uc2a4\ud2b8 >
            \n<\/span><\/div>\n<\/li>\n<\/ol>\n
            \n\n\n<\/colgroup>\n\n\n\n
            SQL> conn ASO_TEST\/ASO_TEST
            \n<\/span><\/p>\n

            SQL> create table employee (
            \n<\/span><\/p>\n

            2 first_name varchar2(128),
            \n<\/span><\/p>\n

            3 last_name varchar2(128),
            \n<\/span><\/p>\n

            4 empid number,
            \n<\/span><\/p>\n

            5 salary number(6) encrypt using ‘ARIA128’);
            \n<\/span><\/p>\n

            SQL> create table employee1 (
            \n<\/span><\/p>\n

            2 first_name varchar2(128),
            \n<\/span><\/p>\n

            3 last_name varchar2(128),
            \n<\/span><\/p>\n

            4 empid number,
            \n<\/span><\/p>\n

            5 salary number(6) encrypt using ‘SEED128’);
            \n<\/span><\/p>\n

            SQL> create table employee2 (
            \n<\/span><\/p>\n

            2 first_name varchar2(128),
            \n<\/span><\/p>\n

            3 last_name varchar2(128),
            \n<\/span><\/p>\n

            4 empid number,
            \n<\/span><\/p>\n

            5 salary number(6) encrypt using ‘3DES168’);
            \n<\/span><\/p>\n

            SQL> create table employee4 (
            \n<\/span><\/p>\n

            2 first_name varchar2(128),
            \n<\/span><\/p>\n

            3 last_name varchar2(128),
            \n<\/span><\/p>\n

            4 empid number,
            \n<\/span><\/p>\n

            5 salary number(6) encrypt);<\/span><\/td>\n<\/tr>\n

            \"\"<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
              \n
            1. \n
              \uc554\ud638\ud654\ub41c \ud14c\uc774\ube14\uc758 \uc0c1\ud0dc\ub97c \uc870\ud68c\ud574 \ubd05\ub2c8\ub2e4.(SYSDBA)
              \n<\/span><\/div>\n<\/li>\n<\/ol>\n
              \n\n\n<\/colgroup>\n\n\n\n
              SQL> SET LINESIZE 200
              \n<\/span><\/p>\n

              SQL> COL OWNER FORMAT A10
              \n<\/span><\/p>\n

              SQL> COL TABLE_NAME FORMAT A20
              \n<\/span><\/p>\n

              SQL> COL COLUMN_NAME FORMAT A20
              \n<\/span><\/p>\n

              SQL> COL ENCRYPTION_ALG FORMAT A40
              \n<\/span><\/p>\n

              SQL> SELECT * FROM DBA_ENCRYPTED_COLUMNS;<\/span><\/td>\n<\/tr>\n

              \"\"<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

              \n

                \n
              1. \n
                \uc554\ud638\ud654\ub41c \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\ub97c \ub9cc\ub4ed\ub2c8\ub2e4. ( \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \uc554\ud638\ud654 \ud14c\uc2a4\ud2b8 )
                \n<\/span><\/div>\n<\/li>\n<\/ol>\n
                \n\n\n<\/colgroup>\n\n\n\n
                CREATE TABLESPACE “UNIONE_ENC_ARIA”
                \n<\/span><\/p>\n

                DATAFILE ‘\/oracle\/oracle12\/oradata\/oracle12\/UNIONE_ENC_ARIA.dbf’
                \n<\/span><\/p>\n

                SIZE 400M
                \n<\/span><\/p>\n

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

                EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
                \n<\/span><\/p>\n

                ENCRYPTION USING ‘ARIA128’ DEFAULT STORAGE(ENCRYPT);
                \n<\/span><\/p>\n

                CREATE TABLESPACE “UNIONE_ENC_SEED”
                \n<\/span><\/p>\n

                DATAFILE ‘\/oracle\/oracle12\/oradata\/oracle12\/UNIONE_ENC_SEED.dbf’
                \n<\/span><\/p>\n

                SIZE 400M
                \n<\/span><\/p>\n

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

                EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
                \n<\/span><\/p>\n

                ENCRYPTION USING ‘SEED128’ DEFAULT STORAGE(ENCRYPT);
                \n<\/span><\/p>\n

                CREATE TABLESPACE “UNIONE_ENC_AES”
                \n<\/span><\/p>\n

                DATAFILE ‘\/oracle\/oracle12\/oradata\/oracle12\/UNIONE_ENC_AES.dbf’
                \n<\/span><\/p>\n

                SIZE 400M
                \n<\/span><\/p>\n

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

                EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
                \n<\/span><\/p>\n

                ENCRYPTION USING ‘AES128’ DEFAULT STORAGE(ENCRYPT);
                \n<\/span><\/p>\n

                CREATE TABLESPACE “UNIONE_ENC_3DES”
                \n<\/span><\/p>\n

                DATAFILE ‘\/oracle\/oracle12\/oradata\/oracle12\/UNIONE_ENC_3DES.dbf’
                \n<\/span><\/p>\n

                SIZE 400M
                \n<\/span><\/p>\n

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

                EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
                \n<\/span><\/p>\n

                ENCRYPTION USING ‘3DES168’ DEFAULT STORAGE(ENCRYPT);<\/span><\/td>\n<\/tr>\n

                \"\"<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                \n

                  \n
                1. \n
                  \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \uc554\ud638\ud654 \ub41c \uc0c1\ud0dc\ub97c \uc870\ud68c \ud569\ub2c8\ub2e4.
                  \n<\/span><\/div>\n<\/li>\n<\/ol>\n
                  \n\n\n<\/colgroup>\n\n\n\n
                  SQL> SELECT TABLESPACE_NAME,ENCRYPTED FROM DBA_TABLESPACES WHERE TABLESPACE_NAME LIKE ‘UNIONE_ENC%’ ;
                  \n<\/span><\/p>\n

                  SQL> SELECT A.NAME, B.ENCRYPTIONALG, B.ENCRYPTEDTS, A.CON_ID FROM V$TABLESPACE A, V$ENCRYPTED_TABLESPACES b
                  \n<\/span><\/p>\n

                  WHERE A.TS# = B.TS#;<\/span><\/td>\n<\/tr>\n

                  \"\"<\/p>\n

                  \"\"<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n


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

                  Oracle DB 12C Release 2 \ubc84\uc804 \ubd80\ud130 Oracle ASO ( Advanced Security Option \u2013 \uad6c Oracle TDE ) \uc758 \uae30\ub2a5\uc744 \uc774\uc6a9 \ud558\uba74 DB \uc554\ud638\ud654 \uc2dc \ud55c\uad6d\uc758 \ub300\ud45c \uc54c\uace0\ub9ac\uc998\uc778 ARIA \ubc29\uc2dd\uacfc SEED \ubc29\uc2dd \uc9c0\uc6d0\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4. (Oracle 12C Release 1\uc740 \ubd88\uac00) <\uc9c0\uc6d0\uc5ec\ubd80 \ud655\uc778> \ubcf8 \ud658\uacbd\uc740 \ub9ac\ub205\uc2a4 \ud658\uacbd \uc5d0\uc11c \ud14c\uc2a4\ud2b8 \ub418\uc5c8\uc2b5\ub2c8\ub2e4. Sqlnet.ora \uc138\ud305\ud569\ub2c8\ub2e4. ENCRYPTION_WALLET_LOCATION = (SOURCE = (METHOD […]<\/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":[20],"tags":[],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1595"}],"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=1595"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1595\/revisions"}],"predecessor-version":[{"id":1597,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1595\/revisions\/1597"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1595"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1595"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1595"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}