I have just installed a oracle 12c 12.1.0 DB on a linux machine.
after completing the installation i tried to login to database as sysdba
[oracle@bjorn adump]$ sqlplus sys as sysdba/welcome Enter password:SQL*Plus: Release 12.1.0.2.0 Production on Wed Oct 12 16:41:17 2016 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to an idle instance.
Now i tried to startup the DB using below command
SQL> startup mount ORA-09925: Unable to create audit trail file Linux-x86_64 Error: 2: No such file or directory Additional information: 9925
and this error pop up !
my ENV variable are --
[oracle@bjorn adump]$ echo $ORACLE_BASE /oracle [oracle@bjorn adump]$ echo $ORACLE_HOME /oracle/product/12.1.0/db_1
I have checked into pfile which is $ORACLE_HOME/dbs/init.ora
there is the entry for audit file
audit_file_dest="/oracle/admin/orcl/adump"
I also go to this location and check if the folder exists or nt but the folder was there and it aleady has some files in it like
orcl_m000_21634_20161012143245012051143795.aud
there are lots of file with names like this.
I gave permission to this folder
chmod -R 755 /oracle/admin/orcl/adump
tried creating a new file using
touch afile
and file get created.
It also got connect to the idle session but when i tried to do a startup the error pops up !
Please suggest what i am overlooking here which needs to be corrected.