_____________________________________________________________________________________________________________________
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='*';
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment