topic Re: What could be causing this problem?ORA-?? in Operating System - HP-UX

What could be causing this problem?ORA-??

Jung.S.H — Thu, 03 Jun 2004 22:22:29 GMT

HP-UX 11.0

java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01115: IO error reading block from file 2 (block # 15683)
ORA-01110: data file 2: '/data1/FDS/rbs01.dbf'
ORA-27041: unable to open file
HP-UX Error: 13: Permission denied
What could be causing this problem?

Re: What could be causing this problem?ORA-??

Patrick Wallek — Thu, 03 Jun 2004 22:31:53 GMT

Well, have you checked the permissions on the /data1 and /data1/FDS directories and the /data1/FDS/rbs01.dbf files? Make sure the permissions are set appropriately for whatever user is attempting to access the database.

Re: What could be causing this problem?ORA-??

Joseph Loo — Thu, 03 Jun 2004 22:34:42 GMT

hi,

taken from Oracle Metalink Note:1074719.6

Usually, after an offline drop of a datafile, a tablespace will then be successfully dropped. Checked the status of the data file from DBA_DATA_FILES and it shows it as available although a drop command has already been issued.

The following command is usually not performed. However, in this case, creating a datafile first an then dropping the tablespace was the only way the tablespace could be dropped.

(1) Issue alter database create datafile ''.

(2) Then issue a drop tablespace including contents;

regards.

Re: What could be causing this problem?ORA-??

Joseph Loo — Thu, 03 Jun 2004 22:42:38 GMT

read the attachment for more detail on how to solve your error.

this is taken from Oracle Metalink.

regards.

Re: What could be causing this problem?ORA-??

Jung.S.H — Thu, 03 Jun 2004 22:50:43 GMT

Thank you very much.