{"id":442,"date":"2013-12-06T18:31:43","date_gmt":"2013-12-07T03:31:43","guid":{"rendered":"\/blog\/?p=442"},"modified":"2023-09-21T09:38:48","modified_gmt":"2023-09-21T00:38:48","slug":"oracle-datasecure-%ec%95%94%ed%98%b8%ed%99%94-%ed%85%8c%ec%8a%a4%ed%8a%b8","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=442","title":{"rendered":"[Oracle] DataSecure \uc554\ud638\ud654 \ud14c\uc2a4\ud2b8"},"content":{"rendered":"\n

1. \uae30\uc874 \uc2a4\ud0a4\ub9c8\uc640 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc0ad\uc81c<\/span>

DROP USER TEST CASCADE;<\/span>
DROP TABLESPACE TS_TEST INCLUDING CONTENTS AND DATAFILES;<\/span>

DROP USER INGRIAN CASCADE;<\/span>
DROP TABLESPACE TS_INGRIAN INCLUDING CONTENTS AND DATAFILES;<\/span>


2. \uc2dc\ud5d8\uc6a9 \uacc4\uc815 \ubc0f \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc0dd\uc131 \uc2a4\ud06c\ub9bd\ud2b8 (\ub9cc\ub4e4\uc5b4\uc11c oracle \uacc4\uc815\uc73c\ub85c \uc2e4\ud589)<\/span>

#!\/bin\/bash<\/span>
export ORACLE_SID=SIDTEST<\/span>
echo \"    Create Tablespace SID:${ORACLE_SID}...\"<\/span>
sqlplus \/ as sysdba << EOF<\/span>
CREATE TABLESPACE TS_TEST<\/span>
 DATAFILE '\/oradata\/SIDTEST\/ts_test.dbf'<\/span>
 SIZE 100M<\/span>
 AUTOEXTEND ON NEXT 10M<\/span>
 DEFAULT STORAGE(<\/span>
 INITIAL 10K<\/span>
 NEXT 10K<\/span>
 MINEXTENTS 2<\/span>
 PCTINCREASE 80) ONLINE;<\/span>

CREATE USER TEST<\/span>
 IDENTIFIED BY \"P@ss1234\"<\/span>
 DEFAULT TABLESPACE TS_TEST;<\/span>

GRANT CONNECT,RESOURCE,DBA TO TEST;<\/span>
ALTER USER TEST QUOTA UNLIMITED ON TS_TEST;<\/span>
GRANT UNLIMITED TABLESPACE TO TEST;<\/span>

EXIT;<\/span>
EOF<\/span>

3. ingrian \uacc4\uc815 \ubc0f \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc0dd\uc131 (\ub9cc\ub4e4\uc5b4\uc11c oracle \uacc4\uc815\uc73c\ub85c \uc2e4\ud589)<\/span>

#!\/bin\/bash<\/span>
export ORACLE_SID=SIDTEST<\/span>
echo \"    Create Tablespace SID:${ORACLE_SID}...\"<\/span>
sqlplus \/ as sysdba << EOF<\/span>
CREATE TABLESPACE TS_INGRIAN<\/span>
 DATAFILE '\/oradata\/SIDTEST\/ts_ingrian.dbf'<\/span>
 SIZE 100M<\/span>
 AUTOEXTEND ON NEXT 10M<\/span>
 DEFAULT STORAGE(<\/span>
 INITIAL 10K<\/span>
 NEXT 10K<\/span>
 MINEXTENTS 2<\/span>
 PCTINCREASE 80) ONLINE;<\/span>

CREATE USER INGRIAN<\/span>
 IDENTIFIED BY \"P@ss1234\"<\/span>
 DEFAULT TABLESPACE TS_INGRIAN;<\/span>

GRANT CONNECT,RESOURCE,DBA TO INGRIAN;<\/span>
ALTER USER INGRIAN QUOTA UNLIMITED ON TS_INGRIAN;<\/span>
GRANT UNLIMITED TABLESPACE TO INGRIAN;<\/span>

EXIT;<\/span>
EOF<\/span>


2. \ud14c\uc2a4\ud2b8 \ud14c\uc774\ube14\uc5d0 \ub79c\ub364 \ub370\uc774\ud130 \uc0dd\uc131 SQL<\/span>

-- \uc2dc\ud5d8\uc6a9 \ud14c\uc774\ube14 \uc0dd\uc131 (SQL Developer\uc5d0\uc11c \uc2e4\ud589\ud560 \uac83.)<\/span>

CREATE TABLE TBL_TEST (<\/span>
    test_no         number(10),<\/span>
    test_name       varchar2(30),<\/span>
    test_salary     number(10)<\/span>
) TABLESPACE TS_TEST;<\/span>
--COMMIT<\/span>

-- \ud14c\uc774\ube14\uc5d0 100\ud589 \uc0bd\uc785<\/span>
BEGIN<\/span>
FOR i IN 1..100<\/span>
LOOP<\/span>
    INSERT INTO TBL_TEST<\/span>
        VALUES (i, DBMS_RANDOM.STRING('U',30), DBMS_RANDOM.VALUE(1000,7000));<\/span>
    IF MOD(i, 10000) = 0 THEN<\/span>
        COMMIT;<\/span>
    END IF;<\/span>
END LOOP;<\/span>
END;<\/span>
--COMMIT;<\/span>


4. ProtectDB \uc124\uce58 (oracle \uacc4\uc815\uc73c\ub85c \uc124\uce58)<\/span>

[oracle@oracle ProtectDB-Oracle]$ .\/install.sh<\/span>
Description: Loads, reloads or removes the ProtectDB Oracle Provider<\/span>
Usage:       .\/install.sh install<\/span>
             .\/install.sh reload<\/span>
             .\/install.sh localonly Oracle_Architecture<\/span>
             .\/install.sh uninstall<\/span>
             .\/install.sh uninstall localonly<\/span>

[oracle@oracle ProtectDB-Oracle]$ .\/install.sh install<\/span>
Info: Creating logging directory \/tmp\/inginstall<\/span>
     Success<\/span>
18:23:00 - ........................................................<\/span>
18:23:00 - Beginning SafeNet Oracle's ProtectDB Installation<\/span>
18:23:00 - 2013. 12. 06. (\uae08) 18:23:00 KST<\/span>
18:23:00 - ........................................................<\/span>
18:23:00 - Info: Mode = install<\/span>
Enter the password for the Oracle user SYS:<\/span>
Confirm the password for the Oracle user SYS:<\/span>

Enter the password for the Oracle user INGRIAN:<\/span>
Confirm the password for the Oracle user INGRIAN:<\/span>
18:23:07 - Info: Creating ProtectDB Instance ID<\/span>
Please enter the ProtectDB Instance ID for this installation [22639-4024-17276-30561]:<\/span>
18:23:10 - Using default ProtectDB Instance ID<\/span>
18:23:10 - Info: Verifying ORACLE_HOME environment variable is set<\/span>
18:23:10 -      Success - using ORACLE_HOME:  \/oracle\/11g<\/span>
18:23:10 - Info: Locating sqlplus executable<\/span>
18:23:10 -      Success - using sqlplus: \/oracle\/11g\/bin\/sqlplus<\/span>
18:23:10 - Info: Operating System - Linux Version - 2.6.18-308.el5<\/span>
18:23:10 - Info: Generic OS type set to Linux<\/span>
18:23:10 - Info: Using Oracle version 11<\/span>
18:23:10 - Info: Verifying login for user SYS<\/span>
18:23:10 -      Success<\/span>
18:23:10 - Info: Verifying login for user INGRIAN<\/span>
18:23:10 -      Success<\/span>
18:23:10 - Info: Checking if DBMS_LOB package installed.<\/span>
18:23:11 - Success<\/span>
18:23:11 - Info: Checking if connector is present.<\/span>
18:23:11 - Success<\/span>
18:23:11 - Info: Determining Oracle Architecture<\/span>
18:23:11 -      Using 64 Bit Oracle<\/span>
18:23:11 - Info: Installing 64 bit shared libriaries<\/span>
18:23:11 - Info: Granting required permissions to INGRIAN user<\/span>
18:23:11 -      Success<\/span>
18:23:11 - Info: Checking object dependencies<\/span>
18:23:11 -      Success<\/span>
18:23:11 - Info: Creating ProtectDB Database Schema<\/span>
18:23:13 -      Success<\/span>
18:23:13 - Info: Creating ProtectDB lib directory \/oracle\/11g\/lib\/safenet<\/span>
18:23:13 -      Success<\/span>
18:23:13 - Info: Copying default ProtectDB.properties<\/span>
18:23:13 - Info: Loading System Properties<\/span>
Default ProtectDB.properties is located in:<\/span>
\/oracle\/11g\/lib\/safenet\/ProtectDB.properties<\/span>
Enter full path to the properties file:<\/span>
ERROR: Properties file path is required.<\/span>
Enter full path to the properties file: \/oracle\/11g\/lib\/safenet\/ProtectDB.properties<\/span>
Enter the IP Address of the ProtectDB NAE Server: 10.10.10.43<\/span>
Enter the Port of the ProtectDB NAE Server [9000]:<\/span>
Enter the full path for your ProtectDB Log File: \/home\/oracle\/logfile<\/span>
No errors.<\/span>
+ Property_File_Path = \/oracle\/11g\/lib\/safenet\/ProtectDB.properties<\/span>
18:24:18 -      Success<\/span>
18:24:18 - Info: Registering Shared Libraries<\/span>
18:24:18 -      Success<\/span>
18:24:18 - Info: Creating ProtectDB Stored Procedures<\/span>
18:24:18 -      Success<\/span>
18:24:18 - Info: Installing ProtectDB Indexing Cartridge<\/span>
18:24:22 -      Success<\/span>
18:24:22 - Info: Creating ProtectDB User Defined Functions<\/span>
18:24:23 -      Success<\/span>
18:24:23 - Info: Inserting ProtectDB Instance ID<\/span>
18:24:23 -      Success<\/span>
18:24:23 - Info: ProtectDB lib directory \/oracle\/11g\/lib\/safenet already exists<\/span>
18:24:23 - Info: Copying File<\/span>
18:24:23 -      Source - .\/libingdb.so<\/span>
18:24:23 -      Destination - \/oracle\/11g\/lib\/safenet\/libingdb.so<\/span>
18:24:23 -      Success<\/span>
18:24:23 - Info: Copying File<\/span>
18:24:23 -      Source - .\/libstdc++.so.6<\/span>
18:24:23 -      Destination - \/oracle\/11g\/lib\/safenet\/libstdc++.so.6<\/span>
18:24:23 -      Success<\/span>
18:24:23 - Info: Copying File<\/span>
18:24:23 -      Source - .\/libgcc_s.so.1<\/span>
18:24:23 -      Destination - \/oracle\/11g\/lib\/safenet\/libgcc_s.so.1<\/span>
18:24:23 -      Success<\/span>
18:24:23 - Info: Creating Symbolic Link<\/span>
18:24:23 -      Physical File - \/oracle\/11g\/lib\/safenet\/libstdc++.so.6<\/span>
18:24:23 -      Linked File - \/oracle\/11g\/lib\/libstdc++.so.6<\/span>
18:24:23 -      Success<\/span>
18:24:23 - Info: Creating Symbolic Link<\/span>
18:24:23 -      Physical File - \/oracle\/11g\/lib\/safenet\/libgcc_s.so.1<\/span>
18:24:23 -      Linked File - \/oracle\/11g\/lib\/libgcc_s.so.1<\/span>
18:24:23 -      Success<\/span>
18:24:23 - .....................................................................<\/span>
18:24:23 - Successfully Completed ProtectDB Oracle ProtectDB Installation<\/span>
18:24:23 - 2013. 12. 06. (\uae08) 18:24:23 KST<\/span>
18:24:23 - .....................................................................<\/span>
[oracle@oracle ProtectDB-Oracle]$<\/span>
[oracle@oracle ProtectDB-Oracle]$ .\/grantPermission.sh \/ ingrian<\/span>
[oracle@oracle ProtectDB-Oracle]$ .\/grantPermission.sh \/ test<\/span>


4. Oracle \ub9ac\uc2a4\ub108 \uc124\uc815 \ubcc0\uacbd<\/span>

# \/oracle\/11g\/network\/admin\/listener.ora<\/span>
LISTENER =<\/span>
  (DESCRIPTION_LIST =<\/span>
    (DESCRIPTION =<\/span>
      (ADDRESS = (PROTOCOL = IPC)(KEY = SafeNetKey))<\/span>
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))<\/span>
    )<\/span>
  )<\/span>

