-
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
oracle: 9.0.1
9iAS: 1.0.2.2.1
-
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.
cheese
anandkl
