sqlplus / as sysdba SQL> startup ORACLE instance started. Total System Global Area 1068937216 bytes Fixed Size 2233344 bytes Variable Size 809503744 bytes Database Buffers 251658240 bytes Redo Buffers 5541888 bytes Database mounted. ORA-01114: IO error writing block to file 5 (block # 1) ORA-01110: data file 5: '/data/oracle/bb/bb1.dbf' ORA-27091: unable to queue I/O ORA-27041: unable to open file Linux-x86_64 Error: 13: Permission denied Additional information: 3
I changed the permissions to data file and problem solved:
sudo chmod 660 /data/oracle/bb/bb1.dbf sqlplus / as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Fri Oct 16 17:59:36 2015 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production SQL> startup ORACLE instance started. Total System Global Area 1068937216 bytes Fixed Size 2233344 bytes Variable Size 809503744 bytes Database Buffers 251658240 bytes Redo Buffers 5541888 bytes Database mounted. Database opened.
The most effective method to Solve Oracle ORA-01114 Error Message through Remote DBA Services
ReplyDeleteThe Oracle ORA-01114 signifies "IO blunder composing square to record sharing" the primary driver for this issue is, you attempted to compose a document, yet gadget where the record lives is disconnected that is the reason you need to confront this issue. Be that as it may, don't stress you can undoubtedly handle this issue; just you have to reestablish access to this gadget and afterward attempt re-keeping in touch with the document. We have another technique to take care of this issue, rapidly contact to Online Oracle DB Support or Database Administration for Oracle.
For More Info: https://cognegicsystems.com/
Contact Number: 1-800-450-8670
Email Address- info@cognegicsystems.com
Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801