[20191129]OER 7451 in Load Indicator Error Code = OSD-04500.txt

来源：这里教程网时间：2026-03-03 14:38:46 作者：

[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分钟.