Zasfe's memory

기억 보존용 데이터 저장

# 참고

1. 워나크라이(WannaCry)’ 랜섬웨어는 윈도 운영체제 SMBv2 원격코드실행 취약점*에 대한 패치를 적용하지 않아 보안이 취약한 PC로 전파되며, PC 내 

다양한 문서파일(doc, ppt, hwp 등), 압축파일, DB 파일, 가상머신 파일 등을 암호화하여 사용하지 못하게 만든다.

2. MS 링크

영문: https://technet.microsoft.com/en-us/library/security/ms17-010.aspx

한글: https://technet.microsoft.com/ko-kr/library/security/MS17-010.aspx

업데이트 파일 다운로드 : http://www.catalog.update.microsoft.com/Search.aspx?q=KB4012598

MS고객가이드: https://blogs.technet.microsoft.com/msrc/2017/05/12/customer-guidance-for-wannacrypt-attacks/

MS코드분석: https://blogs.technet.microsoft.com/mmpc/2017/05/12/wannacrypt-ransomware-worm-targets-out-of-date-systems/

# 증상

아래 이벤트 로그가 지속적으로 발생한다.

# 참고문서

http://support2.microsoft.com/kb/920783

예전에 리눅스에서 오라클 실행할줄도 몰라서 쩔쩔매엇던 기억이 난다..-_-;;
이게 또 사용을 안하니깐 기억이 가물가물해질려고해서 간단하게 메모를 남긴다...

최초 오라클 계정으로 접속한 후 (11 기준)
# su - oracle
# sqlplus /nolog 
   SQL> conn /as sysdba 
   SQL> startup

기본적으로 오라클이 실행된다. 그후 리스너를 실행시키자.

[root@localhost ~]# su - oracle
[oracle@localhost ~]$ sqlplus /nolog
 
SQL*Plus: Release 11.2.0.1.0 Production on Fri Jul 4 09:30:27 2014
 
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
 
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
 
Total System Global Area 6680915968 bytes
Fixed Size                  2213936 bytes
Variable Size            3556771792 bytes
Database Buffers         3087007744 bytes
Redo Buffers               34922496 bytes
Database mounted.
Database opened.
SQL> 

# lsnrctl start     -> 리스너 실행
# lsnrctl status   -> 리스너 상태
# lsnrctl stop     -> 리스너 정지

[oracle@localhost ~]$ lsnrctl start
 
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-JUL-2014 09:31:31
 
Copyright (c) 1991, 2009, Oracle.  All rights reserved.
 
Starting /database/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...
 
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /database/oracle/product/11.2.0/db_1/network/admin/listener.ora
Log messages written to /database/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                04-JUL-2014 09:31:33
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /database/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /database/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@localhost ~]$ lsnrctl status
 
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-JUL-2014 09:31:40
 
Copyright (c) 1991, 2009, Oracle.  All rights reserved.
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                04-JUL-2014 09:31:33
Uptime                    0 days 0 hr. 0 min. 7 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /database/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /database/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@localhost ~]$ lsnrctl status
 
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-JUL-2014 09:31:42
 
Copyright (c) 1991, 2009, Oracle.  All rights reserved.
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                04-JUL-2014 09:31:33
Uptime                    0 days 0 hr. 0 min. 9 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /database/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /database/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
The listener supports no services
The command completed successfully

# 주의

- CentOS 4.x 는 2013-11-09 최종 Maintenance 가 완료됨.

- 해당 경로는 임시 경로로 해외망 접속에 문제가 없는 경우 정상 동작합니다.

http://en.wikipedia.org/wiki/CentOS#cite_note-redhat-life-cycle-dates-84

# 처리방법

cp -pa /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.old 

wget -q http://vault.centos.org/4.9/CentOS-Base.repo -O /etc/yum.repos.d/CentOS-Base.repo 

rm -rf /var/cache/yum/*