OraFAQ Forum: Unix » Oracle Error 1115 encountere

Home » Infrastructure » Unix » Oracle Error 1115 encountere

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Error 1115 encountere [message #98043]

Fri, 19 December 2003 00:34

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 ?

Report message to a moderator

Re: Oracle Error 1115 encountere [message #98044 is a reply to message #98043]

Fri, 19 December 2003 02:23

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: Oracle Error 1115 encountere [message #98045 is a reply to message #98044]

Fri, 19 December 2003 23:47

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 ?

Report message to a moderator

Re: Oracle Error 1115 encountere [message #98046 is a reply to message #98045]

Sat, 20 December 2003 02:39

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

fix the disk.
restore the database from ur backup.

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	FTP file size limitation on UNIX?
Next Topic:	Help needed in installation of Oracle 9i on Sun Solaris

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 21:01:23 CST 2024