标签云
asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-00742 ORA-01110 ORA-01555 ORA-01578 ORA-08103 ORA-600 2131 ORA-600 2662 ORA-600 2663 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-600 KCLCHKBLK_4 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 Oracle 恢复 ORACLE恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (103)
- 数据库 (1,716)
- DB2 (22)
- MySQL (74)
- Oracle (1,576)
- Data Guard (52)
- EXADATA (8)
- GoldenGate (24)
- ORA-xxxxx (160)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (15)
- ORACLE 21C (3)
- Oracle 23ai (8)
- Oracle ASM (68)
- Oracle Bug (8)
- Oracle RAC (54)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (28)
- Oracle备份恢复 (575)
- Oracle安装升级 (94)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (81)
- PostgreSQL (18)
- PostgreSQL恢复 (6)
- SQL Server (28)
- SQL Server恢复 (9)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (37)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (20)
-
最近发表
- 不当使用_allow_resetlogs_corruption参数引起ORA-600 2662错误
- CSSD signal 11 in thread clssnmRcfgMgrThread故障处理
- 使用sid方式直接访问pdb(USE_SID_AS_SERVICE_LISTENER)
- ORA-00069: cannot acquire lock — table locks disabled for xxxx
- ORA-600 [4000] [a]相关bug
- sql server数据库“正在恢复”故障处理
- 如何判断数据文件是否处于begin backup状态
- CDM备份缺少归档打开数据库报ORA-600 kcbzib_kcrsds_1故障处理
- ORA-07445: exception encountered: core dump [expgod()+43] [IN_PAGE_ERROR]
- 2025年第一起ORA-600 16703故障恢复
- _gc_undo_affinity=FALSE触发ORA-01558
- public授权语句
- 中文环境显示AR8MSWIN1256(阿拉伯语字符集)
- 处理 Oracle 块损坏
- Oracle各种类型坏块说明和处理
- fio测试io,导致磁盘文件系统损坏故障恢复
- ORA-742 写丢失常见bug记录
- Oracle 19c 202501补丁(RUs+OJVM)-19.26
- 避免 19c 数据库性能问题需要考虑的事项 (Doc ID 3050476.1)
- Bug 21915719 Database hang or may fail to OPEN in 12c IBM AIX or HPUX Itanium – ORA-742, DEADLOCK or ORA-600 [kcrfrgv_nextlwn_scn] ORA-600 [krr_process_read_error_2]
分类目录归档:Unix
通过netstat+rmsock查找AIX端口对应进程
rmsock除去不包含文件描述符的套接字。它接受 socket、tcpcb、inpcb、ripcb 或 rawcb 地址并将其转换成套接字地址。然后检查每个进程所有打开的文件以查找套接字的匹配。如果没找到匹配,对该套接字执行异常终止操作,而不考虑套接字 linger 选项的存在。套接字保留的端口号释放。如果发现匹配,文件描述符和主进程状态显示给用户。
命令格式:rmsock Address TypeofAddress
[zwq:/]netstat -Aan|grep 6200|grep LISTEN f1000e0000307bb0 tcp4 0 0 *.6200 *.* LISTEN --f1000e0000307bb0 为系统内核地址 [zwq:/]rmsock f1000e0000307bb0 tcpcb The socket 0x307808 is being held by proccess 5701830 (ons). [zwq:/]ps -ef|grep 5701830|grep -v grep oracle10 5701830 5112098 0 Apr 21 - 7:17 /oracle10/app/product/crs/10.2.0/opmn/bin/ons -d
nmon使用说明
Nmon 工具是 IBM 提供的免费的监控 AIX 系统与 Linux 系统资源的工具。该工具可实时监控系统性能,也可以将服务器的系统资源耗用情况收集起来并输出一个特定的文件,并可利用 excel 分析工具进行数据的统计分析,非常利用 UNIX 或者 Linux 系统的性能数据分析。
1.下载地址
nmon官网
NMON_Analyser官网
本地下载nmon
本地下载nmon_analyser
2.安装nmon
在压缩包中找到相应的版本,上传至服务器,然后授予执行权限
3.主要操作说明
+-HELP---------most-keys-toggle-on/off------------------------------------------+ |h = Help information q = Quit nmon 0 = reset peak counts | |+ = double refresh time - = half refresh r = ResourcesCPU/HW/MHz/AIX | |c = CPU by processor C=upto 128 CPUs p = LPAR Stats (if LPAR) | |l = CPU avg longer term k = Kernel Internal # = PhysicalCPU if SPLPAR | |m = Memory & Paging M = Multiple Page Sizes P = Paging Space | |d = DiskI/O Graphs D = DiskIO +Service times o = Disks %Busy Map | |a = Disk Adapter e = ESS vpath stats V = Volume Group stats | |^ = FC Adapter (fcstat) O = VIOS SEA (entstat) v = Verbose=OK/Warn/Danger | |n = Network stats N=NFS stats (NN for v4) j = JFS Usage stats | |A = Async I/O Servers w = see AIX wait procs "="= Net/Disk KB<-->MB | |b = black&white mode g = User-Defined-Disk-Groups (see cmdline -g) | |t = Top-Process ---> 1=basic 2=CPU-Use 3=CPU(default) 4=Size 5=Disk-I/O | |u = Top+cmd arguments U = Top+WLM Classes . = only busy disks & procs | |W = WLM Section S = WLM SubClasses) |
4.实时监控结果
1)监控内存使用情况
| Memory -----------------------------------------------------------------------| | Physical PageSpace | pages/sec In Out | FileSystemCache | |% Used 93.8% 34.3% | to Paging Space 0.0 0.0 | (numperm) 44.3% | |% Free 6.2% 65.7% | to File System 0.0 257.9 | Process 18.2% | |MB Used 1786.0MB 175.8MB | Page Scans 0.0 | System 31.4% | |MB Free 118.0MB 336.2MB | Page Cycles 0.0 | Free 6.2% | |Total(MB) 1904.0MB 512.0MB | Page Steals 0.0 | ------| | | Page Faults 279.9 | Total 100.0% | |------------------------------------------------------------ | numclient 44.3% | |Min/Maxperm 361MB( 19%) 1443MB( 76%) <--% of RAM | maxclient 75.8% | |Min/Maxfree 960 1088 Total Virtual 2.4GB | User 58.4% | |Min/Maxpgahead 2 8 Accessed Virtual 0.9GB 40.1%| Pinned 28.6% | |-------------------------------------------------------------------------------|
2)监控cpu使用情况
| 0----------25-----------50----------75----------100 |CPU User% Sys% Wait% Idle%| | | | | | 0 0.0 0.0 0.0 100.0|> | | 1 0.0 0.0 0.0 100.0|> | | 2 0.0 0.0 0.0 100.0|> | | 3 0.0 0.0 0.0 100.0|> | |Physical Averages +-----------|------------|-----------|------------+ |All 0.2 2.5 0.7 96.6|> | | +-----------|------------|-----------|------------+
3)监控进程状态
| Top-Processes-(147) -----Mode=3 [1=Basic 2=CPU 3=Perf 4=Size 5=I/O 6=Cmds]-----------------------------| | PID %CPU Size Res Res Res Char RAM Paging Command | | Used KB Set Text Data I/O Use io other repage | | 1908868 0.8 30508 29764 132 29632 2 2% 0 3 0 secldapclntd | | 2306196 0.7 512 512 0 512 0 0% 1 8 0 trclogio | | 2732116 0.6 2520 0 0 0 0 0% 0 33 0 <defunct Zombie>| | 340036 0.2 1416 296 72 224 0 0% 0 0 0 dtgreet |
5.监控一段时间性能
-f spreadsheet output format [note: default -s300 -c288] optional -s <seconds> between refreshing the screen [default 2] -c <number> of refreshes [default millions] -t spreadsheet includes top processes 具体信息nmon -h
例如:nmon -f -t -s 30 -c 120
-s 30:每30秒进行一次数据采集
-c 120:一共采集120次
6.分析数据
打开nmon analyser,设置宏的安全级别是低 ,之后点击 Analyser NMON data 按钮 输入文件 保存成excel格式即可。
查看Aix进程占用内存大小
内存从大到小排序
-bash-3.00$ ps aux | head -1 ; ps aux | sort -rn +3 | head -10 USER PID %CPU %MEM SZ RSS TTY STAT STIME TIME COMMAND root 1908868 0.1 2.0 30508 29724 - A Dec 21 235:34 /usr/sbin/secld zhldang 2728188 0.0 0.0 1208 1288 pts/15 A 11:20:20 0:00 -bash zhldang 1421376 0.0 0.0 2036 1056 - A 11:20:15 0:00 sshd: zhldang@p zerbo625 2482224 0.0 0.0 1164 1244 pts/24 A 11:04:35 0:00 -bash zerbo625 1523730 0.0 0.0 1796 1036 - A 11:04:29 0:00 sshd: zerbo625@ yxq198sm 2429092 0.0 0.0 152 156 - A 12:24:48 0:00 sleep 30 yxq198sm 1327254 0.0 0.0 1600 1872 - A Feb 01 0:06 /usr/bin/bsh /u yanmotia 1274070 0.0 0.0 1164 768 pts/22 A Dec 23 0:00 -bash xinximai 2658402 0.0 0.0 1156 760 pts/83 A Dec 28 0:00 -bash xifengke 2330668 0.0 0.0 1160 756 pts/80 A Dec 05 0:00 -bash
内存从大到小排序(详细执行命令)
-bash-3.00$ ps -ealf | head -1 ; ps -ealf | sort -rn +9 | head -10 F S UID PID PPID C PRI NI ADDR SZ WCHAN STIME TTY TIME CMD 240001 A root 188582 1 0 60 20 2823c400 36708 * Jan 03 - 676:39 /usr/sbin/secldapclntd 240001 A root 1908868 1 0 60 22 6648400 30508 * Dec 21 - 235:40 /usr/sbin/secldapclntd 240001 A root 331840 86176 0 60 20 205f8400 4088 Sep 15 - 11:04 /usr/lpp/X11/bin/X -D /usr/lib/X11//rgb -T -force :0 -auth /var/dt/A:0-0xukaa 240001 A root 2216054 233648 0 60 20 142a400 3992 f100060002c9e8c8 11:19:59 - 0:00 sshd: zhldang [priv] 240001 A root 1515620 233648 0 60 20 2075f400 3992 f100060003bb0cc8 12:21:48 - 0:00 sshd: undeadbird [priv] 240001 A root 2719848 233648 0 60 20 916a400 3988 f100060002b068c8 13:07:55 - 0:00 sshd: wangyh0313 [priv] 240001 A root 2003106 233648 0 60 20 3428400 3876 f1000600038f94c8 11:02:58 - 0:00 sshd: intrepid [priv] 240001 A root 2560234 233648 0 60 20 44a8400 3816 f1000600018264c8 11:01:54 - 0:00 sshd: xifenfei [priv] 240001 A root 2846944 233648 0 60 20 22c7b400 3784 f100060003b050c8 11:04:12 - 0:00 sshd: zerbo625 [priv] 200001 A undeadbi 2220232 1007670 0 60 20 2355f400 3104 f100060001c2c878 13:03:08 pts/9 0:00 /usr/bin/smitty
查找某个进程使用内存
-bash-3.00$ ps aux | head -1 ; ps aux | grep xifenfei USER PID %CPU %MEM SZ RSS TTY STAT STIME TIME COMMAND xifenfei 2494532 0.0 0.0 1836 1044 - A 11:02:05 0:00 sshd: xifenfei@ xifenfei 2666546 0.0 0.0 1148 1228 pts/20 A 11:02:10 0:00 -bash root 2560234 0.0 0.0 3816 3024 - A 11:01:54 0:00 sshd: xifenfei xifenfei 2220230 0.0 0.0 912 940 pts/20 A 13:03:06 0:00 ps aux xifenfei 1310908 0.0 0.0 228 240 pts/20 A 13:03:06 0:00 grep xifenfei
查找某个进程使用内存(详细执行命令)
-bash-3.00$ ps -ealf | head -1 ;ps -ealf|grep xifenfei F S UID PID PPID C PRI NI ADDR SZ WCHAN STIME TTY TIME CMD 40001 A xifenfei 2494532 2560234 0 60 20 37575400 1836 11:02:05 - 0:00 sshd: xifenfei@pts/20 200001 A xifenfei 2510946 2666546 1 60 20 14045400 960 12:57:25 pts/20 0:00 ps -ealf 200001 A xifenfei 2543730 2666546 0 60 20 10cc6400 228 f100010017976ca0 12:57:25 pts/20 0:00 grep xifenfei 240001 A root 2560234 233648 0 60 20 44a8400 3816 f1000600018264c8 11:01:54 - 0:00 sshd: xifenfei [priv]
发表在 AIX
评论关闭