ORA-27125错误解决

一个测试库主机重启后突然就起不来了,说与hugetable有关,看到开发人员直接在上面创建一些表空间,是不是部署了什么大表,最后修改一个参数起来了,具体原因还要验证

oracle@ittest:~> 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
oracle@ittest:~> cat /proc/version
Linux version 2.6.5-7.202.7-bigsmp (geeko@buildhost) (gcc version 3.3.3 (SuSE Linux)) #1 SMP Tue Nov 29 14:32:53 UTC 2005
oracle@ittest:~> 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
oracle@ittest:~> export DISABLE_HUGETLBFS=1
oracle@ittest:~> 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>

请使用浏览器的分享功能分享到微信等