본문 바로가기

전체 글213

javascript Diagram http://gojs.net https://github.com/jgraph/draw.io 2020. 4. 19.
windows / batch script 날짜 date,time @echo off rem 날짜포맷만 가지고 변수로 지정 rem setlocal enableextensions rem 오전시간 시간이 1자리인경우 left "0" 추가 set hour=%time:~0,2% if "%time:~0,1%"==" " set hour=0%time:~1,1% set arcname1=%date:~0,4%%date:~5,2%%date:~8,2%%hour%%time:~3,2%%time:~6,2% rem YYYYMMDDHH24mi echo %arcname1% 2020. 4. 19.
openshift / ERROR: Could not find a valid gem 'rhc' (>= 0) Microsoft Windows [Version 10.0.14393] (c) 2016 Microsoft Corporation. All rights reserved. C:\Users\KJH>gem install rhc ERROR: Could not find a valid gem 'rhc' (>= 0), here is why: Unable to download data from https://rubygems.org/ - SSL_connect returned=1 errno=0 state=SSLv3 read server certificate B: certificate verify failed (https://rubygems.org/latest_specs.4.8.gz) C:\Users\KJH>gem sources.. 2020. 4. 19.
jenkins / centos 1.사전설치 jdk wget 2.jenkins 설치 wget -O /etc/yum.repos.d/jenkins.repo http://pkg.jenkins-ci.org/redhat/jenkins.repo rpm --import https://jenkins-ci.org/redhat/jenkins-ci.org.key yum install jenkins 3. jenkins 설치경로 /var/lib/jenkins 4. jenkins 포트변경 vi /etc/sysconfig/jenkins JENKINS_PORT="9090" :wq! 5. jenkins 서비스시작 /etc/init.d/jenkins start 6. jenkins 설치 확인 yum list jenkins 7. jenkins 설치 버전 삭제 yum re.. 2020. 4. 19.
jenkins / 사용자,프로젝트권한관리 http://updates.jenkins-ci.org/download/plugins/matrix-auth/ 최신버전 다운로드 jenkins > Jenkins관리 > 플러그인 관리 > 플러그인올리기 > 파일선택 2020. 4. 19.
centos / openjdk [root@localhost ~]# yum list java*jdk-devel Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * base: centos.mirror.cdnetworks.com * extras: centos.mirror.cdnetworks.com * updates: centos.mirror.cdnetworks.com Available Packages java-1.6.0-openjdk-devel.x86_64 1:1.6.0.41-1.13.13.1.el7_3 base java-1.7.0-openjdk-devel.x86_64 1:1.7.0.171-2.6.13.0.el7_4 updates java-1.8.0-open.. 2020. 4. 19.
linux / centos7 / hostname [root@localhost ~]# hostname localhost.localdomain [root@localhost ~]# set-hostname ABCD -bash: set-hostname: command not found [root@localhost ~]# [root@localhost ~]# hostnamectl set-hostname ABCD [root@localhost ~]# [root@localhost ~]# hostname abcd [root@localhost ~]# ssh재접속시 적용됨 2020. 4. 19.
oracle / job / batch 참고 : https://docs.oracle.com/database/121/ARPLS/d_job.htm#ARPLS66560 1. 신규등록 DBMS_JOB.SUBMIT( job OUT BINARY_INTEGER, what IN VARCHAR2, next_date IN DATE DEFAULT SYSDATE, interval IN VARCHAR2 DEFAULT 'NULL', no_parse IN BOOLEAN DEFAULT FALSE, instance IN BINARY_INTEGER DEFAULT ANY_INSTANCE, force IN BOOLEAN DEFAULT FALSE ); ex) DECLARE job NUMBER; BEGIN DBMS_JOB.SUBMIT(job --자동생성 , 'DBMS_OUTPUT... 2020. 4. 17.
oracle / dbms_scheduler 1. 조회 SELECT * FROM user_scheduler_jobs; SELECT * FROM dba_scheduler_jobs; SELECT NEXT_RUN_DATE,REPEAT_INTERVAL, a.* FROM user_scheduler_jobs a; ---신규 생성후 NextRunData , RepeatInterval 확인 2. 권한부여 grant create any job to 유저명 ; 2. 신규등록 begin dbms_scheduler.create_job( -- 신규 JOB을 생성 job_name => 'insert_job_test1' , -- dbms_scheduler 내에서 사용될 job 이름지정 job_type => 'plsql_block' , -- 5번줄에 적은 프로그램의 타입을 적.. 2020. 4. 17.
반응형