ITPub博客

首页 > 数据库 > Oracle > ORA-27125错误解决

ORA-27125错误解决

原创 Oracle 作者:jichengjie 时间:2014-02-11 09:15:25 0 删除 编辑
一个测试库主机重启后突然就起不来了,说与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>

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26870952/viewspace-1079273/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
成为全能!

注册时间:2012-04-10

  • 博文量
    163
  • 访问量
    439610