Srini,
Thanks for the info. That sure is irritating.
Cherie
[EMAIL PROTECTED]@fatcity.com on 03/19/2001 08:35:42 AM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Cherie,
This in itself is a bug !
I asked the same question at an Oracle education class about 18 months ago
and was told that the default visibility when creating an entry in the bug
database is "internal" - i.e. not visible outside of Oracle. Analysts have
been asked to set visibility to global when logging bugs in the database,
but if they forget to do so, you will not be able to search for it.
I cannot understand why the visibility cannot be changed after the bug is
created as "internal".
Go figure !
HTH
Srini Chavali
Oracle DBA
Cummins Inc
[EMAIL PROTECTED]@fatcity.com on 03/19/2001 08:50:22 AM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
I have an error on an 8.1.5 export/import.
Metalink shows a reference to bug 909635.
When I search the bug database putting the
bug number 909635 in the bug number field
and pressing search, the search engine
replies that there were no hits.
How can this be? If a bug is identified in
the knowledge base, it must exist and be
searchable in the bug database.
Sometimes I get so frustrated with Metalink.
We pay so many hundreds of thousands
of dollars for support and I can't even search
Metalink, much less get a person to tell me
the answers to questions that I have.
Can anyone tell me what I might be doing
wrong or forward any information on this
bug to me?
Thanks,
Cherie Machler
Gelco Information Network
"djordjej" <[EMAIL PROTECTED]>@fatcity.com on 03/19/2001 07:26:34 AM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Here is the document from Metalink regading this error:
HTH.
Djordje
*********
Doc ID:
Note:49946.1
Subject:
OERR: ORA 27072 skgfdisp:
I/O error
Type:
REFERENCE
Status:
PUBLISHED
Content Type:
TEXT/PLAIN
Creation Date:
21-NOV-1997
Last Revision Date:
08-JUN-1999
Language:
USAENG
Error: ORA-27072
Text: skgfdisp: I/O error
---------------------------------------------------------------------------
Cause: read/write/readv/writev system call returned error, additional
information indicates starting block number of I/O
Action: check errno
*** Important: The notes below are for experienced users - See
[NOTE:22080.1]
Explanation:
This error was introduced in Oracle8.
The error is raised in port specific code so the exact system calls
preceeding the error can vary between platforms. The error indicates
that a read or write call either:
a) returned an error
or
b) returned a value indicating that the number of bytes
read/written
does not match the number of bytes we asked to read/write
Hence the error number reported may or may not be meaningful.
If the read/write returned an error then the ERRNO reported corresponds
to the actual read/write call used. If the read/write returned a
different
number of bytes to that expected then ERRNO is just the left over error
from some previous system call and should be ignored.
Additional information is the first BLOCK NUMBER being read/written
in the named file.
Diagnosis:
1. 2Gb limits (or other limits) can cause this sort of error so check if
the filename reported in the corresponding error is a large file.
The block number in the additional information can help show if you
are close to this limit.
2. It is helpful to know the system call which caused the error so
exact version information is important. If the error is repeatable at
will then TRUSS or similar may help identify the call raising the
error.
3. Determine if the file/s are on raw devices / logical raw volumes or
file system files.
References / Known Bugs etc..
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
There are several known issues that can cause this error, plus it can be
a non-Oracle problem so it is important to collect all the information:
2Gb or not 2Gb - file limits in Oracle [NOTE:62427.1]
See the above article as an anchor point for 2Gb issues on various
platforms.
Eg: Solaris 2Gb issue [BUG:774252]
Backup of RAW controlfile [NOTE:60953.1]
Sequent AIO issue [NOTE:64632.1]
----- Original Message -----
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, March 19, 2001 3:05 AM
> Hello All,
>
> J ust now i got a error select count(*) from s_org_ext.
>
> SQLWKS> select count(*) from s_org_ext; where S_org_ext is Name of the
> Table.
> COUNT(*)
> ----------
> ORA-01115:
> ORA-01110: 4: /db/oracle/oradata/tlisuser/data03.dbf
> ORA-27072: skgfdisp:
> SVR4 Error: 25: Inappropriate ioctl for device
> Additional information: 262132
>
> But When I do select x,y,z,t,..... from s_org_ext then No error occured.
>
> The size of that Table is 2.4GB. Its Initial extent is 1Gb and Next is
1mb.
>
> Vesion of Orcale 8.0.5 and OS is Sun solaris 5.6
>
> Developped got this error while executing a procedure. I think that
> procedurte will be insert into data into s_org_ext.
>
> PLease tell me what i will do. I think datafile will be damagaed. can not
> coiped on OS prompt when last time I took backup.
>
> Please help me.,
>
> Regards,
> Saroj.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Dash, Saroj (CAP,CEF)
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: djordjej
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
