This content has been marked as final. Show 4 replies
error: permission denied on key 'fs-aio-max-nr'It seems you are either not using the root user to change these parameters or your VPS (your original post indicated you are using that virtualization plattform) doesn't allow you to change these parameters at all.
Could you please help me?
Either way, it doesn't seem to be a problem specific to Oracle Database XE but an OS/VM-level topic. I'd recommend to post to some forum that covers this.
Edited by: Udo on 19.11.2012 10:08
if you want to use MEMORY_TARGET(Automatic Memory Management) then /dev/shm filesystem size should be greater than or equal to MEMORY_TARGET/MEMORY_MAX_TARGET value. df -h will confirm that.
so make sure /dev/shm has enough space before thinking of using MEMORY_TARGET.
Or you have other option Instead of using MEMORY_TARGET try using Automatic Shared Memory Management ie by setting sga & pga manually in pfile and start the database.
pga_aggregate_target = 100M
sga_target = 500M