DataSecure Java Connector 설치방법

install.sh

■ install.sh 실행 전 작업

IngrianNAE.properties의 아래 항목을 적당하게 수정
ex)
NAE_IP.1=10.10.10.85
Log_File=/oracle/product/db/10.2.0/javavm/lib/safenet.log
IngrianNAE_Properties_Conf_Filename=/oracle/product/db/10.2.0/javavm/lib/IngrianNAE.properties

■ install.sh 실행 후 테스트 SQL

SELECT INGRIAN.ING_GN_RNDM(8) FROM DUAL;

■ install.sh

#!/bin/bash

INGRIAN_ID=INGRIAN

read -p "[INGRIAN] Password : " INGRIAN_PW
read -p "INSTANCE_ID(ex.26529656774027060113568971) : " INSTANCE_ID
echo
echo ">> INGRIAN Password : '${INGRIAN_PW}'"
echo ">> INSTANCE_ID : '${INSTANCE_ID}'"
read -p "Press [Enter] key to continue..."

echo sqlplus "/ as sysdba" @grantJavaPermissions.sql INGRIAN
sqlplus "/ as sysdba" @grantJavaPermissions.sql INGRIAN
read -p "Press [Enter] key to continue..."

echo sqlplus ${INGRIAN_ID}/${INGRIAN_PW} @IngrianSchema.sql
sqlplus ${INGRIAN_ID}/${INGRIAN_PW} @IngrianSchema.sql
read -p "Press [Enter] key to continue..."

echo
echo INSERT INTO ${INGRIAN_ID}.ING_PROPERTY VALUES \(
echo \ \'INSTANCE_ID\',
echo \ \'${INSTANCE_ID}\',
echo \ SYSDATE,
echo \ \'${INGRIAN_ID}\',
echo \ SYSDATE,
echo \ \'${INGRIAN_ID}\'
echo \ \)\;
read -p "Press [Enter] key to continue..."

echo ./loadjce.sh ${INGRIAN_ID}/${INGRIAN_PW}
./loadjce.sh ${INGRIAN_ID}/${INGRIAN_PW}
read -p "Press [Enter] key to continue..."

echo sqlplus ${INGRIAN_ID}/${INGRIAN_PW} @IngrianUDF.sql
sqlplus ${INGRIAN_ID}/${INGRIAN_PW} @IngrianUDF.sql
read -p "Press [Enter] key to continue..."

echo sqlplus ${INGRIAN_ID}/${INGRIAN_PW} @create_java_udf430.sql
sqlplus ${INGRIAN_ID}/${INGRIAN_PW} @create_java_udf430.sql
read -p "Press [Enter] key to continue..."

echo sqlplus ${INGRIAN_ID}/${INGRIAN_PW} @IngrianProc.sql
sqlplus ${INGRIAN_ID}/${INGRIAN_PW} @IngrianProc.sql
read -p "Press [Enter] key to continue..."

echo sqlplus ${INGRIAN_ID}/${INGRIAN_PW} @create_java_ingstat.sql
sqlplus ${INGRIAN_ID}/${INGRIAN_PW} @create_java_ingstat.sql
read -p "Press [Enter] key to continue..."

echo sqlplus ${INGRIAN_ID}/${INGRIAN_PW} @create_java_ingidx.sql
sqlplus ${INGRIAN_ID}/${INGRIAN_PW} @create_java_ingidx.sql
read -p "Press [Enter] key to continue..."

echo sqlplus ${INGRIAN_ID}/${INGRIAN_PW} @5.4.0_delta_ddl.sql
sqlplus ${INGRIAN_ID}/${INGRIAN_PW} @5.4.0_delta_ddl.sql
read -p "Press [Enter] key to continue..."

echo cp -fv IngrianNAE.properties loadProperties.sh loadProperties.sql $ORACLE_HOME/javavm/lib
cp -fv IngrianNAE.properties loadProperties.sh loadProperties.sql $ORACLE_HOME/javavm/lib
read -p "Press [Enter] key to continue..."

echo ./loadProperties.sh
./loadProperties.sh
read -p "Press [Enter] key to continue..."

echo
echo
echo
echo SELECT COUNT\(*\) FROM USER_OBJECTS WHERE OBJECT_TYPE = \'FUNCTION\' AND STATUS = \'VALID\'\;
echo
echo SELECT INGRIAN.ING_GN_RNDM\(8\) FROM DUAL\;