分享
 
 
 

Oracle诊断案例1 -SGA与Swap

王朝oracle·作者佚名  2008-05-31
窄屏简体版  字體: |||超大  

案例描述:

用户报告,服务器启动一段时间以后,无法建立数据库连接

重新启动几分钟以后,再次无法连接

系统无法正常使用.

1.登陆系统

SunOS 5.8

login: root

PassWord:

Last login: Tue Mar 23 13:56:59 from 172.16.31.41

Sun Microsystems Inc. SunOS 5.8 Generic Patch October 2001

You have new mail.

2.su 为Oracle用户

检查启动的Oracle进程

发现后台进程正常,有一定量的用户连接

wapplatform:/su - oracle

Sun Microsystems Inc. SunOS 5.8 Generic Patch October 2001

You have new mail.

/eXPort/home1/oraclels

admin codesyndealt31 exp.sh local.cshrc local.profile oraclebak oui v6_database

app exp.log jre local.login nsmail oradata swan

export/home1/oraclecd admin

/export/home1/oracle/adminps -efgrep ora

oracle 25269 25258 0 13:58:36 pts/3 0:00 grep ora

oracle 25257 24906 0 13:58:31 pts/4 0:00 vi alert_HSWAPDB.log

oracle 25267 1 1 13:58:34 ? 0:00 oracleHSWAPDB (LOCAL=NO)

oracle 25184 1 0 13:56:57 ? 0:00 ora_p007_HSWAPDB

oracle 25182 1 0 13:56:57 ? 0:00 ora_p006_HSWAPDB

oracle 25193 1 0 13:57:03 ? 0:01 oracleHSWAPDB (LOCAL=NO)

oracle 25209 1 0 13:57:09 ? 0:00 oracleHSWAPDB (LOCAL=NO)

oracle 25176 1 0 13:56:57 ? 0:00 ora_p003_HSWAPDB

oracle 25180 1 0 13:56:57 ? 0:00 ora_p005_HSWAPDB

oracle 25172 1 0 13:56:56 ? 0:00 ora_p001_HSWAPDB

oracle 25178 1 0 13:56:57 ? 0:00 ora_p004_HSWAPDB

oracle 25170 1 0 13:56:56 ? 0:00 ora_p000_HSWAPDB

oracle 24254 24240 0 12:08:25 pts/2 0:00 -ksh

oracle 25174 1 0 13:56:56 ? 0:00 ora_p002_HSWAPDB

oracle 25244 1 1 13:58:23 ? 0:00 oracleHSWAPDB (LOCAL=NO)

oracle 25218 1 0 13:57:23 ? 0:00 oracleHSWAPDB (LOCAL=NO)

oracle 25159 1 0 13:56:42 ? 0:02 ora_qmn0_HSWAPDB

oracle 25230 1 0 13:57:40 ? 0:01 oracleHSWAPDB (LOCAL=NO)

oracle 25161 1 0 13:56:42 ? 0:00 ora_s000_HSWAPDB

oracle 25149 1 0 13:56:41 ? 0:01 ora_lgwr_HSWAPDB

oracle 25157 1 0 13:56:42 ? 0:00 ora_cjq0_HSWAPDB

oracle 24906 3698 0 13:47:47 pts/4 0:00 -ksh

oracle 25153 1 0 13:56:42 ? 0:01 ora_smon_HSWAPDB

oracle 25058 7464 0 13:55:14 pts/1 0:00 -ksh

oracle 25163 1 0 13:56:42 ? 0:00 ora_d000_HSWAPDB

oracle 25155 1 0 13:56:42 ? 0:00 ora_reco_HSWAPDB

oracle 25151 1 0 13:56:41 ? 0:00 ora_ckpt_HSWAPDB

oracle 25145 1 0 13:56:41 ? 0:00 ora_dbw0_HSWAPDB

oracle 25199 1 15 13:57:04 ?

0:49 ora_j000_HSWAPDB

oracle 4149 4146 0 12:05:11 pts/5 0:00 -ksh

oracle 25232 1 0 13:57:41 ? 0:00 oracleHSWAPDB (LOCAL=NO)

