experchange > solaris

John D Groenveld (06-15-19, 08:03 PM)
I have a legacy Oracle application stack on top of Solaris.
I'm trying to increase the database SGA, but I'm unable to get
the max-shm-memory resource control to persist across reboots.

# prtconf|head -2
System Configuration: Oracle Corporation i86pc
Memory size: 57340 Megabytes

# zonecfg -z oracle export
create -b
set brand=solaris
set zonepath=/var/opt/zones/oracle
add net
set physical=vnic16
end
add net
set physical=vnic17
end
add capped-memory
set physical=36G
end
add rctl
set name=zone.max-shm-memory
add value (priv=privileged,limit=34359738368,action=deny)
end

# zlogin oracle "prctl -n zone.max-shm-memory -i project 100"
project: 100: user.oracle
NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT
zone.max-shm-memory
usage 0B
privileged 32.0GB - deny -
system 16.0EB max deny -

Here's where things go sideways:
# zlogin oracle "su - oracle -c 'id -p'"
Oracle Corporation SunOS 5.11 11.4 May 2019
uid=100(oracle) gid=100(dba) projid=100(user.oracle)

# zlogin oracle "tail -1 /etc/project"
user.oracle:100:RDBMS::dba:max-shm-memory=(privileged,34359738368,deny)

# zlogin oracle "su - oracle -c 'prctl -n project.max-shm-memory -i project 100'"
Oracle Corporation SunOS 5.11 11.4 May 2019
project: 100: user.oracle
NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT
project.max-shm-memory
usage 0B
privileged 13.5GB - deny -
system 16.0EB max deny

13.5 != 32

But weirdly, now this...

# zlogin oracle "prctl -n project.max-shm-memory -r -v 32GB -i project user.oracle"
# zlogin oracle "su - oracle -c 'prctl -n project.max-shm-memory -i project 100'"
Oracle Corporation SunOS 5.11 11.4 May 2019
project: 100: user.oracle
NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT
project.max-shm-memory
usage 0B
privileged 32.0GB - deny -
system 16.0EB max deny

And the database boots with the large 32G SGA.
John
groenveld
John D Groenveld (07-08-19, 08:33 PM)
In article <JpaNE.40271$IQ6.15778>,
John D Groenveld <groenveld> wrote:
>Here's where things go sideways:
># zlogin oracle "su - oracle -c 'id -p'"
>Oracle Corporation SunOS 5.11 11.4 May 2019
>uid=100(oracle) gid=100(dba) projid=100(user.oracle)
># zlogin oracle "tail -1 /etc/project"
>user.oracle:100:RDBMS::dba:max-shm-memory=(privileged,34359738368,deny)


user.oracle:100:RDBMS::dba:project.max-shm-memory=(privileged,34359738368,deny)

Dumb mistake on my part.
John
groenveld
Similar Threads