Pages

Thursday 14 July 2016

ORA-15120: ASM file name 'ORA-27090: Unable to reserve kernel resources for asynchro' does not begin with the ASM prefix character

Database fails to create with below error


Completing Database Creation
DBCA_PROGRESS : 73%
DBCA_PROGRESS : 76%
DBCA_PROGRESS : 85%
PRCR-1079 : Failed to start resource ora.test03.db
CRS-5017: The resource action "ora.test03.db start" encountered the following error:
ORA-01565: error in identifying file '+TEST03_DATA/test03/PARAMETERFILE/spfile.268.917148803'
ORA-17503: ksfdopn:10 Failed to open file +TEST03_DATA/test03/PARAMETERFILE/spfile.268.917148803
ORA-15120: ASM file name 'ORA-27090: Unable to reserve kernel resources for asynchro' does not begin with the ASM prefix character
. For details refer to "(:CLSN00107:)" in "/opt/oracle/product/base/diag/crs/test03.domain.com/crs/trace/crsd_oraagent_oracle.trc".

CRS-2674: Start of 'ora.test03.db' on 'test03.domain.com' failed
CRS-2632: There are no more servers to try to place resource 'ora.test03.db' on that would satisfy its placement policy
DBCA_PROGRESS : 94%
DBCA_PROGRESS : 100%
Database creation complete. For details check the logfiles at:
 /opt/oracle/product/obase/cfgtoollogs/dbca/test03.
Database Information:
Global Database Name:test03
System Identifier(SID) Prefix:test03


Reason:

fs.aio-max-nr value was set low in /etc/sysctl.conf.


fs.aio-max-nr = 1048576

As per Oracle standard, set fs.aio-max-nr to  3145728

fs.aio-max-nr= 3145728

Solution:

1. update fs.aio-max-nr in /etc/sysctl.conf with root user
vi /etc/sysctl.conf
#fs.aio-max-nr = 1048576
fs.aio-max-nr = 3145728

2. Run /sbin/sysctl -p to make it permanent

root:test03.domain.com ~ # sysctl -p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 1
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmax = 65536
net.ipv6.conf.all.disable_ipv6 = 1
net.ipv6.conf.default.disable_ipv6 = 1
net.ipv4.conf.all.accept_redirects = 0
.......
....
....
.........

7 comments:

  1. Quick fix for errors is available at our <a href="https://www.theqbsupportphonenumber.com/quickbooks-enterprise/>QuickBooks Enterprise Support Phone Number</a> +1 800-417-3165. For an accounting application as extensive and popular as QuickBooks, having a few technical glitches is not a surprise at all. Our team helps you work smoothly on this software by eliminating all the errors that emerge in it. Read more- https://tinyurl.com/y62hwd2h & visit us-https://www.theqbsupportphonenumber.com/quickbooks-enterprise/

    ReplyDelete
  2. The experts at QuickBooks Technical Support Phone Number +1 (877) 282-6222 are available 24x7 hours and are always ready to help you with the best solution, every time. The experts at QuickBooks Technical Support Phone Number +1 (877) 282-6222 are available 24x7 hours and are always ready to help you with the best solution, every time.
    QuickBooks Technical Support Phone Number
    QuickBooks Technical Support Phone Number
    QuickBooks Technical Support Phone Number

    ReplyDelete
  3. Hey! Superb Blog. I couldn’t leave your website without informing you that I loved your blog. Your blog has all the detailed information and supporting statement for the topic. QuickBooks Payroll software is the best option for managing your payroll. You can get 24/7 help and support at QuickBooks Payroll Tech Support Number 1-833-401-0204. Read more: https://tinyurl.com/rr9z6f8 or visit us: https://www.mildaccounting.com/quickbooks-payroll-tech-support-number/

    ReplyDelete
  4. Nice Blog!
    Know How to do QuickBooks general ledger .For effective solution get in touch with Our expert.
    Click Here to Know how to do QuickBooks general ledger
    Dial our tech support Number for any support +1-844-908-0801.

    ReplyDelete
  5. Nice Blog!
    QuickBooks toll-free Number are available 24*7 for help the customer to get hassle less service.
    Dial QuickBooks Customer Services +1-844-908-0801

    ReplyDelete
  6. Thank you for nice information. please visit our web :
    Firlah
    Firlah

    ReplyDelete