Tina Admin

Size: px

Start display at page:

Download "Tina Admin"

형탁 초
5 years ago
Views:

1 유니원아이앤씨 DB 팀최순석 문서정보프로젝트명서브시스템명 버전 1.0 문서명 작성일 작성자 최순석 최종수정일 문서번호 UNIONE css 재개정이력 일자내용수정인버전 문서배포이력 발신자수신자배포목적일자비고.

2 Table of Contents 1 개요 기본설정 파일업로드 압축해제 설정파일수정 실행및종료 실행 종료 수집항목내용 ifconfig iostat meminfo mpstat netstat prvstat ps slabinfo top vmstat OSWatcher 에대한의견 참고자료 owsbb 사용방법 java 최신버전다운로드 java 설치 java 등록 oswbb 실행 gif파일생성 archive 경로에수집된자료의그래프

3 1 개요 OSWatcher 사용밥법기술 2 기본설정 OSWatcher (Includes: [Video]) ( 문서 ID ) => 문서를통해최신파일다운로드 : oswbb732 OS Watcher User's Guide ( 문서 ID ) 2.1 파일업로드 ex ) $> /oracle/work/oswbb732.tar 2.2 압축해제 $> tar xvf oswbb732.tar $> ls l drwxrwxr-x 2 oracle 502 drwxr-xr-x 12 oracle dba drwxrwxr-x 2 oracle 502 drwxrwxr-x 4 oracle 502 drwxrwxr-x 2 oracle 502 drwxr-xr-x 2 oracle May 2 19:46 analysis 4096 Oct 6 17:57 archive 67 Jan call_du.sh 68 Oct call_sar.sh 71 Jan call_uptime.sh 4096 May 2 19:46 data 4096 Sep 9 00:37 docs 626 Jan Example_extras.txt 1864 Oct Exampleprivate.net 4096 May 2 19:49 gif 772 May 8 22:21 ifconfigsub.sh 743 Oct iosub.sh 4096 Oct 10 13:15 locks 1486 Jan ltop.sh 542 Oct mpsub.sh 740 Oct nfssub.sh 3/24

4 5062 Sep 17 18:15 OSWatcherFM.sh Sep 17 18:27 OSWatcher.sh Sep 5 23:37 oswbba.jar -rwxr-xr-x 1 oracle dba drwxrwxr-x 2 oracle 502 drwxrwxr-x 2 oracle 502 drwxr-xr-x 2 oracle dba 414 Oct oswib.sh 435 Jan oswnet.sh 825 Oct oswrds.sh 524 Oct oswsub.sh 262 Oct 6 17:25 private.net 4096 May 2 19:50 profile 1445 Oct psmemsub.sh 4096 May 2 19:50 src 2385 Oct startoswbb.sh 558 Oct 10 09:11 stoposwbb.sh 746 Nov tarupfiles.sh 4219 Nov tar_up_partial_archive.sh 4096 Oct 10 13:15 tmp 537 Jan topaix.sh 544 Oct vmsub.sh 1486 Jan xtop.sh # uninstall 방법은디렉토리를삭제하면된다 $> rm -rf oswbb 2.3 설정파일수정 $> cp /oracle/work/oswbb/exampleprivate.net /oracle/work/oswbb/private.net $> vi / oracle/work/oswbb/private.net # This file contains examples of how to monitor private networks. To # monitor your private networks create an executable file in this same # directory named private.net. Use the example for your host os below. # Make sure not to remove the last line in this file. Your file # private.net MUST contain the rm lock.file line. #Solaris Example 4/24

5 echo "zzz ***"`date` traceroute -r -F <node1-priv> traceroute -I -r -F <node1-priv> traceroute -r -F <node2-priv> traceroute -I -r -F <node2-priv> #HP Example echo "zzz ***"`date` traceroute -r -F <node1-priv> traceroute -r -F <node2-priv> #Linux Example echo "zzz ***"`date` traceroute -r -F <node1-priv> traceroute -r -F <node2-priv> #Tru64 Example echo "zzz ***"`date` traceroute -r -f <node1-priv> traceroute -r -f <node2-priv> #AIX Example echo "zzz ***"`date` traceroute -r <node1-priv> traceroute -r <node2-priv> # DO NOT DELETE THE FOLLOWING LINE!!!!!!!!!!!!!!!!!!!!! rm locks/lock.file 5/24

