Oracle RAC 停止启动问题

这个是solaris 内核参数 project.max-shm-memory  不足以放下你的sga 值 导致 被分段，会影响性能

提示内存不足，看看alert日志，启动报什么错误

我就是两个节点系统都重启了，重启后用srvctl启动还是报错；

但是通过sqlplus启动，就正常启动了

重启一下系统，然后手动单独启动有报错吗

主机重启下，估计是用srv关闭没有完全释放内存资源。

已经提示内存不足了。你返回到系统界面，看下内存状态。是不是有内存条有点问题了。

Start Database by sqlplus, can not by srvctl on Solaris 10 (Oracle RAC 10G)

http://surachartopun.com/2008/12/start-database-by-sqlplus-can-not-by.html

After I changed project on Solaris 10.

projmod -s -K \"project.max-shm-memory=(privileged,13832385536,deny)\" oracle

something wrong, i can start instance by sqlplus, but can not by srvctl

srvctl  start instance -d db  -i  db2

PRKP-1001 : Error starting instance db2 on node node02

CRS-0215: Could not start resource \'ora.db.db2.inst\'.

When checked log files on ORACLE_HOME/log/{hostname}/racg/imon*log

SQL> ORA-27102: out of memory

SVR4 Error: 22: Invalid argument

SQL> Disconnected

So, found out some informations from matalink.

Cause

Problem is not the oracle project.

This occurs because when we start an instance using srvctl it will inherit the system project, since the crsd.bin is running as root, our racg infrastructure is starting the resource as oracle however racgwrap is initially started as root. It calls  setuid/setgid to change the user & group IDs but unfortunately when we do this we dont call the project ID.

Solution

Easiest fix for this problem is to define a project for system.

% projmod -s -K \"project.max-shm-memory=(privileged,2.00TB,deny)\" system

% projmod -s -K \"process.max-sem-nsems=(privileged,2048,deny)\" system

Above assigns root user the system project in order for the CRSD daemon (run under root\'s user id) to pick up the changes:

% vi /etc/user_attr, add root to project=system:

Finally restart CRS stack

And then I modified project (for system project)

projmod -s -K \"project.max-shm-memory=(privileged,13832385536,deny)\" oracle

projmod -s -K \"project.max-shm-memory=(privileged,15132385536,deny)\" system

that helped me solve this case.

srvctl  start instance -d db  -i  db2

export SRVM_TRACE=TRUE

执行srvctl 的trace日志贴一下，

sqlplus  /  as sysdba

show parameter spfile

看报错，是内存问题