StarLord

1) PLSQL 로 SHA512 JAVA class 생성 CREATE_COMPILE_JAVA_SOURCE_SHA512.sql create or replace and compile java source named SHA512 as import java.security.MessageDigest; public class SHA512 { public static String encrypt(String tmpStr) throws Exception{ //SHA-512 적용 MessageDigest md = MessageDigest.getInstance("SHA-512"); md.update(tmpStr.getBytes()); byte[] msgb = md.digest(); StringBuffer sb = new S..

#su - postgres $createdb SSO #psql -U postgres -d SSO < schema.sql #psql -U postgres -d SSO < VIEW_output.sql ※ FATAL: Peer authentication failed for user "postgres" 오류가 뜰 경우 #vi /etc/postgresql/9.5/main/pg_hba.conf local all postgres md5 ※ 스키마 단위로 마이그레이션 하기 위해서는 릴레이션을 위해 role을 만들어야 한다. #su -u postgres -i #createuser -l -d -P sso

■ EXPORT #yum install perl-DBD-Pg perl perl-devel perl-DBI perl-CPAN -y #yum install perl-Time-HiRes #cd /data/ora2pg #wget https://www.cpan.org/modules/by-module/DBI/DBI-1.642.tar.gz #tar xvzf DBI-1.642.tar.gz #cd DBI-1.642 #perl Makefile.PL #make #make install #export ORACLE_HOME=/ora11g/product/11.2.0 #export LD_LIBRARY_PATH=/ora11g/product/11.2.0/lib #perl -MCPAN -e shell . . . . . . Would y..

■ psql 올리기 #docker run -p 5432:5432 --name pg-test2 -it 레포지토리주소/ubuntu:18.04 bash > apt-get update > apt-get install postgresql postgresql-contrib > service postgresql start > exit #firewall-cmd --permanent --zone=public --add-port=5432 ■ oracle instant client 설치 https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html #mkdir /download #docker cp /storage/download/..