I am getting this error while uploading the data to the database. On the same server I 9iAS is running. I am unable to shutdown the database.
ERROR at line 1:
ORA-01116: error in opening database file 2
ORA-01110: data file 2: '/delivery/datafile/Deliverydatafile.dbf'
ORA-27041: unable to open file
Linux Error: 1: Operation not permitted
Additional information: 3
ORA-06512: at "ESLDBA.UPLOADDELIVERY", line 83
ORA-06512: at "ESLDBA.UPLOADDELIVERY", line 319
ORA-06512: at line 1
os=linux RH 7.2
does the user you used to install Oracle have the rights on directory /delivery/datafile/ and on the file Deliverydatafile.dbf ???
the user has the right to write on these datafiles.
I was able to upload data for 4 days all of sudden, I am facing the problem in shutdown. oracle is not shutdowning.
Query DBA_DATAFILES and just check the status of this particular file.
Click Here to Expand Forum to Full Width