6 ==> 위항목중에운영중인 OS의설정을제외한다른항목은제거한다. ex) linux #Linux Example echo "zzz ***"`date` traceroute -r -F <node1-priv> traceroute -r -F <node2-priv> # DO NOT DELETE THE FOLLOWING LINE!!!!!!!!!!!!!!!!!!!!! rm locks/lock.file ==> 싱글 db 의경우서버호스트네임을입력하면된다 3 실행및종료 3.1 실행 $> cd /oracle/work/oswbb/ $>./ startoswbb.sh # 옵션을이용해서백그라운드로수행한다 => nohup./startoswbb.sh 60 1 gzip & : 60초마다 1회씩수집하고파일은자동 gzip 실행 [1] nohup: appending output to `nohup.out' $> ps -ef grep OSWatcher.sh oracle :25 pts/1 00:00:00 /bin/sh./oswatcher.sh 60 1 gzip # oswatcher 을실행할경우./oswbb/archive 폴더가자동생성되며 archive 하위에실행되는각각의수집명령에관련된폴더들이추가로생성된다 $> pwd /oracle/work/oswbb/archive drwxr-xr-x 2 oracle dba 4096 Oct 10 13:00 oswifconfig 6/24

7 drwxr-xr-x 2 oracle dba 4096 Oct 10 13:00 oswiostat drwxr-xr-x 2 oracle dba 4096 Oct 10 13:00 oswmeminfo drwxr-xr-x 2 oracle dba 4096 Oct 10 13:00 oswmpstat drwxr-xr-x 2 oracle dba 4096 Oct 10 13:00 oswnetstat drwxr-xr-x 2 oracle dba 4096 Oct 10 13:00 oswprvtnet drwxr-xr-x 2 oracle dba 4096 Oct 10 13:00 oswps drwxr-xr-x 2 oracle dba 4096 Oct 10 13:00 oswslabinfo drwxr-xr-x 2 oracle dba 4096 Oct 10 13:00 oswtop drwxr-xr-x 2 oracle dba 4096 Oct 10 13:00 oswvmstat 3.2 종료 $> cd /oracle/work/oswbb/ $>./ stoposwbb.sh 4 수집항목내용 4.1 ifconfig zzz ***Fri Oct 10 13:36:54 KST 2014 eth0 Link encap:ethernet HWaddr 08:00:27:D1:6D:E9 inet addr: Bcast: Mask: UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:28174 errors:0 dropped:0 overruns:0 frame:0 TX packets:22353 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes: (8.2 MiB) TX bytes: (4.1 MiB) lo Link encap:local Loopback inet addr: Mask: UP LOOPBACK RUNNING MTU:16436 Metric:1 RX packets:26907 errors:0 dropped:0 overruns:0 frame:0 TX packets:26907 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:0 RX bytes: (3.9 MiB) TX bytes: (3.9 MiB 7/24

8 4.2 iostat zzz ***Fri Oct 10 13:36:54 KST 2014 avg-cpu: %user %nice %system %iowait %steal %idle Device: rrqm/s wrqm/s r/s w/s rkb/s wkb/s avgrq-sz avgqu-sz await svctm %util sda sda sda sda sda meminfo zzz ***Fri Oct 10 13:36:54 KST 2014 MemTotal: MemFree: Buffers: Cached: SwapCached: Active: Inactive: Active(anon): Inactive(anon): Active(file): Inactive(file): Unevictable: Mlocked: SwapTotal: SwapFree: Dirty: Writeback: AnonPages: Mapped: Shmem: Slab: kb kb kb kb 3372 kb kb kb kb kb kb kb 4448 kb 4448 kb kb kb 76 kb 0 kb kb kb kb kb 8/24

9 SReclaimable: SUnreclaim: KernelStack: PageTables: NFS_Unstable: Bounce: WritebackTmp: CommitLimit: Committed_AS: VmallocTotal: VmallocUsed: VmallocChunk: kb kb 1696 kb kb 0 kb 0 kb 0 kb kb kb kb 8000 kb kb HugePages_Total: 0 HugePages_Free: 0 HugePages_Rsvd: 0 HugePages_Surp: 0 Hugepagesize: DirectMap4k: DirectMap2M: 2048 kb 8128 kb kb 4.4 mpstat zzz ***Fri Oct 10 13:36:54 KST 2014 Linux el5uek (single) 10/10/ :36:54 PM CPU %user %nice %sys %iowait %irq %soft %steal %idle intr/s 01:36:55 PM all :36:55 PM :36:55 PM CPU %user %nice %sys %iowait %irq %soft %steal %idle intr/s 01:36:56 PM all :36:56 PM Average: CPU %user %nice %sys %iowait %irq %soft %steal %idle intr/s Average: all Average: /24

10 4.5 netstat zzz ***Fri Oct 10 13:36:54 KST 2014 Kernel Interface table Iface MTU Met RX-OK RX-ERR RX-DRP RX-OVR TX-OK TX-ERR TX-DRP TX-OVR Flg eth BMRU lo LRU Ip: total packets received 182 with invalid addresses 0 forwarded 0 incoming packets discarded incoming packets delivered requests sent out 42 dropped because of missing route Icmp: 4947 ICMP messages received 0 input ICMP message failed. ICMP input histogram: destination unreachable: ICMP messages sent 0 ICMP messages failed ICMP output histogram: destination unreachable: 4947 IcmpMsg: InType3: 4947 OutType3: 4947 Tcp: 6869 active connections openings 19 passive connection openings 6864 failed connection attempts 10 connection resets received 5 connections established segments received segments send out 6 segments retransmited 10/24

11 0 bad segments received resets sent Udp: 55 packets received 4947 packets to unknown port received. 0 packet receive errors 4972 packets sent UdpLite: TcpExt: 3 TCP sockets finished time wait in fast timer 1 time wait sockets recycled by time stamp 495 delayed acks sent 4 delayed acks further delayed because of locked socket 261 packets directly queued to recvmsg prequeue packets directly received from prequeue packets header predicted 72 packets header predicted and directly queued to user 5202 acknowledgments not containing data received 2119 predicted acknowledgments 0 TCP data loss events 6 other TCP timeouts 6 DSACKs received 1 connections reset due to early user close 8 connections aborted due to timeout TCPDSACKIgnoredOld: 6 IpExt: InMcastPkts: 42 OutMcastPkts: 14 InBcastPkts: 1478 InOctets: OutOctets: InMcastOctets: 5915 OutMcastOctets: 2125 InBcastOctets: /24

12 4.6 prvstat zzz ***Fri Oct 10 13:34:54 KST 2014 traceroute to single ( ), 30 hops max, 40 byte packets 1 single ( ) ms ms ms zzz ***Fri Oct 10 13:35:54 KST 2014 traceroute to single ( ), 30 hops max, 40 byte packets 1 single ( ) ms ms ms zzz ***Fri Oct 10 13:36:54 KST 2014 traceroute to single ( ), 30 hops max, 40 byte packets 1 single ( ) ms ms ms 4.7 ps zzz ***Fri Oct 10 13:35:54 KST 2014 USER PID PPID PRI %CPU %MEM VSZ RSS WCHAN S STARTED TIME COMMAND oracle semtim S Oct 09 00:00:06 ora_smon_stg oracle semtim S Oct 09 00:00:29 ora_mmon_stg oracle semtim S Oct 09 00:00:19 ora_dbw0_stg oracle semtim S Oct 09 00:01:07 ora_cjq0_stg oracle semtim S 12:57:42 00:00:11 ora_j000_stg oracle semtim S Oct 09 00:00:03 ora_arc2_stg... root worker S Oct 09 00:00:00 [kintegrityd/0] root poll_s S Oct 09 00:00:00 /sbin/udevd -d root bdi_fo S Oct 09 00:00:00 [bdi-default] root bdi_sy S Oct 09 00:00:00 [sync_supers] root async_ S Oct 09 00:00:00 [async/mgr] root poll_s S Oct 09 00:00:01 init [5] oracle pipe_w S 13:36:54 00:00:00 sort -nr -k 6 oracle R 13:36:54 00:00:00 ps -aeo user,pid,ppid,pri,pcpu,pmem,vsize,rssize,wchan,s,start,cputime,command oracle hrtime S 13:36:54 00:00:00 sleep 60 oracle pause S 13:36:54 00:00:00 iostat -xk 1 3 oracle pause S 13:36:54 00:00:00 mpstat -P ALL /24

13 oracle hrtime S 13:36:54 00:00:00 vmstat 1 3 avahi unix_s S Oct 09 00:00:00 avahi-daemon: chroot helper evdev_ S Oct 09 00:00:00 hald-addon-keyboard: listening on /dev/input/event evdev_ S Oct 09 00:00:00 hald-addon-keyboard: listening on /dev/input/event evdev_ S Oct 09 00:00:00 hald-addon-keyboard: listening on /dev/input/event unix_s S Oct 09 00:00:00 hald-addon-acpi: listening on acpid socket /var/run/acpid.socket 4.8 slabinfo zzz ***Fri Oct 10 13:36:54 KST 2014 slabinfo - version: 2.1 # name <active_objs> <num_objs> <objsize> <objperslab> <pagesperslab> : tunables <limit> <batchcount> <sharedfactor> : slabdata <active_slabs> <num_slabs> <sharedavail> rpc_buffers : tunables : slabdata rpc_tasks : tunables : slabdata rpc_inode_cache : tunables : slabdata iser_descriptors : tunables : slabdata ib_mad : tunables : slabdata size-32(dma) : tunables : slabdata size : tunables : slabdata size : tunables : slabdata kmem_cache : tunables : slabdata top zzz ***Fri Oct 10 13:36:54 KST 2014 top - 13:36:56 up 1 day, 2:00, 4 users, load average: 0.00, 0.00, 0.00 Tasks: 182 total, 1 running, 181 sleeping, 0 stopped, 0 zombie Cpu(s): 2.0%us, 2.0%sy, 0.0%ni, 95.1%id, 1.0%wa, 0.0%hi, 0.0%si, 0.0%st 13/24

14 Mem: k total, k used, 19744k free, 28916k buffers Swap: k total, 20804k used, k free, k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND oracle R :00.03 top 2503 root m 10m 3924 S :12.69 Xorg root S :00.73 sshd 1 root S :01.15 init 2 root S :00.00 kthreadd 3 root RT S :00.00 migration/0 4 root S :26.46 ksoftirqd/0 5 root RT S :00.00 watchdog/0 6 root S :04.08 events/0 7 root S :00.00 cpuset 8 root S :00.02 khelper 9 root S :00.00 netns 4.10 vmstat zzz ***Fri Oct 10 13:36:54 KST 2014 procs memory swap io system cpu r b swpd free buff cache si so bi bo in cs us sy id wa st OSWatcher 에대한의견 오라클SR 확인결과 OSWatcher 실행시 OS에미치는영향은거의없다고합니다. 서버에부하를주지않기때문에운영서버에평상시걸어놔도문제가없다고합니다. 한가지고려할사항은로그파일사이즈와관련해서디스크공간확보문제인데, 테스트결과 60 1 설정의경우 1일누적로그사이즈가 5M 를넘지않았습니다. 여기에 gzip 옵션을추가할경우 2M 정도로감소하는것을확인했습니다. 노트북의테스트환경과실제운영서버환경의차이가있겠지만그크기차는미미할것으로예상합니다. 서버과부하를야기시키지도않고다양한 OS 정보를수집할수있는 OSWatcher 를활용해봅시다. 14/24

15 6 참고자료 owsbb 사용방법 java version 이상설치 xwindow 환경설정 - 조건이안될경우 gif 파일을생성해서분석가능하다. OSWatcher Analyzer User Guide ( 문서 ID ) 6.1 java 최신버전다운로드 java 설치 # cd /usr/ # mkdir java # cd java # tar zxvf jre-7u7-linux-x64.tar.gz # java 설치경로 : /usr/java/jre1.7.0_67/bin 6.3 java 등록 $> java version java version "1.4.2" gij (GNU libgcj) version (Red Hat ) Copyright (C) 2006 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. $ su # cd /usr/bin #> ls l java lrwxrwxrwx 1 root root 22 Nov java -> /etc/alternatives/java #> mv java java.1.4.bak #> ls -l java* lrwxrwxrwx 1 root root 22 Nov java.1.4.bak -> /etc/alternatives/java lrwxrwxrwx 1 root root 23 Nov javac -> /etc/alternatives/javac 15/24

16 lrwxrwxrwx 1 root root 25 Nov javadoc -> /etc/alternatives/javadoc lrwxrwxrwx 1 root root 23 Nov javah -> /etc/alternatives/javah #> ln -s /usr/java/jre1.7.0_67/bin /usr/bin/java #> ls -l java* lrwxrwxrwx 1 root root 25 Oct 10 15:02 java -> /usr/java/jre1.7.0_67/bin lrwxrwxrwx 1 root root 22 Nov java.1.4.bak -> /etc/alternatives/java lrwxrwxrwx 1 root root 23 Nov javac -> /etc/alternatives/javac lrwxrwxrwx 1 root root 25 Nov javadoc -> /etc/alternatives/javadoc lrwxrwxrwx 1 root root 23 Nov javah -> /etc/alternatives/javah #> ls -l /usr/bin/java lrwxrwxrwx 1 root root 25 Oct 10 15:02 /usr/bin/java -> /usr/java/jre1.7.0_67/bin $> java -version java version "1.7.0_67" Java(TM) SE Runtime Environment (build 1.7.0_67-b01) Java HotSpot(TM) 64-Bit Server VM (build b04, mixed mode) 6.4 oswbb 실행 $> java -jar oswbba.jar -i /oracle/work/oswbb/archive/ Starting OSW Analyzer V7.3.1 OSWatcher Analyzer Written by Oracle Center of Expertise Copyright (c) 2014 by Oracle Corporation Parsing Data. Please Wait... WARNING. oswbba has detected at least some of the files in you archive have been compressed. These files will not be analyzed. You must uncompress all the files in the archive for full analysis and graphing capabilities. Scanning file headers for version and platform info... Compressed file found. Ignoring single_iostat_ dat.gz... 16/24

17 Compressed file found. Ignoring single_iostat_ dat.gz... Parsing file single_iostat_ dat... Compressed file found. Ignoring single_vmstat_ dat.gz... Parsing file single_vmstat_ dat... Compressed file found. Ignoring single_netstat_ dat.gz... Parsing file single_netstat_ dat... Compressed file found. Ignoring single_top_ dat.gz... Parsing file single_top_ dat... Compressed file found. Ignoring single_ps_ dat.gz... Parsing file single_ps_ dat... Parsing Completed. Enter 1 to Display CPU Process Queue Graphs Enter 2 to Display CPU Utilization Graphs Enter 3 to Display CPU Other Graphs Enter 4 to Display Memory Graphs Enter 5 to Display Disk IO Graphs Enter 6 to Generate All CPU Gif Files Enter 7 to Generate All Memory Gif Files Enter 8 to Generate All Disk Gif Files Enter L to Specify Alternate Location of Gif Directory Enter T to Alter Graph Time Scale Only (Does not change analysis dataset) Enter D to Return to Default Graph Time Scale 17/24

18 Enter R to Remove Currently Displayed Graphs Enter A to Analyze Data Enter S to Analyze Subset of Data(Changes analysis dataset including graph time scale) Enter P to Generate A Profile Enter X to Export Parsed Data to File Enter Q to Quit Program Please Select an Option: => 위 Option 항목에 1~5 의항목을선택하면화면에그래프를띄워준다 => 위 Option 항목에 6~8 의항목을선택하면 gif 파일을생성한다. 6.5 gif 파일생성 oswbb 를실행후 Generate를선택한경우 OSWatcher 를설치한메인디렉토리에 gif 폴더가생성되고그래프로출력한파일들이날짜별로생성된다. $> ls -l /oracle/work/oswbb/gif/ Oct _ rw-r--r-- 1 oracle dba 1295 Oct 10 15:36 BlockQueue.data -rw-r--r-- 1 oracle dba 1332 Oct 10 15:36 CpuIdle.data -rw-r--r-- 1 oracle dba 1295 Oct 10 15:36 CpuSystem.data -rw-r--r-- 1 oracle dba 1295 Oct 10 15:36 CpuUser.data -rw-r--r-- 1 oracle dba 1296 Oct 10 15:36 CpuWaitIo.data -rw-r--r-- 1 oracle dba 1406 Oct 10 15:36 CS.data -rw-r--r-- 1 oracle dba 1369 Oct 10 15:36 Interrupts.data -rw-r--r-- 1 oracle dba 7864 Oct 10 15:36 OSWg_OS_Block_Queue.gif -rw-r--r-- 1 oracle dba Oct 10 15:36 OSWg_OS_Context_Switches.gif -rw-r--r-- 1 oracle dba 8544 Oct 10 15:36 OSWg_OS_Cpu_Idle.gif -rw-r--r-- 1 oracle dba Oct 10 15:36 OSWg_OS_Cpu_Interrupts.gif -rw-r--r-- 1 oracle dba 7471 Oct 10 15:36 OSWg_OS_Cpu_System.gif -rw-r--r-- 1 oracle dba 7142 Oct 10 15:36 OSWg_OS_Cpu_User.gif -rw-r--r-- 1 oracle dba 7147 Oct 10 15:36 OSWg_OS_Cpu_Wa.gif -rw-r--r-- 1 oracle dba 8533 Oct 10 15:36 OSWg_OS_Run_Queue.gif -rw-r--r-- 1 oracle dba 1295 Oct 10 15:36 RunQueue.data 18/24

19 6.6 archive 경로에수집된자료의그래프 19/24

20 20/24

21 21/24

22 22/24

23 23/24

24 24/24

SQL Developer Connect to TimesTen 유니원아이앤씨 DB 기술지원팀 2010 년 07 월 28 일 문서정보 프로젝트명 SQL Developer Connect to TimesTen 서브시스템명 버전 1.0 문서명 작성일 작성자

SQL Developer Connect to TimesTen 유니원아이앤씨 DB 팀 2010 년 07 월 28 일 문서정보 프로젝트명 SQL Developer Connect to TimesTen 서브시스템명 버전 1.0 문서명 작성일 2010-07-28 작성자 김학준 최종수정일 2010-07-28 문서번호 20100728_01_khj 재개정이력 일자내용수정인버전