[20191129]OER 7451 in Load Indicator Error Code = OSD-04500.txt
--//生产系统数据库,报如下错误:
OER 7451 in Load Indicator : Error Code = OSD-04500: 指定了非法选项
# grep "OER 7451" alert_orcl.log|wc
7673398 84407378 529464462
# wc alert_orcl.log
19239872 142341579 893392051 alert_orcl.log
--//7673398/19239872 = .3988,居然这个错误出现在alert文件里面占40%,这样的数据库什么能用...
--//上网查询发现:
错误原因
Installed 32-bit Oracle database software on a 64-bit MS Windows OS which is not supported.
Note: For the Database software, you can ONLY install the x64 version on MS Windows (x64).
You can NOT install the 32-bit version Database software on MS Windows (x64).
解决办法
Install 32-bit Oracle database software only on 32-bit MS Windows OS.
--//就是这个问题:
# grep -B1 -i "alter system" alert_orcl.log
Mon May 06 11:55:43 2019
ALTER SYSTEM SET cursor_sharing='FORCE' SCOPE=MEMORY;
--
Mon May 06 11:57:22 2019
ALTER SYSTEM SET cursor_sharing='FORCE' SCOPE=SPFILE;
--
--//以上2个参数是我修改的,参考链接:http://blog.itpub.net/267265/viewspace-2643485/=>[20190506]视图嵌套与绑定变量.txt
Tue Nov 05 20:05:07 2019
ALTER SYSTEM SET sga_max_size='6200M' SCOPE=SPFILE;
--
Tue Nov 05 20:05:13 2019
ALTER SYSTEM SET sga_target='6000M' SCOPE=SPFILE;
--
Tue Nov 05 20:08:21 2019
ALTER SYSTEM SET sga_max_size='4200M' SCOPE=SPFILE;
--
Tue Nov 05 20:08:29 2019
ALTER SYSTEM SET sga_target='4000M' SCOPE=SPFILE;
--
Tue Nov 05 20:10:09 2019
ALTER SYSTEM SET sga_max_size='3200M' SCOPE=SPFILE;
--
Tue Nov 05 20:10:17 2019
ALTER SYSTEM SET sga_target='3000M' SCOPE=SPFILE;
--//很明显对方在曾经尝试修改sga_target,sga_max_size参数.明显失败,数据库无法启动.最后定位sga_target='3000M'.
--//我以前一直以为这样也起不来,实际上还是ok.我估计如果OS是32位,不做特别修改,应该还是起不来.
# grep -i sga_target alert_orcl.log
sga_target = 1258291200
--//1258291200/1024/1024 = 1200M.
sga_target = 1258291200
sga_target = 1258291200
sga_target = 1258291200
sga_target = 1258291200
sga_target = 1258291200
sga_target = 1258291200
ALTER SYSTEM SET sga_target='9000M' SCOPE=SPFILE;
sga_target = 1258291200
sga_target = 1258291200
sga_target = 1258291200
sga_target = 1258291200
sga_target = 1258291200
sga_target = 1258291200
sga_target = 1258291200
sga_target = 1258291200
sga_target = 1258291200
ALTER SYSTEM SET sga_target='6000M' SCOPE=SPFILE;
sga_target = 1258291200
ALTER SYSTEM SET sga_target='4000M' SCOPE=SPFILE;
sga_target = 1258291200
ALTER SYSTEM SET sga_target='3000M' SCOPE=SPFILE;
sga_target = 3145728000
--//像这样的系统根本不能用,建议升级到64位先.
XXXX> @ tpt/ash/ash_wait_chains10g event2 1=1 trunc(sysdate)+9/24 trunc(sysdate)+11/24
-- Display ASH Wait Chain Signatures script v0.2 BETA by Tanel Poder ( http://blog.tanelpoder.com )
%This SECONDS AAS WAIT_CHAIN
------ ---------- ---------- -----------------------------------------------------------------
70% 3642 .5 -> ON CPU
17% 859 .1 -> db file sequential read
11% 577 .1 -> db file scattered read
0% 19 0 -> read by other session
0% 15 0 -> enq: TX - row lock contention
0% 9 0 -> control file parallel write
0% 9 0 -> control file sequential read
0% 9 0 -> log file sync -> ON CPU
0% 8 0 -> SQL*Net more data to client
0% 7 0 -> log file parallel write
0% 6 0 -> log file sync -> log file parallel write
0% 5 0 -> direct path write
0% 5 0 -> log file switch completion
0% 5 0 -> enq: TX - row lock contention -> ON CPU
0% 5 0 -> null event
0% 2 0 -> SQL*Net more data from client
0% 2 0 -> direct path write temp
0% 2 0 -> direct path read temp
0% 1 0 -> enq: TX - row lock contention -> db file sequential read
0% 1 0 -> os thread startup
0% 1 0 -> SQL*Net message to client
0% 1 0 -> direct path read
0% 1 0 -> log buffer space
0% 1 0 -> library cache lock -> db file sequential read
24 rows selected.
--//上线刚半年.应该看不多多少db file scattered read,消耗已经在10分钟.
[20191129]OER 7451 in Load Indicator Error Code = OSD-04500.txt
-
lfree
2019-11-29 11:28:39 -
Oracle
- 原创