problems with projects
908067Dec 4 2012 — edited Dec 5 2012Hi guys,
I have a Solaris 10 server; it has an Oracle DB 10g running; a project was created for the oracle user:
# projects -l oracle.project
oracle.project
projid : 100
comment: "Oracle Project"
users : oracle
groups : (none)
attribs: process.max-sem-nsems=(privileged,256,deny)
project.max-sem-ids=(privileged,100,deny)
project.max-shm-ids=(privileged,100,deny)
project.max-shm-memory=(privileged,5905580032,deny)
There 2 Oracle DB instances that have SGAs < 4Gb together, so the max-shm-memory is correct (5.5GB).
The DBs ran fine for a long period of time (years) with this setup. Recently I rebooted the server (clean reboot) and when the DBA tries to start both DBs, they get ORA-27102 error at startup (which basically means there's no enough memory).
The strange thing is that I suspect the oracle.project is not applied anymore:
# ps -ef -o user,uid,pid,projid|grep oracle
USER UID PID PROJID
oracle 102 1706 0
oracle 102 15543 0
oracle 102 15549 0
oracle 102 15563 0
oracle 102 17737 0
oracle 102 15514 0
oracle 102 15503 0
Any idea what happened? Why the project is not enforced anymore?
Thank you!