[Eglish] 외운 문구

no way, Jose.

Not much of a difference. (도토리 키재기야)

Don't worry. You doing great.

You can pay on your way out. (계산은 한번에 하면 됩니다)

Keep it up. (열심히 해라! 힘내!, 격려의 의미)
Keep up the good work (열심히 잘해봐!!, 격려의 의미)


Hit the jackpot. (


I can't dance to save my life (난 몸치야) cf) I have two legs (관용구. 잘 안씀)
I cant' do singing to save my life (난 음치야)
I cant' ~ to save my life.


Kill them(it)! (실력발휘해)
Show 'em his boss
Do your best. (위에가 더 많이 쓰는 표현)

I'm up to my neck in work (손이 열개라도 모자라)
I got a lot of my plate right now (손이 열개라도 모자라)
I'm really busy (바뻐. 잘 안씀)
I'm too busy. (나 엄청 바뻐. 거부의 의미. 잘 안씀)


There are many fishes in the sea (짚신도 짝이 있을거다. 인연이 또 있을거다. 위로)

[Java] Release Timeline

[Oracle] How to show trigger or procedure error log (트리거 또는 프로시져 에러 로그 확인 방법)

-- Current user error log
SELECT * FROM SYS.USER_ERRORS;
-- Current user error log related with trigger
SELECT * FROM SYS.USER_ERRORS WHERE TYPE ='TRIGGER';
-- Current user error log related with procedure
SELECT * FROM SYS.USER_ERRORS WHERE TYPE ='PROCEDURE';

-- All user error log
SELECT * FROM SYS.DBA_ERRORS;
-- All user error log related with trigger
SELECT * FROM SYS.DBA_ERRORS WHERE TYPE ='TRIGGER';
-- All user error log related with procedure
SELECT * FROM SYS.DBA_ERRORS WHERE TYPE ='PROCEDURE';

 

[Network] How to whether domain is registered in DNS Server( DNS서버 도메인 등록 여부 확인)

<Check whether domain is registered in default DNS server>

nslookup [DOMAIN]

<Check whether domain is registered in particular DNS server>

nslookup [DOMAIN] [DNS_SERVER]

[Oracle] Charset 확인

SELECT NAME, VALUE$ FROM SYS.PROPS$ WHERE NAME = 'NLS_CHARACTERSET';
SELECT NAME, VALUE$ FROM SYS.PROPS$ WHERE NAME = 'NLS_NCHAR_CHARACTERSET';
SELECT NAME, VALUE$ FROM SYS.PROPS$ WHERE NAME = 'NLS_LANGUAGE';

[Oracle] Unlock user that has expired password (사용자 계정 잠금/해제)

Check default password expiration time (기본 비밀번호 만료 기간 확인)

SELECT RESOURCE_NAME, LIMIT FROM DBA_PROFILES WHERE PROFILE='DEFAULT' AND RESOURCE_NAME LIKE 'PASSWORD%';

Set password expiration disabled (비밀번호 만료 해제)

ALTER PROFILE DEFAULT LIMIT  PASSWORD_LIFE_TIME UNLIMITED;

Check users have expired password (비밀번호 만료된 유저 확인)

SELECT USERNAME, ACCOUNT_STATUS, LOCK_DATE, EXPIRY_DATE FROM DBA_USERS WHERE ACCOUNT_STATUS = 'EXPIRED';

Unlock user (잠금계정 해제)

ALTER USER [USER_NAME] IDENTIFIED BY [USER_NAME];

[SUNDB] JDBC Connection Properties

[SUNDB] Install SUNDB (SUNDB 설치)

1. Setup Kernel Parameters related with Shared Memory (Shared Memory 관련 커널 파라미터 수정)

SUNDB architecture is not multi-thread but multi-process based on shared memory.
Therefore, you must kernel parameters related with shared memory.
(SUNDB는 multi-thread 구조가 아닌 shared memory 기반의 Multi-process 구조로 되어 있다. 그러므로 shared memory 관련된 커널 파라미터를 수정해줘야한다.)

1.1. Check Parameters

#> ipcs -l

1.2. Change parameters permanently and apply it (파라미터 변경 및 적용)

#> vi /etc/sysctl.conf

# shared memory
kernel.shmmax = 34359738368
kernel.shmall = 8388608
kernel.shmmni = 4096
# semaphore
kernel.sem = 250 32000 100 128

#> sysctl -p

2. Install DBMS

2.1. Uncompressed install file (설치파일 압축해제)

#> cd [INSTALL_DIRECTORY]
#> tar xvf [INSTALL_FILE]

2.2. Setup environment variables (환경변수 설정)

#> vi ~/.bashrc

# for SUNDB
export SUNDB_HOME=[INSTALLED_HOME_DIRECTROY]
export SUNDB_DATA=[INSTALLED_DATA_DIRECTROY]
export PATH=$SUNDB_HOME/bin:$PATH
export LD_LIBRARY=$SUNDB_HOME/lib:$LD_LIBRARY_PATH

#>. ~/.bashrc

3. Create Database (DB 생성)

3.1. create DB (DB 생성)

#> gcreatedb --help
#> gcreatedb --db_name="[DB_NAME]" --db_comment="[DB_COMMENT]" --timezone="[{+/-}{TZH:TZM}]" --character_set="[SQL_ASCII | UTF8 | UHC | GB18030] --char_length_units="[OCTETS | CHARACTERS]"

3.2. Open DB for creating dictionary schema (Dictionary Schema 생성을 위한 DB open)

#> gsql --as sysdba

gSQL> \startup open

3.3. Create dictionary schema (Dictionary Schema 생성)

#> gsql --as sysdba --import $SUNDB_HOME/admin/DictionarySchema.sql
#> gsql --as sysdba --import $SUNDB_HOME/admin/InformationSchema.sql
#> gsql --as sysdba --import $SUNDB_HOME/admin/PerformanceViewSchema.sql

4. Startup DB (DB 구동)

4.1. Startup DB (DB 구동)

#> gsql --as sysdb

gSQL> \startup nomount
gSQL> \alter system mount database;
gSQL> \alter system open database;

4.2. Startup listener (리스너 구동)

#> glsnr --start