共計 3539 個字符，預計需要花費 9 分鐘才能閱讀完成。
這篇文章主要為大家展示了“在 Oracle11g RAC 環(huán)境下如何處理 ORA-00845 錯誤”，內(nèi)容簡而易懂，條理清晰，希望能夠幫助大家解決疑惑，下面讓丸趣 TV 小編帶領大家一起研究并學習一下“在 Oracle11g RAC 環(huán)境下如何處理 ORA-00845 錯誤”這篇文章吧。
因機房空調(diào)停電原因機房溫度過高而導致兩個節(jié)點的 Oracle11G RAC 數(shù)據(jù)庫服務器自動關機。等啟動服務器后，發(fā)現(xiàn)數(shù)據(jù)庫起不來，如題如下：
[oracle@DB-2 ~]$
sqlplus / as sysdba
SQL*Plus: Release
11.2.0.1.0 Production on Wed Aug 2 10:35:31 2017
Copyright (c) 1982,
2009, Oracle. All rights reserved.
Connected to an idle
instance.
SQL startup
ORA-00845:
MEMORY_TARGET not supported on this system
SQL exit
原因為初始化參數(shù) MEMORY_TARGET 或 MEMORY_MAX_TARGET 不能大于共享內(nèi)存(/dev/shm), 為了解決這個問題，要不調(diào)整 Oracle 初始化參數(shù)要不調(diào)大 /dev/shm。
Oracle 原來參數(shù)文件相關參數(shù)文件如下：
orcl2.memory_max_target=68719476736
orcl1.memory_max_target=68719476736
*.memory_target=30558650368
orcl2.memory_target=68719476736
orcl1.memory_target=6871947673
操作系統(tǒng)的共享內(nèi)存 (/dev/shm) 參數(shù)如下：
[oracle@DB-1 shm]$
cat /etc/fstab | grep tmpfs
tmpfs /dev/shm tmpfs defaults,size=131072M 0 0
通過 vi /etc/fstab 命令分別修改兩個節(jié)點的 size 為 64G，如下：
tmpfs /dev/shm tmpfs defaults,size=64G 0 0
[oracle@CRXJ-DB-1
~]$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_crxjdb1-LogVol02
2.3T 1.3T 882G 60% /
tmpfs 64G 34G 30G 54% /dev/shm
/dev/sda1 194M 33M 152M 18% /boot
/dev/mapper/vg_crxjdb1-LogVol01
9.9G 151M 9.2G 2% /tmp
重新嘗試啟動數(shù)據(jù)庫，還是報 ORA-00845 錯誤，因此對將初始化參數(shù)文件 spfile 導出成 pfile 后進行編輯并重新生成 spfile，過程如下：
[oracle@DB-1 ~]$
sqlplus / as sysdba
SQL*Plus: Release
11.2.0.1.0 Production on Wed Aug 2 10:36:33 2017
Copyright (c) 1982,
2009, Oracle. All rights reserved.
Connected to an idle
instance.
SQL create
spfile from pfile= /home/oracle/pfile_yu.ora
File created.
Elapsed: 00:00:00.21
編輯相關內(nèi)容如下：
orcl2.memory_max_target=64424509440
orcl1.memory_max_target=64424509440
*.memory_target=64424509440
orcl2.memory_target=64424509440
orcl1.memory_target=64424509440
重新生成 spfile 并啟動數(shù)據(jù)庫：
SQL create
spfile from pfile= /home/oracle/pfile_yu.ora
File created.
Elapsed: 00:00:00.18
SQL exit
Disconnected
[oracle@DB-1 ~]$
sqlplus / as sysdba
SQL*Plus: Release
11.2.0.1.0 Production on Wed Aug 2 10:40:30 2017
Copyright (c) 1982,
2009, Oracle. All rights reserved.
Connected to an idle
instance.
SQL startup
ORACLE instance
started.
Total System Global
Area 6.4137E+10 bytes
Fixed Size 2219552 bytes
Variable Size 3.8118E+10 bytes
Database
Buffers 2.5770E+10 bytes
Redo Buffers 247029760 bytes
Database mounted.
Database opened.
SQL
數(shù)據(jù)庫啟動成功。
在另一個節(jié)點也進行類似操作，兩個節(jié)點數(shù)據(jù)庫都正常啟動并運行，應用能正常訪問了。
注：在節(jié)點一生成完 spfile 后，在節(jié)點二上企圖啟動數(shù)據(jù)庫，但還是報錯：
[oracle@DB-2 ~]$
sqlplus / as sysdba
SQL*Plus: Release
11.2.0.1.0 Production on Wed Aug 2 10:35:31 2017
Copyright (c) 1982,
2009, Oracle. All rights reserved.
Connected to an idle
instance.
SQL startup
ORA-00845:
MEMORY_TARGET not supported on this system
查看操作系統(tǒng)信息：
[oracle@DB-2 ~]$ df
-h|grep shm
tmpfs 64G 397M 63G 1% /dev/shm
[oracle@DB-2 ~]$
sqlplus / as sysdba
SQL*Plus: Release
11.2.0.1.0 Production on Wed Aug 2 10:46:28 2017
Copyright (c) 1982,
2009, Oracle. All rights reserved.
Connected to an idle
instance.
SQL create
pfile= /home/oracle/pfile_yu.ora from spfile;
create
pfile= /home/oracle/pfile_yu.ora from spfile
*
ERROR at line 1:
ORA-01565: error in
identifying file ?/dbs/spfile@.ora
ORA-27037: unable to
obtain file status
Linux-x86_64 Error:
2: No such file or directory
Additional
information: 3
對于以上問題，從節(jié)點一把參數(shù)文件復制過來后直接生成 spfile
[oracle@DB-1
~]$ scp pfile_yu.ora DB-2:/home/oracle/pfile_yu.ora 100% 1929 1.9KB/s 00:00
[oracle@DB-2 ~]$
sqlplus / as sysdba
SQL*Plus: Release
11.2.0.1.0 Production on Wed Aug 2 10:54:48 2017
Copyright (c) 1982,
2009, Oracle. All rights reserved.
Connected to an idle
instance.
SQL create
spfile from pfile= /home/oracle/pfile_yu.ora
File created.
SQL startup
ORACLE instance
started.
Total System Global
Area 6.4137E+10 bytes
Fixed Size 2219552 bytes
Variable Size 3.3554E+10 bytes
Database
Buffers 3.0333E+10 bytes
Redo Buffers 247029760 bytes
Database mounted.
Database opened.
SQL exit
以上是“在 Oracle11g RAC 環(huán)境下如何處理 ORA-00845 錯誤”這篇文章的所有內(nèi)容，感謝各位的閱讀！相信大家都有了一定的了解，希望分享的內(nèi)容對大家有所幫助，如果還想學習更多知識，歡迎關注丸趣 TV 行業(yè)資訊頻道！
