https://www.adminschool.net/wiki/ 2026-04-21T23:49:11+00:00 https://www.adminschool.net/wiki/ https://www.adminschool.net/wiki/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2021-05-27T13:16:40+00:00 starlits (starlits@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=study&rev=1622121400&do=diff History Lecture * Oracle Performance Tuning * Oracle Administrator I * Oracle Administrator II Database * 화랑도 - 새로쓴 데용량 데이타베이스 솔루션 2010-04-29 ~ 2010-07-15 * Oracle Database 2 Day DBA : 2010-01-28 ~ 2010-04-01 * Advanced OWI in Oracle 10g : 2009-07-31 ~ 2009-09-18 * Oracle Database 10g Administration workshop II : 2008-03-23 ~ 2008-06-22 * Oracle Database 10g Administration workshop I : 2008-01-13 ~ 2008-03-09 * 새로쓴 데용량 데이타베이스 솔루션 : 2007-09-19 ~ 2007-12-11 … text/html 2021-02-26T11:23:55+00:00 starlits (starlits@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=os:ubuntu:apt:hold&rev=1614338635&do=diff 특정 패키지 업데이트 막기 패키지 리스트 조회 dpkg --get-selections 업그레이드 hold하기 및 hold해지하기 * google-chrome-stable 패키지를 업그레이드를 막고 싶다면 echo "google-chrome-stable hold" | sudo dpkg --set-selections text/html 2021-02-26T11:19:04+00:00 starlits (starlits@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=os:ubuntu&rev=1614338344&do=diff Ubuntu * 우분투 설치후 설정해야 할일들 * warning: setlocale: LC_CTYPE: cannot change locale (UTF-8) 에러 대응 * letsencrypt install on ubuntu * 특정 패키지 업데이트 막기 (hold) text/html 2021-01-13T03:39:11+00:00 starlits (starlits@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:oracle:tools:sqldeveloper:troubleshoot&rev=1610509151&do=diff SQL Developer TroubleShoot MacOS Big Sur ERROR FIX * Locale not recoginized 에러가 발생했을때도 적용하면 된다. * $HOME/.sqldeveloper/20.2.0/product.conf # JAVA_HOME ( MacOS Big Sur ERROR FIX ) SetJavaHome /Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/ # ERROR : Locale not recoginized AddVMOption -Duser.language=ko AddVMOption -Duser.country=KR text/html 2020-12-25T01:10:41+00:00 starlits (starlits@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:mysql:admin:recovery:comment&rev=1608858641&do=diff MySQL 복원시 주석까지 복구 * mysqldump 로 DB 및 프로시저 백업시 백업 파일에는 주석이 정상적으로 백업된다. * 복원시 주석이 제거되는데, 다음 옵션을 주면 주석도 복원 된다. mysql -uroot -p -c < mysql_dumpfile.sql text/html 2020-12-25T01:08:13+00:00 starlits (starlits@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:mysql&rev=1608858493&do=diff MySQL Admin * root 패스워드 변경 * mysql 명령어로 접근하기 * 계정,데이타베이스 생성 명령어 * mysql UTF-8 * MySQL Administrator Tip & Tech * MySQL backup and restore * 테이블(table) 크기 확인 * 백업/복구시 주석까지 복구 MySQL 5.5 * MySQL 5.5 설치 * MySQL 5.5 New Features * MySQL 5.5 Backup & Recovery Scenario v1.0 Developer * MySQL Query * MySQL Comment 설정 및 조회 * MySQL Procedure * MySQL 암복호화 ( encode, decode, password ) * MySQL 날짜함수… text/html 2020-06-26T03:18:15+00:00 starlits (starlits@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=docker&rev=1593141495&do=diff 도커(Docker) * <none> tag 도커 이미지 삭제하기 * Dockerfile 사용하기 참고사이트 * <https://didalgus.github.io/2019/08/07/Docker-Apache-PHP.html> * <https://velog.io/@wimes/docker-%EC%9D%B4%EB%AF%B8%EC%A7%80%EB%A1%9C-apache%EB%B0%8F-php-%EA%B0%9C%EB%B0%9C%ED%99%98%EA%B2%BD-%EA%B5%AC%EC%B6%95> * <https://www.daleseo.com/docker-containers/> ( 도커명령어 정리 ) text/html 2020-06-09T10:35:23+00:00 starlits (starlits@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=service:was:tomcat:shutdown&rev=1591698923&do=diff tomcat shutdown.sh 시 정상동작 하지 않을 경우 tomcat blocking issue 방법1 * O/S별 환경변수 설정 LINUX * JAVA_OPTS 설정 JAVA_OPTS="$JAVA_OPTS -Djava.security.egd=file:/dev/./urandom" Windows * 내컴퓨터 > 고급 시스템 설정 > 고급 > 환경 변수(N).. > 시스템 변수(S) > 새로 만들기(W).. text/html 2020-06-06T12:47:44+00:00 starlits (starlits@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=service:was:tomcat&rev=1591447664&do=diff Tomcat * Install Tomcat 6 on Debian (squeeze) with virtual hosts and Apache2 integration * CentOS 5 에서 설치하기 * Deian Linux (Etch) 에서 Apache 2.2 와 Tomcat 5.5 설치(연동) * Connection Pool 설정하기 * shutdown.sh 실행시 서비스가 종료되지 않는 경우 한글문제 해결책 * <http://kwon37xi.egloos.com/1462013> 참고사이트 * DBCP와 iBatis를 통한 Connection Pooling 사용기 * 초보 Java 웹 개발자들을 위한 학습 로드맵… text/html 2020-06-06T12:29:26+00:00 starlits (starlits@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=os:ubuntu:letsencrypt&rev=1591446566&do=diff letsencrypt letsencrypt 설치 * letsencrypt 설치 # apt-get update ; apt-get dselect-upgrade -f fix-missing upgrade # apt-cache search letsencrypt # apt-get install letsencrypt # apt-cache show letsencrypt * ubuntu 는 certbot 를 이용한다. text/html 2020-03-19T15:54:55+00:00 starlits (starlits@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?image=dbms%3Aoracle%3Atools%3Adbeaver%3A%EC%8A%A4%ED%81%AC%EB%A6%B0%EC%83%B7_2020-03-20_%EC%98%A4%EC%A0%84_12.54.35.png&ns=dbms%3Aoracle%3Atools%3Adbeaver&rev=1584633295&tab_details=history&media_do=diff&do=media <img src="https://www.adminschool.net/wiki/lib/exe/fetch.php?w=500&amp;h=500&amp;tok=aa6a38&amp;media=dbms:oracle:tools:dbeaver:%EC%8A%A4%ED%81%AC%EB%A6%B0%EC%83%B7_2020-03-20_%EC%98%A4%EC%A0%84_12.54.35.png" alt="스크린샷_2020-03-20_오전_12.54.35.png" loading="lazy" width="500" height="500" /> text/html 2016-06-17T02:00:11+00:00 starlits (starlits@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?image=dbms%3Aoracle%3Adata%3Aslide53.png&ns=dbms%3Aoracle%3Adata&rev=1466128811&tab_details=history&media_do=diff&do=media <img src="https://www.adminschool.net/wiki/lib/exe/fetch.php?w=500&amp;h=500&amp;tok=e027d7&amp;media=dbms:oracle:data:slide53.png" alt="slide53.png" loading="lazy" width="500" height="500" /> text/html 2016-06-17T01:43:29+00:00 starlits (starlits@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?image=dbms%3Aoracle%3Adata%3Adissassembling_the_data_block.pdf&ns=dbms%3Aoracle%3Adata&rev=1466127809&tab_details=history&media_do=diff&do=media <img src="https://www.adminschool.net/wiki/lib/images/fileicons/svg/pdf.svg" alt="dissassembling_the_data_block.pdf" loading="lazy" width="500" height="500" /> text/html 2016-06-17T01:40:03+00:00 starlits (starlits@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?image=dbms%3Aoracle%3Adata%3Aoracle_forensics_part_1._dissecting_the_redo_logs.pdf&ns=dbms%3Aoracle%3Adata&rev=1466127603&tab_details=history&media_do=diff&do=media <img src="https://www.adminschool.net/wiki/lib/images/fileicons/svg/pdf.svg" alt="oracle_forensics_part_1._dissecting_the_redo_logs.pdf" loading="lazy" width="500" height="500" /> text/html 2016-06-17T01:28:17+00:00 starlits (starlits@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?image=dbms%3Aoracle%3Aconcept%3Aoracle_data_block_layout.gif&ns=dbms%3Aoracle%3Aconcept&rev=1466126897&tab_details=history&media_do=diff&do=media <img src="https://www.adminschool.net/wiki/lib/exe/fetch.php?w=500&amp;h=500&amp;tok=5be023&amp;media=dbms:oracle:concept:oracle_data_block_layout.gif" alt="oracle_data_block_layout.gif" loading="lazy" width="500" height="500" /> text/html 2015-06-24T00:43:02+00:00 starlits (starlits@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?image=application%3A2011_netcat%E1%84%8E%E1%85%A1%E1%86%B7%E1%84%80%E1%85%A9%E1%84%89%E1%85%A5_v1.pdf&ns=application&rev=1435106582&tab_details=history&media_do=diff&do=media <img src="https://www.adminschool.net/wiki/lib/images/fileicons/svg/pdf.svg" alt="2011_netcat참고서_v1.pdf" loading="lazy" width="500" height="500" /> text/html 2014-07-18T13:29:24+00:00 starlits (starlits@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?image=design%3Afont%3A%E1%84%87%E1%85%B5%E1%84%89%E1%85%A1%E1%86%BC%E1%84%8B%E1%85%A5%E1%86%B8%E1%84%8C%E1%85%A5%E1%86%A8%E1%84%8B%E1%85%B5%E1%84%8B%E1%85%AD%E1%86%BC_%E1%84%86%E1%85%AE%E1%84%85%E1%85%AD%E1%84%91%E1%85%A9%E1%86%AB%E1%84%90%E1%85%B3.jpg&ns=design%3Afont&rev=1405690164&tab_details=history&media_do=diff&do=media <img src="https://www.adminschool.net/wiki/lib/exe/fetch.php?w=500&amp;h=500&amp;tok=789c16&amp;media=design:font:%E1%84%87%E1%85%B5%E1%84%89%E1%85%A1%E1%86%BC%E1%84%8B%E1%85%A5%E1%86%B8%E1%84%8C%E1%85%A5%E1%86%A8%E1%84%8B%E1%85%B5%E1%84%8B%E1%85%AD%E1%86%BC_%E1%84%86%E1%85%AE%E1%84%85%E1%85%AD%E1%84%91%E1%85%A9%E1%86%AB%E1%84%90%E1%85%B3.jpg" alt="비상업적이용_무료폰트.jpg" loading="lazy" width="500" height="500" /> text/html 2014-07-18T13:28:55+00:00 starlits (starlits@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?image=design%3Afont%3A%E1%84%89%E1%85%A1%E1%86%BC%E1%84%8B%E1%85%A5%E1%86%B8%E1%84%8C%E1%85%A5%E1%86%A8%E1%84%8B%E1%85%B5%E1%84%8B%E1%85%AD%E1%86%BC_%E1%84%86%E1%85%AE%E1%84%85%E1%85%AD%E1%84%91%E1%85%A9%E1%86%AB%E1%84%90%E1%85%B3.jpg&ns=design%3Afont&rev=1405690135&tab_details=history&media_do=diff&do=media <img src="https://www.adminschool.net/wiki/lib/exe/fetch.php?w=500&amp;h=500&amp;tok=86f2d5&amp;media=design:font:%E1%84%89%E1%85%A1%E1%86%BC%E1%84%8B%E1%85%A5%E1%86%B8%E1%84%8C%E1%85%A5%E1%86%A8%E1%84%8B%E1%85%B5%E1%84%8B%E1%85%AD%E1%86%BC_%E1%84%86%E1%85%AE%E1%84%85%E1%85%AD%E1%84%91%E1%85%A9%E1%86%AB%E1%84%90%E1%85%B3.jpg" alt="상업적이용_무료폰트.jpg" loading="lazy" width="500" height="500" /> text/html 2014-07-18T13:24:37+00:00 starlits (starlits@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?image=%E1%84%87%E1%85%B5%E1%84%89%E1%85%A1%E1%86%BC%E1%84%8B%E1%85%A5%E1%86%B8%E1%84%8C%E1%85%A5%E1%86%A8%E1%84%8B%E1%85%B5%E1%84%8B%E1%85%AD%E1%86%BC_%E1%84%86%E1%85%AE%E1%84%85%E1%85%AD%E1%84%91%E1%85%A9%E1%86%AB%E1%84%90%E1%85%B3.jpg&ns=0&rev=1405689877&tab_details=history&media_do=diff&do=media <img src="https://www.adminschool.net/wiki/lib/exe/fetch.php?w=500&amp;h=500&amp;tok=2f9215&amp;media=%E1%84%87%E1%85%B5%E1%84%89%E1%85%A1%E1%86%BC%E1%84%8B%E1%85%A5%E1%86%B8%E1%84%8C%E1%85%A5%E1%86%A8%E1%84%8B%E1%85%B5%E1%84%8B%E1%85%AD%E1%86%BC_%E1%84%86%E1%85%AE%E1%84%85%E1%85%AD%E1%84%91%E1%85%A9%E1%86%AB%E1%84%90%E1%85%B3.jpg" alt="비상업적이용_무료폰트.jpg" loading="lazy" width="500" height="500" /> text/html 2014-07-18T13:22:28+00:00 starlits (starlits@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?image=%E1%84%89%E1%85%A1%E1%86%BC%E1%84%8B%E1%85%A5%E1%86%B8%E1%84%8C%E1%85%A5%E1%86%A8%E1%84%8B%E1%85%B5%E1%84%8B%E1%85%AD%E1%86%BC_%E1%84%86%E1%85%AE%E1%84%85%E1%85%AD%E1%84%91%E1%85%A9%E1%86%AB%E1%84%90%E1%85%B3.jpg&ns=0&rev=1405689748&tab_details=history&media_do=diff&do=media <img src="https://www.adminschool.net/wiki/lib/exe/fetch.php?w=500&amp;h=500&amp;tok=5496d5&amp;media=%E1%84%89%E1%85%A1%E1%86%BC%E1%84%8B%E1%85%A5%E1%86%B8%E1%84%8C%E1%85%A5%E1%86%A8%E1%84%8B%E1%85%B5%E1%84%8B%E1%85%AD%E1%86%BC_%E1%84%86%E1%85%AE%E1%84%85%E1%85%AD%E1%84%91%E1%85%A9%E1%86%AB%E1%84%90%E1%85%B3.jpg" alt="상업적이용_무료폰트.jpg" loading="lazy" width="500" height="500" />