Home » Infrastructure » Unix » Oracle Error 1115 encountere
Oracle Error 1115 encountere [message #98043] Fri, 19 December 2003 00:34 Go to next message
Mohammad Shakir
Messages: 3
Registered: May 2003
Junior Member
we are using sco unix 5.0.4 and oracle 7.2.

when we make export for a user, export show this error

EXP-00008: ORACLE error 1115 encountered
ORA-01115: IO error reading block from file 18 (block # 38338)
ORA-01110: data file 18: '/home/sysgatho3.dbf'
ORA-07373: sfrfb: read returned incorrect number of bytes.
Additional information: 38338
Additional information: 55296

anybody will help me how I can slove this problem ?
Re: Oracle Error 1115 encountere [message #98044 is a reply to message #98043] Fri, 19 December 2003 02:23 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
ask the unix admin to check the disk....possible disk corruption.
in os level, try to copy the files . iF it whines, it is to do with hardware/OS.

Re: Oracle Error 1115 encountere [message #98045 is a reply to message #98044] Fri, 19 December 2003 23:47 Go to previous messageGo to next message
Mohammad Shakir
Messages: 3
Registered: May 2003
Junior Member
I have checked that hard disk has bad sector.

Can I change/recover that file from bad sector ?
Re: Oracle Error 1115 encountere [message #98046 is a reply to message #98045] Sat, 20 December 2003 02:39 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
fix the disk.
restore the database from ur backup.
Error: Oracle error occured but error could not be reterived from oracle [message #98110 is a reply to message #98045] Sat, 28 February 2004 09:18 Go to previous messageGo to next message
Ashu Goel
Messages: 2
Registered: February 2004
Junior Member
error: Oracle error occured but error could not be reterived from oracle.

This error occurs sometimes when i run the application.
It just occurs while making the connection between VB6.0 and Oracle8i.

The connectivity string is :
cnn.Open "Provider=MSDAORA.1;User ID=scott/tiger;Data Source=Oracle;Persist Security Info=False"

I m using Windows 2000 server. My system has hyperthread P-4 processor with 516MB ram.

This error does'nt gives the error no as well.

Plz help me solve this problem
Thanks

Ashu
--> ashugoel@hotmail.com
Re: Error: Oracle error occured but error could not be reterived from oracle [message #98159 is a reply to message #98110] Tue, 13 April 2004 03:17 Go to previous message
ledebo
Messages: 1
Registered: April 2004
Junior Member
i have the same problem. I can`t fix it. I have seen oracle permissions folder, tnsnames file , all is correct. te most frustration is i have a computer (win2000) with oracle client which work but other computer (win2000) same oracle client not work.

bufffffffffffff. if u fix the problem tell me. thx
Previous Topic: FTP file size limitation on UNIX?
Next Topic: Help needed in installation of Oracle 9i on Sun Solaris
Goto Forum:
  


Current Time: Thu Mar 28 14:11:56 CDT 2024