Skip to content

Instantly share code, notes, and snippets.

ifconfig <interface name> <ip> netmask <netmask> broadcast <broadcast>
sudo vi /etc/network/interfaces
auto enp5s0
iface enp5s0 inet static
address 192.168.0.104
netmask 255.255.255.0
broadcast 192.168.0.255
gateway 192.168.0.1
# MariaDB database server configuration file.
#
# You can copy this file to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
@otwm
otwm / cadvisor
Created September 29, 2016 06:14
docker run \
--volume=/:/rootfs:ro \
--volume=/var/run:/var/run:rw \
--volume=/sys:/sys:ro \
--volume=/var/lib/docker/:/var/lib/docker:ro \
--publish=8080:8080 \
--detach=true \
--name=cadvisor \
google/cadvisor:latest
#find ./ -type d -exec mkdir -p [[대상폴더]]/{} \;
#ex
find ./ -type d -exec mkdir -p ~/temp2/dst/{} \;
#포트는 확인 할 것.
sudo docker run -d -p 80:80 --name svn-server krisdavison/svn-server:v2.0 /startup.sh
# 접속
sudo docker exec -it <container-name> bash
# 저장소 추가
svnadmin create myrepo
#사용자 추가
@otwm
otwm / wm_concat_define
Created March 29, 2016 01:58
wm_concat 함수 재정의
CREATE OR REPLACE TYPE t_string_agg AS OBJECT
(
g_string VARCHAR2(32767),
STATIC FUNCTION ODCIAggregateInitialize(sctx IN OUT t_string_agg)
RETURN NUMBER,
MEMBER FUNCTION ODCIAggregateIterate(self IN OUT t_string_agg,
value IN VARCHAR2 )
@otwm
otwm / sql
Created March 2, 2016 04:20
oracle 계정생성
1. 계정의 테이블 스페이스 생성
create tablespace [tablespace_name]
datafile '/home/oracle/oradata/DANBEE/[file_name].dbf' size 500m;
예)
CREATE TABLESPACE ADMIN DATAFILE 'D:\ORACLE\ORADATA\XE\ADMIN.dbf' SIZE 500M ;
2. 오라클 유저 만들기
@otwm
otwm / sql
Created March 2, 2016 04:18
oracle 만료기간 설정
-- 만료기간 검색
select resource_name, limit from dba_profiles
where profile='DEFAULT'
;
-- 만료기간 무제한 설정
alter profile default limit password_life_time unlimited;
-- 만료 계정 검색
select username,account_status,lock_date,expiry_date from dba_users
@otwm
otwm / [ubuntu]hash sum problem fix.txt
Last active March 18, 2016 20:13
[ubuntu]hash sum problem fix
sed -i 's/kr.archive.ubuntu.com/ftp.daum.net/g' /etc/apt/sources.list
@otwm
otwm / build.gradle
Created January 1, 2016 18:17
queryDsl generate by gradle
apply plugin: 'spring-boot'
jar {
baseName = 'core'
version = '0.5.0'
}
sourceSets {
generated {