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

_____________________________________________________________________________________________________________________

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.

_____________________________________________________________________________________________________________________

0 comments:

Post a Comment

 

acehints.com Copyright 2011-17 All Rights Reserved | Site Map | Contact | Disclaimer | Google