ORA-27125錯誤解決

一個測試庫主機重啟後突然就起不來了,說與hugetable有關,看到開發人員直接在上面建立一些表空間,是不是部署了什麼大表,最後修改一個引數起來了,具體原因還要驗證

:~> uname -a
Linux ittest 2.6.5-7.202.7-bigsmp #1 SMP Tue Nov 29 14:32:53 UTC 2005 i686 i686 i386 GNU/Linux
:~> cat /proc/version
Linux version 2.6.5-7.202.7-bigsmp () (gcc version 3.3.3 (SuSE Linux)) #1 SMP Tue Nov 29 14:32:53 UTC 2005
:~> sqlplus /nolog

SQL*Plus: Release 9.2.0.6.0 - Production on Mon Feb 10 15:43:30 2014

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORA-27125: unable to create shared memory segment
Linux Error: 1: Operation not permitted
SQL> exit
Disconnected
:~> export DISABLE_HUGETLBFS=1
:~> sqlplus /nolog

SQL*Plus: Release 9.2.0.6.0 - Production on Mon Feb 10 15:44:04 2014

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 1261820324
bytes

Fixed Size                   453028
bytes

Variable Size             620756992
bytes

Database Buffers          637534208
bytes

Redo Buffers                3076096

bytes

Database mounted.
Database opened.
SQL>