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
.......
....
....
.........
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
.......
....
....
.........
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/
ReplyDeleteThe 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.
ReplyDeleteQuickBooks Technical Support Phone Number
QuickBooks Technical Support Phone Number
QuickBooks Technical Support Phone Number
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/
ReplyDeletehttps://youtu.be/RF5hTm9vmnc
ReplyDeletehttps://youtu.be/Xrkf8OudbWs
https://youtu.be/YWsOxdHkJt0
Nice Blog!
ReplyDeleteKnow 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.
Nice Blog!
ReplyDeleteQuickBooks toll-free Number are available 24*7 for help the customer to get hassle less service.
Dial QuickBooks Customer Services +1-844-908-0801
Thank you for nice information. please visit our web :
ReplyDeleteFirlah
Firlah