SID_LIST_LISTENER =<\/span>
  (SID_LIST =<\/span>
    (SID_DESC =<\/span>
        (SID_NAME = SIDTEST)<\/span>
        (ORACLE_HOME = \/oracle\/11g)<\/span>
        (ENVS=\"LD_LIBRARY_PATH=\/oracle\/11g\/lib\/safenet\")<\/span>
    )<\/span>
  )<\/span>

# \/oracle\/11g\/network\/admin\/tnsnames.ora<\/span>
SIDTEST =<\/span>
  (DESCRIPTION =<\/span>
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))<\/span>
    (CONNECT_DATA =<\/span>
      (SERVER = DEDICATED)<\/span>
      (SERVICE_NAME = SIDTEST)<\/span>
    )<\/span>
  )<\/span><\/p>


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

1. \uae30\uc874 \uc2a4\ud0a4\ub9c8\uc640 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc0ad\uc81c DROP USER TEST CASCADE;DROP TABLESPACE TS_TEST INCLUDING CONTENTS AND DATAFILES; DROP USER INGRIAN CASCADE;DROP TABLESPACE TS_INGRIAN INCLUDING CONTENTS AND DATAFILES; 2. \uc2dc\ud5d8\uc6a9 \uacc4\uc815 \ubc0f \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc0dd\uc131 \uc2a4\ud06c\ub9bd\ud2b8 (\ub9cc\ub4e4\uc5b4\uc11c oracle \uacc4\uc815\uc73c\ub85c \uc2e4\ud589) #!\/bin\/bashexport ORACLE_SID=SIDTESTecho ”    Create Tablespace SID:${ORACLE_SID}…”sqlplus \/ as sysdba << EOFCREATE TABLESPACE TS_TEST DATAFILE ‘\/oradata\/SIDTEST\/ts_test.dbf’ SIZE 100M AUTOEXTEND ON NEXT 10M DEFAULT STORAGE( INITIAL […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[12],"tags":[],"class_list":["post-442","post","type-post","status-publish","format-standard","hentry","category-computing_security"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/442","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=442"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/442\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=442"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=442"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=442"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}