Operating System - HP-UX
1748103 Members
4615 Online
108758 Solutions
New Discussion юеВ

What could be causing this problem?ORA-??

 
SOLVED
Go to solution
Jung.S.H
Occasional Contributor

What could be causing this problem?ORA-??

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?
4 REPLIES 4
Patrick Wallek
Honored Contributor

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

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.
Joseph Loo
Honored Contributor
Solution

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

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.
what you do not see does not mean you should not believe
Joseph Loo
Honored Contributor

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

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

this is taken from Oracle Metalink.

regards.
what you do not see does not mean you should not believe
Jung.S.H
Occasional Contributor

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

Thank you very much.