{"id":667,"date":"2016-08-17T16:07:05","date_gmt":"2016-08-18T01:07:05","guid":{"rendered":"\/blog\/?p=667"},"modified":"2023-09-21T09:37:58","modified_gmt":"2023-09-21T00:37:58","slug":"safenet-datasecure-protectdb-%ec%84%a4%ec%b9%98","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=667","title":{"rendered":"SafeNet DataSecure ProtectDB \uc124\uce58"},"content":{"rendered":"\n

1. INGRIAN \uacc4\uc815 \uc0dd\uc131<\/span><\/p>\r\n


<\/p>\r\n

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

# Oracle \uad00\ub9ac\uc790 \uc811\uc18d<\/span><\/p>\r\n

sqlplus sys\/\ube44\ubc00\ubc88\ud638 as sysdba<\/span><\/p>\r\n


<\/p>\r\n

REM \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \uc0dd\uc131<\/span><\/p>\r\n

CREATE TABLESPACE ts_ingrian DATAFILE '\/oradata\/orcl\/ingrian.dbf' SIZE 2M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;<\/span><\/p>\r\n


<\/p>\r\n

REM \uacc4\uc815 \uc0dd\uc131<\/span><\/p>\r\n

CREATE USER ingrian IDENTIFIED BY \"\ube44\ubc00\ubc88\ud638\";<\/span><\/p>\r\n


<\/p>\r\n

REM \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \ud560\ub2f9<\/span><\/p>\r\n

ALTER USER ingrian DEFAULT TABLESPACE ts_ingrian;<\/span><\/p>\r\n


<\/p>\r\n

REM temp \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \ud560\ub2f9<\/span><\/p>\r\n

ALTER USER ingrian TEMPORARY TABLESPACE TEMP;<\/span><\/p>\r\n


<\/p>\r\n

REM \ube44\ubc00\ubc88\ud638 \uc218\uc815<\/span><\/p>\r\n

ALTER USER ingrian IDENTIFIED BY \"\ube44\ubc00\ubc88\ud638\";<\/span><\/p>\r\n


<\/p>\r\n

REM \ubaa8\ub4e0 \uad8c\ud55c \uc8fc\uae30<\/span><\/p>\r\n

GRANT CONNECT, DBA, RESOURCE TO ingrian; <\/span><\/p>\r\n<\/td><\/tr><\/tbody><\/table>


<\/p>\r\n

2. ProtectDB \uc124\uce58 (oracle \uacc4\uc815\uc73c\ub85c \uc124\uce58)<\/span><\/p>\r\n


<\/p>\r\n

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

$ <\/span>.\/install.sh install<\/span><\/strong><\/span><\/p>\r\n

07:02:36 - Info: SafeNet logging directory \/tmp\/inginstall already exists<\/span><\/p>\r\n

07:02:36 - ........................................................<\/span><\/p>\r\n

07:02:36 - Beginning SafeNet Oracle's ProtectDB Installation<\/span><\/p>\r\n

07:02:36 - 2016. 08. 17. (\uc218) 07:02:36 KST<\/span><\/p>\r\n

07:02:36 - ........................................................<\/span><\/p>\r\n

07:02:36 - Info: Mode = install<\/span><\/p>\r\n

Enter the password for the Oracle user SYS: <\/span>********<\/span><\/strong><\/span><\/p>\r\n

Confirm the password for the Oracle user SYS: <\/span>********<\/span><\/strong><\/span><\/p>\r\n

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

Enter the password for the Oracle user INGRIAN: <\/span>********<\/span><\/strong><\/span><\/p>\r\n

Confirm the password for the Oracle user INGRIAN: <\/span>********<\/span><\/strong><\/span><\/p>\r\n

07:02:48 - Info: Creating ProtectDB Instance ID<\/span><\/p>\r\n

Please enter the ProtectDB Instance ID for this installation [5242-8514-17693-17347]: <\/span><\/p>\r\n

07:02:49 - Using default ProtectDB Instance ID<\/span><\/p>\r\n

07:02:49 - Info: Verifying ORACLE_HOME environment variable is set<\/span><\/p>\r\n

07:02:49 -      Success - using ORACLE_HOME:  \/opt\/oracle\/11g<\/span><\/p>\r\n

07:02:49 - Info: Locating sqlplus executable<\/span><\/p>\r\n

07:02:49 -      Success - using sqlplus: \/opt\/oracle\/11g\/bin\/sqlplus<\/span><\/p>\r\n

07:02:49 - Info: Operating System - Linux Version - 2.6.9-103.0.0.0.1.ELsmp<\/span><\/p>\r\n

07:02:49 - Info: Generic OS type set to Linux<\/span><\/p>\r\n

07:02:49 - Info: Using Oracle version 11<\/span><\/p>\r\n

07:02:49 - Info: Verifying login for user SYS<\/span><\/p>\r\n

07:02:49 -      Success<\/span><\/p>\r\n

07:02:49 - Info: Verifying login for user INGRIAN<\/span><\/p>\r\n

07:02:49 -      Success<\/span><\/p>\r\n

07:02:49 - Info: Checking if DBMS_LOB package installed.<\/span><\/p>\r\n

07:02:50 - Success<\/span><\/p>\r\n

07:02:50 - Info: Checking if connector is present.<\/span><\/p>\r\n

07:02:50 - Success<\/span><\/p>\r\n

07:02:50 - Info: Determining Oracle Architecture<\/span><\/p>\r\n

07:02:50 -      Using 64 Bit Oracle<\/span><\/p>\r\n

07:02:50 - Info: Installing 64 bit shared libriaries<\/span><\/p>\r\n

07:02:50 - Info: Granting required permissions to INGRIAN user<\/span><\/p>\r\n

07:02:51 -      Success<\/span><\/p>\r\n

07:02:51 - Info: Checking object dependencies<\/span><\/p>\r\n

07:02:51 -      Success<\/span><\/p>\r\n

07:02:51 - Info: Creating ProtectDB Database Schema<\/span><\/p>\r\n

07:02:55 -      Success<\/span><\/p>\r\n

07:02:55 - Info: Creating ProtectDB lib directory \/opt\/oracle\/11g\/lib\/safenet<\/span><\/p>\r\n

07:02:55 -      Success<\/span><\/p>\r\n

07:02:55 - Info: Copying default ProtectDB.properties<\/span><\/p>\r\n

07:02:55 - Info: Loading System Properties<\/span><\/p>\r\n

Default ProtectDB.properties is located in: <\/span><\/p>\r\n

\/opt\/oracle\/11g\/lib\/safenet\/ProtectDB.properties<\/span><\/p>\r\n

Enter full path to the properties file: <\/span>\/opt\/oracle\/11g\/lib\/safenet\/ProtectDB.properties<\/span><\/strong><\/span>
<\/p>\r\n

Enter the IP Address of the ProtectDB NAE Server: <\/span>10.10.10.86<\/span><\/strong><\/span><\/p>\r\n

Enter the Port of the ProtectDB NAE Server [9000]: <\/span><\/p>\r\n

Enter the full path for your ProtectDB Log File: <\/span>\/opt\/oracle\/11g\/lib\/safenet\/protectdb.log<\/span><\/strong><\/span><\/p>\r\n

No errors.<\/span><\/p>\r\n

+ Property_File_Path = \/opt\/oracle\/11g\/lib\/safenet\/ProtectDB.properties<\/span><\/p>\r\n

07:04:46 -      Success<\/span><\/p>\r\n

07:04:46 - Info: Registering Shared Libraries<\/span><\/p>\r\n

07:04:46 -      Success<\/span><\/p>\r\n

07:04:46 - Info: Creating ProtectDB Stored Procedures<\/span><\/p>\r\n

07:04:46 -      Success<\/span><\/p>\r\n

07:04:46 - Info: Installing ProtectDB Indexing Cartridge<\/span><\/p>\r\n

07:04:52 -      Success<\/span><\/p>\r\n

07:04:52 - Info: Creating ProtectDB User Defined Functions<\/span><\/p>\r\n

07:04:55 -      Success<\/span><\/p>\r\n

07:04:55 - Info: Inserting ProtectDB Instance ID<\/span><\/p>\r\n

07:04:55 -      Success<\/span><\/p>\r\n

07:04:55 - Info: ProtectDB lib directory \/opt\/oracle\/11g\/lib\/safenet already exists<\/span><\/p>\r\n

07:04:55 - Info: Copying File<\/span><\/p>\r\n

07:04:55 -      Source - .\/libingdb.so<\/span><\/p>\r\n

07:04:55 -      Destination - \/opt\/oracle\/11g\/lib\/safenet\/libingdb.so<\/span><\/p>\r\n

07:04:55 -      Success<\/span><\/p>\r\n

07:04:55 - Info: Copying File<\/span><\/p>\r\n

07:04:55 -      Source - .\/libstdc++.so.6<\/span><\/p>\r\n

07:04:55 -      Destination - \/opt\/oracle\/11g\/lib\/safenet\/libstdc++.so.6<\/span><\/p>\r\n

07:04:55 -      Success<\/span><\/p>\r\n

07:04:55 - Info: Copying File<\/span><\/p>\r\n

07:04:55 -      Source - .\/libgcc_s.so.1<\/span><\/p>\r\n

07:04:55 -      Destination - \/opt\/oracle\/11g\/lib\/safenet\/libgcc_s.so.1<\/span><\/p>\r\n

07:04:55 -      Success<\/span><\/p>\r\n

07:04:55 - Info: Creating Symbolic Link<\/span><\/p>\r\n

07:04:55 -      Physical File - \/opt\/oracle\/11g\/lib\/safenet\/libstdc++.so.6<\/span><\/p>\r\n

07:04:55 -      Linked File - \/opt\/oracle\/11g\/lib\/libstdc++.so.6<\/span><\/p>\r\n

07:04:55 -      Success<\/span><\/p>\r\n

07:04:55 - Info: Creating Symbolic Link<\/span><\/p>\r\n

07:04:55 -      Physical File - \/opt\/oracle\/11g\/lib\/safenet\/libgcc_s.so.1<\/span><\/p>\r\n

07:04:55 -      Linked File - \/opt\/oracle\/11g\/lib\/libgcc_s.so.1<\/span><\/p>\r\n

07:04:55 -      Success<\/span><\/p>\r\n

07:04:55 - .....................................................................<\/span><\/p>\r\n

07:04:55 - Successfully Completed ProtectDB Oracle ProtectDB Installation<\/span><\/p>\r\n

07:04:55 - 2016. 08. 17. (\uc218) 07:04:55 KST<\/span><\/p>\r\n

07:04:55 - .....................................................................<\/span> <\/span><\/p>\r\n<\/td><\/tr><\/tbody><\/table>

<\/p>\r\n

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

1. INGRIAN \uacc4\uc815 \uc0dd\uc131 # Oracle \uad00\ub9ac\uc790 \uc811\uc18d sqlplus sys\/\ube44\ubc00\ubc88\ud638 as sysdba REM \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \uc0dd\uc131 CREATE TABLESPACE ts_ingrian DATAFILE ‘\/oradata\/orcl\/ingrian.dbf’ SIZE 2M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE; REM \uacc4\uc815 \uc0dd\uc131 CREATE USER ingrian IDENTIFIED BY “\ube44\ubc00\ubc88\ud638”; REM \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \ud560\ub2f9 ALTER USER ingrian DEFAULT TABLESPACE ts_ingrian; REM temp \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \ud560\ub2f9 ALTER USER […]<\/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":[10],"tags":[],"class_list":["post-667","post","type-post","status-publish","format-standard","hentry","category-computing_database"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/667","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=667"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/667\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=667"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=667"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=667"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}