Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01114: IO error writing block to file 201 (block # 111425)

user589420Feb 25 2008 — edited Aug 18 2008
Hi i am
getting an ORA-01114 error (i know that i have a free space error)
my question is what is the file causing the error is it the 201 in this case
why following query
SQL> select max(file#) from v$datafile;

MAX(FILE#)
----------
157

return 157
any help

Comments

Darryl Gove-Oracle

Hi,

I'm not sure what problem you are hitting. My suggestions for workarounds are:

a) record the experiment to /tmp (-o /tmp/test.1.er) this is probably good practice anyway since it avoids problems where disk latency creates a probe effect.

b) Try starting the process under collect then using signals to switch on data collection for the duration of interest.

https://blogs.oracle.com/d/entry/controlling_profiling

c) I've not tried -S on with -P <pid> I suspect that it relies on interposing on the synchronisation calls, so would not be effective. So I'd try dropping this combination of options.

Regards,


Darryl.

2727557

Hi Darryl,

Thanks for your response, let me try the option b mentioned in your blog because the first option didn't work.

Will let you know whether we could gather all the measures which we are interested.

Thanks

Sattish

2727557

Hi Darryl,

We tried with the below mentioned option

./collect -P 24829 -o /tmp/test.9.er  But still the same error

NOTE: No J2SE[tm] was specified for checking.

    The following J2SE[tm] versions are recommended:

      J2SE[tm] 1.7.0_25 or later 1.7.0 updates (preferred)

NOTE: You can download and install the J2SE[tm] from http://www.oracle.com/technetwork/java/javase/downloads.

WARNING: Java data collection may fail: J2SE[tm] version is unsupported.

Reading atlasserv

Reading ld-linux.so.2

Reading libppfaketime.so.1

Reading librt.so.1

Reading libpthread.so.0

Reading libcrypt.so.1

Reading libz.so.1

Reading libdl.so.2

Reading libkrb5.so.3

Reading libicui18n.so.36

Reading libicuuc.so.36

Reading libicudata.so.36

Reading libicuio.so.36

Reading libexpat.so.0

Reading libqpidmessaging.so.3

Reading libqpidtypes.so.1

Reading libxerces-c.so.27

Reading libstdc++.so.6

Reading libm.so.6

Reading libc.so.6

Reading libgcc_s.so.1

Reading libk5crypto.so.3

Reading libcom_err.so.2

Reading libkrb5support.so.0

Reading libkeyutils.so.1

Reading libresolv.so.2

Reading libqpidclient.so.6

Reading libuuid.so.1

Reading libselinux.so.1

Reading libqpidcommon.so.6

Reading libsepol.so.1

Reading libboost_program_options.so.2

Reading libboost_filesystem.so.2

Reading libsasl2.so.2

Reading ISO8859-1.so

Reading libcollector.so

Attached to process 24829

t@4133668672 (l@24829) stopped in __kernel_vsyscall at 0xffffe410

0xffffe410: __kernel_vsyscall+0x0010:   popl     %ebp

dbx: The HW counter configuration could not be loaded

Run "collect -h" or "er_kernel -h" with no other arguments for more information on HW counters on this system.

dbx: Creating experiment database /tmp/test.9.er (Process ID: 7769) ...

dbx: Experiment directory not writable

Experiment aborted

error at line 15 of file 'dbxcol61PZeE'

detaching from process 24829

Could you please review

Thanks

Sattish.

Darryl Gove-Oracle

Did you have any better luck with option (b)? Regards, Darryl.

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 15 2008
Added on Feb 25 2008
6 comments
8,730 views