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

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