Fix ORA-15045 ORA-15120 ORA-27090: Unable to reserve kernel resources for as

advertisements

_____________________________________________________________________________________________________________________

Error Description

Alter system command fails with ORA-27090: Unable to reserve kernel resources for as

 

SQL> alter system set db_securefile=PERMITTED scope=both sid='*';
alter system set db_securefile=PERMITTED scope=both sid='*'
*
ERROR at line 1:

ORA-01565: error in identifying file
'+DATA_T2/DOEMPROD/PARAMETERFILE/spfile.329.926856473'
ORA-17503: ksfdopn:2 Failed to open file
+DATA_T2/DOEMPROD/PARAMETERFILE/spfile.329.926856473
ORA-15045: ASM file name 'ORA-27090: Unable to reserve kernel resources for as'
is not in reference form
ORA-15120: ASM file name 'ORA-27090: Unable to reserve kernel resources for as'
does not begin with the ASM prefix character

Solution Description

Set/add the value fs.aio-max-nr=3145728 in /etc/sysctl.conf file. After setting the value I am able to run the alter system command successfully. 

Open /etc/sysctl.conf and add fs.aio-max-nr = 3145728

# vi /etc/sysctl.conf

Run sysctl -p command as root.
# sysctl -p
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
kernel.shmmax = 135101190144
kernel.shmall = 26386951
fs.aio-max-nr = 3145728

SQL> alter system set db_securefile=PERMITTED scope=both sid='*';

System altered.

_____________________________________________________________________________________________________________________

Website Stats