oracle 25119 1 0 13:56:29 ? 0:00 oraclehswapdb (LOCAL=NO)

oracle 25075 1 0 13:55:34 ? 0:00 /export/home1/oracle/app/bin/tnslsnr LISTENER -inherit

oracle 24374 4149 0 12:21:56 pts/5 0:00 sqlplus /nolog

oracle 25143 1 0 13:56:41 ? 0:00 ora_pmon_HSWAPDB

oracle 25258 25242 0 13:58:31 pts/3 0:00 -ksh

/export/home1/oracle/adminps -efgrep ora_

oracle 25275 25258 0 13:58:42 pts/3 0:00 grep ora_

oracle 25184 1 0 13:56:57 ? 0:00 ora_p007_HSWAPDB

oracle 25182 1 0 13:56:57 ? 0:00 ora_p006_HSWAPDB

oracle 25176 1 0 13:56:57 ? 0:00 ora_p003_HSWAPDB

oracle 25180 1 0 13:56:57 ? 0:00 ora_p005_HSWAPDB

oracle 25172 1 0 13:56:56 ? 0:00 ora_p001_HSWAPDB

oracle 25178 1 0 13:56:57 ? 0:00 ora_p004_HSWAPDB

oracle 25170 1 0 13:56:56 ? 0:00 ora_p000_HSWAPDB

oracle 25174 1 0 13:56:56 ? 0:00 ora_p002_HSWAPDB

oracle 25159 1 0 13:56:42 ? 0:02 ora_qmn0_HSWAPDB

oracle 25161 1 0 13:56:42 ? 0:00 ora_s000_HSWAPDB

oracle 25149 1 0 13:56:41 ? 0:01 ora_lgwr_HSWAPDB

oracle 25157 1 0 13:56:42 ? 0:00 ora_cjq0_HSWAPDB

oracle 25153 1 0 13:56:42 ? 0:01 ora_smon_HSWAPDB

oracle 25163 1 0 13:56:42 ? 0:00 ora_d000_HSWAPDB

oracle 25155 1 0 13:56:42 ? 0:00 ora_reco_HSWAPDB

oracle 25151 1 0 13:56:41 ? 0:00 ora_ckpt_HSWAPDB

oracle 25145 1 0 13:56:41 ? 0:00 ora_dbw0_HSWAPDB

oracle 25199 1 13 13:57:04 ? 0:51 ora_j000_HSWAPDB

oracle 25143 1 0 13:56:41 ? 0:00 ora_pmon_HSWAPDB

3.检查Alert.log警报日志文件

/export/home1/oracle/adminls

hswapdb

/export/home1/oracle/admincd *

/export/home1/oracle/admin/hswapdbls

bdump cdump create pfile udump

/export/home1/oracle/admin/hswapdbcd bdump

/export/home1/oracle/admin/hswapdb/bdump

/export/home1/oracle/admin/hswapdb/bdumpls -l *.log

-rw-r--r-- 1 oracle dba 813396 Mar 23 13:57 alert_HSWAPDB.log

/export/home1/oracle/admin/hswapdb/bdumpvi *.log

"alert_HSWAPDB.log" 18888 lines, 813396 characters (115 null)

Tue Jun 24 21:17:14 2003

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

SCN scheme 3

Using log_archive_dest parameter default value

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Starting up ORACLE RDBMS Version: 9.2.0.3.0.

System parameters with non-default values:

processes = 400

timed_statistics = TRUE

shared_pool_size = 117440512

large_pool_size = 83886080

Java_pool_size = 33554432

control_files = /export/home1/oracle/oradata/hswapdb/control01.ctl,

/export/home1/oracle/oradata/hswapdb/control02.ctl,

/export/home1/oracle/oradata/hswapdb/control03.ctl

db_block_size = 8192

db_cache_size = 352321536

compatible = 9.2.0.0.0

db_file_multiblock_read_count= 16

fast_start_mttr_target = 300

undo_management = AUTO

undo_tablespace = UNDOTBS1

undo_retention = 10800

remote_login_passwordfile= EXCLUSIVE

