因機房空調停電原因機房溫度過高而導致兩個節點的Oracle11G RAC資料庫伺服器自動關機。等啟動伺服器後，發現資料庫起不來，如題如下：

[oracle@DB-2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 2 10:35:31 2017

Connected to an idle instance.

SQL> startup

ORA-00845: MEMORY_TARGET not supported on this system

SQL> exit

原因為初始化引數MEMORY_TARGET或MEMORY_MAX_TARGET不能大於共享記憶體(/dev/shm),為了解決這個問題，要不調整Oracle初始化引數要不調大/dev/shm。

Oracle原來引數檔案相關引數檔案如下：

orcl2.memory_max_target=68719476736

orcl1.memory_max_target=68719476736

*.memory_target=30558650368

orcl2.memory_target=68719476736

orcl1.memory_target=6871947673

作業系統的共享記憶體(/dev/shm)引數如下：

[oracle@DB-1 shm]$ cat /etc/fstab | grep tmpfs

tmpfs /dev/shm tmpfs defaults,size=131072M 0 0

透過vi /etc/fstab命令分別修改兩個節點的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

重新嘗試啟動資料庫，還是報ORA-00845錯誤，因此對將初始化引數檔案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

Connected to an idle instance.

SQL> create spfile from pfile='/home/oracle/pfile_yu.ora';

File created.

Elapsed: 00:00:00.21

編輯相關內容如下：

orcl2.memory_max_target=64424509440

orcl1.memory_max_target=64424509440

*.memory_target=64424509440

orcl2.memory_target=64424509440

orcl1.memory_target=64424509440

重新生成spfile並啟動資料庫：

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

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>

資料庫啟動成功。

在另一個節點也進行類似操作，兩個節點資料庫都正常啟動並執行，應用能正常訪問了。

注：在節點一生成完spfile後，在節點二上企圖啟動資料庫，但還是報錯：

[oracle@DB-2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 2 10:35:31 2017

Connected to an idle instance.

SQL> startup

ORA-00845: MEMORY_TARGET not supported on this system

檢視作業系統資訊：

[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

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

對於以上問題，從節點一把引數檔案複製過來後直接生成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

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環境下處理ORA-00845錯誤案例

相關文章