{"id":452,"date":"2014-01-26T14:13:33","date_gmt":"2014-01-26T23:13:33","guid":{"rendered":"\/blog\/?p=452"},"modified":"2023-09-21T09:38:47","modified_gmt":"2023-09-21T00:38:47","slug":"datasecure-java-connector-%ec%84%a4%ec%b9%98%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=452","title":{"rendered":"DataSecure Java Connector \uc124\uce58\ubc29\ubc95"},"content":{"rendered":"\n<p><br \/><\/p><p><a href=\"\/index.php?module=file&amp;act=procFileDownload&amp;file_srl=2219&amp;sid=3d1cfc44d8ff1096fd1d70d83115b3c9\">install.sh<\/a><\/p><p><br \/><\/p><p><\/p><p><b><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 12pt;\">\u25a0 install.sh \uc2e4\ud589 \uc804 \uc791\uc5c5<\/span><\/b><br \/><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">IngrianNAE.properties\uc758 \uc544\ub798 \ud56d\ubaa9\uc744 \uc801\ub2f9\ud558\uac8c \uc218\uc815<\/span><br \/>ex)<br \/><span style=\"font-family: Courier New; font-size: 9pt;\"><b>NAE_IP.1<\/b>=10.10.10.85<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\"><b>Log_File<\/b>=\/oracle\/product\/db\/10.2.0\/javavm\/lib\/safenet.log<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\"><b>IngrianNAE_Properties_Conf_Filename<\/b>=\/oracle\/product\/db\/10.2.0\/javavm\/lib\/IngrianNAE.properties<\/span><\/p><p><span style=\"font-family: Courier New; font-size: 9pt;\"><b><span style=\"font-size: 12pt; font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\"><br \/><\/span><\/b><\/span><\/p><p><span style=\"font-family: Courier New; font-size: 9pt;\"><b><span style=\"font-size: 12pt; font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\u25a0 install.sh \uc2e4\ud589 \ud6c4 \ud14c\uc2a4\ud2b8 SQL<\/span><\/b><br \/><br \/>SELECT INGRIAN.ING_GN_RNDM(8) FROM DUAL;<\/span><\/p><p><b><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 12pt;\"><br \/><\/span><\/b><\/p><p><b><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 12pt;\">\u25a0 install.sh<\/span><\/b><br \/><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">#!\/bin\/bash<\/span><br \/><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">INGRIAN_ID=INGRIAN<\/span><br \/><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">read -p \"[INGRIAN] Password : \" INGRIAN_PW<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">read -p \"INSTANCE_ID(ex.26529656774027060113568971) : \" INSTANCE_ID<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo \"&gt;&gt; INGRIAN Password : '${INGRIAN_PW}'\"<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo \"&gt;&gt; INSTANCE_ID : '${INSTANCE_ID}'\"<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">read -p \"Press [Enter] key to continue...\"<\/span><br \/><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo sqlplus \"\/ as sysdba\" @grantJavaPermissions.sql INGRIAN<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">sqlplus \"\/ as sysdba\" @grantJavaPermissions.sql INGRIAN<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">read -p \"Press [Enter] key to continue...\"<\/span><br \/><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo sqlplus ${INGRIAN_ID}\/${INGRIAN_PW} @IngrianSchema.sql<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">sqlplus ${INGRIAN_ID}\/${INGRIAN_PW} @IngrianSchema.sql<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">read -p \"Press [Enter] key to continue...\"<\/span><br \/><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo INSERT INTO <\/span><span style=\"font-family: Courier New; font-size: 9pt;\"><span style=\"font-family: Courier New; font-size: 9pt;\">${INGRIAN_ID}.<\/span>ING_PROPERTY VALUES \\(<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo \\ \\'INSTANCE_ID\\',<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo \\ \\'${INSTANCE_ID}\\',<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo \\ SYSDATE,<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo \\ \\'${INGRIAN_ID}\\',<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo \\ SYSDATE,<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo \\ \\'${INGRIAN_ID}\\'<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo \\ \\)\\;<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">read -p \"Press [Enter] key to continue...\"<\/span><br \/><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo .\/loadjce.sh ${INGRIAN_ID}\/${INGRIAN_PW}<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">.\/loadjce.sh ${INGRIAN_ID}\/${INGRIAN_PW}<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">read -p \"Press [Enter] key to continue...\"<\/span><br \/><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo sqlplus ${INGRIAN_ID}\/${INGRIAN_PW} @IngrianUDF.sql<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">sqlplus ${INGRIAN_ID}\/${INGRIAN_PW} @IngrianUDF.sql<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">read -p \"Press [Enter] key to continue...\"<\/span><br \/><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo sqlplus ${INGRIAN_ID}\/${INGRIAN_PW} @create_java_udf430.sql<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">sqlplus ${INGRIAN_ID}\/${INGRIAN_PW} @create_java_udf430.sql<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">read -p \"Press [Enter] key to continue...\"<\/span><br \/><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo sqlplus ${INGRIAN_ID}\/${INGRIAN_PW} @IngrianProc.sql<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">sqlplus ${INGRIAN_ID}\/${INGRIAN_PW} @IngrianProc.sql<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">read -p \"Press [Enter] key to continue...\"<\/span><br \/><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo sqlplus ${INGRIAN_ID}\/${INGRIAN_PW} @create_java_ingstat.sql<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">sqlplus ${INGRIAN_ID}\/${INGRIAN_PW} @create_java_ingstat.sql<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">read -p \"Press [Enter] key to continue...\"<\/span><br \/><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo sqlplus ${INGRIAN_ID}\/${INGRIAN_PW} @create_java_ingidx.sql<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">sqlplus ${INGRIAN_ID}\/${INGRIAN_PW} @create_java_ingidx.sql<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">read -p \"Press [Enter] key to continue...\"<\/span><br \/><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo sqlplus ${INGRIAN_ID}\/${INGRIAN_PW} @5.4.0_delta_ddl.sql<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">sqlplus ${INGRIAN_ID}\/${INGRIAN_PW} @5.4.0_delta_ddl.sql<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">read -p \"Press [Enter] key to continue...\"<\/span><br \/><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo cp -fv IngrianNAE.properties loadProperties.sh loadProperties.sql $ORACLE_HOME\/javavm\/lib<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">cp -fv IngrianNAE.properties loadProperties.sh loadProperties.sql $ORACLE_HOME\/javavm\/lib<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">read -p \"Press [Enter] key to continue...\"<\/span><br \/><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo .\/loadProperties.sh<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">.\/loadProperties.sh<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">read -p \"Press [Enter] key to continue...\"<\/span><br \/><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo SELECT COUNT\\(*\\) FROM USER_OBJECTS WHERE OBJECT_TYPE = \\'FUNCTION\\' AND STATUS = \\'VALID\\'\\;<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo<\/span><br \/><span style=\"font-family: Courier New; font-size: 9pt;\">echo SELECT INGRIAN.ING_GN_RNDM\\(8\\) FROM DUAL\\;<\/span><br \/><\/p>\n\n\n<div class=\"wp-block-file\"><a href=\"\/blog\/wp-content\/uploads\/cms_xe\/bin0051\">install.sh<\/a><a href=\"\/blog\/wp-content\/uploads\/cms_xe\/bin0051\" class=\"wp-block-file__button\" download>\ub2e4\uc6b4\ub85c\ub4dc<\/a><\/div>\n\n","protected":false},"excerpt":{"rendered":"","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-452","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\/452","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=452"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/452\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=452"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=452"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=452"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}