db_domain = eygle.com

instance_name = hswapdb

dispatchers = (PROTOCOL=TCP) (SERVICE=hswapdbXDB)

job_queue_processes = 10

hash_join_enabled = TRUE

background_dump_dest = /export/home1/oracle/admin/hswapdb/bdump

user_dump_dest = /export/home1/oracle/admin/hswapdb/udump

core_dump_dest = /export/home1/oracle/admin/hswapdb/cdump

sort_area_size = 524288

db_name = hswapdb

open_cursors = 300

star_transformation_enabled= FALSE

query_rewrite_enabled = FALSE

pga_aggregate_target = 154140672

aq_tm_processes = 1

.................

Tue Mar 23 13:40:45 2004

skgpspawn failed:category = 27142, depinfo = 12, op = fork, loc = skgpspawn3

skgpspawn failed:category = 27142, depinfo = 12, op = fork, loc = skgpspawn3

skgpspawn failed:category = 27142, depinfo = 12, op = fork, loc = skgpspawn3

skgpspawn failed:category = 27142, depinfo = 12, op = fork, loc = skgpspawn3

skgpspawn failed:category = 27142, depinfo = 12, op = fork, loc = skgpspawn3

skgpspawn failed:category = 27142, depinfo = 12, op = fork, loc = skgpspawn3

skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn5

skgpspawn failed:category = 27142, depinfo = 12, op = fork, loc = skgpspawn3

skgpspawn failed:category = 27142, depinfo = 12, op = fork, loc = skgpspawn3

Tue Mar 23 13:42:02 2004

skgpspawn failed:category = 27142, depinfo = 12, op = fork, loc = skgpspawn3

skgpspawn failed:category = 27142, depinfo = 12, op = fork, loc = skgpspawn3

skgpspawn failed:category = 27142, depinfo = 12, op = fork, loc = skgpspawn3

skgpspawn failed:category = 27142, depinfo = 12, op = fork, loc = skgpspawn3

Tue Mar 23 13:55:38 2004

Starting ORACLE instance (normal)

Shutting down instance: further logons disabled

Tue Mar 23 13:56:20 2004

Shutting down instance (abort)

License high water mark = 26

Instance terminated by USER, pid = 25112

Tue Mar 23 1

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
2023年上半年GDP全球前十五强
 百态   2023-10-24
美众议院议长启动对拜登的弹劾调查
 百态   2023-09-13
上海、济南、武汉等多地出现不明坠落物
 探索   2023-09-06
印度或要将国名改为“巴拉特”
 百态   2023-09-06
男子为女友送行,买票不登机被捕
 百态   2023-08-20
手机地震预警功能怎么开?
 干货   2023-08-06
女子4年卖2套房花700多万做美容:不但没变美脸,面部还出现变形
 百态   2023-08-04
住户一楼被水淹 还冲来8头猪
 百态   2023-07-31
女子体内爬出大量瓜子状活虫
 百态   2023-07-25
地球连续35年收到神秘规律性信号,网友:不要回答!
 探索   2023-07-21
全球镓价格本周大涨27%
 探索   2023-07-09
钱都流向了那些不缺钱的人,苦都留给了能吃苦的人
 探索   2023-07-02
倩女手游刀客魅者强控制(强混乱强眩晕强睡眠)和对应控制抗性的关系
 百态   2020-08-20
美国5月9日最新疫情:美国确诊人数突破131万
 百态   2020-05-09
荷兰政府宣布将集体辞职
 干货   2020-04-30
倩女幽魂手游师徒任务情义春秋猜成语答案逍遥观:鹏程万里
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案神机营:射石饮羽
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案昆仑山:拔刀相助
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案天工阁:鬼斧神工
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案丝路古道:单枪匹马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:与虎谋皮
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:李代桃僵
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:指鹿为马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:小鸟依人
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:千金买邻
 干货   2019-11-12
 
推荐阅读
 
 
 
>>返回首頁<<
 
靜靜地坐在廢墟上,四周的荒凉一望無際,忽然覺得,淒涼也很美
© 2005- 王朝網路 版權所有