Sometimes while starting up the databases, we may get the error ORA-46365. Today we will discuss how to resolve this error. Let’s go through this.
Table of Contents
Error :
SQL> startup nomount;
ORA-46365: Audit file '/u01/oracle/audit/test/ora_audit_07051.bin' could not be created.
ORA-27072: File I/O error Linux-x86_64 Error: 22: Invalid argument Additional information: 4 Additional information: 1 Additional information: 4294967295
Resolution :
Step 1 :
If DB is completely down, then modify the below parameter in spfile :
filesystemio_options=’NONE’
Or,
Issue the below command :
alter system set filesystemio_options='NONE' scope=spfile;
Step 2:
Start the Database :
SQL>startup;
That’s how you can simply resolve this ORA error. Also, you can get further reference on this from the below Doc as well
Database Not Starting With Error ORA-46365: Audit File Could Not be Created (Doc ID 2516926.1)
Related ORA-Error Relatee Articles :
