Database - RAC/Scalability (MOSC)

MOSC Banner

在T5-4中安装11.2.0.4 RAC,DBCA创建数据库时遇到ORA-27102 out of memory错误。

edited Jan 7, 2015 10:01AM in Database - RAC/Scalability (MOSC) 1 commentAnswered

T5-4的内存是1TB,我在设置project.max-shm-memory 参数时,设定800GB,DBCA创建数据库只给数据库400G的SGA,发生了这个错误。

把project.max-shm-memory 调小到128G,SGA给100G左右也不行。

  1. oracle@dbcenter1: prctl -n project.max-shm-memory $
  2. process: 33047: -bash
  3. NAME    PRIVILEGE       VALUE    FLAG   ACTION                       RECIPIENT
  4. project.max-shm-memory
  5.         privileged       128GB      -   deny                                 -
  6.         system          16.0EB    max   deny     

复制代码

  

alert_*.log的日志:

Mon Dec 29 16:51:08 2014

ARC2: Archival stopped

ARCH shutting down

ARC1: Archival stopped

ARC0: Archival stopped

ARC3: Archival stopped

Thread 1 closed at log sequence 6

Successful close of redo thread 1

Mon Dec 29 16:51:09 2014

NOTE: Deferred communication with ASM instance

NOTE: deferred map free for map id 12

Completed: ALTER DATABASE CLOSE NORMAL

ALTER DATABASE DISMOUNT

Shutting down archive processes

Archiving is disabled

Completed: ALTER DATABASE DISMOUNT

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center